Skip to Content.
Sympa Menu

freetds - [freetds] Can connect with TDS, but not ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Casey Allen Shobe" <cshobe AT osss.net>
  • To: FreeTDS AT lists.ibiblio.org
  • Cc:
  • Subject: [freetds] Can connect with TDS, but not ODBC
  • Date: Tue, 17 Feb 2004 15:38:53 -0500 (EST)

Hi,

I've got the latest stable version of both FreeTDS and UnixODBC compiled
and installed. FreeTDS is installed in /usr/local/freetds, and UnixODBC
in /usr/local.

I can connect from perl using DBD::Sybase, and I can connect to a
PostgreSQL database using either DBD::Pg -or- DBD::ODBC, so I know that
UnixODBC is at least working to some extent. I've tried following the
instructions on freetds.org to no avail. Using DBD::Sybase is not an
option because placeholders are not supported by DBD::Sybase, which the
script depends on.

Here's my configuration files:

[root@core-devel root]# cat /usr/local/etc/odbcinst.ini
[PostgreSQL]
Driver = /usr/lib/libodbcpsql.so.2.0.0
Setup = /usr/lib/libodbcpsqlS.so

[TDS]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Setup = /usr/local/lib/liboplodbcS.so

[root@core-devel root]# cat /usr/local/etc/odbc.ini
[ODBC Data Sources]
smx_main = SMX Main Database
adreports = AD Reports Database

[smx_main]
Driver = PostgreSQL
Description = SMX Main Database
Trace = No
TraceFile = /tmp/odbc.log
Database = smx_main
Servername = localhost
UserName =
Password =
Port = 5432
Protocol = 7.2
ReadOnly = Yes
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =

[adreports]
Driver = /usr/local/freetds/lib/libtdsodbc.so
Description = AD Reports Database
Server = 172.16.0.216
Port = 1433
TDS_Version = 8.0
Database = adreports
UID = sa
Trace = No

[Default]
driver = /usr/local/freetds/lib/libtdsodbc.so

[root@core-devel root]# cat /usr/local/freetds/etc/freetds.conf
[global]
tds version = 8.0
port = 1433
try server login = yes
try domain login = no

[adreports]
host = 172.16.0.216
port = 1433
tds version = 8.0

Thanks in advance for any advice,

--
Casey Allen Shobe
Open Source Software Solutions
cshobe AT osss.net




Archive powered by MHonArc 2.6.24.

Top of Page