Hi everyone!
A client is having a problem connecting to SQL Server from Accpac v62. It's in conflict with their MIS reports connection. They have setup 2 System DSNs (C:\Windows\SysWOW64\odbcad32.exe), 1 for the MIS reports and 1 for Accpac. MIS and Accpac are connecting to 2 different SQL servers. Both connects successfully when testing the connection in odbcad32.
MIS DSN: <server1>32
SQL Server: <server2>
Accpac DSN: Sage300
SQL Server: <server1>
MIS reports can connect successfully to server2 but when we changed the database profile for the Accpac company in Database Setup to connect through "Sage300" DSN given the same user name and password used in odbcad32.exe, it gives a login failed error. Previously it is using the server name in the database profile. If we delete the DSN for MIS in odbcad32 and set the database profile for the Accpac company to connect via the server name, you can connect to Accpac but then they can't connect the MIS reports to server2.
What might it be? I'm suspecting the DSN name used for the MIS reports? Please help. Thanks in advance.
A client is having a problem connecting to SQL Server from Accpac v62. It's in conflict with their MIS reports connection. They have setup 2 System DSNs (C:\Windows\SysWOW64\odbcad32.exe), 1 for the MIS reports and 1 for Accpac. MIS and Accpac are connecting to 2 different SQL servers. Both connects successfully when testing the connection in odbcad32.
MIS DSN: <server1>32
SQL Server: <server2>
Accpac DSN: Sage300
SQL Server: <server1>
MIS reports can connect successfully to server2 but when we changed the database profile for the Accpac company in Database Setup to connect through "Sage300" DSN given the same user name and password used in odbcad32.exe, it gives a login failed error. Previously it is using the server name in the database profile. If we delete the DSN for MIS in odbcad32 and set the database profile for the Accpac company to connect via the server name, you can connect to Accpac but then they can't connect the MIS reports to server2.
What might it be? I'm suspecting the DSN name used for the MIS reports? Please help. Thanks in advance.