473,696 Members | 2,127 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data Access Vista/IIS&/Access2000

Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.

I think the problem is in the file permission. Under XP Pro/IIS6 is used to
have to set the .mdb file security via windows explorer to give
IUSR_machinenam e full permissions on this file for anonymous web access.

Cant seem to do this with Vista explorer - says object cannot be found.

Also, getting conflicting statements from IIS Help - it tells me firstly
that

a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
This account is created when you install IIS 7.0.

and then

b. Similarly, a new Windows built-in account named IUSRS replaces the
local IUSR_MachineNam e anonymous account from IIS 6.0.

Anyway, whatever syntax I use, I cant seem to add anonymous web user
permission to daters.mdb via the security tab in Windown Explorer.

Any help greatly appreciated - getting very frustrated

Thanks

Hugh

Aug 26 '07 #1
10 3083
"hugh welford" <hu**********@b tinternet.comwr ote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.
I know this is a Microsoft group and I'll get shot down for saying this,
but...

1. Remove Vista
2. Revert to XP Pro (or preferably Server 2003)
3. Wait 18 months to 2 years for sufficient servicepacks to render Vista
usable.

Past experience has shown (think back even to MS-DOS 4) that you should
never trust a new operating system for any critical use. Might be great for
games, but wait 'til it's had at least the major failings ironed out before
using it for work.

--
Bob Milutinovic
Cognicom - "Australia' s Web Presence Specialists"
http://www.cognicom.net.au/
telephone (0417) 45-77-66
facsimile (02) 9824-2240
Aug 27 '07 #2
hugh welford wrote:
Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.
Huh? What is the error message?
I think the problem is in the file permission.
Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to assign
Modify permissions for the folder containing the file to ALL users of the
database file. Try posting to a Vista group for help with that, or maybe
someone in the iis group will be able to help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Aug 27 '07 #3
thanks Bob - already thinking along these lines

hugh
"Bob Milutinovic" <co******@gmail .comwrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..
"hugh welford" <hu**********@b tinternet.comwr ote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
>Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.

I know this is a Microsoft group and I'll get shot down for saying this,
but...

1. Remove Vista
2. Revert to XP Pro (or preferably Server 2003)
3. Wait 18 months to 2 years for sufficient servicepacks to render Vista
usable.

Past experience has shown (think back even to MS-DOS 4) that you should
never trust a new operating system for any critical use. Might be great
for games, but wait 'til it's had at least the major failings ironed out
before using it for work.

--
Bob Milutinovic
Cognicom - "Australia' s Web Presence Specialists"
http://www.cognicom.net.au/
telephone (0417) 45-77-66
facsimile (02) 9824-2240

Aug 27 '07 #4
Hi Bob

Thanks for reply.

The error merssage is the non-specific "An error occurred on the server when
processing the URL" - not much help is it?

I am assuming that the error is a permissions problem, as I have not been
able to set the full permissions for the file - hence the post. I will
re-post in vista and iis groups as suggested - thanks.

Hugh

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:Ot******** ******@TK2MSFTN GP06.phx.gbl...
hugh welford wrote:
>Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.

Huh? What is the error message?
>I think the problem is in the file permission.

Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to assign
Modify permissions for the folder containing the file to ALL users of the
database file. Try posting to a Vista group for help with that, or maybe
someone in the iis group will be able to help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Aug 27 '07 #5
Well your first step should be to shut off "friendly errors".
This can be done in IIS Manager and may also need to be done in the
browser you are using.

hugh welford wrote:
Hi Bob

Thanks for reply.

The error merssage is the non-specific "An error occurred on the
server when processing the URL" - not much help is it?

I am assuming that the error is a permissions problem, as I have not
been able to set the full permissions for the file - hence the post.
I will re-post in vista and iis groups as suggested - thanks.

Hugh

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:Ot******** ******@TK2MSFTN GP06.phx.gbl...
>hugh welford wrote:
>>Hi

Have just installed IIS7 on Vista and am trying to access a .mdb
file through ASP. Getting server error.

Huh? What is the error message?
>>I think the problem is in the file permission.

Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to
assign Modify permissions for the folder containing the file to ALL
users of the database file. Try posting to a Vista group for help
with that, or maybe someone in the iis group will be able to help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Aug 27 '07 #6
Thanks Bob.

Made a few changes, and now getting unspecified error on trying to open a
connection with the string

cst = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=c:/access/brits/daters.mdb"

Presume new Provider with Vista.

Any idea what the correct string should be under Vista???

Thanks

Hugh
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:eA******** ******@TK2MSFTN GP02.phx.gbl...
Well your first step should be to shut off "friendly errors".
This can be done in IIS Manager and may also need to be done in the
browser you are using.

hugh welford wrote:
>Hi Bob

Thanks for reply.

The error merssage is the non-specific "An error occurred on the
server when processing the URL" - not much help is it?

I am assuming that the error is a permissions problem, as I have not
been able to set the full permissions for the file - hence the post.
I will re-post in vista and iis groups as suggested - thanks.

