Libname oledb connection

[QLi]

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

[ChrisNZ]

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

[QLi]

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

[ChrisNZ]

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_p...

[SASKiwi]

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