Hi ,
when im trying to access the Netezza database from base SAS, im getting the below error.
its clear that, Netezza drivers are missing.
but anyone let me know how can i install the drivers and connect the database
thanks in advance!!
Do any of the following apply to / help your situation:
http://support.sas.com/kb/20/650.html
http://support.sas.com/kb/34/207.html
http://support.sas.com/kb/35/799.html
If not, then please provide further information, such as:
Amir.
What SAS product are you using (for example, Base SAS, SAS EG, etc.)?
sas 9.4 TS1 Level M4
What version of the product do you have licensed?
base SAS foundation
What platform is the product running on?
windows 7 pro-64
Have you successfully done this before?
no
Can any of your colleagues successfully connect?
no
What does the log show when you run proc setinit; run;?
76 proc setinit; run;
NOTE: PROCEDURE SETINIT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
Original site validation data
Site name: 'AXA EQUITABLE LIFE INSURANCE CO'.
Site number: 70165964.
Expiration: 29APR2019.
Grace Period: 45 days (ending 13JUN2019).
Warning Period: 45 days (ending 28JUL2019).
System birthday: 04JUL2018.
Operating System: WX64_WKS.
Product expiration dates:
---Base SAS Software
29APR2019
---SAS/STAT
29APR2019
---SAS/GRAPH
29APR2019
---SAS/ETS
29APR2019
---SAS/CONNECT
29APR2019
---SAS/Secure 168-bit
29APR2019
---SAS/Secure Windows
29APR2019
---SAS Enterprise Guide
29APR2019
---SAS/ACCESS Interface to Oracle
29APR2019
---SAS/ACCESS Interface to PC Files
29APR2019
---SAS Workspace Server for Local Access
29APR2019
---High Performance Suite
29APR2019
Is there any other information you can supply that might help?
earler im accesing the same netezza through SAS which is installed in server by remote.
now,i installed this on local machine and while trying to access the netezza i facing this.
Did you check any of the links that I sent, especially the first one, as it might provide a quick win?
Otherwise, I advise you check and try the following:
http://support.sas.com/kb/21/047.html
Amir.
You do not have a license for SAS/ACCESS to Netezza. Ask the people responsible for SAS administration in your company to get you the license.
do we need to buy license seperately?
@sg_kr wrote:
do we need to buy license seperately?
Yes. It is a separate module (like SAS/ACCESS to Oracle), and not included in any other.
Either add SAS/Access to Netezza to your local machine or since you have SAS/Connect licenses make a connection to the remote server that does have it licensed and submit the code to access the database in the remote session.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: