Marius et al.
Yes, that is all correct as far as I can tell thus can't be causing the
error.
the dot notion in the query..hould I do datasourcename.db.fieldname or
something else? Cos someone was touching on that before..but I couldn't
understand their post.
Thanks, Martin.
>From: "Marius Milosav" <[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 21:15:15 -0500
>
>If the database name is correct, check that you authenticate using SQL
>server authentication and you provide the same login information in
>ColdFusion Administrator.
>
>Also, I hope that you created the ODBC datasource as System DSN
>
>Marius Milosav
>www.scorpiosoft.com
>Virtual Help Desk Demo (VHD)
>www.scorpiosoft.com/vhd/login.cfm
>----- Original Message -----
>From: "Martin S" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Sunday, October 29, 2000 8:57 PM
>Subject: Re: ODBC Error Code = S0002 (Base table not found)
>
>
> > Marius and all,
> >
> > Sorry about this. I am new to accessing DBs other than Access in
> > COldFusion..so excuse my ignorance when it comes to this.
> >
> > I belive I have done what you say, but please verify this with me, as I
>am
> > after all new to this frontier.
> >
> > I just went to confirm this from the ontrol Panel, ODBC DS, System DSN,
>and
> > it was all there..I checked it etc..
> >
> > and at the end it came up with this test successfull result :
> > Microsoft SQL Server ODBC Driver Version 03.70.0623
> >
> > Data Source Name: BP
> > Data Source Description: Internet Billpay Staging box
> > Server: ###.####....
> > Database: TGV
> > Language: (Default)
> > Translate Character Data: Yes
> > Log Long Running Queries: No
> > Log Driver Statistics: No
> > Use Integrated Security: No
> > Use Regional Settings: Yes
> > Prepared Statements Option: Drop temporary procedures on disconnect
> > Use Failover Server: No
> > Use ANSI Quoted Identifiers: Yes
> > Use ANSI Null, Paddings and Warnings: Yes
> >
> > Whwere does this leave me?
> >
> > >From: "Marius Milosav" <[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 20:55:00 -0500
> > >
> > >When you created the ODBC datasource, you have to point to the database
>you
> > >want to connect. By default its the master dB.
> > >Go in Control Panel\ODBC and edit the datasource. This should fix the
> > >problem
> > >
> > >Marius Milosav
> > >www.scorpiosoft.com
> > >Virtual Help Desk Demo (VHD)
> > >www.scorpiosoft.com/vhd/login.cfm
> > >----- Original Message -----
> > >From: "Martin S" <[EMAIL PROTECTED]>
> > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > >Sent: Sunday, October 29, 2000 8:22 PM
> > >Subject: Re: ODBC Error Code = S0002 (Base table not found)
> > >
> > >
> > > > 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/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]
> > > >
> > > >
> >
> >_________________________________________________________________________
> > > > 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]
> >
> >
>_________________________________________________________________________
> > 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]
_________________________________________________________________________
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]
