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
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