SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Sybase via ODBC windows

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Sybase via ODBC windows

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  


Accepted Solutions
Solution
‎02-26-2017 07:45 AM
Super User
Posts: 19,861

Re: Sybase via ODBC windows

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

View solution in original post


All Replies
Super User
Posts: 19,861

Re: Sybase via ODBC windows

Is the scheme assigned as well?

Are the table names longer than 32 char?

Occasional Contributor
Posts: 14

Re: Sybase via ODBC windows

No, the schema is not assigned.

and the names is not longer than 32 char.

 

Thx

Solution
‎02-26-2017 07:45 AM
Super User
Posts: 19,861

Re: Sybase via ODBC windows

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

Occasional Contributor
Posts: 14

Re: Sybase via ODBC windows

By adding the schema name, it works now.

Thank you

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 267 views
  • 1 like
  • 2 in conversation