libname odbc intersystems

[doudouh]

Hi,

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

could you help me

Thx

[LinusH]

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?

[doudouh]

Thx for your replay.

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

[SASKiwi]

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]

Hi,

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

Thx

[LinusH]

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.

[doudouh]

Ok Thx,

I will see with DBA team