Accessing SQL Server using ODBC Data Source

Reply
Contributor
Posts: 42

Accessing SQL Server using ODBC Data Source

I am trying to access a SQL server using the ODBC Data Source.  I have verified using proc setinit that I have SAS/ACCESS to ODBC installed on my computer but am still receiving the following message: ERROR: The ODBC engine cannot be found. ERROR: Error in the LIBNAME statement. Is there anything else I can try.  Any help is appreciated.

Super User
Posts: 19,038

Re: Accessing SQL Server using ODBC Data Source

Are you on windows?

If so set up the ODBC connection in the ODBC manager in the Windows control panel and test your connection there. Once that's verified try your SAS code.

Contributor
Posts: 42

Re: Accessing SQL Server using ODBC Data Source

Hi Reeza, Thanks for your response.  My ODBC Data Source is defined and tested successfully; however, I still get the message when trying to use the LIBNAME method. I am trying this method because the SQL Server data contains over 1 million observations and connecting via File>Open>ODBC times out.

Super User
Posts: 19,038

Re: Accessing SQL Server using ODBC Data Source

proc setint shows what's licenced on your computer.

proc product_status shows what's installed. What does proc product_status show for ODBC?

You may also want to post your libname statement and error.

Contributor
Posts: 42

Re: Accessing SQL Server using ODBC Data Source

I see the following when I run Proc Product_status.  I do not see SAS/ACCESS to ODBC.  This is probably why it does not work.

For Base SAS Software ...

Custom version information: 9.3

Image version information: 9.03.01M0P052511

For SAS/GRAPH ...   Custom version information: 9.3

For SAS/AF ...   Custom version information: 9.3

For SAS/SHARE ...   Custom version information: 9.3

For SAS/CONNECT ...   Custom version information: 9.3

For SAS Integration Technologies ...   Custom version information: 9.3

For SAS/ACCESS Interface to Oracle ...   Custom version information: 9.3

For SAS/ACCESS Interface to PC Files ...   Custom version information: 9.3

For SAS/ACCESS Interface to OLE DB ...   Custom version information: 9.3

Ask a Question
Discussion stats
  • 4 replies
  • 355 views
  • 1 like
  • 2 in conversation