06-19-2013 12:33 PM
I am sorry but a after several attempts i have failed to connect to an oracle database from SAS,
The code i use to try connecting is below:
libname mydblib odbc user=matovua password=password datasrc=dm2;
dm2 is a system DNS for microsoft ODBC for oracle,
i get the error below
CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] The specified
DSN contains an architecture mismatch between the Driver and Application
06-19-2013 01:12 PM
1.why are you not using SAS/Interface Access to Oracle?
2. Can you connect to the database with Toad or any other tool that using the "dm2" configuration? For the odbc connection to work from SAS, first make sure that you could connect to the database using TOAD.
I also think that dm2 should be in quote. but not sure??
06-19-2013 03:52 PM
Test the connection in the windows ODBC interface where the ODBC was created. That will verify that the connection works. I believe SAS just using the ODBC call as setup in windows.
Also check what MS says about the error:
Hope this is helpful!
12-05-2013 04:49 PM
I have the same problem. How did you specify to use 64 instead of 32 bit. My system was upgraded from XP to Windows 7, I might have some 32 ODBC files remined in the system, but I reinstalled the drivers and reconfiged the ODBC to only have 64 bit data sources. However I am still getting this error when trying to connecting to SQL server database. I think your solution would work for me too. Thanks in advance for sharing and help!!