Database Tutorial in ASP, Weird permissions issue

microsoft.public.inetserver.asp.db - Microsoft Internet Explorer


Database Tutorial in ASP >> Weird permissions issue

by U2hpbno2Mg » Sat, 19 Feb 2005 06:09:12 GMT

Howdy Experts!

I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access
2003 database via an ODBC DSN. The app works great in a hundred or more
installations. However, I have one customer that when they try to write
anything (it reads data just fine), the ASP page gives this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/rwrapp.asp, line 302

For the life of me, I can't figure it out. The volume the DB is on is NOT
NTFS, it is FAT. I added IUSR_MachineName to the Administrators group
even...and still no luck. I have recreated the DSN, checked for 'read only',
or 'exclusive' in both the DB and the DSN. I have transferred the DB to
another workstation, and it worked there. I have reinstalled the ASP pages.
I have restarted IIS. I have restarted the PC. I have also re-installed
MDAC 2.6.

HEEEEEELLLLLLLLLPPPPPP!!!!!

-Shinz62
Top

Database Tutorial in ASP >> Weird permissions issue

by Steven Burn » Sat, 19 Feb 2005 18:32:49 GMT


http://aspfaq.com/show.asp?id=2062

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!



only',
pages.
Top

Database Tutorial in ASP >> Weird permissions issue

by U2hpbno2Mg » Sat, 26 Feb 2005 03:25:02 GMT

No dice on that link. All the things they suggest are things I have already
tried. Any other advice out there?!?
Top

Database Tutorial in ASP >> Weird permissions issue

by John Blessing » Sat, 26 Feb 2005 04:20:40 GMT


The Jet database drivers are not included in MDAC (since 2.5 IIRC). Although
I would have also said it is a permissions issue, it is worth installing the
latest Jet drivers

http://support.microsoft.com/?kbid=829558

Also, don't use DSN. Your connection string should be something like:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\yourdb.mdb;Persist
Security Info=False

<C:\temp\yourdb.mdb should be changed to the path of your access format
database file>

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
Top

Database Tutorial in ASP >> Weird permissions issue

by Duffaukid » Wed, 02 Mar 2005 08:25:32 GMT

On Fri, 25 Feb 2005 20:20:40 -0000, "John Blessing"





Mine has a DBQ= instead of Data Source=.
Is that important?

PJ
Top

Database Tutorial in ASP >> Weird permissions issue

by John Blessing » Wed, 02 Mar 2005 17:09:07 GMT


Try it and see !

--
John Blessing
Top
Similar Threads

1. weird permissions issue 

WinXP, DWMX2004 (sftp, apache server)

howdy ... I've been noticing a very bizarre problem:

Lets say I create a new page with one dependent file (img.jpg). If I upload 
this htm file and click yes to "upload dependent files" then img.jpg is 
uploaded with the following permissions:  -r-x-w-r-- (making it unreadable 
by a browser - BAD)

This ONLY happens when the dependent file does not already exist on the 
server. If the file is already there and I'm just reuploading it (lets say I 
changes a color in the img) then all is well and the permissions are fine.

Also, if I upload the file independently (by manually finding it in the 
files panel and uploading it - as opposed to letting DW upload it as a 
dependent file) then it has the following (desired) permissions: -rw-r--r--

Any thoughts? ideas? questions? comments? jokes? humourous musings?

Alex

2. iis5 weird weird weird behaviour

3. FTP Permissions Issues and other issues 

I'm running two servers. One is the public facing FTP server and the other 
is the server where the actual FTP folder is (the public facing server has 
its FTP settings to virtually point to a share on the second server for its 
default folder).

The servers are both 2008 standard, AD Integrated.

I'm running IIS 7 with an FTP site.

I'm having permissions issues. I've got basic and anonymous authentication 
both enabled. No SSL or anyhting like that is enabled. Everything else is 
standard.

On the share that the FTP virtual points to (on the second server), 
permissions have been set up for various AD user accounts.

When a user account that has write access connects, they can read, upload 
and make directories but only within the root folder. Once they make a new 
directory int he root folder, they can go into the folder but trying to 
upload a file doesn't work. I have even manaully created folders wtihin the 
root folder and given full permissions to this specific FTP account and the 
account is still unable to write anything to this folder. When I manually 
put something into the folder via normal file operations on the local 
network, the FTP user can see the file, but cannot view or download the 
file.

Another issue is passive mode. No one can connect unless passv mode is 
turned OFF in their FTP client. This also means that connecting via a web 
browser is not possible unless they go into the security settings and make 
the change. Even then, files are now shown properly as in a windows ecplorer 
window (when using explorer). Files show up as a list of links only.

How can I fix these issues? Why can't people use the FTP service any deeper 
than root level?

TIA,
Jim

4. Weird connection issues...

5. Weird IIS6 issues

6. Weird issues with IIS6 after installiation of PIX 501

7. Weird IIS6 issue - 404s for pages that aren't missing 

Hi,

I have a weird IIS6 issue. We set up an IIS6 server on a new 2003 machine.
The service hosts a site that today runs on a Win2K IIS5 machine without
problems.

On the new machine, it simply won't show an .asp page as existing - the
pages come up 404. The .aspx pages are all fine, but the .asp pages will not
come up. I can't imagine it is a permissions problem, since that would
presumably return some kind of 403 error, but that is not the case. It
insists the pages are missing.

I've uninstalled and reinstalled IIS. (The problems were even worse before
the reinstallation - it didn't like aspx pages then either.)

Any ideas whats up?

8. Weird 'No Images' issue in either IE6/IIS5