[freetds] SQL Anywhere 11

Daniel Fazekas fdsubs at t-online.hu
Wed Nov 26 04:21:52 EST 2008


On Nov 26, 2008, at 10:13, Brian Johnson wrote:

> two that upgraded to Sybase SQL Anywhere 11. That being said, the  
> two sites that upgraded are both having the same issue.  When we try  
> to connect, we are getting a "Login Incorrect".

There's one well-known gotcha when it comes to SQL Anywhere:
"In general, the dataserver name is arbitrary and local; it's used  
only by your client programs to tell FreeTDS which server to connect  
to. You can choose any name you like.

Sybase SQL Anywhere (a/k/a Sybase ASA), however, is fussy. You must  
use the database's name as your dataserver name. Otherwise, the server  
will refuse your connection."

Quoted from the bottom of this page:
http://www.freetds.org/userguide/freetdsconf.htm

If that doesn't solve it, you'll have to enable logging:
http://www.freetds.org/userguide/logging.htm

> I've tried every TDS_Version setting,

Don't try anything but 5.0 for Sybase.



More information about the FreeTDS mailing list