[freetds] using freeTDS and DBD::Sybase to connect to Sybase Server

Daniel Fazekas fdsubs at t-online.hu
Wed Apr 19 15:46:57 EDT 2006


On Apr 19, 2006, at 21:27, KParamasivam at claritas.com wrote:

> [test]
> host = 10.x.x.x
> port=2638
> tds version=5.0
[...]
> Unable for connect to server Server message number=911 severity=16  
> state=0
> line=0 text=ASA Error -83: Specified database not foundOpenClient  
> message:
> LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
> Server test, database
> Message String: Login incorrect.


The footnote on this page applies to you:
http://freetds.org/userguide/freetdsconf.htm#FTN.AEN801

"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."

That is, replace [test] with [name of your database].


> Using tds version=8.0 gives me a different error:

TDS 7.0 and 8.0 are only used for MSSQL.

-- 
fds


More information about the FreeTDS mailing list