Ping Kevin Spencer/Stefan Rusynko

T

Thomas A. Rowe

MikeR,

Are you saying that you can't store the databases in fpdb folder and use the default FP generated
connection?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
J

JIMCO Software

Steve said:
Hi Jim.
Regedit.exe has been around since Windows 95.

regedt32 came about with NT / 2K
Click to expand...

Steve,

Regedit.exe does not allow you to change permissions on Win2K and earlier.
You have to use Regedt32 for that. Beginning with Windows XP, Regedit.exe
took on the ability to alter permissions. That's what I was referring to.

--
Jim Cheshire
JIMCO Software
http://www.jimcosoftware.com

FrontPage add-ins for FrontPage 2000 - 2003
 
K

Kevin Spencer

Hi Tom,

On your local computer you wouldn't, and as long as permissions are set up
right on the host machine you wouldn't. But as MikeR was already having
permissions issues with reading the registry, he would.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Paranoia is just a state of mind.
 
M

MikeR

Jim -
Could you point out exactly where the "Security menu" is in regedit? Any version?
Number 3 in the list. AFAICT since Win95, there have never been menus associated with regedit.
Mike
 
M

MikeR

Hi Thomas -
Yes, I could put the db in a folder named fpdb. I do not and will not use FP generated
code to do anything with a database. I think I misunderstood the "stored outside of the
web root" phrase.
Mike
 
J

JIMCO Software

MikeR said:
Jim -
Could you point out exactly where the "Security menu" is in regedit?
Any version? Number 3 in the list. AFAICT since Win95, there have never
been menus
associated with regedit. Mike
Click to expand...

Hi Mike,

Edit / Permissions.

--
Jim Cheshire
JIMCO Software
http://www.jimcosoftware.com

FrontPage add-ins for FrontPage 2000 - 2003
 
M

MikeR

Sonofagun. There it is (but still a bad description ;=> ). I was totally focused on the
keys/values. That's why I hang out here, I'm always learning something.

So now to step 4. What's up is a dialog for assigning privs to users, pretty much like you
get in Windows Explorer, Sharing and Security (WIn XP Pro), except the caption is
Permissions for ODBC.

This doesn't make any alterations to the registry (at least not under ODBC). Otherwise,
crusing thru the dialogs that appear, permissions are correctly set.

I'm still wondering why changing the enabled property of parent paths lets it work if the
path is like this. dbname="DBQ=" & Server.MapPath("../db/qsl.mdb")


Mike
 
J

JIMCO Software

MikeR said:
I'm still wondering why changing the enabled property of parent paths
lets it work if the path is like this. dbname="DBQ=" &
Server.MapPath("../db/qsl.mdb")
Click to expand...

If parent paths are disabled, that path will not work. You won't be able to
navigate up a directory by using ../.

--
Jim Cheshire
JIMCO Software
http://www.jimcosoftware.com

FrontPage add-ins for FrontPage 2000 - 2003
 
S

Stefan B Rusynko

When you File Import a .mdb into a FP web (and allow FP to put it in the fpdb folder) the only thing FP will do is create the
folders fpdb (w/ your .mdb in it) and _fpclass (w/ FP .inc files in it if you need them for the DBRW - leave it alone and don't use
them), but most importantly it will generate a global.asa w/ your connection (for use in your hand coding)




| Hi Thomas -
| Yes, I could put the db in a folder named fpdb. I do not and will not use FP generated
| code to do anything with a database. I think I misunderstood the "stored outside of the
| web root" phrase.
| Mike
|
| Thomas A. Rowe wrote:
| > MikeR,
| >
| > Are you saying that you can't store the databases in fpdb folder and use the default FP generated
| > connection?
| >
 
M

MikeR

Hi Jim -
Yes I know. This whole thread started because my host disabled parent paths. I have two
domains, and on my local machine each site is in it's own subweb. FP handles the links
fine that way.
When I disabled my local parent paths, and used Server.MapPath("/db/qsl.mdb") I get the error.
I'm just trying to sync up the loacal and host paths to the db, as I have enough database
based pages to make it tedious and error-prone to change them all evwry tim I publish
(either way).
Since it works fine (locally) one way but not the other, I'm having a hard time seeing it
as a permissions issue. Seems like the same permissions would be needed either way.
Mike
 
M

MikeR

Stefan -
Thanks for the input. Maybe unfortunately, I didn't start that way, and am so far down the
road now it would be a pretty big effort to change. And there isn't any big deal about
hand coding the connection. Only need to do it once, then copy and paste. I actually find
it more difficult to have FP do it, most likely due to my unfamialarity with the FP
methods. I'll give it a try, tho.
Mike
 
J

JIMCO Software

MikeR said:
Hi Jim -
Yes I know. This whole thread started because my host disabled parent
paths. I have two domains, and on my local machine each site is in
it's own subweb. FP handles the links fine that way.
When I disabled my local parent paths, and used
Server.MapPath("/db/qsl.mdb") I get the error. I'm just trying to
sync up the loacal and host paths to the db, as I have enough
database based pages to make it tedious and error-prone to change
them all evwry tim I publish (either way). Since it works fine (locally)
one way but not the other, I'm having a
hard time seeing it as a permissions issue. Seems like the same
permissions would be
needed either way. Mike
Click to expand...

