topic Sybase via ODBC windows in SAS Data Management

Sybase via ODBC windows

doudouh — Mon, 20 Feb 2017 11:24:31 GMT

Hello,

I have an issue with the odbc sybase library.

I use the driver SQL Anywher, I'm connected when I did the test.

In SAS the library is created but I can't see any table.

Could

Reeza — Mon, 20 Feb 2017 11:38:15 GMT

Is the scheme assigned as well?

Are the table names longer than 32 char?

doudouh — Mon, 20 Feb 2017 11:47:38 GMT

No, the schema is not assigned.

and the names is not longer than 32 char.

Thx

Reeza — Mon, 20 Feb 2017 11:50:13 GMT

Try including the scheme either in the ODBC dsn entry or connection string.

doudouh — Mon, 20 Feb 2017 13:56:14 GMT

By adding the schema name, it works now.

Thank you