FreeTDS Development Group

[lsunley AT mb.sympatico.ca]

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