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]
