Question
Ken Wenze · Jan 6, 2020

ODBC Providers for SQL Server

Where can i get the latest odbc providers from SQL Server 2012/2016?

 

I see some posts on line to  an ftp site out there but I am unsuccessful at getting access to it.  I have a version loaded on my server but get errors when querying cache'.

"[Cache ODBC][State : 22005][Native Code 22005]" 

Any help would be appreciated.

the one we have might be version  2014.01.05851  64 bit (would that make sense?)

 

 

00
3 0 4 547

Replies

Thank you Rupert -

We are querying to a Cache instance from a SQL Server.  Intermittently - the sql server shows the query never finishes leaving us to reboot the sql server without knowing what happened on the cache server.

Hi Ken,

I am assuming that you need the Caché ODBC drivers rather than SQL Server?

How big is the query data?

Could you share details/screenshot of the ODBC connection you have set up in SQL Server?

Ken

We have removed our old FTP server.  The best way to get an ODBC Drive is to contact InterSystems Support:  Phone 1 617 621 0700 or Email Support@InterSystems.com

As for the error you are getting, older versions of Cache did have issues with a long-lasting (days) connection getting into a state where it would no longer work and reconnecting would be needed.