FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

It's not good you reply to a message digest...

Il lun, 2003-12-29 alle 20:37, Daughterson, Adam [EPM/BOU/MMI] ha
scritto:
> I set the environment variable TDSDUMPCONFIG to /usr/local/freetds/dumpo and
> ran:
> 
> root@USBOU1-DHDLINUX:~# cat /dev/null > /usr/local/freetds/dumpo
> root@USBOU1-DHDLINUX:~# tsql -S usbou1-scallog -U esp_it
> locale is "C"
> charset is "ANSI_X3.4-1968"
> Password:
> Msg 5703, Level 0, State 1, Server USBOU1-SCALLOG, Line 0
> Changed language setting to us_english.
> 1>
> root@USBOU1-DHDLINUX:~#
> 
> No problem...
> The contents of the dumpo file agrees:
> 
> root@USBOU1-DHDLINUX:~# cat /usr/local/freetds/dumpo
> Starting log file for FreeTDS 0.61.2 with debug level 99.
> 2003-12-29 13:15:08.764752 Attempting to read conf files.
> 2003-12-29 13:15:08.764913 ...$FREETDSCONF not set.  Trying $HOME.
> 2003-12-29 13:15:08.765570 Found conf file
> '/usr/local/freetds/etc/freetds.conf' (default). Reading section
> 'usbou1-scallog'.
> 2003-12-29 13:15:08.765617 Looking for section global.
> 2003-12-29 13:15:08.765688 ... Found section global.
> 2003-12-29 13:15:08.765711 Got a match.
> 2003-12-29 13:15:08.765734 option = 'tds version' value = '4.2'.
> 2003-12-29 13:15:08.765767 option = 'initial block size' value = '512'.
> 2003-12-29 13:15:08.765803 option = 'swap broken dates' value = 'no'.
> 2003-12-29 13:15:08.765825 no is a 'no/off/false'.
> 2003-12-29 13:15:08.765849 option = 'swap broken money' value = 'no'.
> 2003-12-29 13:15:08.765870 no is a 'no/off/false'.
> 2003-12-29 13:15:08.765896 option = 'try server login' value = 'yes'.
> 2003-12-29 13:15:08.765917 yes is a 'yes/on/true'.
> 2003-12-29 13:15:08.765940 option = 'try domain login' value = 'no'.
> 2003-12-29 13:15:08.765961 no is a 'no/off/false'.
> 2003-12-29 13:15:08.765987 option = 'cross domain login' value = 'no'.
> 2003-12-29 13:15:08.766008 no is a 'no/off/false'.
> 2003-12-29 13:15:08.766038 option = 'text size' value = '64512'.
> 2003-12-29 13:15:08.766066 ... Found section mypool.
> 2003-12-29 13:15:08.766097 ... Found section usbou1-scallog.
> 2003-12-29 13:15:08.766140 Looking for section usbou1-scallog.
> 2003-12-29 13:15:08.766188 ... Found section global.
> 2003-12-29 13:15:08.766252 ... Found section mypool.
> 2003-12-29 13:15:08.766282 ... Found section usbou1-scallog.
> 2003-12-29 13:15:08.766302 Got a match.
> 2003-12-29 13:15:08.766324 option = 'host' value = 'usbou1-scallog'.
> 2003-12-29 13:15:08.766345 Found host entry usbou1-scallog.
> 2003-12-29 13:15:08.768006 IP addr is 155.177.99.17.
> 2003-12-29 13:15:08.768086 option = 'port' value = '1433'.
> 2003-12-29 13:15:08.768115 option = 'tds version' value = '8.0'.
> 2003-12-29 13:15:08.768157 ...Success.
> root@USBOU1-DHDLINUX:~#
> 
> I tried using odbcinst to create a DSN, but that never seems to work, so
> this time I used your documentation(much more informative that the 'live'
> version on the freeTDS website!) to manually create all three types of
> odbc.ini.  I still get the same error with isql, but it doesn't seem to
> write to the log file...
> 
> root@USBOU1-DHDLINUX:~# isql -v esp_ms_sql esp_it real_passwd
> [S1000][unixODBC]Client unable to establish connection
> [ISQL]ERROR: Could not SQLConnect
> root@USBOU1-DHDLINUX:~#
> 
> Here's what my /usr/local/etc/odbc.ini looks like(staight odbc connection):
> 

Mmmm... are you sure isql look at your odbc.ini ? Try doing a

# cp /usr/local/etc/odbc.ini ~/.odbc.ini

> [ODBC Data Sources]
> esp_ms_sql = MS SQL Server
> 
> [esp_ms_sql]
> Driver =  /usr/local/freetds/lib/libtdsodbc.so
> Description =   MS SQL Server
> Trace = No
> Server =        155.177.99.17
> Database =    esp35_it

Try also to remove this line (Database=), it db is not present connect
fails...

> Port =  1433
> TDS_Version = 8.0
> 
> [Default]
> Driver =  /usr/local/freetds/lib/libtdsodbc.so
> root@USBOU1-DHDLINUX:~#
> 
> And here's what the logfile looks like after trying to connect:
> 
> root@USBOU1-DHDLINUX:~# cat /usr/local/freetds/dumpo
> root@USBOU1-DHDLINUX:~#
> 
> (totally empty...)
> 
> I did also try DSNless, as well as combined ODBC/freeTDS configurations.
> None seem to either connect, or write to the logfile.
> 
> Again, I truly appreciate this help.
> Adam Daughterson
> 

freddy77