FreeTDS Development Group

["Casey Allen Shobe" <cshobe AT osss.net>]

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