FreeTDS Development Group

[jdyke <jdyke AT azimapower.com>]

Lowden, James K wrote:
> > From: Gene Dymarskiy
> > Sent: Tuesday, November 02, 2004 5:42 PM
> >
> > Some additional info.
> >
> > TDSDUMPs for tsql and isql connections look different. 
> >
> > Note: the name of the database I am connecting to is "needles".    The
> > name is being passed with tsql but not with isql if I read the dumps
> > properly.
Gene.

I don't know if you fixed this, but i ran into exactly the same issue with ASA9 
and found out that only Sybase 12 is supported through this method(from reading 
your posts, our sucesses and failures are identical).  In order for me to 
connect from *nix to W2k3 running ASA9.01 i needed to install the ODBC->ODBC 
Bridge software.

HTH
Jeff

PS.  If you find that this is incorrect and you are able to connect just using 
freetds and unixodbc, please let me know. :)

> tsql snippet:
>
> > 13:04:39.519751 Connecting to 192.168.1.5 port 2638, TDS 5.0.
> > Sending packet @ 13:04:39.560330
> > ...
> > 00b0 00 00 04 6e 65 65 64 6c-65 73 00 00 00 00 00 00 |...needl
>
> es......|
>
> isql snippet:
>
> > pid: 9258:13:06:10.059606 Connecting to 192.168.1.5 port 2638, TDS
>
> 5.0.
>
> > pid: 9258:Sending packet @ 13:06:10.372320
> > ...
> > 00b0 00 00 00 53 59 42 41 53-45 00 00 00 00 00 00 00 |...SYBAS
>
> E.......|
>
> Something's missing.  
>
> As you say, the tsql connection is passing "needles" correctly, and the
> isql one is not.    We're looking at offset 179 in the login packet,
> which, according to http://www.freetds.org/tds.html#login, is the
> Servername field.  
>
> We know that there's nothing isql itself can do set that field; there's
> no interface to that part of the login packet.  (At least that's true
> for db-lib; I don't think there's one for ODBC, either.) That means
> FreeTDS is inserting the 'SYBASE' string.  Why would it do that?  That's
> the default last-ditch name, what it uses when it can't find any name.  
>
> However, src/tds/config.c *did* do something right, because it correctly
> looked up the ip address, port, and TDS version.  No chance you have a
> [SYBASE] entry in freetds.conf, is there?  
>
> I suggest you set TDSDUMPCONFIG, try both commands again, and compare
> them.  Are they looking up the same name, and finding the same entries?
>
>
> --jkl
>
> -----------------------------------------
> The information contained in this transmission may contain privileged and 
> confidential information and is intended only for the use of the person(s) 
> named above. If you are not the intended recipient, or an employee or agent 
> responsible for delivering this message to the intended recipient, any 
> review, dissemination, distribution or duplication of this communication is 
> strictly prohibited. If you are not the intended recipient, please contact 
> the sender immediately by reply e-mail and destroy all copies of the original 
> message. Please note that we do not accept account orders and/or instructions 
> by e-mail, and therefore will not be responsible for carrying out such orders 
> and/or instructions.
> If you, as the intended recipient of this message, the purpose of which is to inform 
> and update our clients, prospects and consultants of developments relating to our 
> services and products, would not like to receive further e-mail correspondence from the 
> sender, please "reply" to the sender indicating your wishes.  In the U.S.: 
> 1345 Avenue of the Americas, New York, NY 10105.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds