BookmarkSubscribeRSS Feed
Jade_SAS
Pyrite | Level 9

Hi All,

 

    I have one testing SAS server and one production SAS server. I tested the pass through to SQL data connection coding, it works on testing server, but not on production SAS server, I wonder what is the possible reason.

 

   Config: Same ODBD.ini file on both SAS servers(testing and production).

                Same coding

  

The coding is as below:

  

proc sql;

connect to odbc (noprompt = "dsn=**;DRIVER=SQLServer;uid=**;pwd=**;");

create table test as

select * from connection to odbc

(SELECT *

FROM [**].[**].[**]

)

;

disconnect from odbc;

quit;

 

The Error for the production server is as beow:

ERROR: CLI describe error: [

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

 disconnect from odbc;

NOTE: Statement not executed due to NOEXEC option.

quit;

NOTE: The SAS System stopped processing this step because of errors.

 

 

Thank you!

Jade

2 REPLIES 2
Jade_SAS
Pyrite | Level 9

1)  if I try libname at schema level, the table show in TESTing is the same at SQL studio, see attachment TEST.

 LIBNAME sqltest odbc Password=** User=** DATASRC=** schema=dbo;

 

 2) if  if I try libname at schema level in Production server,  the table show in Production seems have chopped name (in my case, the table only have letter s, whihc is the initial letter of those tables in TEST server), see attachment PROD.


TEST.png
Jade_SAS
Pyrite | Level 9

PROD table seems have chopped name from tables in TESTing server


PROD.png

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 741 views
  • 0 likes
  • 1 in conversation