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
