Connecting to a InterSystems Cache ODBC Data source

Reply
Contributor lei
Contributor
Posts: 37

Connecting to a InterSystems Cache ODBC Data source

Hi,

 

I have an oracle database that has been set up using InterSystems Cache driver in the ODBC window. I am wondering if anyone knows how I can specify a libname to set this up. I used OBC but it says that

 

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] The specified
DSN contains an architecture mismatch between the Driver and Application
 

Thanks.

Super User
Posts: 5,424

Re: Connecting to a InterSystems Cache ODBC Data source

The first step is to make sure that the ODBC driver and connection works outside SAS, like calling it from Excel.

 

Then, if your libname stills fails, please share the code/full log.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 304 views
  • 0 likes
  • 2 in conversation