FreeTDS Development Group

[Vinh Nguyen <vinhdizzo AT gmail.com>]

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