BookmarkSubscribeRSS Feed
Fluorite | Level 6

I want to know for using pass through facility of SQL in SAS is there need to install some service. This question arised because of the following ERROR in the log

ERROR: The SQLSERVE engine cannot be found.

ERROR: A Connection to the sqlserver DBMS is not currently supported, or is not installed at your site.

Opal | Level 21

In general you need the appropriate SAS/ACCESS product installed and licensed to be able to connect to an external database regardless of the method, LIBNAME, PASSTHRU, SQL etc.

You can confirm what SAS products are licensed by running PROC SETINIT.

What database are you trying to connect to? Your errors suggest SQL Server. In which case you will need SAS/ACCESS to SQL Server, or SAS/ACCESS to ODBC. Your choice may depend on what operating system your SAS server runs on. 

Fluorite | Level 6

Thanks for the reply

When i submit proc setinit i got the following:-

---SAS/ACCESS Interface to PC Files                                                                
---SAS/ACCESS Interface to ODBC                                                                    

---SAS/ACCESS Interface to MySQL      

So i have question whether i am able to use PROC SQL pass through or not                                                           

Rhodochrosite | Level 12

With those products, you can use Pass-thru.  With ODBC, you will need the appropriate drivers for your target database installed.  On Windows, you can technically do it yourself, but you may need your IT support to provide the proper parameterization.

Opal | Level 21

As Doc says you have the right products. Please post the code that gave you the errors you put in your first post. Also which database are you trying to connect to?

My guess is you are trying to use the SQL Server engine when you should be using ODBC: libname test ODBC dsn=xxxx etc.

Fluorite | Level 6

Thanks for the reply

I am connecting ot SQL server using pass through facility

Can you provide me the code for this so that it will be error free

Thanks in advance

Fluorite | Level 6

I submitted the following code

Proc sql;

Connect to odbc(datasrc=tribal user=** password=****);

Create table work.account as

Select * from connection to odbc

(Select *

   From tribal.uu);

Disconnect from odbc;


ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] The specified DSN contains an

       architecture mismatch between the Driver and Application

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no

       default driver specified

ERROR: Connection to the odbc DBMS does not exist



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

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.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 4 in conversation