| Author |
 Topic  |
|
|
StormKing
Starting Member
18 Posts |
 Posted - 18 February 2004 : 15:02:40
|
I don't have a WINNT directory on my server that I'm aware of, so, why am I getting this message?
Microsoft JET Database Engine error '80004005'
'C:\WINNT\system32\peternielsen\wwwroot\sf2k3404\ppff2k.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/SF2K3404/inc_header.asp, line 111
Should the string have a 'C:\' in it? Or should it have an 'http://www'? Should the statement be enclosed in ""?
This is what my entry, including the strConnString looks like:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=peternielsen\wwwroot\sf2k3404\ppff2k.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 18 February 2004 : 15:07:01
|
| it should have c:\ in it. but i really doubt that your host has placed your web files in the winnt\system32 folder. did you run whereami.asp? what did it return? |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
 |
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 16:04:17
|
quote:
Originally posted by Nikkol
it should have c:\ in it. but i really doubt that your host has placed your web files in the winnt\system32 folder. did you run whereami.asp? what did it return?
Nikol, thanks for your reponse. Here's what whereami.asp returned:
C:\peternielsen\wwwroot\sf2k3404\snitz_forums_2000.mdb
|
|
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 16:08:57
|
quote:
Originally posted by StormKing
quote:
Originally posted by Nikkol
it should have c:\ in it. but i really doubt that your host has placed your web files in the winnt\system32 folder. did you run whereami.asp? what did it return?
Nikol, thanks for your reponse. Here's what whereami.asp returned:
C:\peternielsen\wwwroot\sf2k3404\snitz_forums_2000.mdb
Here's what it looks line when I past the result in my file:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("") '## MS Access 2000 on Brinkster
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\peternielsen\wwwroot\sf2k3404\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN |
|
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 16:17:34
|
quote:
Originally posted by Nikkol
it should have c:\ in it. but i really doubt that your host has placed your web files in the winnt\system32 folder. did you run whereami.asp? what did it return?
After pasting the path statement from whereami.asp into the config.asp file, I get this message:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
/sf2k3404/default.asp, line 91
What does this mean?
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 16:25:40
|
quote:
Originally posted by Nikkol
1. is your database in the sf2k3404 folder and did you keep the original name?
2. did you run setup.asp?
Nikol, the database currently has the default name. It was different, but I changed it back until I can get this problem resolved. Furthermore, I have not run setup.asp. |
|
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 16:36:27
|
quote:
Originally posted by Nikkol
1. is your database in the sf2k3404 folder and did you keep the original name?
2. did you run setup.asp?
Nikol, I ran setup.asp and got this message:
The database needs to be installed !!
You need to create all the tables in the database before you can start using the forum.
Click here to create the tables in the database.
Click here to retry.
I tried it and got 13 errors. Do I need to upload a virgin copy of the database created in the initial unpack of the zip file? |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 18 February 2004 : 17:07:18
|
| if the error are updateable query errors then it's because the folder you put the database in does not have the correct permissions. didn't you say that you had the database in the fpdb folder in a different post? if so just change the connection string to reflect that folder. also, if you are upgrading, you want to keep your old db so that you don't lose any posts. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 21:47:28
|
quote:
Originally posted by Nikkol
if the error are updateable query errors then it's because the folder you put the database in does not have the correct permissions. didn't you say that you had the database in the fpdb folder in a different post? if so just change the connection string to reflect that folder. also, if you are upgrading, you want to keep your old db so that you don't lose any posts.
Nikol;
I did indicate the file was in the fpdb folder and that the file and folder were both specified in my path statment(s). Nothing seems to be working and I don't know why, because the board was working fine until I tried to upgrade. Here's the latest error 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 : 80004005
Error Description :
'c:\peternielsen.com\wwwroot\snitz_forums_2000.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Here's my latest strConnString:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\peternielsen.com\wwwroot\fpdb\snitz_forums_2000.mdb" '## MS Access 2000 using virtual path
That's where my database is according to whereami.asp.
|
|
|
|
StormKing
Starting Member
18 Posts |
Posted - 18 February 2004 : 22:14:53
|
quote:
Originally posted by Nikkol
if the error are updateable query errors then it's because the folder you put the database in does not have the correct permissions. didn't you say that you had the database in the fpdb folder in a different post? if so just change the connection string to reflect that folder. also, if you are upgrading, you want to keep your old db so that you don't lose any posts.
Nikol;
Don't ask how or why, but after stepping through the connection string path code character by character, the last thing I tried was removing the .com from the end of the domain name in the path. All of a sudden, it worked! Strange considering I have the dot com extention in another path statement for another forum on another web site. But it works, so I don't care why or how.
There's one feature I don't see, however, and that's the forgot password option that is on this particular board. How do I get that feature on my forum?
Thanks.
Storm |
|
|
| |
Topic |
|
Topic Locked
