Miles,
I've used Interbase from ASP before - nothing special about the setup.
Are
you using Local Interbase by any chance? It does its stuff via IPC's and
shared memory, and it blows chunks if you go accross user security
boundries.
Below is some code I used - might be usefull to you? I made no changes
from what I would use to hit MSSQL, except for the UID and PWD.
N
from somepage.
Dim SQLText, NewsRS
CreateConn()
SQLText = "select * from newsitem order by newsid desc"
Set NewsRS = Server.CreateObject("ADODB.RecordSet")
NewsRS.Open SQLText, Conn, 0, 1
from global.asa
Session("DUG_ConnectionString") = "DSN=DUG;UID=SYSDBA"
Session("DUG_ConnectionTimeout") = 15
Session("DUG_CommandTimeout") = 30
Session("DUG_RuntimeUserName") = "SYSDBA"
Session("DUG_RuntimePassword") = "masterkey"
The CreateConn function
Sub CreateConn()
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = Session(Session("ProjName") &
"_ConnectionTimeout")
Conn.CommandTimeout = Session(Session("ProjName") & "_CommandTimeout")
Conn.Open Session(Session("ProjName") &
"_ConnectionString"),Session(Session("ProjName") & "_RuntimeUserName"),
Session(Session("ProjName") & "_RuntimePassword")
End Sub
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
