FreeTDS Development Group

[lsunley AT mb.sympatico.ca]

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

>I absolutely have to figure it out. I have to be able to connect to ASA
>from PHP on Linux platform. What can I do to help? Should I mobilize
>unixodbc people? Can  I use anything other than unixodbc to connect?
>Looks like php sybase works with ASE, not ASA.  Are there any other
>freetds ASA ODBC drivers I can use? (forgive me for breach of loyalty)  

>Thank you for all the help

>-----Original Message-----
>From: freetds-bounces AT lists.ibiblio.org
>[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
>Sent: Saturday, November 06, 2004 4:48 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] Sybase ASA 7, unixODBC problem

>"Gene Dymarskiy" <gagarin AT i-dep.com> wrote:
>>
>> It would not build with the patch. I get the following error:
>> 
>> odbc.c: In function `odbc_connect':
>> odbc.c:293: error: structure has no member named `tds_login'

>I'm sorry, Gene.  I see the problem, two problems, actually.  One is that
>odbc_connect() doesn't have access (afaict) to a TDSLOGIN structure. Two
>is that the ODBC driver doesn't get the configuration information the
>same way that db-lib and ct-lib do, by calling
>tds_read_config_info().  I guess it re-implements that logic somewhere,
>but having just spent 30 minutes looking for it, I give up.  It's just
>too painful.  

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

>Perhaps someone more familiar with and more enthusiastic about the code
>can figure out where that call should be made.  Until then, it won't
>connect to ASA servers.  :-(

>Regards, 

>--jkl

I'm coming into this a little late but...

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

The ODBC code picks up a "server name" that is supposed to be the DNS name
of the server or the host IP address. Should there be something else?

Lorne

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