| Author |
 Topic  |
|
|
Jay Brown
Starting Member
USA
8 Posts |
 Posted - 09 May 2007 : 16:20:40
|
When I run setup.asp, this is what I get:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
The dbtype is set for access and the connstring is defined as the full physical path.
Onec again, It's bound to be something simple, but I could use some help.
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 09 May 2007 : 16:25:09
|
| Are you sure you have the right path? In the tools.zip (or something like that) there should be a page called whereami.asp that you can use to check the path. Just place that file in your database directory and point your browser to it. |
 |
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 09 May 2007 : 16:44:14
|
As well as make sure you have deleted out the' from in front of the line I know it sounds dumb but its an easy thing to miss  |
|
|
|
Jay Brown
Starting Member
USA
8 Posts |
Posted - 09 May 2007 : 17:12:06
|
OK, here's where I stand right now. I"ve double checked the two lines in config.asp and verified they are correct. The path points to the file and the type is set for access, and the comment marks have been removed where they should be removed.
I suspect it may be a problem with the jet driver. I have msjet40.dll and the version is 4.0.9335.0 which seems to be the latest, but when I try to open the file in access (2003) I get a message saying something about the jet driver not being installed and running unsafe expressions.
I don't think I mentioned in my first post, but for the record, I am running this under Vista Ultimate.
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 09 May 2007 : 17:23:18
|
| I'd hit the MSDN and see if there are any issues with Access and Vista Ultimate. I would think that if you've installed Access the proper JET drivers would have been installed.... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Jay Brown
Starting Member
USA
8 Posts |
Posted - 09 May 2007 : 19:56:16
|
quote:
Originally posted by ruirib
You seem to be using an ODBC driver. Try the OLEDB driver.
Using this line
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=<path to DB>\snitz_forums_2000.mdb" '## MS Access 97
I get:
Code : 80004005
Error Description :
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
Using this line
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path to DB>\snitz_forums_2000.mdb" '## MS Access 2000
I get:
Code : 80004005
Error Description :
Unspecified error
|
Edited by - AnonJr on 09 May 2007 21:04:58 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 09 May 2007 : 21:08:12
|
Just FYI, you might not want to post the path to your DB in a public forum. 
Also, just to eliminate some of the simple stuff, do you have the database open in Access while you are trying to do this? I ask because I do remember reading an article somewhere about how that can cause some odd errors.
I'd still check over at http://msdn.microsoft.com/ - its not the easiest to find what you're looking for, but I bet there's an answer in there. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 May 2007 : 21:17:35
|
Those unspecified errors are just hard to sort. Unfortunately I have no experience with Vista, so I really can't help.
I would suggest that you check permissions on the file and folder. They are a frequent issue and maybe the error message isn't specific enough in Vista. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Jay Brown
Starting Member
USA
8 Posts |
Posted - 13 May 2007 : 19:23:31
|
OK, I finally gave up on the vista machine and set up a new xp machine. I've installed Office 2003 so I assume that jet 4.0 also got installed.
Set up IIS and a third party asp administrator and then unpacked a fresh copy of the forum.
Opened up config.asp and selected the appropriate dbtype and connection string and now I get the following:
Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I've tried every access connection string in the config.asp with similar results.
Anybody have any idea what I'm missing?
Btw, about a year ago, I had snitz working properly under an NT server.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 13 May 2007 : 20:02:26
|
| Now you have a permissions problem, which is a very common one when using Access. You need to assign read / write permissions for the database file and folder to the anonymous internet user. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 14 May 2007 : 08:11:05
|
Just a side note - I know you say you've got Jet4 installed on the Vista box, is it definitely registered int the registry? regsvr32.exe will allow you to register it if it isn't
'Fraid I'm not at all up on Vista, and what comes pre-installed and pre-supported, but I do know Jet is being phased out slowly in favour of MSDE/SQL Express engine |
|
|
|
Jay Brown
Starting Member
USA
8 Posts |
Posted - 16 May 2007 : 10:09:00
|
I'm at my wit's end. I've tried everything I can think of and all of the suggestions presented in this forum.
Just as a review, I'm using XPPro, the latest version of the forum code, IIS (6, I think)
I downloaded a program called XPPro IIS Admin which gave me the ability to properly handle the asp code. That seems to be working fine.
I have tried evey connection string in the config.asp for access yet I still get the message saying "Operation must use an updateable query."
I suspect it's a permissions issue (nothing else left) but I can't seem to find the setting I need.
Help!! Help!! Help!! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
gddwms
Starting Member
1 Posts |
|
| |
Topic |
|
Topic Locked
