We recently upgraded to version 10 and since that the ODBC connection will not connect. Did something change? When I use a 32bit I get a application version mismatch. 64bit connections get a 6420 error.
Announcement
Collapse
No announcement yet.
ODBC failed after upgrade to 10
Collapse
X
-
Mike C
- 41
ODBC failed after upgrade to 10
-
Mike C
- 41
Re: ODBC failed after upgrade to 10
Actual Message received. Firewall is good. It literally stopped working after updating to 10 and rebooting. Webinterface appears to be working. Clients are connecting just fine.
The test connection to the linked server failed.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "COMMITDATA".
OLE DB provider "MSDASQL" for linked server "COMMITDATA" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "COMMITDATA" returned message "[iAnywhere Solutions][Advantage SQL][ASA] Error 6420: The 'discovery' process for the Advantage Database Server failed. Unable to connect to the Advantage Database Server. axServerConnect". (Microsoft SQL Server, Error: 7303)
For help, click: http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476
-
Support Team
- 7532
Re: ODBC failed after upgrade to 10
Thank you for posting this.
In general version upgrade does not affect on ODBC connections.
We think that it may be related to the server reboot, probably the workstation that uses ODBC connection is unable to connect to the RangerMSP server and allocate Advantage Database Server.
Have you tried rebooting the workstation? Or connect using ODBC from another computer?
Please review OBDC settings and verify that RangerMSP database path configured there is accessible.
Please keep up posted.
Comment
Comment