topic Re: ODBC MSSQL cannot show table from libname in Administration and Deployment

ODBC MSSQL cannot show table from libname

haibh — Wed, 03 Apr 2024 03:20:38 GMT

SAS APP is utf-8 encoding server.

from SAS EG, run "libname test9 odbc dsn=MSSQLTest authdomain=mssqlAuth;" this command run ok.

DB have one table "TEST", but from library show "t"

when open "t", get error

Re: ODBC MSSQL cannot show table from libname

Patrick — Wed, 03 Apr 2024 03:36:54 GMT

What's the result if you run below code?

option validmemname=extend;
libname test9 odbc dsn=MSSQLTest authdomain=mssqlAuth;
proc contents data=test9._all_;
run;quit;

Re: ODBC MSSQL cannot show table from libname

haibh — Wed, 03 Apr 2024 04:10:28 GMT

1 The SAS System Saturday, June 10, 2023 11:08:00 AM

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program 13';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='C:\setups\Project.egp';
6 %LET _CLIENTPROJECTPATHHOST='SVR170';
7 %LET _CLIENTPROJECTNAME='Project.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 option validmemname=extend;
29 libname test9 odbc dsn=MSSQLTest authdomain=mssqlAuth;
NOTE: Credential obtained from SAS metadata server.
NOTE: Libref TEST9 was successfully assigned as follows:
Engine: ODBC
Physical Name: MSSQLTest
30 proc contents data=test9._all_;
31 run;

ERROR: CLI describe error: :
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.30 seconds
cpu time 0.05 seconds

NOTE: The SAS System stopped processing this step because of errors.
31 ! quit;
32
33 %LET _CLIENTTASKLABEL=;
34 %LET _CLIENTPROCESSFLOWNAME=;
35 %LET _CLIENTPROJECTPATH=;
36 %LET _CLIENTPROJECTPATHHOST=;
37 %LET _CLIENTPROJECTNAME=;
38 %LET _SASPROGRAMFILE=;
39 %LET _SASPROGRAMFILEHOST=;
40
41 ;*';*";*/;quit;run;
42 ODS _ALL_ CLOSE;
43
44
2 The SAS System Saturday, June 10, 2023 11:08:00 AM

45 QUIT; RUN;
46

Re: ODBC MSSQL cannot show table from libname

Patrick — Wed, 03 Apr 2024 04:37:53 GMT

That's not much error message.... Are you the SAS admin at your site? If not then that's the first person you need to contact for further support.

Re: ODBC MSSQL cannot show table from libname

Sajid01 — Thu, 04 Apr 2024 23:53:06 GMT

Hello @haibh
Did you get a chance to look at this?

https://support.sas.com/kb/57/650.html