Re: libname odbc intersystems

doudouh · Posted 05-24-2017 08:25 AM

Hi,

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

could you help me

Thx

LinusH · Posted 05-24-2017 09:01 AM

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?

Data never sleeps

doudouh · Posted 05-26-2017 03:04 AM

Thx for your replay.

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

SASKiwi · Posted 05-25-2017 04:05 AM

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.

doudouh · Posted 05-26-2017 03:10 AM

Hi,

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

Thx

LinusH · Posted 05-26-2017 06:03 AM

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.

Data never sleeps

doudouh · Posted 05-26-2017 09:39 AM

Ok Thx,

I will see with DBA team

libname odbc intersystems