Desktop productivity for business analysts and programmers

Connecting to SQL Server from SAS EG running on unix server

Reply
Frequent Contributor
Posts: 79

Connecting to SQL Server from SAS EG running on unix server

[ Edited ]

Hi guys,

 

I am using windows SAS Enterprise guide 6.1 , running on Linux server x86_64.

We wanted to access the SQL server from SAS EG itself, however we dont think we have the odbc connection setup for it.

Connection string:

[ABC_DRI]

Driver=/sso/faw/dbclinet/lib/S0451.so

Description=DataDirect 7.1.5 SQL Server Wire Protocol

AuthenticationMethod=1

BulkLoadBatchSize=1

database=abc_dri_reporting

EnableQuotedIdentifier=0

EnableBulkLoad=1

Hostname=dri02stub_abc

Portnumber=1726

 

libname sqlsvr1 sqlsvr noprompt="

Driver=/sso/faw/dbclinet/lib/S0451.so;

/*Description=DataDirect 7.1.5 SQL Server Wire Protocol;*/

AuthenticationMethod=1;

BulkLoadBatchSize=1;

database=abc_dri_reporting;

EnableQuotedIdentifier=0;

EnableBulkLoad=1;

Hostname=dri02stub_abc;

Portnumber=1726;

UID= fv4578;

PWD=abc_def_124;

";

 

Do you know if we can use the connection as DSNLESS using the username and password that we are using to login to sql server management studio on windows.

 

I tried using it but it didnt execute. Below is the errro :CLI Datadirect ODBC lib data source  name not found.

 

Also I don't have the user privileges to change odbc.ini on linux server

 

am i using the correct format and what could i be doing wrong? TIA

 

aa.JPG

 


Cheers from India!

Manjeet
Super User
Super User
Posts: 9,866

Re: Connecting to SQL Server from SAS EG running on unix server

You need a driver of some sort, if you want to connect via odbc, then you need an odbc driver.  Login details is just part of the login process, it does not pass information back and forth, this is a driver task.

Frequent Contributor
Posts: 79

Re: Connecting to SQL Server from SAS EG running on unix server

hi @RW9

 

thanks for the reply. I have the driver path, please see below:

 

Driver=/sso/faw/dbclinet/lib/S0451.so


Cheers from India!

Manjeet
Super User
Super User
Posts: 9,866

Re: Connecting to SQL Server from SAS EG running on unix server

"however we dont think we have the odbc connection setup for it." - speak with your IT, you need to have the driver setup to work correctly with the database.

Frequent Contributor
Posts: 79

Re: Connecting to SQL Server from SAS EG running on unix server

This driver setup is already working for the other SQL server prod environment, we just wanted to make it work for UAT environment.

It's just the server name the database is different for UAT.

Cheers from India!

Manjeet
Super User
Posts: 5,920

Re: Connecting to SQL Server from SAS EG running on unix server

Just to be clear, we are talking about connecting from the SAS server, not the EG client right (since libname is executed on the server)?

Verify that you have the SAS/ACCESS to ODBC license. And you have that module installed.

Then follow the constructions for post install configurations.

Data never sleeps
Ask a Question
Discussion stats
  • 5 replies
  • 161 views
  • 0 likes
  • 3 in conversation