Accessing MS SQL & Coldfusion

[bj]

I've set up a local MS SQL 2000 database for development yet coldfusion MX 6
refuses to see my database tables.

My datasource verifies ok in coldfusion administrator im using the Microsft
SQL server Driver. When I try and connect I get the following error. The
table definately exisits and the user has permission to see the table yet i
still get the error below. Im convinced its a permission problem in the
database but Ive tried everything. the username in question is the owner of
the database table and is part of the admin user group yet I still get it to
work.

Any help?? Going mad!!



Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL
Server Driver][SQL Server]Invalid object name 'products'.

The error occurred in C:\Inetpub\wwwroot\Brady2006\test.cfm: line 1

1 : <cfquery name="available" datasource="#client.dsn#"
username="#client.username#" password="#client.password#">
2 : SELECT *
3 : FROM products where product='832112'

[The ScareCrow]

Could be a reserved word problem, try

SELECT *
FROM where = '832112'

Ken

[Dan Bracuk]

Does the query work in Query Analyzer?

[bj]

mmmm it doesnt work in query analyzer

yet the products table is there in enterprise manager

still think it something to do with the login


"Dan Bracuk" <webforumsuser@macromedia.com> wrote in message
news:e3rk97$27p$1@forums.macromedia.com...

> Does the query work in Query Analyzer?

[bj]

not sure what happened but i deleted the products table and recreated it and
now all is working.

Thanks for all your help


"bj" <orders@seton.net.au> wrote in message
news:e3rnhq$5k1$1@forums.macromedia.com...

> mmmm it doesnt work in query analyzer
>
> yet the products table is there in enterprise manager
>
> still think it something to do with the login
>
>
> "Dan Bracuk" <webforumsuser@macromedia.com> wrote in message
> news:e3rk97$27p$1@forums.macromedia.com...

>> Does the query work in Query Analyzer?

>
>