FreeTDS Development Group

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

Thank you for reply.

No, I do not have Sybase entry in freetds.conf 

TDSDUMPCONFIG dumps look identical to me:

 cat freetds_conf_tsql.log (successful tsql connection):

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Starting log file for FreeTDS 0.62.1
        on 2004-11-03 13:59:22 with debug level 99.
13:59:22.908364 Attempting to read conf files.
13:59:22.908386 ...$FREETDSCONF not set.  Trying $FREETDS/etc.
13:59:22.908402 ...$FREETDS not set.  Trying $HOME.
13:59:22.908787 Found conf file '/etc/freetds.conf' (default). Reading
section 'needles'.
13:59:22.908810 Looking for section global.
13:59:22.908847 ... Found section global.
13:59:22.908863 Got a match.
13:59:22.908880 option = 'tds version' value = '4.2'.
13:59:22.908903 option = 'dump file' value = '/tmp/freetds.log'.
13:59:22.908921 option = 'debug level' value = '10'.
13:59:22.908938 option = 'timeout' value = '10'.
13:59:22.908955 option = 'connect timeout' value = '10'.
13:59:22.908973 option = 'text size' value = '64512'.
13:59:22.908991 ... Found section jdbc.
13:59:22.909009 ... Found section jdbc_42.
13:59:22.909027 ... Found section mypool.
13:59:22.909050 ... Found section needles.
13:59:22.909073 Looking for section needles.
13:59:22.909100 ... Found section global.
13:59:22.909126 ... Found section jdbc.
13:59:22.909144 ... Found section jdbc_42.
13:59:22.909162 ... Found section mypool.
13:59:22.909184 ... Found section needles.
13:59:22.909199 Got a match.
13:59:22.909214 option = 'host' value = '192.168.1.5'.
13:59:22.909229 Found host entry 192.168.1.5.
13:59:22.909249 IP addr is 192.168.1.5.
13:59:22.909265 option = 'port' value = '2638'.
13:59:22.909282 option = 'tds version' value = '5.0'.
13:59:22.909298 option = 'dump file append' value = 'yes'.
13:59:22.909314 yes is a 'yes/on/true'.
pid: 13476:13:59:22.909332 option = 'dump file' value =
'/tmp/freetds.log'.
pid: 13476:13:59:22.909351 option = 'client charset' value = 'UTF-8'.
pid: 13476:13:59:22.909368 tds_config_login:444: client charset is
UTF-8.
pid: 13476:13:59:22.909386 ...Success.
pid: 13476:13:59:22.909412 tds_config_login:474: client_charset is
UTF-8.
~~~~~~~~~~~~~~~~~~

 cat freetds_conf_isql.log ( dump from isql, not working):

~~~~~~~~~~~~~~~~~
Starting log file for FreeTDS 0.62.1
        on 2004-11-03 13:56:42 with debug level 99.
13:56:42.260459 Attempting to read conf files.
13:56:42.260482 ...$FREETDSCONF not set.  Trying $FREETDS/etc.
13:56:42.260497 ...$FREETDS not set.  Trying $HOME.
13:56:42.260896 Found conf file '/etc/freetds.conf' (default). Reading
section 'needles'.
13:56:42.260920 Looking for section global.
13:56:42.260960 ... Found section global.
13:56:42.260976 Got a match.
13:56:42.260992 option = 'tds version' value = '4.2'.
13:56:42.261015 option = 'dump file' value = '/tmp/freetds.log'.
13:56:42.261033 option = 'debug level' value = '10'.
13:56:42.261050 option = 'timeout' value = '10'.
13:56:42.261068 option = 'connect timeout' value = '10'.
13:56:42.261086 option = 'text size' value = '64512'.
13:56:42.261104 ... Found section jdbc.
13:56:42.261122 ... Found section jdbc_42.
13:56:42.261140 ... Found section mypool.
13:56:42.261163 ... Found section needles.
13:56:42.261188 Looking for section needles.
13:56:42.261215 ... Found section global.
13:56:42.261242 ... Found section jdbc.
13:56:42.261260 ... Found section jdbc_42.
13:56:42.261278 ... Found section mypool.
13:56:42.261300 ... Found section needles.
13:56:42.261315 Got a match.
13:56:42.261331 option = 'host' value = '192.168.1.5'.
13:56:42.261346 Found host entry 192.168.1.5.
13:56:42.261367 IP addr is 192.168.1.5.
13:56:42.261383 option = 'port' value = '2638'.
13:56:42.261400 option = 'tds version' value = '5.0'.
13:56:42.261417 option = 'dump file append' value = 'yes'.
13:56:42.261433 yes is a 'yes/on/true'.
pid: 13430:13:56:42.261451 option = 'dump file' value =
'/tmp/freetds.log'.
pid: 13430:13:56:42.261470 option = 'client charset' value = 'UTF-8'.
pid: 13430:13:56:42.261488 tds_config_login:444: client charset is
UTF-8.
pid: 13430:13:56:42.261506 ...Success.
pid: 13430:13:56:42.261533 tds_config_login:474: client_charset is
UTF-8.
~~~~~~~~~~

What could it possibly be?

I appreciate your help, truly

gd

 

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of 
> Lowden, James K
> Sent: Wednesday, November 03, 2004 11:25 AM
> To: FreeTDS Development Group
> Subject: RE: [freetds] Sybase ASA 7, unixODBC problem
> 
> > 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.
> 
> 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
> 

 

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