FreeTDS Development Group

["Gene Dymarskiy" <gagarin AT i-dep.com>]

This worked!

Thank you all very much 

-----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 7:30 PM
To: FreeTDS Development Group
Subject: RE: [freetds] Sybase ASA 7, unixODBC problem

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

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