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