RangerMSP Business Automation for successful ITs


Go Back   RangerMSP Forums > RangerMSP Software Discussion Forum (CCRM)

Thread Tools Search this Thread
 
January 25th, 2016, 03:53 PM
Mike C
 
Posts: 41
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.
 
January 25th, 2016, 04:19 PM
Mike C
 
Posts: 41
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
 
January 26th, 2016, 06:04 AM
Support Team
 
Posts: 7,514
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.
Reply





All times are GMT -6. The time now is 11:04 AM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.