I have..
The thing is I am doing the Cold Fusion remotely on a different computer on
the network.
I have set up the remote computer (where the Code and DB is stored)
datasource settings in Both NT and ColdFusion Admin..as well a the local
computer (my pc) datasource settings in both NT and ColdFusion Admin. I am
not sure if this is over-kill or required but as I said I am new to using a
DB other than Acss (which I haven't had many problems with before) and
working remotely, so to speak.
Thanks,
Martin.
>From: [EMAIL PROTECTED] (Brian bouldernet)
>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:25:14 -0700
>
>Hey... to make it simple go through Cold Fusion ODBC. do this by pointing
>your browser to something like
>http://yourserver.com/cfide/Administrator/index.cfm
>
>Create the ODBC that way...
>
>
>----- Original Message -----
>From: Marius Milosav <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Sent: Sunday, October 29, 2000 7:15 PM
>Subject: Re: ODBC Error Code = S0002 (Base table not found)
>
>
> > 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]
> >
>
>------------------------------------------------------------------------------------------------
>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]