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.npRep ortErr - -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?
Error messages in our log file are
From the DYImport.log:
03/09/2008 09:50:55 modImport.npRep ortErr - -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?