Skip to Content.
Sympa Menu

freetds - [freetds] Freetds 0.60.1 vs freetds 0.62.3 and unixODBC 2.2.8

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Novick, Jeff" <novickj AT toysrus.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Freetds 0.60.1 vs freetds 0.62.3 and unixODBC 2.2.8
  • Date: Thu, 13 May 2004 11:23:54 -0400

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.




Archive powered by MHonArc 2.6.24.

Top of Page