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
