开发者

Errors in Access 2003 front end after switching DSN to sqlncli10

开发者 https://www.devze.com 2023-03-05 11:15 出处:网络
I have an Access 2003 front end linked (DSN) to a SQL 2008 back end. I had originally developed it using the older sqlsvr32 DSN driver, but were having performance issues. A new DSN was created to use

I have an Access 2003 front end linked (DSN) to a SQL 2008 back end. I had originally developed it using the older sqlsvr32 DSN driver, but were having performance issues. A new DSN was created to use the sqlncli10 (Server 2008r2 version) driver and the tables relinked. This increased performance, but now causes what looks like timeout errors at unpredicable intervals in the front end with everything from ADO recordset queries to simple dropdown box populations. The only thing which has chan开发者_高级运维ged is the driver, and I can't determine the cause of these timeouts. Any suggestions?


The DSN was created using the OBDC manager (odbcad32.exe) using the Sql Server Native Client 10.0 (2009.100.1600.01). Tables were dropped and re-linked from the database (SQL Server 2008). This did not resolve the issue. Custom functions were re-written to use ADO, and tables were converted to a DSN-less connection with the same driver. Neither had an apparent effect on the issue. The issue was resolved after targeting different servers for testing to see if the server was the problem. Any server with 2008 R2 did not show any symptoms on this issue. The issue was resolved by uninstalling all SQL server instances, installing 2008 R2, and restoring the databases. I'm not sure of the exact cause, but this seems to fix the issue.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号