ALAS, Your a legend, it works now!! Thanks..I can progress to another problem no doubt :-) Cheers mate. >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 19:19:36 -0800 > > ><cfquery datasource="BP" username="yourusername" password="Your_pwd" > > >Select * from TGV.dbo.tablename.column_name WHERE some_column_name = '43' > ></cfquery> > >Are you absolutely positive that the table "name" your using in your query >statement actually exists in the database ? > >Steve > > > >----- Original Message ----- >From: "Martin S" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Sunday, October 29, 2000 6:50 PM >Subject: Re: ODBC Error Code = S0002 (Base table not found) > > > > Marius et al. > > > > Yes, that is all correct as far as I can tell thus can't be causing the > > error. > > > > the dot notion in the query..hould I do datasourcename.db.fieldname or > > something else? Cos someone was touching on that before..but I couldn't > > understand their post. > > > > > > > > > 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 > > > > > > >------------------------------------------------------------------------------------------------ >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]