Skip to Content.
Sympa Menu

freetds - Re: [freetds] Sybase ASA 7, unixODBC problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: lsunley AT mb.sympatico.ca
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Sybase ASA 7, unixODBC problem
  • Date: Sat, 06 Nov 2004 17:59:49 -0500

In <20041106185815.3a3cd0c1.jklowden AT schemamania.org>, on 11/06/04
at 06:58 PM, "James K. Lowden" <jklowden AT schemamania.org> said:

>lsunley AT mb.sympatico.ca wrote:
>> >The issue, we know: the ODBC driver does not set the servername field
>> >of the login packet before connecting. It should call tds_set_server()
>> >when it discovers the servername, although it's not clear what "server
>> >name" means when freetds.conf isn't used.

>> Is the servername supposed to be the resolved host name of the server?

>No. The "servername" in this case is a field passed to the server in the
>login packet. It's the dataserver name, the [servername] in the
>freetds.conf file, the name the client application uses to open a
>connection.

>Most servers ignore it, afaik. ASA requires it, because it uses it as
>the name of the database to "start".

>The ct-lib and db-lib libraries fill the field correctly; the ODBC driver
>stuffs in 'SYBASE' instead. That be the problem.

>Hope that's clear. :-)

Yes,

I'll take a quick look at the ODBC code, it should be really simple to
put in an additional key in the odbc.ini for that value and pass it along
to the right spot.

Lorne

--
-----------------------------------------------------------
lsunley AT mb.sympatico.ca
-----------------------------------------------------------





Archive powered by MHonArc 2.6.24.

Top of Page