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 20:29:45 -0500

When I was digging through the code...

You can set the environment variable DSQUERY to the server name and that
will be used by tds_set_server

More news at 11 ...

Lorne

In <DD7A861A4B391843998031C3E19578D82418B9 AT MAIL.i-dep.com>, on 11/06/04
at 06:13 PM, "Gene Dymarskiy" <gagarin AT i-dep.com> said:

>Great idea! there is got to be a way to pass this value form odbc.ini
>Like "databasename" field or such. please let me know if any luck. Thank
>you for looking into this
>-----Original Message-----
>From: freetds-bounces AT lists.ibiblio.org
>[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
>lsunley AT mb.sympatico.ca
>Sent: Saturday, November 06, 2004 5:00 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] Sybase ASA 7, unixODBC problem

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

>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds

>

>......CONFIDENTIALITY NOTICE......
>The information in this email may be confidential and/or privileged.
>This email is intended to be reviewed by only the individual or
>organization named above. If you are not the intended recipient or an
>authorized representative of the intended recipient, you are hereby
>notified that any review, dissemination or copying of this email and its
>attachments, if any, or the information contained herein is prohibited.
>If you have received this email in error, please immediately notify the
>sender by return email and delete this email from your system. Thank
>You.


>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds

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





Archive powered by MHonArc 2.6.24.

Top of Page