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]

Reply via email to