| Author |
 Topic  |
|
|
yingko
Starting Member
5 Posts |
 Posted - 05 June 2001 : 12:23:57
|
I've read the other messages regarding the database not opening causing the following error:
Code : -2147467259
Here is what I have done. I made a virtual directory called /forum/ I made /tools/ a sub-directory of it. In the directory I have given both snitz_forums_2000.mdb full control by the Anonymous Internet User and to Everyone (I know this is a security hole). I have run the whereami.asp script to verify the correct path for the strConnString and I have downloaded Microsoft Jet 4.0 SP3. It still fails everytime. I have tried the MS Access 97, MS Access 2000 (virtual path), MS Access 2000 vanilla.. None of the different strings will work. the Strdbtype is "access". Here is the relevant portion of my config.asp:
'#################################################################################
'## 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=C:\Documents and Settings\thomasc\Desktop\forums\tools\snitz_forum_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/forum/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\thomasc\Desktop\forums\tools\snitz_forums_2000.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
I am eager to use this product but am frustrated with the setup. I also have uninstalled and re-installed 4 times with slight different configurations (the tools directory being outside of the forums directory, etc.) Nothing has worked. Please advise.
Cheers,
Colin
|
|
|
yingko
Starting Member
5 Posts |
Posted - 05 June 2001 : 12:30:45
|
As a side note.. when I browse directly to http://<servername>/forum/ I get a runtime error crash that yields the following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x720 Thread 0x72c DBC 0x194b00c Jet'.
thanks again for any advice
|
 |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 05 June 2001 : 12:40:41
|
If you can, convert the database to access 2000, then use the 2000 connection string. It looks like you're MDAC is not handling the 97 database very well (I ran into this one my host when they converted to Win2K
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead |
|
|
|
yingko
Starting Member
5 Posts |
Posted - 05 June 2001 : 13:03:50
|
my bad.. I am using access 2000.. I forgot to mention that..
colin
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 05 June 2001 : 14:11:54
|
If you're using Access 2k then why are you using the Access 97 connection string?
http://www.ugfl.net/forums |
|
|
|
yingko
Starting Member
5 Posts |
Posted - 05 June 2001 : 16:21:32
|
I'm simply trying all my options. I tried both the Jet access 2000 strings, and I tried the access 97 because I assumed MDAC would be backward compatible, regardless its moot, because nothing seems to work.
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 05 June 2001 : 16:58:06
|
Are you sure you have read and write access to all on the directory with the database in it? If you have that ability, check and change the permissions there, otherwise e-mail/dial-up your server and have them change them for you.
http://www.ugfl.net/forums |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 06 June 2001 : 07:46:49
|
quote:
my bad.. I am using access 2000.. I forgot to mention that..
So you did convert it yourself, then? The snitz_forums_2000.mdb which comes with the zip is the Access 97 version, not the 2000 version. That misconception has happened before...
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 June 2001 : 12:22:07
|
Maybe something in this article will help.
http://support.microsoft.com/support/kb/articles/q183/0/60.asp
Keep in mind, you're not using Access 97 or Access 2000 when you use a .mdb file in a asp page. More accurately you're using a Jet 3.x or Jet 4.0 ADO (activex data objects) provider.
The connection string labeled Access 97 is actually an ODBC driver for MS Access db's, and the one labeled Access 2000 is an OLE DB provider for Jet 4.0 db's.
======
Doug G
====== |
|
|
|
yingko
Starting Member
5 Posts |
Posted - 06 June 2001 : 12:34:54
|
Thanks for all your help.. On a lark I tried installing it on a separate machine and it came up fine. My laptop must have something screwy in it. Regardles I got it running on my test server and peope are now happilly foruming away :)
I appreciate all the comments I recieved, thanks again.
Cheers,
Colin
|
|
|
| |
Topic |
|
Topic Locked
