Database Access

[sg_kr]

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!!

[Amir]

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:

1. What SAS product are you using (for example, Base SAS, SAS EG, etc.)?
2. What version of the product do you have licensed?
3. What platform is the product running on?
4. Have you successfully done this before?
5. Can any of your colleagues successfully connect?
6. What does the log show when you run proc setinit; run;?
7. Is there any other information you can supply that might help?

Amir.

[sg_kr]

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.

[Amir]

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.

[Kurt_Bremser]

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.

[sg_kr]

do we  need to buy license seperately?

[Kurt_Bremser]

---

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

[Tom]

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.