topic Re: libname odbc intersystems in SAS Programming

libname odbc intersystems

doudouh — Wed, 24 May 2017 12:25:01 GMT

Hi,

I created an odbc intersystems cache library but I can't see any table.

could you help me

Thx

Re: libname odbc intersystems

LinusH — Wed, 24 May 2017 13:01:46 GMT

Step one, test from a non-SAS client on the same machine. Like Excel.

Then there can be tons of reasons: authorization, source table names not comply with SAS naming conventions (table names longer than 32 char as an example).

Also, check with the DBA if they can spot any messages during your access.

Can you perform an explicit SQL pass through?

Re: libname odbc intersystems

SASKiwi — Thu, 25 May 2017 08:05:29 GMT

So how did you create this? In code, in SAS Management Console, or some other means? Without details of how you set this up we can only guess what might be wrong.

Re: libname odbc intersystems

doudouh — Fri, 26 May 2017 07:04:12 GMT

Thx for your replay.

I don't have the name of the tables in order to do this test.

Re: libname odbc intersystems

doudouh — Fri, 26 May 2017 07:10:34 GMT

Hi,

I created the librairy in Management console, everything is correct.

Thx

Re: libname odbc intersystems

LinusH — Fri, 26 May 2017 10:03:10 GMT

Say what now? So how do you even know that there are any tables? In order to trouble shoot this you need help from people on the DB side.

Re: libname odbc intersystems

doudouh — Fri, 26 May 2017 13:39:08 GMT

Ok Thx,

I will see with DBA team