Wanna post your code (the asp page, mostly)
N
----- Original Message -----
From: "Jeremy Coulter" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Tuesday, August 01, 2000 6:03 PM
Subject: RE: [DUG]: Interbase 6 targeted by ASP
> Ok...well I tried that, and got THIS error :-
>
> [INTERSOLV][ODBC InterBase driver]Optional feature not implemented.
>
> AGH !!!!!
>
> Any Ideas ??
>
> Cheers, Jeremy
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Nic Wise
> > Sent: Tuesday, August 01, 2000 4:37 PM
> > To: Multiple recipients of list delphi
> > Subject: [DUG]: Interbase 6 targeted by ASP
> >
> >
> >
> > OK people, I got it running very easily after getting the updated
> > IBConsole, which was the entire problem I was having with the linux
> > version.
> >
> > So, here's what I did.
> >
> > 1. install IBLinux on my linux box. I tried this against an NT box and
it
> > worked too.
> > 2. install the client on my laptop. I can't use the server on my
> > laptop 'cos
> > I have a 3rd party app (saleslogix) that uses 5.6.
> > 3. made and ODBC DSN using the Intersolv driver which was
> > installed. I have
> > the visi one as well as 2 instances of the intersolv one, and I dont
know
> > which one the client install installed. I'd guess the intersolv
> > one. If not,
> > get the 5.6 "pack" down off interbase.com, and install JUST the
> > ODBC driver
> > before installing the 6.0 client.
> >
> > 4. fired up delphi 5 ent. and connected with ADO, just to generate the
> > connection string:
> >
> > Provider=MSDASQL.1;Password=masterkey;Persist Security Info=True;User
> > ID=sysdba;Data Source=testaspib
> >
> > the params from testaspib system DSN were:
> >
> > alias: testaspib
> > database: 192.168.100.101:/root/ibtest.gdb
> >
> > 5. fired up this ASP page:
> > <HTML>
> > <BODY>
> > <%
> > set conn = server.createobject("adodb.connection")
> >
> > conn.open "Provider=MSDASQL.1;Password=masterkey;Persist Security
> > Info=True;User ID=sysdba;Data Source=testaspib"
> >
> > set rs = conn.execute("select * from test")
> >
> > while not rs.eof
> > %>[<%=rs("pk")%>]<%=rs("s")%><BR><%
> > rs.movenext
> > wend
> > %>
> > </BODY>
> > </HTML>
> >
> >
> > 6. got the expected results (after crashing IIS when I forgot the
> > rs.movenext)
> >
> > I can't get the visigenic driver to work AT ALL, not even connect. The
> > Intersolv one works fine.
> >
> > N
> > --
> > Nic Wise - [EMAIL PROTECTED] / Inprise/Borland New Zealand
> > main line: 09.360.0231 / ddi: 09.360.6713 / cell: 021.676.418
> >
> >
> > ------------------------------------------------------------------
> > ---------
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> >
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
