Small ODBC Problem

J

jimsauerii

Guppy
I have located a couple of access db's above my root to access them there. I am unable to select the files from there as a valid path in my odbc settings. Can we not do this now or do i need something else done?
 
Do you mean in the control panel?

It is based from the "user" folder, so just putting the path as folderoutsidewebroot/database.mdb will work.
 
Stephen said:
It is based from the "user" folder, so just putting the path as folderoutsidewebroot/database.mdb will work.
Click to expand...

I figured out what I was doing wrong i think. Been a while. What is the correct path string for dsnless here?

Such as....
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/whatever/folderoutsidewebroot/database.mdb;"
 
Just like to note one thing, this applies for all winX with X being a number, if you are using CF with a server named wincf or winCFX with X being a number the path will be e:\hshome\username\(rest of path).

While we do not allow ASP on the CF servers, there is sometimes a need for a hard path in CF coding, so I am putting this here for reference if someone searches.
 
You must log in or register to reply here.
Back
Top