| Author |
 Topic  |
|
Benny Lee
Starting Member
20 Posts |
 Posted - 13 July 2001 : 11:28:32
|
My ISP support ASP. I have spend a couple of days to read most of the message about this topic in this forum and try all the suggestion but no luck. I uploaded the unziped forum folder to my www folder, the mdb to my database folder. When I go to setup page I got this message
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 : -2147217843
My root folder structure is:
my directory > cgi bin, database, www >forum
http://www.cyborgstudio.com/forum/setup.asp
Please help
Thank you in advance |
|
|
Id
Junior Member
USA
129 Posts |
Posted - 13 July 2001 : 11:34:35
|
what's the connection string (strConnString) in config.asp look like?
Also, what version of Access is your ISP running? 97 or 200?
Edited by - Id on 13 July 2001 11:35:36 |
 |
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 13 July 2001 : 12:48:32
|
This is the connection string I have use
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../database/cyborg_forum.mdb") '## MS Access 2000 using virtual path
My ISP suggested me to use Access 97 with Snitz, I believe they support 2000 Access as well
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 13 July 2001 : 13:08:14
|
Go here http://forum.snitz.com/archive/default.asp?catid=11&cattitle=Forum+Setup+Tools and download the "Where Am I?" tool. Extract the script to where your database is and browse to it using your browser. It will tell you the direct location to your database you will use that path in the following connection string:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PATH TO DATABASE;" '## MS Access 2000
Replace the letters in red with the path you got from the script.
- David |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 13 July 2001 : 13:51:57
|
do the whereami.asp, and as far as the access database, I had a problem with my ISP and Access, they were running access2000 on their servers, but since the mdb that comes with the snitz download is access97 it wouldn't work. I had to convert my database to access2k and then upload it again in order for it to work properly
|
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 13 July 2001 : 17:15:35
|
I have put a whereami.asp page in my database folder to try to find out the path to the database, but I can not access that page from the browser since it is located outside the www folder. I put another file into the www folder then I got this path
Path Translated: w:\inetpub\wwwroot\cyborgstudio\www\whereami.asp
I have modify the string to the following
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=w:\inetpub\wwwroot\database\cyborg_forum.mdb" '## MS Access 2000
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=w:\inetpub\wwwroot\cyborgstudio\database\cyborg_forum.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=w:\inetpub\wwwroot\cyborgstudio\database\cyborg_forum.mdb" '## MS Access 2000
None of this work.
Can someone help please
|
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 13 July 2001 : 17:44:32
|
ok, what you need to check now is what version of Access your ISP is running, because if it's 2000 then the Snitz database'll need to be upgraded, and if that's the case, i can e-mail you a converted database
|
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 13 July 2001 : 22:04:27
|
Can you please email it to me asap? I think it would be faster for me to try the upgraded database then to wait for the ISP to answer my question.
My email address is lpm@interlog.com
Thank you very much for your help
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 13 July 2001 : 22:09:10
|
Can you log in via FTP to your site?
If so, what is the location of the database directory in relation to your www directory? |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 14 July 2001 : 00:09:50
|
it's winging it's way to you, sorry it took so long for me to get it there, but it'll show up here eventually, if the e-mail by chance doesn't show up, you can grab it here from my FTP server ftp://ftp.gamers-hub.com. Hope this gets you working.
|
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 14 July 2001 : 01:08:36
|
To answer Richard Kinser's question. Under my directory, I have 3 folder created by the ISP, cgi-bin, database and www. The wwww folder is where I put my site's file and the forum folder was created inside it. The mdb file was put in the database folder.
ID, I have received your Access 2000 file, I will try it first thing tomorrow. Thank you so much for your help.
|
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 14 July 2001 : 08:36:56
|
I make a mistake on the last post. Under my directory, I have 3 folder created by the ISP, ftp, database and www. I don't have a cgi-bin.
I have try the Access 2000 mdb file but I still got the same error message.
I have change the mdb name to cyborg_forum. Do I need to change other files to matc?
Do I need to ask the ISP to set the DSN?
This is my string
snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=w:\inetpub\wwwroot\cyborgstudio\database\cyborg_forum.mdb" '## MS Access 2000
Any suggestion?
Thank you
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 July 2001 : 19:31:33
|
I get this when I go to your forums:Microsoft JET Database Engine error '80040e4d'
Not a valid password.
/forum/inc_top.asp, line 42 From what you are saying to the location of your database, I would think that your last post is using the correct path:strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=w:\inetpub\wwwroot\cyborgstudio\database\cyborg_forum.mdb" '## MS Access 2000 But just to make sure, can you post your strConnString and strDBType from your config.asp file, just to make sure you have everything ok in there since you made a few modifications.
If your connection strings are ok, and it is still asking for a password it would mean that you need to give the "Anonymous User" (IUSR_computername) account read/write/modify access.
- David |
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 14 July 2001 : 20:26:37
|
The message I got is different from yours no matter which string I use please see my first post.
The setting I use for the forum is
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=w:\inetpub\wwwroot\cyborgstudio\database\cyborg_forum.mdb" '## MS Access 2000
I am on a Mac running OS 9.04 and using Netscape 4.74
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 July 2001 : 20:51:47
|
Since you are using access database you don't need to run the setup.asp file. Because all the database fields and tables are already setup in the database file that came with the zip. So you would need to go to http://www.cyborgstudio.com/forum/default.asp and you will see the error I am talking about.
You could try sending the error message to your ISP and ask them why it's asking for a password when trying to connect to your database.
I did some searching at the MSDN site and learnt that it might be that the database you are trying to connect to is password protected. If you have access you can open download the database and open it up and take the password off the database.
- David |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 July 2001 : 21:00:07
|
Did you password protect your mdb file for the forum? You may need to provide the database username and password in your connection string. Try adding "...;User Id=Admin;Database Password="""";..." in your connection string.
Admin is the default for a .mdb file, if you changed it use the appropriated username and password.
Your problem is that your web server fails to log into the database. Permissions are probably OK, since the server gets far enough along to try loggin in.
======
Doug G
====== |
|
|
|
Topic |
|
Topic Locked
