FreeTDS Development Group

[Casey Allen Shobe <cshobe AT softhome.net>]

I'm still in utter failure after a full day's work.

I finally got the thing to seemingly install correctly (at least to the point 
that I could start Apache/PHP and still use DB2) by using iODBC.  I pointed 
iODBC at my db2 stuff and db2 queries work fine!

However, the FreeTDS stuff seems to be getting nowhere...

odbc.ini:
[ODBC Data Sources]
sw_p    = IBM DB2 Connect Driver
pivotal = FreeTDS Driver

[Default]
driver = /usr/lib/oplodbc.so.1

[sw_p]
Description     = DB2 Production Database
Options         = sw_p
Port            = 523
Protocol        = TCP/IP
Driver          = /usr/DBMdb2/V7.1/lib/libdb2.so.1
Database        = sw
FetchBufferSize = 99

[pivotal]
Description     = Pivotal Production Database
Options         = sw_enterprise_data
Port            = 1433
Host            = 192.168.24.6
ServerType      = SQLServer 2000
Protocol        = TCP/IP
Driver          = /usr/lib/libtdsodbc.so
Database        = sw_enterprise_data
FetchBufferSize = 99
Trace           = No



odbcinst.ini:
[ODBC Drivers]
IBM DB2 Connect Driver = Installed
FreeTDS Driver = Installed

[IBM DB2 Connect Driver]
Driver  = /usr/IBMdb2/V7.1/lib/libdb2.so.1
Setup   = /usr/IBMdb2/V7.1/lib/libdb2.so.1

[FreeTDS Driver]
Driver  = /usr/lib/libtdsodbc.so
Setup   = /usr/lib/libtdsodbc.so



test.php:
<?php

$piv_conn = odbc_connect ('pivotal', 'SECUREWORKS\cshobe', 'password');
$dbtest = odbc_exec ($piv_conn, 'select * from company');

?>



I get the following when I try to load it:

Warning: SQL error: Could not find Database parameter, SQL state 08001 in 
SQLConnect in test.php on line 3.
Warning: Supplied argument is not a valid ODBC-Link resource in test.php on 
line 4.


Help please!!  I'm stuck and don't know where to go from here.

-- 
Casey Allen Shobe
cshobe AT softhome.net
GCS/CM d+ s+:->+: a-- C++(++++) ULU++++$ P- L+++>++++ E- W++ N++ !o K- w-- !O
M V- PS++ PE Y+ PGP>++ t+ 5+ X R>+ tv-- b++ DI+ D---- G++ e h-(*) r--- z--