| Author |
 Topic  |
|
|
wcameron
New Member
55 Posts |
 Posted - 15 April 2001 : 18:39:44
|
I have two websites, both hosted with Interland. The folders are set up exactly the same with the snitz_forums_2000.mdb in the fpdb folder and the rest of the files in the forum and forum/tools directory.
I have selected the following:
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Yet on one of the web sites the program works fine, and on the other it does not work at all.
www.WardCameron.com/forum works
www.MountainNature.com/forum does not work.
Please help
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 April 2001 : 18:48:48
|
| Have you tried re-uploading the database? |
 |
|
|
wcameron
New Member
55 Posts |
Posted - 15 April 2001 : 19:01:44
|
I have tried to re-upload the database. When I did this, I got the following message when I tried to open the default.asp file
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 : -2147467259
After this first attempt, I get a message indicating that the page cannot be displayed when I try to open the page.
you can try it at www.mountainnature.com/forum
thanks
Ward
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 April 2001 : 21:11:49
|
that is weird that it works on one site and not another.
Can you open the database in MS Access? |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 15 April 2001 : 21:27:52
|
I'm just guessing, is it possible your two webs are part of only one web application, sharing an Application collection?
======
Doug G
====== |
|
|
|
wcameron
New Member
55 Posts |
Posted - 15 April 2001 : 21:51:36
|
No, they cannot be part of one web. They are hosted on different servers with different IP Addresses. I've tried deleting all the files and uploading them again. Here is how I stand currently:
Config.asp:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\64.225.57.5\fpdb\snitz_forums_2000.mdb" '## MS
Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '##
MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.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
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
When I try to run the forum, I get the following message:
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 : -2147467259
I have set up the Database connection in FrontPage 2000 and verified it. I do not use DNS's. Do I need to. The working forum does not use them. My connection is called "snitzforums".
My server uses MS-IIS/5.0 with Front Page Server Extensions version 4.0.2.4324. This is the same as the working site.
The folders are set to the following permissions:
forum and forum/tools = Read-Write-Execute
Thanks for your help
Ward
|
|
|
|
wcameron
New Member
55 Posts |
Posted - 15 April 2001 : 21:58:16
|
Another update.
I tried to run with the following in the config.asp file and got the same result.
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\64.225.57.5\fpdb\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\64.225.57.5\fpdb\snitz_forum.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
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
I got the path by creating a Whereami.asp file as recommended elsewhere in the postings and got the following path: Path Translated = d:\64.225.57.5\forum\whereami.asp
Still getting the following message:
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 : -2147467259
Oh Well, still trying
Ward
|
|
|
|
wcameron
New Member
55 Posts |
Posted - 16 April 2001 : 10:52:33
|
I have a new problem. I started from scratch and uploaded the forum software from scratch. First, however I updated the access database to v2000. When I first had problems with the forum on this site, it was because it could not make a connection with the Access 97 version of the database. Updating it helped solve this problem.
Now, it is working swimmingly, but it won't let me log off. If I click the logout button, it gives me the message that I logged out successfully, but then returns with the message that I am logged on as Admin.
Ward
|
|
|
| |
Topic |
|
Topic Locked
