SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS/ACCESS Explicit Pass Through Connection Options

Reply
PROC Star
Posts: 1,231

SAS/ACCESS Explicit Pass Through Connection Options

I'm running an explicit pass-through query against a MS SQL Server database from SAS 9.4 on Linux, and getting intermittent connection errors:

 

ERROR: CLI error trying to establish connection: [SAS][ODBC 20101 driver]252 : [SAS][ODBC 
       20101 driver]1243

 

When this happens I can resubmit the code immediately, and it runs fine.

 

I suspect something is timing out in the handshake between SAS and SQL server, so I want to extend the SQL Server connection timeout limit.

 

My usual CONNECT statement uses an AuthDomain to keep userid / password out of the code. It looks like:

Connect to sqlsvr as MyDB (datasrc=MyDB AUTHDOMAIN="MyDomain");

 

It looks like I can add the timeout limit by passing the full connection string:

  Connect to sqlsvr as MyDB (required="dsn=MyDB; uid=me; password=mypassword; Connect Timeout=30");

 

But I don't want to put the user name and password into my code.  Is there any way I can add the Connect Timeout option to my connection string while at the same time using the authdomain to pass the userid and password?

Contributor
Posts: 25

Re: SAS/ACCESS Explicit Pass Through Connection Options

Hi Quentin,

 

I've noticed that I got the "CLI error" when the file I was trying to access was already open in another process, and so needed to be closed first before I tried to access it again.

 

John

Ask a Question
Discussion stats
  • 1 reply
  • 299 views
  • 0 likes
  • 2 in conversation