Or that :-) depends ....
> take off all references of dbo.
> ----- Original Message -----
> From: Martin S <[EMAIL PROTECTED]>
> > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
