Forums
This topic is locked
PWS to IIS problem
11 Sep 2002 10:41:46 Stefan P posted:
Until recently I've still been using Personal Web Server on Win 98 with no problem running my ASP pages. I've just bought a new PC with Win 2000 Pro so have moved to IIS. When I tried to run a page that returns records from Access I got this error:Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
I have look at the Microsoft Web site and it gives 3 possible reasons:
1. incorrect permissions
2. incorrect version of MDAC
3. need ODBC version 4 or greater
I've tried changing permissions but still have problems.
Anyone had this problem and/or know how to resolve it?
Thanks
Stefan Passchier<i></i>
Replies
Replied 11 Sep 2002 13:07:58
11 Sep 2002 13:07:58 Iain Stewart replied:
Hi,
I had a similar problem when i moved to win2k, have you set up your system dns in admin tools ?
Think thats what was giving me the problems when i moved over.
Iain
head hurts, 'mental note to self, stop banging head !'
I had a similar problem when i moved to win2k, have you set up your system dns in admin tools ?
Think thats what was giving me the problems when i moved over.
Iain
head hurts, 'mental note to self, stop banging head !'
Replied 11 Sep 2002 14:18:38
11 Sep 2002 14:18:38 Stefan P replied:
Yes I did set up DSN in Admin tools, is there another way?
Replied 11 Sep 2002 15:07:55
11 Sep 2002 15:07:55 Iain Stewart replied:
As Far as i can remember, i got the errors because i set my machine up as administrator, then created my user account and started using that to log onto the system, i had set my dsn up as administrator, so i had to go back in under my own account and set up another dsn, made it a system dsn rather than user and picked the db and it all worked then.
Hope this helps
Iain
head hurts, 'mental note to self, stop banging head !'
Hope this helps
Iain
head hurts, 'mental note to self, stop banging head !'
Replied 16 Sep 2002 19:14:56
16 Sep 2002 19:14:56 David Behan replied:
Navigate to the folder using Windows Explorer. Right click and get properties of database folder. Set access rights to read, write for the IUSR_GUEST account in web sharing. Also share the folder on the network. That is what I do to ensure connection to the database and image folders.
I know I have had this problem before but I can't remember exactly how I fixed it. Your pages are connecting to the database cause if they weren't they would say cannot find database and no default dsn specified.
Regards,
Dave
_________________________
WinXP : IIS 5.1 : StudioMX : ASP : VBScript
www.clicksdesign.com
I know I have had this problem before but I can't remember exactly how I fixed it. Your pages are connecting to the database cause if they weren't they would say cannot find database and no default dsn specified.
Regards,
Dave
_________________________
WinXP : IIS 5.1 : StudioMX : ASP : VBScript
www.clicksdesign.com