Data Federator to SAS- Getting Different Error at Different Port

[Former Member]

Hi

wth Port 8551

jdbc:sharenet://172.x.x.x:8551

sharenet.S58.ex.txt:

Sharenet.S273.ex.txtDriver Coudn't open socket. Connection Refused

With 8591

jdbc:sharenet://172.x.x.x:8591

sharenet.S58.ex.txt:

Sharenet.S279.ex.txtDriver.Sharenet.S06.ex.txt: UserId/password not accepted by server..

With Port 8561

jdbc:sharenet://172.x.x.x:8561

sharenet.S58.ex.txt:

Sharenet.S279.ex.txtDriver.Sharenet.S06.ex.txt: UserId/password not accepted by server..

pls help with this.

Thanks

Sandeep Jain

Edited by: sandeep jain on Apr 12, 2010 8:56 AM

Edited by: sandeep jain on Apr 12, 2010 8:56 AM

[Former Member · Accepted solution]

Hello,

Please check that the version for SAS/SHARE server and for SAS/SHARE JDBC driver are 9.1.3.

Also make sure the port and login/password information used to connect to the SAS/SHARE server are right.

Regards,

Cristian Saita

[Former Member · Accepted solution]

Hi Cristain,

Thanks for your response.

I guess we have missed something. To be frank we arenot pretty much aware that we must install SAS/SHARE server on Data Federator Server.

If i am not interpretting it wrong!!

Scenario:-

We need to coneect to SAS to extract data outof it using Data Federator.

Version Data Federator XI 3.0 SP2.

We are given

1. SAS Server Name (hostname)

2. User Name

3. Password

We haven't installed SAS/SHARE server on any of the machine neither on SAS Server nor on Data Federator Server.

[Former Member · Accepted solution]

Hello Sandeep,

You only need to install the SAS/SHARE JDBC driver 9.1.3 on the Data Federator server machine in the folder 'DF_INSTALL_DIR\LeSelect\Drivers'.

You don't need to install the SAS/SHARE server. The SAS/SHARE server should be already installed on the machine where the SAS data sets are located. The server version should be at least 9.1.3.

To connect to the SAS/SHARE server from Data Federator server you should have the following:

1. SAS/SHARE server host name

2. SAS/SHARE server port

3. user name

4. user password

Please make sure the server port and user name / password are correct.

Regards,

Cristian