Click to See Complete Forum and Search --> : Trouble accessing my MSACCESS DB on server


jots_ozark
12-10-2005, 03:15 PM
I developed an entire ColdFusion website and I am a newb at this. On my localhost everything worked fine. But, when I loaded it to the hosting server, it seems like I have something wrong in my query statement.

Of couse my host has a DSN Name for the MS Access DB. Here is my code on one of the pages:
<cfquery
datasource="bobconwood_accesscf_c4c"
username="#"
password="#"
timeout="600"
name="tabs">
SELECT ID,TabName, TabBody
FROM Tabs
ORDER BY ID
</cfquery>

My DSN Name is - bobconwood_accesscf_c4c
My database name is "c4c"

Please help, I am supposed to have this done by the end of today or the client will go elsewhere.

When I load the page I get errors - one time it will tell me it timed out, another says it could not find the datasource

chrismartz
12-12-2005, 10:09 PM
This looks to be an error in the Coldfusion manager where the admin would setup the datasource. If you have access to this manager, check your datasource to make sure its correct. Also, make sure you uploaded your access file to a folder that has read/write permissions. If both of these don't fix the problem, I suggest you contact your host. I wish you the best.