FreeTDS Development Group

["Novick, Jeff" <novickj AT toysrus.com>]

Hi, all,
        I have a small problem with freetds and unixODBC.
When I use freetds 0.60.1, I can connect to my MS SQL server via unixODBC
and when using 0.62.3 I cannot.
Here's the weird thing, tsql works with both versions, but isql spits out a
login incorrect message.

Is this a freetds or unixODBC problem?
How can I help you to help me troubleshoot this?

Thank you,
Jeff

0.62.3 output
isql orderwareDTM sa -v -x0x09
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
[][unixODBC][FreeTDS][SQL Server]Login failed for user 'sa'.
[][unixODBC][FreeTDS][SQL Server]Cannot open database requested in login
'dbo'. Login fails.
[ISQL]ERROR: Could not SQLConnect

tsql -S orderwareDTM -U sa
locale is "C"
locale charset is "ANSI_X3.4-1968"
Password:
Msg 5703, Level 0, State 1, Server GFSDB, Line 0
Changed language setting to us_english.
1> select * from bru.dbo.bru_action_log with (nolock) where action='PULSE'
and date >= dateadd(hh,-2,getdate()) order by date desc
2> go
ACTION  DATE    NOTE
PULSE   May 13 2004 10:30AM     Its ALIVE
PULSE   May 13 2004 09:30AM     Its ALIVE
1>


0.60.1 output
isql orderwareDTM sa -v -x0x09
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from bru.dbo.bru_action_log with (nolock) where action='PULSE'
and date >= dateadd(hh,-2,getdate()) order by date desc
PULSE   May 13 2004 10:30AM     Its ALIVE
PULSE   May 13 2004 09:30AM     Its ALIVE
SQL>

tsql -S orderwareDTM -U sa
Password:
Msg 5703, Level 0, State 1, Server GFSDB, Line 0
Changed language setting to us_english.
1> select * from bru.dbo.bru_action_log with (nolock) where action='PULSE'
and date >= dateadd(hh,-2,getdate()) order by date desc
2> go
ACTION  DATE    NOTE
PULSE   May 13 2004 10:30AM     Its ALIVE
PULSE   May 13 2004 09:30AM     Its ALIVE
1>

======================================================================== 
This email message is for the sole use of the intended recipient (s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies
of the original message. To reply to our email administrator directly, send
an email to EmailAdmin AT toysrus.com. 
Toys "R" Us, Inc.