topic How to set up an ODBC connection to Oracle/DB2 from Unix in SAS Procedures

How to set up an ODBC connection to Oracle/DB2 from Unix

Tal — Sun, 26 Mar 2017 20:11:58 GMT

a copy of the odbc.ini file which is saved in my unix home directory does not have anyhting that points to
odbc connection to db2 or oracle.Only to SQL Server so i am wondering how i am able to
access databases in oracle and db2 from UNIX?

Re: How to set up an ODBC connection to Oracle/DB2 from Unix

SASKiwi — Sun, 26 Mar 2017 22:00:01 GMT

Reading the recommendations for your post is a good start like this one.

https://communities.sas.com/t5/SAS-Communities-Library/A-quick-guide-to-connecting-to-Oracle-from-SAS/ta-p/331849

Re: How to set up an ODBC connection to Oracle/DB2 from Unix

Tal — Sun, 26 Mar 2017 22:25:19 GMT

Thanks Reeza for editing my post. No clue how i forgot the subject line and i aplogize about it.

SASKiwi thanks for the article.

What i was saying is i do have access to oracle and db2 with no problems but i dont see anyhting in the odbc.ini file that points to these 2 engines.

I mean ok i do have the tnsnames.ora saved in oracle/network/admin....and i guess that takes care of the oracle connection but what about the DB2? How come i am still able to read/write from DB2 if i dont have those queries in the odbc.ini

Re: How to set up an ODBC connection to Oracle/DB2 from Unix

SASKiwi — Mon, 27 Mar 2017 06:51:51 GMT

Well I know it is possible with some ODBC database connections to specify the connection completely in a connection string without storing definitions elsewhere. I do it with ODBC and SQL Server under Windows. However I don't have access to Unix and DB2 to try out.

If it is possible with ODBC DB2 under Unix then I would expect a complete connection string would look like this:

https://www.connectionstrings.com/ibm-db2-odbc/

How do you define a working ODBC DB2 connection? If it doesn't contain a connection string I can only assume it referencing a connection definition somewhere else like Oracle's TNSNAMES.ORA.

Re: How to set up an ODBC connection to Oracle/DB2 from Unix

Tal — Thu, 30 Mar 2017 00:51:14 GMT

I asked for an updated odbc.ini and again nothing that ponts to ibm db2 odbc...
I guess there must be some hidden script then..

Cheers