| Author |
 Topic  |
|
|
Zuel
Average Member
USA
540 Posts |
 Posted - 17 June 2007 : 12:50:50
|
strDBType: access
strConnString: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Windows XP Professional
Microsoft Access 2003 Installed
I don't have a security Tab, however, I have shared the application folder on the network. I even went into IIS and set the directory as an application and gave it execute rights.
Google reports the following:
Database is open by another user
Security rights - No Write ability on user
My prognosis:
BS. There is no other application or user using this database. For a matter of fact, every new and old database now fails with this error and I dunno why. Has anyone ever encountered and fixed this error? Google and MSDN have not provided solutions.
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 June 2007 : 20:30:47
|
First, you should turn off "simple file sharing" and you'll then have the security tab in explorer (assuming you're using ntfs). Check for any orphaned .ldb file along with your .mdb, if there is one close everything, delete it, and try again.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
Zuel
Average Member
USA
540 Posts |
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 20 June 2007 : 18:47:00
|
quote:
Originally posted by Doug G
First, you should turn off "simple file sharing" and you'll then have the security tab in explorer (assuming you're using ntfs). Check for any orphaned .ldb file along with your .mdb, if there is one close everything, delete it, and try again.
No dice.
Connection String #1:
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Connection String #1 Error:
There has been an error !!
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 :
Unspecified error
Click here to retry.
Connection String Suggested by WhereAmI.asp:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\wwwroot\avatarmod\snitz_forums_2000.mdb" '## MS Access 97
Connection String Suggest by WhereAmI.asp Error:
There has been an error !!
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]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa08 Thread 0xfe4 DBC 0x1633e14 Jet'.
Click here to retry.
|
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
optimal
Starting Member
12 Posts |
Posted - 23 June 2007 : 05:13:20
|
I am having a similiar problem...
I am moving our forum from one host to another.
On the old server the connection string worked as:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\virtualwww\[domainname]\data\snitz_forums_2000.mdb" '## MS Access 97
I was getting a similiar error message to Zuel until I tried on the new server the connection string I can get to work is:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/data/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
So now the forum default page comes up showing all the forums and topics but all of the graphics are missing and there is no login button and the links to the forums work but the links to the topics generate an error message:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/forum.asp, line 329
I tried changing adOpenStatic to 3 but that did nothing
Can anyone help here? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 23 June 2007 : 10:49:56
|
quote:
Originally posted by ruirib
Make sure you have the latest MDAC and Jet Service Pack. If that doesn't work, I suggest that you install, MySQL and/or SQL Server Express Edition.
This did not work. I currently have Msjet40.dll version 4.0.8618.0 which is the latest for WindowsXP.
Reference: http://support.microsoft.com/kb/239114
I guess I'll continue development on another machine. Bummer  |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 23 June 2007 : 23:36:48
|
As another guess, make sure the IIS user account has read/write permission on the .mdb file, and the folder that the mdb is in. Also try adding the IIS user to the %TEMP% file permissions. Have you opened the mdb in Access itself and tried a compact & repair on it?
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 24 June 2007 : 10:13:13
|
quote:
Originally posted by Doug G
As another guess, make sure the IIS user account has read/write permission on the .mdb file, and the folder that the mdb is in. Also try adding the IIS user to the %TEMP% file permissions. Have you opened the mdb in Access itself and tried a compact & repair on it?
This problem happens on a fresh install.
I found a solution, here's the steps to help others:
1. Explorer > Tools > Folder Options > View > (Uncheck) Use Simple File Sharing
2. Navigate to the MDB or cgi-bin > Right Click > Properties > Security > I gave "everyone" Full Control
You can modify the security more in depth but I'm the only user on my computer.
Thanks for the help, that bug has been around for months. |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
optimal
Starting Member
12 Posts |
Posted - 24 June 2007 : 13:47:58
|
quote:
Originally posted by ruirib
Did you run setup.asp?
Thanks so much for this tip, I had never installed a snitz forum and did not know about this. It was a 5 second solution to my problem! |
|
|
|
optimal
Starting Member
12 Posts |
Posted - 24 June 2007 : 13:49:26
|
quote:
Originally posted by optimal
quote:
Originally posted by ruirib
Did you run setup.asp?
Thanks so much for this tip, I had never installed a snitz forum and did not know about this. It was a 5 second solution to my problem!
PS What is setup_login.asp for? |
|
|
| |
Topic |
|
Topic Locked
