By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

SQL 2000 to SQL 2005 conversion fails

P: 1
We create our databases in SQL2000. One of our customers has SQL2005 server for the database and a separate 2003 server for the application. I detached the database at our end, and he attached it his end. Access to view information using our bespoke application (VB6) works successfully; however when we come to update it fails dismally. It works if the application is on the 2005 server.
Error messages in our log file are
From the DYImport.log:

03/09/2008 09:50:55 modImport.npReportErr - -2147467259 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

03/09/2008 09:50:55 dyImport ended abnormally at 03/09/2008 09:50:55

Any ideas?
Nov 7 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.