FreeTDS Development Group

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

The guys here helped me to get this working. At the end all I had to do
is set environmental variable DSQUERY (used by unixODBC) to the name of
sybase connection used in freetds.conf, which in tern must be named
exactly as the name of Sybase server you are connecting to.  

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of jdyke
Sent: Wednesday, November 03, 2004 3:48 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Sybase ASA 7, unixODBC problem

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
> 

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