Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Anywhere 11

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Johnson" <serversage AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Anywhere 11
  • Date: Wed, 26 Nov 2008 01:52:21 -0800

Thanks for the quick reply Daniel. As we don't use the freetds.conf file
for our connections, and we use DNS-less connections, I'm trying to
construct the connection string to include the dataserver name as well as
it's IP in it, but can't seem to dig up the information. I'm looking at:

http://www.freetds.org/userguide/dsnless.htm

And it shows an example with a dataserver entry in freetds.conf, and one
using a freetds.conf-less connection that has a server entry. Would I
simply add them both and come out with something like:

DRIVER=FreeTDS;SERVER=10.10.10.10
;SERVERNAME=DataServerName;UID=username;PWD=password;DATABASE=dbname;TDS_Version=5.0;Port=5000

Where 10.10.10.10 is the IP of the server, DataServerName would be the
dataserver name we get from the vendor, username is the username they give
us, password is the password they give us, dbname is the name of the
database we are connecting to? I would just try this, but we have to
contact the vendor tomorrow in order to get the dataserver name, and I want
to be armed with as much information as I can before that phone call.

Thanks again for the assistance!

-Brian

On Wed, Nov 26, 2008 at 1:21 AM, Daniel Fazekas <fdsubs AT t-online.hu> wrote:

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