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.
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.
No, how does one attempt that? II have connect through SQL Studio manager but just having trouble connecting throughSAS
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.