Looks like a great place and look forward to learning from all of you.
Now my question is, I am just getting into database design (MS access) and ColdFusion. My problem is I can create a DB connection locally on my machine at home, and all seems to work fine (info is being entered into the DB), but once I get it online it does not seem to find the DB. The host I have has a create DB source. I create one and I name it exactly as I have it but it still does not work (cant find data source)? Am I doing something wrong or is there something I am missing?
sounds like you just need to point your scripts to the particular directory where the db is located.
for example let's say you have a linux host and your msaccess is located here... "/home/webhosting/account/databases/youraccess.mdb"
you would have to point your scripts to that directory in order for it to work. the same applies to a windows account as well. for example if it's located here
"c:"\home\webhosting\account\databases\youraccess.mdb" then make the changes to find the db in question. hope this helps.
I'm not sure what you mean by pointing the path to my DB,
when I go through my site and create a DB source it creates a path
mysite.com\database\myDB.mdb
The DB is in a database folder called database
I thought all I needed to do was to name my DNS source?
for eg...
CFQUERY DATASOURCE="myDB"
I have been looking on all CF scripts and That is all I can find, I don't see anyone mention the full path inside the CF script itself. Should I put it in
so it would look like this?
CFQUERY DATASOURCE="mysite.com\database\myDB.mdb"
yes try that out and see if that helps. hmm do this first k instead of the mysite.com <<< part remove that and only put this there instead >>>>> CFQUERY DATASOURCE="\database\myDB.mdb"
Bookmarks