467,915 Members | 1,352 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

SQL 2000 to SQL 2005 conversion fails

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
  • viewed: 921

Post your reply

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

Similar topics

6 posts views Thread by PFI | last post: by
6 posts views Thread by jim_geissman | last post: by
2 posts views Thread by Luke.Schollmeyer | last post: by
2 posts views Thread by =?Utf-8?B?SmVmZnJleQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.