Ok thanks for that Nick.
Your Connect String has a few extra bits that mine didn't..which is prob.
the problem is some respects, but I dont have linux on a michine, but I do
have it on a win95 machine I can test the connection with.
I was REALLY hoping to use it on the local server rather than on another
machine.
BUT if I am using a TCP/IP connections, then the other thing I ned to do is
specifi the server and the database too ??
i.e. 192.168.0.1:e:\database\mydatabase.gdb
192.168.0.1 being the internet server's ip address.
Would this be right ??
thanks, 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
