Hi Frank, No problem - although like I say I have never used godaddy so I'm shooting in the dark here.
But - you shouldn't need to do all that - that code is ASP not CF. If you enabled access support, and uploaded your mdb file to the access_db folder that was created, then you just need to follow the instructions here http://help.godaddy.com/article/975 Putting the name of the .mdb file in the database file information field. That should set you up with a cf datasource, which you can then use in your cfqueries. Assuming you've done that, if you try querying that datasource, are you getting an error message or something. Cheers Will -----Original Message----- From: Frank Velazquez [mailto:[EMAIL PROTECTED] Sent: 18 January 2008 21:04 To: CF-Newbie Subject: Re: Godaddy and Coldfusion Dbs Issues Hey Will, Thanks for answering...I have access enabled on the hosting account, and I also have the coldfusion installed... I followed the Help.godaddy.com articles, I don't know how to set up the DSN, I created one Called Hunters, which has the same name as the database I already had (The one I uploaded from my machine), but I don't know how to connect them. I found this code on article http://help.godaddy.com/article/259: <% Dim oConn, oRs Dim qry, connectstr, sDSNDir Dim db_name, db_username, db_userpassword Dim db_server, dsn_name dsn_name = "your_dsn_name" fieldname = "your_fieldname" tablename = "your_tablename" sDSNDir = Server.MapPath("_dsn") connectstr = "filedsn=" & sDSNDir & "/" & dsn_name Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open connectstr qry = "SELECT * FROM " & tablename Set oRS = oConn.Execute(qry) if not oRS.EOF then while not oRS.EOF response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & " " oRS.movenext wend oRS.close end if Set oRs = nothing Set oConn = nothing %> Like I said before I'm new with coldfusion, so this quite confuses me. Thanks for the help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3234 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
