This gets more interesting - the following code works okay on my machine (NT4
Workstation) & Office 97, but does not on the other which has an Office 2000 version
installed (NT4 Server).
const
SELECTSTRING = 'SELECT * FROM Employees';
DSNSTRING = 'DSN=TADEV;UID=SYSDBA;PASSWORD=masterkey';
var
RecordSet: OleVariant;
begin
// Create an empty recordset object
RecordSet := CreateOleObject('ADODB.Recordset');
// Fill the recordset
RecordSet.Open(SELECTSTRING, DSNSTRING);
end;
Other ODBC drivers appear to work okay, it's just the visigenic interbase one causing
the problem.
Don't know if its a OLE DB or ADO problem, or the Visigenic ODBC driver problem.
It would appear from expermintation that no matter what the UID and PASSWORD
specified, that the same error is returned.
Myles.
-----Original Message-----
From: Jeremy Coulter [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 23, 1999 1:19 PM
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase via ADO from IIS/ASP
can you send a sample of the code you are using ??
I.e. esp. the code where you are creating the ADO connection etc.
Thanks, Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Myles Penlington
> Sent: Friday, July 23, 1999 13:08
> To: Multiple recipients of list delphi
> Subject: [DUG]: Interbase via ADO from IIS/ASP
>
>
> Hi,
>
> We are tying to test a connection to an Interbase database from
> IIS using ASP and ADO connections. The ODBC Driver is setup and
> works fine, however this all falls over from IIS.
>
> We keep getting "database unavailable" error returned from the
> Visigenic ODBC driver.
>
> I can test the same ADO connection string from Delphi using ADO
> and variants and it works okay, however from ASP it falls over -
> Any hints as to what's wrong????
>
> Regards
>
> Myles Penlington
> ADVANCED MANAGEMENT SYSTEMS
>
> ------------------------------------------------------------------
> ---------
> 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
application/ms-tnef
