Skip to Content.
Sympa Menu

freetds - FreeTDS woes..

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Casey Allen Shobe <cshobe AT softhome.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: FreeTDS woes..
  • Date: Tue, 4 Dec 2001 16:55:09 -0500


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--




Archive powered by MHonArc 2.6.24.

Top of Page