[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