topic Re: Libname oledb connection in SAS Programming

Libname oledb connection

QLi — Wed, 19 Feb 2020 02:23:55 GMT

I am trying to create library through oledb.

below is the code i submitted :

LIBNAME ntz oledb
init_string="provider=NZOLEDB;
User ID=&myID ;
password=&PW;
Initial Catalog=MKTPRD;
Data Source=MKTPRD-EEE-NTZ"
schema=TRX;
run;

There was error:

35 LIBNAME ntz oledb
36 init_string="provider=NZOLEDB;
37 User ID=&myID ;
38 password=&PW;
39 XXXXXXXXXXXXXXXXXXXXXXXXXX
40 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
41 schema=TRX;
ERROR: Error trying to establish connection: Unable to Initialize: Client unable to establish connection
ERROR: Error in the LIBNAME statement.

Could you help me point it out where is wrong?

Thank you very much

Re: Libname oledb connection

ChrisNZ — Wed, 19 Feb 2020 20:40:01 GMT

You need to know the connection parameters.

You can test the connection outside of SAS if you want, to start with.

Many resources available to do this, for example this one: https://stackoverflow.com/questions/3910364/quick-ways-to-test-ole-db-connection-string

Re: Libname oledb connection

QLi — Wed, 19 Feb 2020 12:59:51 GMT

Chris, I tested it before using your way. in our data link, provider=NZOLEDB which is Netezza server, not among providers.

Re: Libname oledb connection

ChrisNZ — Wed, 19 Feb 2020 20:42:09 GMT

Have you done something like this?

https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.1/com.ibm.nz.datacon.doc/t_datacon_oledb_provider_install.html

Re: Libname oledb connection

SASKiwi — Wed, 19 Feb 2020 21:16:38 GMT

Maybe you need to install an OLE DB provider for Netezza?