I have tried removing the .dbo before and no that didn't seem to work.
I have also tried to add the name of the datasource (db) to the beginning
(ie.db.dbo.blahblah). This was just in a rage of brain storming and that
didn't work. Is that what you were talking about by saying myDB.db.blahblah
or something else, if so can you elaberate a little further.
I know about th * being bad form..just a temp test DB page :-) Thanks
anyway.
Thanks again all.
>From: "Stephen M. Aylor" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: ODBC Error Code = S0002 (Base table not found)
>Date: Sun, 29 Oct 2000 16:34:35 -0800
>
>
>It will likely be advised that you consider changing your "Select *" to the
>actual field/columns you need.
>
>Select myDB.dbo.Billers.Merchant_Name,
> myDB.dbo.Billers.Merchant_Address1,
> myDB.dbo.Billers.Merchant_ZipCode,
> myDB.dbo.Billers.Merchant_Shoe_Size, etc.........
>
>many around here consider Select* to be bad form. tho thats not likely
>causing your error.
>
>you may need the database.owner.tablename syntax :
>
>.... Merchant_Name FROM database_name.dbo.Billers WHERE (Merchant_Name ....
>
>or even:
>
>.... Merchant_Name FROM sql_server_name.database_name.dbo.Billers WHERE
>......
>
>-------------------------------------------------------
>
> > Error Occurred While Processing Request
> > Error Diagnostic Information
> > ODBC Error Code = S0002 (Base table not found)
> >
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> > 'dbo.Billers'.
> >
> >
> > SQL = "SELECT *, Merchant_Name FROM dbo.Billers WHERE (Merchant_Name
>LIKE
> > '43')"
> >
>
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
