By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,715 Members | 1,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,715 IT Pros & Developers. It's quick & easy.

Coldfusion Can't Find Table

P: 2
I have been charged of creating a coldfusion web site for our company.
Our database has a ms sql 2005 backend and ms access frontend. Almost all tables are linked tables with the SQL database, except the temp tables needed at runtime that are in the ms access database.
It will be easier for us to utilize the ms access queries and temp tables, so I set up a datasource on our web server and within the coldfusion administrator to point to the ms access database witht he ms access .mdb driver.
The datasource comes as OK in the coldfusion datasource page.
When I try to run a query from my coldfusion page, the requested table can't be found, although it is there.
The original name of the table is dbo.myTable, but we renamed all the tables in access to remove the "dbo." part, so it shows up as "myTable" only: error message:

"Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Calmweb_Customer'. Make sure it exists and that its name is spelled correctly.

The error occurred in D:\websites\www\Calmweb\forceUserLogin.cfm: line 26
Called from D:\websites\www\Calmweb\Application.cfc: line 18
Called from D:\websites\www\Calmweb\forceUserLogin.cfm: line 26
Called from D:\websites\www\Calmweb\Application.cfc: line 18

24 : FROM Calmweb_Customer
25 : WHERE Username = '#FORM.userLogin#'
26 : AND Password = '#FORM.userPassword#'
27 : </cfquery>
28 :"

The table Calmweb_Customer actually exists and has records.

I tried to put in my query the full dbo.myTable, but coldfusion comes up with the error it can't find the table "dbo"... here is the error message:

"Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\CFusionMX7\db\slserver54\logging\dbo.mdb'.

The error occurred in D:\websites\www\Calmweb\forceUserLogin.cfm: line 26
Called from D:\websites\www\Calmweb\Application.cfc: line 18
Called from D:\websites\www\Calmweb\forceUserLogin.cfm: line 26
Called from D:\websites\www\Calmweb\Application.cfc: line 18

24 : FROM dbo.Calmweb_Customer
25 : WHERE Username = '#FORM.userLogin#'
26 : AND Password = '#FORM.userPassword#'
27 : </cfquery>
28 :"

If anyone has any idea, that would be great.
Thanks a lot.
Jul 23 '07 #1
Share this Question
Share on Google+
1 Reply


P: 24
Could be a permissons issue. Check the datasource has correct read permissions on the table.

(BTW, I'm assuming the lack of <cfqueryparam> tags around the variables in the query is just for sake of brevity).
Jul 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.