take off all references of dbo.
----- Original Message -----
From: Martin S <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Sunday, October 29, 2000 5:14 PM
Subject: ODBC Error Code = S0002 (Base table not found)
> Hello all,
>
> I have been using coldFusion now for almost a year, including interacting
> with DB (before just MS.Access). Now I am a sole developer on a project
> requiring interfacing with Ms.SQl Server. This new adventure is seeing my
> we problems I have never seen before.
>
> Before I go in to the problem, to my knowledge I have the DB source set up
> corretly (in both CFAMINISTRATOR and WIN NT). I have created a query in
> ColdFusion successfully using the Query Builder. Within the query buildr
I
> can exeute the query with no problems. However, when I drag and drop the
> Query in to my page, and run the page the following error occurs (however,
> as I said this error didn't occur in the ColdFusion Query Builder) :
>
> 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')"
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (9:1) to (10:26).
>
>
> Date/Time: 10/30/00 10:55:36
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
> Remote Address: 203.43.104.222
> Template: C:\Inetpub\wwwroot\TGV-Admin\MerchantFindAction.cfm
>
> --------------------------------------------------------------------------
------
>
> On the side I am using ColdFusion 4.0 currently. Work hasn't upgraded :-(
>
> Thanks for your help..please CC your reply to [EMAIL PROTECTED] - I
check
> this email much more regulary - several times daily.
>
> Thanks in advance.
> Adios.
>
>
>
>
>
>
> _________________________________________________________________________
> 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/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]
>
------------------------------------------------------------------------------------------------
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]
