Help using Base SAS procedures

SAS - SQL Sever Connection

Reply
New Contributor
Posts: 2

SAS - SQL Sever Connection

Hello,

I am trying to connect SAS EG to a SQL Server. Below is the code I tried and the error message I received:

libname EUC ODBC dsn="WKCMA05HPDBPR,15001" user="zk9t2vz" pwd="Wait4G0d12" schema=dbo;

ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] System information file not found. Please check the ODBCINI


       environment variable.


ERROR: Error in the LIBNAME statement.

Super User
Posts: 17,959

Re: SAS - SQL Sever Connection

Have you verified your dsn connection in the ODBC Control Panel?

Also if that's your actual userid/password you may want to delete it from the post.

New Contributor
Posts: 2

Re: SAS - SQL Sever Connection

No, how does one attempt that? II have connect through SQL Studio manager but just having trouble connecting throughSAS

Super Contributor
Posts: 578

Re: SAS - SQL Sever Connection

I don't think the dsn can have a comma.  You're using ODBC access...not SQLSRV, so you have to build a ODBC DSN on your computer.

Ask a Question
Discussion stats
  • 3 replies
  • 647 views
  • 0 likes
  • 3 in conversation