| Author |
 Topic  |
|
|
AJ
Starting Member
7 Posts |
 Posted - 22 March 2001 : 15:40:41
|
Hello all. I am really pleased with the forum and wish to use it on my site.
I have a problem with setting up the forum. I get an error. IIS 500.100 asp error.
Here is the rest of the text:
Technical Information (for support personnel)
Error Type:
(0x800401F9)
Error in the DLL
/maglan/Forum/inc_top.asp, line 42
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Page:
GET /maglan/Forum/default.asp
Time:
Thursday, March 22, 2001, 2:39:10 PM
More information:
Microsoft Support
I have this in my config:
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=: d:\inetpub\wwwroot\maglan\Database\forums.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/Database/forums.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=: d:\inetpub\wwwroot\maglan\Database\forums.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
Any ideas on why this isn't working as it should.
I work for my ISP so the permission settings should be right.
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 22 March 2001 : 16:01:35
|
Are you sure the Jet drives are installed ? could you try the ODBC connectionstring instead ?
Pierre |
 |
|
|
AJ
Starting Member
7 Posts |
Posted - 22 March 2001 : 16:06:57
|
You guys are quick, I commend you. Now if I could get the techs here to be like you.
When you say odbc line which is this?
What does that code look like?
AJ
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 22 March 2001 : 16:17:25
|
Try using this line:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=: d:\inetpub\wwwroot\maglan\Database\forums.mdb" '## MS Access 97
(remove the ' in front of the line and add it to the other)
Pierre |
|
|
|
AJ
Starting Member
7 Posts |
Posted - 22 March 2001 : 16:27:08
|
I tried that but no dice. still have the same error.
Would you like any more info to help diagnos the problem?
AJ
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 22 March 2001 : 16:39:10
|
Well, I think you need to talk to the tech guys for this one.
Line 42 in inc_top.asp is:
my_Conn.Open strConnString
Here the code tries to open the connection to the datbase.
If it says "Error in the DLL" I think there is something wrong with the server, but not sure. Couldn't find the error-code on www.microsoft.com
Pierre |
|
|
|
AJ
Starting Member
7 Posts |
Posted - 22 March 2001 : 18:17:25
|
Well they all seem to think we are set up for asp. We do alot of Cold Fusion, and all the other databases on that box work. Any other ideas?
AJ
|
|
|
|
AJ
Starting Member
7 Posts |
Posted - 22 March 2001 : 19:14:03
|
For Grins and Giggles I did a no no in my line of work I moved the forum off the development box and put it on a live server. Please don't tell. 
By the way I love this forum.
I got a new error on the live box.
----------------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x534 Thread 0x27c DBC 0x15e0024 Jet'.
/Forums/inc_top.asp, line 42
-----------------------------------------------------------------------------------------
Does this get me closer to this thing working?
AJ
|
|
|
|
AJ
Starting Member
7 Posts |
Posted - 22 March 2001 : 19:17:11
|
New Error
I am close I can just feel it!
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\Shared\Maglan\Database\forum.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/Forums/inc_top.asp, line 42
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 23 March 2001 : 00:43:38
|
Either you were viewing the database in Access at the moment yourself and opened it in Exclusive mode, or the IIS user doesn't have read rights on that directory/the database.
You need to put the database in a directory where the IIS user has read and write rights.
Pierre |
|
|
|
AJ
Starting Member
7 Posts |
Posted - 23 March 2001 : 16:03:10
|
Thanks gor for all of your help. I now am the proud operator of a Snitz forum.
http://www.maglan.net is the destination for the forums. Again thank you for all your help
AJ
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 23 March 2001 : 16:31:42
|
You're welcome AJ, make sure to post the link in the "Show Off Your Forum" so you can get comments from other members here on your site/forum.
BTW, you hadn't changed the admin password yet, so I did that !
You'll find the current admin password in the mail I've sent you 2 seconds ago 
Pierre |
|
|
| |
Topic |
|
Topic Locked
