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/[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]
> > >
> >
>
>---------------------------------------------------------------------------
---------------------
> >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]
------------------------------------------------------------------------------------------------
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]
