BookmarkSubscribeRSS Feed
lei
Obsidian | Level 7 lei
Obsidian | Level 7

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.

1 REPLY 1
LinusH
Tourmaline | Level 20

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1240 views
  • 0 likes
  • 2 in conversation