Hey will, Thanks once again, I found the answer to my problem, the thing with
go daddy is that you cannot Import Databases that you have created outside of
Godaddy's Control center, but you can create a DSN there, and basially the fix
is renaming your databases to the pre-fixed name the use for the Dbs so if my
Db was Named Hunts.mdb, you gotta rename it to the one they give you which
would be YourUserName_accesscf_Hunts.mdb that would solve the problem...and it
did for me. for atleast an hour, then I got the following error:
//////////////////////////////////////
Error Executing Database Query.
Could not find file 'd:\hosting\travelersbe\access_db\Hunters.mdb'.
The error occurred in D:\Hosting\travelersbe\Hunt000001.cfm: line 14
12 : (PlayerNumber)
13 : Values
14 : (#tick#)
15 : </cfquery>
16 :
--------------------------------------------------------------------------------
SQL INSERT INTO DailyHntr (PlayerNumber) Values (1200760144052)
DATASOURCE MyUserName_accesscf_Hunters
SQLSTATE
//////////////////////////////
I don't know why is looking for "Hunters.mdb" I already changed all my code to
point to "MyUserName_accesscf_Hunters" and is also searching for it in the D:
Drive!!! this is the cf code in that page: (That's it, no more cf code besides
that)
<cfset CurrentDate = Now()>
<cfset CurrentTime = Now()>
<cfset tick = GetTickCount()>
<cfquery datasource="MyUserName_accesscf_Hunters">
INSERT INTO DailyHntr
(PlayerNumber)
Values
(#tick#)
</cfquery>
I really don't understand why it doesn't work, it works perfectly on my testing
server!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3235
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
