I would suspect it's something to do with NT security rather than ODBC or
ADO.
>From: Myles Penlington <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
>Subject: RE: [DUG]: Interbase via ADO from IIS/ASP
>Date: Fri, 23 Jul 1999 16:24:41 +1200
>
>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
><< attach3 >>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
