FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Well it got further. set the TDSDUMP variable and run:

export TDSDUMP=/tmp/freetds.log

and then run and post the log file (please remove your username/password 
if they are important).

Brian

On Tue, 4 Dec 2001, Casey Allen Shobe wrote:

> Added to odbe.ini under [pivotal]:
> 
> Servername    = pivotal
> 
> Added to freetds.conf:
> [pivotal]
>       host = 192.168.24.6
>       port = 1433
>       tds version = 7.0
> 
> Now the script generates:
> 
> Warning: SQL error: tds_connect failed, SQL state 08001 in SQLConnect in 
> test.php...
> 
> - Casey
> 
> On 4 December 2001 17:08, Brian Bruns spaketh unto ye recipient:
> > You need a entry in the odbc.ini file (under the pivotal section)
> >
> > [pivotal]
> > ...
> > Servername = <yourservername>
> > ...
> >
> > Where <yourservername> is the server alias listed in your freetds.conf
> > file.  I would highly recommend grabbing sqsh (www.sqsh.org) and building
> > it to make sure your freetds install and freetds.conf file are correct.
> >
> > This was discussed about a week ago on the list and a change was checked
> > in then to say 'Servername' instead of 'Database'.  i.e. There's an error
> > in the error message. :-/
> >
> > Cheers,
> >
> > Brian
> >
> > P.S. Is it just me, or has there been a whole rash of ODBC questions
> > lately?
> >
> > On Tue, 4 Dec 2001, Casey Allen Shobe wrote:
> > > 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.
> >
> > ---
> > You are currently subscribed to freetds as: [cshobe AT softhome.net]
> > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> 
>