04-10-2018 03:32 AM - edited 04-10-2018 04:49 AM
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.
Description=DataDirect 7.1.5 SQL Server Wire Protocol
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
04-10-2018 04:00 AM
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.
04-10-2018 04:08 AM
thanks for the reply. I have the driver path, please see below:
04-10-2018 04:14 AM
"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.
04-10-2018 04:16 AM
04-10-2018 02:09 PM
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.