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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]