08-20-2015 08:21 AM
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.
08-20-2015 06:34 PM
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.
08-21-2015 01:36 AM
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
08-21-2015 04:14 PM
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.
08-21-2015 08:53 PM
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.
08-31-2015 06:46 AM
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
08-31-2015 07:00 AM
I submitted the following code
Connect to odbc(datasrc=tribal user=** password=****);
Create table work.account as
Select * from connection to odbc
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
08-31-2015 07:53 AM
You are encountering a bitness problem. Most probably the ODBC driver is still 32bit, while you are accessing it with 64 bit SW from SAS on a 64bit system.