| Author |
 Topic  |
|
|
wmull
Starting Member
7 Posts |
 Posted - 26 April 2001 : 16:04:59
|
Hi,
I'm trying to set up the Snitz forums on one of my hosted sites at MindlessGames.com ......
I've set up the DSN correctly via ODBC (Data Sources), and the correct permissions are set for the directory where the .mdb resides, but still I keep getting the same error.....
This works fine locally, so we know something is eluding us, that we haven't been able to determine on the server.
What I need is an ASP guru who wouldn't mind giving me some free consultation on this, and who could even log on to the server and perhaps check things out to make sure.
I wouldn't be able to pay you, so this is strictuly a request for volunteer help for my poor, pitiful self :-/
If you can help, please send me an email at:
wmull@mindlessgames.com .
Thanks, and best,
William |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 26 April 2001 : 17:43:48
|
quote:
... but still I keep getting the same error.....
I bet the odds of a helpful response would increase if you mentioned what the error was.
======
Doug G
====== |
 |
|
|
wmull
Starting Member
7 Posts |
Posted - 26 April 2001 : 18:24:11
|
The first time I go to:
http://bw.mindlessgames.com/forum/
I get this error:quote:
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 : -2147467259
Second time (if I refresh), I get this error:quote:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[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.
/forum/inc_top.asp, line 42
Hope this helps someone help me .........
Best,
William
|
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 26 April 2001 : 18:49:23
|
Could you give us a link to your config file? (has to be a .txt file for us to view it)
|
|
|
|
wmull
Starting Member
7 Posts |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 26 April 2001 : 19:14:18
|
Take the semi-colon off the end of the statement:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\mindlessgames.com\bw\forum\tools\snitz_forums_2000.mdb;" '## MS Access 97
It should look like this:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\mindlessgames.com\bw\forum\tools\snitz_forums_2000.mdb" '## MS Access 97
Hope that fixes it. Suggestion: might want to switch to the 2000 connection string, but you don't have to.
Eric
Edit: actually, go ahead and switch to the 2000 connection string. I've always used the 2000 string and on one of my forums I use a access 97 db. well, I just switched the connection string to the 97 one and this is the error I got:
Provider error '8000ffff'
Catastrophic failure
/testforum/inc_top.asp, line 42
but, when I switch it back to the 2000 connection string, everything works fine
Edited by - e3stone on 26 April 2001 19:27:31 |
|
|
|
wmull
Starting Member
7 Posts |
Posted - 26 April 2001 : 21:11:03
|
Hi,
I've tried it both ways before, and it does the same thing; same error, no matter whether it has the semicolon or not.... :-/
Also, same problem whether I use the Acess 97 string or 2000 string.
Here's what I get w/ the 2000 string, if it's any help:quote:
Microsoft JET Database Engine error '80004005'
Unspecified error
/forum/inc_top.asp, line 42
This is just one of the reasons why this problem is vexing me so much...... I've honestly tried just about everything. I've researched all of the MS database issues, and nothing that it says to try has made any difference whatsoever :/
Oh well, thanks anyway......
Edited by - wmull on 26 April 2001 21:18:07 |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 26 April 2001 : 21:15:31
|
Just to make sure...you ran setup.asp, right?
|
|
|
|
wmull
Starting Member
7 Posts |
Posted - 26 April 2001 : 21:19:11
|
Running setup.asp gives me this error:quote:
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 : -2147467259
|
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 26 April 2001 : 21:24:40
|
Try this as your virtual connection string:
quote:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/bw/forum/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
<-- Eric -->
http://insidewaco.com/forum
(That's all one line, its just wrapping it here)
Edited by - e3stone on 26 April 2001 21:30:33 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 26 April 2001 : 21:44:09
|
You don't need to run setup.asp for the included Access database.
Almost certainly you have a permissions issue. Make sure IUSR_computername has read/write/modify permissions to the mdb file and it's folder (use NT explorer). Strangely, setting these permissions for Everyone doesn't get the job done.
Also, is the path in your string a physical path (there is a directory on your disk ..\mindlessgames.com\..)? If you have a question on the physical location, go to forum.snitz.com and follow links to download a 'whereami' tool to verify the folder location.
======
Doug G
====== |
|
|
|
wmull
Starting Member
7 Posts |
Posted - 27 April 2001 : 20:07:46
|
I tried that string you gave me and it doesn't work either.
I don't believe it's a permissions problem, because IUSR_WIDHN0031ATL2 (Internet Guest Account) has Change permissions for the bw/forum/ folder, and everything in it.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
wmull
Starting Member
7 Posts |
Posted - 29 April 2001 : 18:15:03
|
I've been all through all those pages, and none of them have helped me with my problem.
|
|
|
| |
Topic |
|
Topic Locked