You are reporting two separate issues. One is the parent paths issue. The
other is the error concerning JET's inability to access the Registry.

Either way, a log from Regmon and Filemon would be immensely helpful.

--
Jim Cheshire
JIMCO Software
http://www.jimcosoftware.com

FrontPage add-ins for FrontPage 2000 - 2003
 
M

MikeR

Jim -
Does Jet access the registry differently depending on whether parent paths are disabled or
enabled?

I've got Regmon & Filemon downloaded. Now to figure out how to use them....
More when that's done.
Mike
 
M

MikeR

Jim -
I appreciate your patience.
I feel as though I'm not expresssing myself well, or have missed a critical point somewhere.
With parent path enabled (on my local machine & host, but host has now disabled parent path):

set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("../db/mydb.mdb")

works just fine.

With parent path disabled (on local machine):
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("/subweb/db/mydb.mdb")

works just fine.

With parent path disabled (local machine):
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("/db/mydb.mdb")

throws this error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0xa34 Thread 0x374 DBC 0x11259b4 Jet'.

so in my mind, that's not a permission issue, but a path issue. The permissions work if
the path is good.

This one is the path that works on the server (with parent paths disabled).
Server.MapPath("/db/mydb.mdb")

Mike
 
T

Thomas A. Rowe

On the server are you still under the subweb?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

MikeR said:
Jim -
I appreciate your patience.
I feel as though I'm not expresssing myself well, or have missed a critical point somewhere.
With parent path enabled (on my local machine & host, but host has now disabled parent path):

set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../db/mydb.mdb")

works just fine.

With parent path disabled (on local machine):
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("/subweb/db/mydb.mdb")

works just fine.

With parent path disabled (local machine):
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/db/mydb.mdb")

throws this error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0xa34 Thread 0x374 DBC 0x11259b4 Jet'.

so in my mind, that's not a permission issue, but a path issue. The permissions work if the path
is good.

This one is the path that works on the server (with parent paths disabled).
Server.MapPath("/db/mydb.mdb")

Mike



JIMCO said:
Not that I know of.
Click to expand...
Click to expand...
 
J

JIMCO Software

MikeR said:
so in my mind, that's not a permission issue, but a path issue. The
permissions work if the path is good.
Click to expand...

It is a permissions problem. The HRESULT you're seeing in addition to the
text of the error message dictates that.

--
Jim Cheshire
JIMCO Software
http://www.jimcosoftware.com

FrontPage add-ins for FrontPage 2000 - 2003
 
K

Kevin Spencer

Hi Mike,

I think you're a bit confused. At least, you're being a bit confusing. That
is, note the following paths, as you posted them in your message:
With parent path enabled (on my local machine & host, but host has now
disabled parent path):
Server.MapPath("../db/mydb.mdb")
Click to expand...
With parent path disabled (local machine):
Server.MapPath("/subweb/db/mydb.mdb")
Click to expand...
With parent path disabled (local machine):
Server.MapPath("/db/mydb.mdb")
Click to expand...

These are 2 completely different paths. Number 1 is using a parent path to
(apparently) "/subweb/db". Number 2 is using a root-relative path to
"subweb/db". Number 3 is using a root-relative path to "/db". The 2 dots
("..") indicate a parent path. The single beginning slash indicates a
root-relative path. The root is the root of the web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

MikeR said:
Jim -
I appreciate your patience.
I feel as though I'm not expresssing myself well, or have missed a
critical point somewhere.
With parent path enabled (on my local machine & host, but host has now
disabled parent path):

set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("../db/mydb.mdb")

works just fine.

With parent path disabled (on local machine):
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("/subweb/db/mydb.mdb")

works just fine.

With parent path disabled (local machine):
set conntemp=server.createobject("adodb.connection")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("/db/mydb.mdb")

throws this error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xa34 Thread 0x374
DBC 0x11259b4 Jet'.

so in my mind, that's not a permission issue, but a path issue. The
permissions work if the path is good.

This one is the path that works on the server (with parent paths
disabled).
Server.MapPath("/db/mydb.mdb")

Mike



JIMCO said:
Not that I know of.
Click to expand...
Click to expand...
 
M

MikeR

Jim & Kevin -

I think I'm just not explaining this well.
Long ago and far away, when my host had parent paths enabled this worked on both the host
and local. The local uses a subweb for each of the two domains I have, so I'll say we're
dealing with subweb1.
Server.MapPath("../db/mydb.mdb")

The host disabled parent paths, so to access the db on the host, I had to use
Server.MapPath("/db/mydb.mdb")

I disabled parent paths on my local, and this
Server.MapPath("/db/mydb.mdb") gives the error.
Also, filemon says it's a bad path. I haven't figured out regmon yet. Any tips here?

This path now works locally (parent path disabled)
Server.MapPath("/subweb1/db/mydb.mdb")

So now, I have a different path on the local and host.

I know that the error message states a permission issue, but given the fact that, with the
correct path, it works, still makes me doubt it's the actual error. Sorry to be so stubborn.

Mike
 
Top