topic Re: Oracle connection error in SAS Programming

Oracle connection error

Francisco_Cab — Fri, 22 Mar 2019 18:53:53 GMT

Hi All,

I am trying to connect SAS to an Oracle data base without success (my SAS has ODBC). Is there anything else that I need to do in SAS?. Any help provided will be greatly appreciated.

I am using the following code:

PROC SQL NOPRINT;

CONNECT TO ODBC AS MYDB (DSN="xxxxx" USER="xxxxx" PASSWORD="xxxxx AUTOCOMMIT=YES);

CREATE TABLE THOSEPESKYITEMS AS

SELECT * FROM CONNECTION TO MYDB (SELECT * FROM MYIDS);

QUIT;

Best regards,

Re: Oracle connection error

VDD — Fri, 22 Mar 2019 19:09:23 GMT

do you have an ODBC connection setup for the server in Windows on the PC?

Re: Oracle connection error

SASKiwi — Fri, 22 Mar 2019 21:20:08 GMT

It would help if you posted your SAS log so we can see the error messages. The most likely cause is your Data Source Name - DSN - is not defined or not correctly defined on the computer where you are running SAS. Are you running your SAS program on your own PC or on a remote server?

Re: Oracle connection error

Francisco_Cab — Tue, 26 Mar 2019 13:48:17 GMT

Thanks for your reply.

I am running SAS in my own computer.

This is the error mesage:

1 PROC SQL NOPRINT;

2 CONNECT TO ODBC AS MYDB (DSN="tcerdos" USER="PRODUCCION" PASSWORD=XXXXXX AUTOCOMMIT=YES);

ERROR: CLI error trying to establish connection: [Microsoft][Administrador de controladores ODBC]

La arquitectura del DSN especificado no coincide entre el controlador y la aplicación.

3 CREATE TABLE THOSEPESKYITEMS AS

4 SELECT * FROM CONNECTION TO MYDB (SELECT * FROM MYIDS);

ERROR: The MYDB engine cannot be found.

ERROR: A Connection to the MYDB DBMS is not currently supported, or is not installed at your site.

5 QUIT;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.13 seconds

cpu time 0.00 seconds

Your help will be greatly appreciated,

Best regards,

Francisco

Re: Oracle connection error

Francisco_Cab — Tue, 26 Mar 2019 14:57:49 GMT

Thanks for your reply.

Is there any information with the steps required to do that?

Best regards,

Francisco