Skip to Content.
Sympa Menu

freetds - [freetds] unixODBC/FreeTDS Questions

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rob Garcia <rgarcia AT tiagris.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] unixODBC/FreeTDS Questions
  • Date: Wed, 31 Mar 2004 17:04:06 -0600

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

-----------------------------------------------------------------------







Archive powered by MHonArc 2.6.24.

Top of Page