FreeTDS Development Group

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

I really appreciate your help...here's the dump:

cshobe@sliver:/tmp$ cat freetds.log
2001-12-04 22:16:01 Connecting addr 192.168.24.6 port 1433
2001-12-04 22:16:01 inside tds_process_login_tokens()
Received packet @ 2001-12-04 22:16:01
0000  aa dc 00 14 48 00 00 01 0e 68 00 4c 00 6f 00 67   |....H....h.L.o.g|
0010  00 69 00 6e 00 20 00 66 00 61 00 69 00 6c 00 65   |.i.n. .f.a.i.l.e|
0020  00 64 00 20 00 66 00 6f 00 72 00 20 00 75 00 73   |.d. .f.o.r. .u.s|
0030  00 65 00 72 00 20 00 27 00 53 00 45 00 43 00 55   |.e.r. .'.S.E.C.U|
0040  00 52 00 45 00 57 00 4f 00 52 00 4b 00 53 00 5c   |.R.E.W.O.R.K.S.\|
0050  00 63 00 73 00 68 00 6f 00 62 00 65 00 27 00 2e   |.c.s.h.o.b.e.'..|
0060  00 20 00 52 00 65 00 61 00 73 00 6f 00 6e 00 3a   |. .R.e.a.s.o.n.:|
0070  00 20 00 4e 00 6f 00 74 00 20 00 61 00 73 00 73   |. .N.o.t. .a.s.s|
0080  00 6f 00 63 00 69 00 61 00 74 00 65 00 64 00 20   |.o.c.i.a.t.e.d. |
0090  00 77 00 69 00 74 00 68 00 20 00 61 00 20 00 74   |.w.i.t.h. .a. .t|
00a0  00 72 00 75 00 73 00 74 00 65 00 64 00 20 00 53   |.r.u.s.t.e.d. .S|
00b0  00 51 00 4c 00 20 00 53 00 65 00 72 00 76 00 65   |.Q.L. .S.e.r.v.e|
00c0  00 72 00 20 00 63 00 6f 00 6e 00 6e 00 65 00 63   |.r. .c.o.n.n.e.c|
00d0  00 74 00 69 00 6f 00 6e 00 2e 00 00 00 00 00 fd   |.t.i.o.n........|
00e0  02 00 00 00 00 00 00 00                           |........|


2001-12-04 22:16:01 inside tds_process_default_tokens() marker is aa
2001-12-04 22:16:01 Msg 18452, Level 14, State 1, Server , Line 0
Login failed for user 'SECUREWORKS\cshobe'. Reason: Not associated with a 
trusted SQL Server connection.
2001-12-04 22:16:01 inside tds_process_default_tokens() marker is fd
2001-12-04 22:16:01 leaving tds_process_login_tokens() returning 0


On 4 December 2001 17:56, Brian Bruns spaketh unto ye recipient:
> 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')
>
> ---
> You are currently subscribed to freetds as: [cshobe AT softhome.net]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')

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