Hugh

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:Ot******* *******@TK2MSFT NGP06.phx.gbl.. .
>>hugh welford wrote:
Hi

Have just installed IIS7 on Vista and am trying to access a .mdb
file through ASP. Getting server error.
Huh? What is the error message?

I think the problem is in the file permission.

Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to
assign Modify permissions for the folder containing the file to ALL
users of the database file. Try posting to a Vista group for help
with that, or maybe someone in the iis group will be able to help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Aug 27 '07 #7
No, there is no new provider for Vista per se.
However, there IS a new provider for Access 2007 if that is what you are
using. See www.connectionstrings.com

hugh welford wrote:
Thanks Bob.

Made a few changes, and now getting unspecified error on trying to
open a connection with the string

cst = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=c:/access/brits/daters.mdb"

Presume new Provider with Vista.

Any idea what the correct string should be under Vista???

Thanks

Hugh
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:eA******** ******@TK2MSFTN GP02.phx.gbl...
>Well your first step should be to shut off "friendly errors".
This can be done in IIS Manager and may also need to be done in the
browser you are using.

hugh welford wrote:
>>Hi Bob

Thanks for reply.

The error merssage is the non-specific "An error occurred on the
server when processing the URL" - not much help is it?

I am assuming that the error is a permissions problem, as I have not
been able to set the full permissions for the file - hence the post.
I will re-post in vista and iis groups as suggested - thanks.

Hugh

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:Ot****** ********@TK2MSF TNGP06.phx.gbl. ..
hugh welford wrote:
Hi
>
Have just installed IIS7 on Vista and am trying to access a .mdb
file through ASP. Getting server error.
>

Huh? What is the error message?

I think the problem is in the file permission.

Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to
assign Modify permissions for the folder containing the file to ALL
users of the database file. Try posting to a Vista group for help
with that, or maybe someone in the iis group will be able to help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap
so I don't check it very often. If you must reply off-line, then
remove the "NO SPAM"

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Aug 27 '07 #8
Thanks again, Bob.

It was permissions after all - it appears the following must have full
control permissions for IUSR and IIS_IUSRS accounts

a. The .mdb file to be accessed
b. C:\Windows\Temp
c. C:\Windows\Serv iceProfiles\Net workService\App Data\Local\Temp

Hope this is useful

Regards

Hugh
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:ey******** ******@TK2MSFTN GP06.phx.gbl...
No, there is no new provider for Vista per se.
However, there IS a new provider for Access 2007 if that is what you are
using. See www.connectionstrings.com

hugh welford wrote:
>Thanks Bob.

Made a few changes, and now getting unspecified error on trying to
open a connection with the string

cst = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=c:/access/brits/daters.mdb"

Presume new Provider with Vista.

Any idea what the correct string should be under Vista???

Thanks

Hugh
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:eA******* *******@TK2MSFT NGP02.phx.gbl.. .
>>Well your first step should be to shut off "friendly errors".
This can be done in IIS Manager and may also need to be done in the
browser you are using.

hugh welford wrote:
Hi Bob

Thanks for reply.

The error merssage is the non-specific "An error occurred on the
server when processing the URL" - not much help is it?

I am assuming that the error is a permissions problem, as I have not
been able to set the full permissions for the file - hence the post.
I will re-post in vista and iis groups as suggested - thanks.

Hugh

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:Ot***** *********@TK2MS FTNGP06.phx.gbl ...
hugh welford wrote:
>Hi
>>
>Have just installed IIS7 on Vista and am trying to access a .mdb
>file through ASP. Getting server error.
>>
>
Huh? What is the error message?
>
>I think the problem is in the file permission.
>
Why? Does the error message give you a clue?
If it IS a file permission error, you need to figure out how to
assign Modify permissions for the folder containing the file to ALL
users of the database file. Try posting to a Vista group for help
with that, or maybe someone in the iis group will be able to help.
>
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap
so I don't check it very often. If you must reply off-line, then
remove the "NO SPAM"

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Aug 27 '07 #9
"Full" permissions is overkill. All that is required is "Modify". The
users do not need the ability to assign permissions. Always work from
the standpoint of assigning the least level of permission required to
perform the task. In this case, users need to be able to create, modify
and delete a locking file to enable multi-user access to the mdb file.
The only permission required for that is "Modify", known as "Read/Write"
in some OSs.

hugh welford wrote:
Thanks again, Bob.

It was permissions after all - it appears the following must have full
control permissions for IUSR and IIS_IUSRS accounts

a. The .mdb file to be accessed
b. C:\Windows\Temp
c. C:\Windows\Serv iceProfiles\Net workService\App Data\Local\Temp

Hope this is useful

Regards

Hugh
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:ey******** ******@TK2MSFTN GP06.phx.gbl...
>No, there is no new provider for Vista per se.
However, there IS a new provider for Access 2007 if that is what you
are using. See www.connectionstrings.com

