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]
