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
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
Chris, I tested it before using your way. in our data link, provider=NZOLEDB which is Netezza server, not among providers.
Maybe you need to install an OLE DB provider for Netezza?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.