Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Server version and TDS Version

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Vinh Nguyen <vinhdizzo AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] SQL Server version and TDS Version
  • Date: Sun, 18 Apr 2010 13:29:12 -0700

On Sat, Apr 17, 2010 at 11:01 AM, Vinh Nguyen <vinhdizzo AT gmail.com> wrote:
> My ultimate goal (for now) is to get freeTDS to work with unixODBC
> (isql and osql commands -- ultimately in emacs).  However, even though
> I can connect to the sql server using tsql, I can't with isql and osql
> -- it won't log me in.  I have a hunch that this has to do with the
> TDS version.  If I could get tsql to work at v8.0, then I can test the
> isql/osql commands again to see if I can rule this out.  I know
> unixODBC is recognizing my DSNs.  It just can't log in.

Also, here is the log from isql. I believe the problem comes from
freeTDS which is why I'm trying to get v8.0 or v7.0 to work (v4.2 is
specified in DSN):

[ODBC][95110][1271622355.290507][__handles.c][450]
Exit:[SQL_SUCCESS]
Environment = 0x100801a00
[ODBC][95110][1271622355.291193][SQLAllocHandle.c][364]
Entry:
Handle Type = 2
Input Handle = 0x100801a00
[ODBC][95110][1271622355.292086][SQLAllocHandle.c][482]
Exit:[SQL_SUCCESS]
Output Handle = 0x100821800
[ODBC][95110][1271622355.292470][SQLConnect.c][3614]
Entry:
Connection = 0x100821800
Server Name = [adrc][length = 4 (SQL_NTS)]
User Name = [vqnguyen][length = 8 (SQL_NTS)]
Authentication = [********][length = 8 (SQL_NTS)]
UNICODE Using encoding ASCII 'char' and UNICODE
'UCS-2-INTERNAL'

DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to
data source

[ODBC][95110][1271622355.302544][SQLConnect.c][3982]
Exit:[SQL_ERROR]
[ODBC][95110][1271622355.303003][SQLFreeHandle.c][279]
Entry:
Handle Type = 2
Input Handle = 0x100821800
[ODBC][95110][1271622355.303502][SQLFreeHandle.c][330]
Exit:[SQL_SUCCESS]
[ODBC][95110][1271622355.303728][SQLFreeHandle.c][212]
Entry:
Handle Type = 1
Input Handle = 0x100801a00




Archive powered by MHonArc 2.6.24.

Top of Page