[freetds] unixODBC/FreeTDS Questions
Rob Garcia
rgarcia at tiagris.net
Wed Mar 31 18:04:06 EST 2004
Hi there!
I've got some problems bringing up unixODBC on a Solaris 2.9 box for use
with the Perl DBI. Here's the info on problem.
Thanks in advance for any assistance!
Best regards,
Rob
-----------------------------------------------------------------------
Testing via 'isql' returns the following:
# isql ebill_auth sa pass -v
[IM002][unixODBC][Driver Manager]Data source name not found, and no
default driver specified
[ISQL]ERROR: Could not SQLConnect
--- but, ---
Testing via 'tsql' returns the following:
# tsql -S ebill_auth -U sa
locale is
"/en_US.ISO8859-1/en_US.ISO8859-1/en_US.ISO8859-1/en_US.ISO8859-1/en_US.ISO8859-1/C"
locale charset is "ISO8859-1"
Password:
Msg 5703, Level 0, State 1, Server VOL-EBILL-1, Line 0
Changed language setting to us_english.
1>
-----------------------------------------------------------------------
'.ini' and '.conf' file contents:
<<<freetds.conf>>>
[global]
tds version = 4.2
initial block size = 512
swap broken dates = no
swap broken money = no
cross domain login = no
text size = 64512
[ebill_auth]
host = 192.168.254.130
port = 1433
tds version = 8.0
<<<odbc.ini>>>
[ODBC Data Sources]
[ebill_auth]
Driver = TDS
Description = radius auth server
Trace = No
Servername = ebill_auth
Database = ebill_main
UID = sa
<<<odbcinst.ini>>>
[TDS]
Description = v0.62 with protocol v8.0
Driver = /usr/local/lib/libtdsodbc.so
FileUsage = 1
-----------------------------------------------------------------------
Results of 'odbcinst -j':
# odbcinst -j
unixODBC 2.2.8
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
USER DATA SOURCES..: //.odbc.ini
-----------------------------------------------------------------------
More information about the FreeTDS
mailing list