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

KParamasivam@claritas.com KParamasivam at claritas.com
Wed Apr 19 16:16:06 EDT 2006


Daniel,
I replaced [test] with [name of the database] and it worked.
Thanks a lot for the quick response.
I really appreciate your help on this!!

Regards,
Karthik



Daniel Fazekas <fdsubs at t-online.hu> 
Sent by: freetds-bounces at lists.ibiblio.org
04/19/2006 03:46 PM
Please respond to
FreeTDS Development Group <freetds at lists.ibiblio.org>


To
FreeTDS Development Group <freetds at lists.ibiblio.org>
cc

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







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
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list