Prefix your table with the name of the table owner, eg.
select * from [dbo].[sometable]
SQL Server 2K has slightly different interpretation of security, especially
when it comes to creating objects.
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 13 June 2001 10:13
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: ADO components and SQL 2K
>
>
> hmm...thats weired....I am LOOKING at the table I am doing the Query
> on....might be an access right thing then...
>
>
> Thanks, Jeremy Coulter
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Paul Ritchie
> Sent: Wednesday, 13 June 2001 09:52
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: ADO components and SQL 2K
>
>
>
> MSDN says 0x80040E37 is "The specified table does not exist".
> http://support.microsoft.com/support/kb/articles/Q168/3/54.asp
>
>
> Paul Ritchie
> Radio Computing Services Ltd.
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 13, 2001 9:47 PM
> > To: Multiple recipients of list delphi
> > Subject: [DUG]: ADO components and SQL 2K
> >
> >
> > Hi all.
> >
> > I just went to use the ADO components in Delphi 5 with SQL 2K
> > server, and got an OLE error when I tried to connect.
> >
> > I am ruunin gth update for MDAC 2.6 or whatever that is on
> > the Borland website, but still no luck.
> >
> > The error is "OLE Error 80040E37"
> >
> > Has anyone seen this problem ? is there a way to sort it ?
> >
> > Thanks, Jeremy Coulter
> >
> >
> >
> > Jeremy Coulter (Manager)
> > Visual Software Solutions
> > Christchurch, New Zealand
> > PH 03-3521595
> > FAX 03-3521596
> > MOBILE 021-2533214
> > www.vss.co.nz
> >
> > --------------------------------------------------------------
> > -------------
> > New Zealand Delphi Users group - Delphi List -
> > [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
