Skip to Content.
Sympa Menu

freetds - Re: 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: Re: FreeTDS woes..
  • Date: Tue, 4 Dec 2001 17:20:34 -0500


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




Archive powered by MHonArc 2.6.24.

Top of Page