I moved our Dynamics 9 system from one server to another (Both running SQL Server 2000). For the most part, all is working in Dynamics. However, when our payroll person tries to print the check register, she gets an error message:
A get/change operation on table 'UPR_WORK_HDR' failed accessing SQL data.
In addition, I have some reports in a VB6 system that need to access the Dynamics SQL database. It worked before the move. Yes, I have modified the OLEDB configuration. Dynamics would not run until I did. If I run the report from within Crystal Reports 9 and put in the log on (sa & password), the report runs fine. I just can't seem to invoke it from within the VB6 app. Now, following the report is some code that updates an Excel spreadsheet. It also needs to connect to the database. The open database code runs before the report prints. Since the database won't open for the report there is no reason to believe it will open for the Excel update. This is the database open code. It is exactly the same (with different db names) as the other database open bits. They work.
Set CnxnDynamics = New ADODB.Connection
CnxnDynamics.Provider = "SQLOLEDB"
CnxnDynamics.Properties("Data Source").Value = "Dynamics"
CnxnDynamics.Properties("Initial Catalog").Value = "TG1"
CnxnDynamics.Properties("Integrated Security").Value = "SSPI"
CnxnDynamics.Open
The error I get is: An Error occurred: [-2147467259] [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied.
Any ideas?
*This post is locked for comments
I have the same question (0)
