Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: KParamasivam AT claritas.com
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] using freeTDS and DBD::Sybase to connect to Sybase Server
  • Date: Wed, 19 Apr 2006 16:16:06 -0400

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





Archive powered by MHonArc 2.6.24.

Top of Page