ODBC Providers for SQL Server

Question

Question

Ken Wenze · Jan 6, 2020

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?)

Discussion (4)0

Log in or sign up to continue

Rupert Young · Jan 14, 2020

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?

0 0

score 0 · Answer 1 · 2020-01-07T06:15:14-05:00

Hi Ken,

Would you just clarify from where and to where you are making the query? If you are querying Caché over a ODBC connection the Caché ODBC driver (CacheODBC35.dll) is installed as standard.

If you are looking for the ODBC driver for the Microsoft SQL Server database you may be able to get it from here,

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

Regards,

Rupert

score 0 · Answer 2 · 2020-01-13T15:00:38-05:00

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.

score 0 · Answer 3 · 2020-03-04T12:10:23-05:00

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.