Re: SQL Server version and TDS Version
Vinh Nguyen <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Sat, Apr 17, 2010 at 11:01 AM, Vinh Nguyen <[email protected]> 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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds