<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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