hugh welford wrote:
>>Thanks Bob.

Made a few changes, and now getting unspecified error on trying to
open a connection with the string

cst = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=c:/access/brits/daters.mdb"

Presume new Provider with Vista.

Any idea what the correct string should be under Vista???

Thanks

Hugh
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:eA****** ********@TK2MSF TNGP02.phx.gbl. ..
Well your first step should be to shut off "friendly errors".
This can be done in IIS Manager and may also need to be done in the
browser you are using.

hugh welford wrote:
Hi Bob
>
Thanks for reply.
>
The error merssage is the non-specific "An error occurred on the
server when processing the URL" - not much help is it?
>
I am assuming that the error is a permissions problem, as I have
not been able to set the full permissions for the file - hence
the post. I will re-post in vista and iis groups as suggested -
thanks.
>
Hugh
>
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcomwrote in message
news:Ot**** **********@TK2M SFTNGP06.phx.gb l...
>hugh welford wrote:
>>Hi
>>>
>>Have just installed IIS7 on Vista and am trying to access a .mdb
>>file through ASP. Getting server error.
>>>
>>
>Huh? What is the error message?
>>
>>I think the problem is in the file permission.
>>
>Why? Does the error message give you a clue?
>If it IS a file permission error, you need to figure out how to
>assign Modify permissions for the folder containing the file to
>ALL users of the database file. Try posting to a Vista group for
>help with that, or maybe someone in the iis group will be able
>to help.
>>
>--
>Microsof t MVP - ASP/ASP.NET
>Please reply to the newsgroup. This email account is my spam trap
>so I don't check it very often. If you must reply off-line, then
>remove the "NO SPAM"

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will
get a quicker response by posting to the newsgroup.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Aug 28 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
1735
by: Belinda | last post by:
Hello All I want to install the NT 4.0 Option pack to install the IIS web server. Does the option pack install to get the web server working on my Windows NT workstation running SP6a work. I want this web server to connect to a SQL Server which is running on this NT Workstation as well. Please clarify what are the steps I need to follow to get the web server running on my NT 4.0 workstation to run ASP.
0
1615
by: Victor | last post by:
I have a XML webservice on IIS 5.1 with self-issued certificate. My ActiveX tryes to invoke a webservice method using class CSecureEvtSyncSocket from msdn sample http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcsample/html/vcsamsecuresoapsample.asp Invoking webmethod over regular HTTP it works fine, but over HTTPS i receive error 10054 (Connection reset by peer) during response body read. IIS logs say that request is OK...
3
1331
by: highlandskye | last post by:
I've a new computer running Vista Home Premium and IE7. I've been using FrontPage2003 and Xara's Webstyle 4.0 for several years to maintain my website. I now have a problem creating menus using Webstyle (with Java). The menu looks great in the Design window but simply doesn't exist in the Preview window, which uses IE7. All items are in the correct folder. One suggestion was that I needed to turn down the security in IE7 - did that - didn't...
0
860
by: krithigadevi | last post by:
I Have Recently Installed Windows Vista. After That I Have Installed Visual Studio .net 2003. I Am Able To Use Vb.net, But I Am Not Able To Use Asp.net. It Is Giving A Message Saying Web Development Component Missing. But I Am Not Able To Configure Web Development Component. Will Windows Vista Support .net 2003 Give Me A Solution To This Problem.
9
7943
by: Mark Rae | last post by:
Hi, Now that the VS.NET 2005 SP1 update patch is with us, I'm in the process of moving my main development environment onto 64-bit Vista Business Edition - so far, so good... However, there is a bit of a gotcha with Request.UserHostAddress... Under IIS6 and earlier, that would return a standard xxx.xxx.xxx.xxx IP address. However, Vista enables IP6 by default, which makes
0
1818
by: badkart | last post by:
i have adsl modem hooked to my vista machine via usb and out of that machine to a hub and from there to another pc running xp ...everything worked great before i installed vista on the first machine . everything still works except when i get online with the xp machine after surfing for a minute it always reboots my adsl modem .. i can transfer files fine even download but the xp machine reboots modem everytime .
9
1749
by: | last post by:
Does anyone know which edition of Vista you have to buy if you use Visual Studio and probably will upgrade to Visual Studio 2008? Is the Ultimate edition necessary, or will the home or business edition work just fine?
2
1435
by: =?Utf-8?B?dHBrbm9tYWQ=?= | last post by:
Please don't send me to the Codeproject article, i'm looking for some native way to be able to elevate a user using VB. As it stands right now, Microsoft is providing that "privilege" to Visual C++ developers.
2
1316
by: fnbhns | last post by:
Dear Friends Would you tell me pls that a laptop is running by Windows Vista, if I want aonther operating System Windows-XP, that is I want 2 operating in my system. will it support or any problem May rise. Expecting your kind response.. Firoz
0
8595
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9142
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9008
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8875
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7699
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6512
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5855
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4353
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2313
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.