topic Re: SAS - SQL Sever Connection in SAS Procedures

SAS - SQL Sever Connection

garrickbrim — Mon, 15 Dec 2014 22:33:37 GMT

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.

Reeza — Mon, 15 Dec 2014 22:39:55 GMT

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.

garrickbrim — Mon, 15 Dec 2014 23:12:11 GMT

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

DBailey — Tue, 16 Dec 2014 14:03:55 GMT

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.