| Author |
 Topic  |
|
|
malexandria
Starting Member
25 Posts |
 Posted - 27 May 2001 : 12:13:50
|
Hello,
I just tried to install Snitz Forums, and am having problems. The instructions are not very clear. I'm testing the settings on my my PWS before I transfer it over to the webserver. My settings are below, here's the error. The obvious followup will be how do I set it for a DSNless string when I transfer it over to the server? The database will be in the directory above the root directory. I'm trying to connect to an access 2000 DB.
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"
So I set my configuration settings to the following
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./database/snitzforums.mdb") ## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\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=PASSWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
|
|
malexandria
Starting Member
25 Posts |
Posted - 27 May 2001 : 12:51:19
|
OK, I uncommented the connection string and now I get the following error message
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the m home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/xxxxx/snitz302/config.asp, line 55, column 111
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./database/snitzforums.mdb") ## MS Access 2000 using virtual path
--------------------------------------------------------------------------------------------------------------^
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Page:
GET /emdream/snitz302/setup.asp
Time:
Sunday, May 27, 2001, 12:55:06 PM
More information:
Microsoft Support
quote:
Hello,
I just tried to install Snitz Forums, and am having problems. The instructions are not very clear. I'm testing the settings on my my PWS before I transfer it over to the webserver. My settings are below, here's the error. The obvious followup will be how do I set it for a DSNless string when I transfer it over to the server? The database will be in the directory above the root directory. I'm trying to connect to an access 2000 DB.
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"
So I set my configuration settings to the following
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./database/snitzforums.mdb") ## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\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=PASSWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
 |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 27 May 2001 : 15:04:10
|
You removed one ' to many:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./database/snitzforums.mdb") ' ## MS Access 2000 using virtual path
Pierre
Join the Snitz WebRing |
|
|
|
malexandria
Starting Member
25 Posts |
Posted - 27 May 2001 : 15:57:57
|
Thanks,
However it's still not working. My current directory structure on my local machine is
em
- snitz
- database
- forumsnitz.mdb
Once I move everything over to the webserver the database will be moved above the root.
For the sake of testing, I can't seem to get it to work on my IIS5/PWS
Here's my current settings, I don't think I changed anything
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS
Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitzforums.mdb") '## MS Access
2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\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=PASSWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
which is giving me the same error message as before and I'm sure I have my permissions set properly on my local machine.
quote:
You removed one ' to many:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./database/snitzforums.mdb") ' ## MS Access 2000 using virtual path
Pierre
Join the Snitz WebRing
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 May 2001 : 23:03:04
|
That's still not right.
First, you need to remove the little quote ' at the begining of the line. It's right in front of the word strConnString.
--->'<--- strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb;" '## MS Access 2000
See the arrows pointing to it? Ok, once you remove that, you need to set the location of the database. So with the structure of the folders you gave in your last post I would presume your database is located at C:\snitz\database\forumsnitz.mdb. If so, this is what your connection should now look like:strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\snitz\database\forumsnitz.mdb;" '## MS Access 2000
|
|
|
|
malexandria
Starting Member
25 Posts |
Posted - 28 May 2001 : 09:11:57
|
Ok, now I'm frustrated, it's still not working. I'm running Win2K with IIS 5. My hostprovider is running the same, all I want to do is test it on my machine using a DSNless connection first, and then transfer everything over to my host providers machine. Where the database is going to be above the www folder.
My directory on my home machine is outside my Inetpub directory. I set up a virtual path to it.
So here is the complete directory structure, it's setup as a virtual directory on the c drive it's
C:/emdream/
- Snitz3.02
- Database (The Database folder is it's own separate folder, that's not in the Snitz Folder)
* snitzforums.mdb Access 2000
I tried the most recent suggestion and it's still not working. Here are my current settings.
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitzforums.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitzforums.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=PASSWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
|
|
|
Deleted
deleted
4116 Posts |
Posted - 28 May 2001 : 10:24:55
|
quote:
'#################################################################################
strDBType = "access" THIS IS OK
BELOW ONE OF THEM ARE TOO MUCH, YOU MUST HAVE ONLY ONE (GIVEN BELOW)
'## Make sure to uncomment one of the strConnString lines!
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitzforums.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitzforums.mdb;" '## MS Access 2000
THE FOLLOWING ARE OK
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Well, if you have different directory structures in local and remote server (I mean for the database) you need to have different config.asp files. After uploding the files via FTP, just edit the config.asp file at the remote server. To be able to write the correct configuration, I need to know where the database is in each case. But lets take hypothetical examples:
LOCAL:
Say, you have the forum files in c:\emdream (which keeps your site locally), and the databases are at c:\emdreamdb, then your config asp needs ONLY use (there must be a comment at the beginnning on other)
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\emdreamdb\snitzforums.mdb;" '## MS Access 2000
REMOTE:
Say, your host has the folloving structure: The html files in e:\users\emdream.com\html\ (which keeps your site), and the databases are at e:\users\emdream.com\db\, then your config.asp on the remote server needs ONLY use (there must be a comment at the beginnning on others)
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ce:\users\emdream.com\db\snitzforums.mdb;" '## MS Access 2000
Hope this helps...
Bulent Ozden |
|
|
|
malexandria
Starting Member
25 Posts |
Posted - 28 May 2001 : 12:16:47
|
Cool! That worked, ...can you feel the "but" coming. Now when I click to go to the forum, I'm now getting the following error message.
Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'FORUM_A_TOPICS'. Make sure it exists and that its name is spelled correctly.
/emdream/snitz302/default.asp, line 297
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Page:
GET /emdream/snitz302/default.asp
Also is this a DSNless connection string or a DSN based one?
quote:
quote:
'#################################################################################
strDBType = "access" THIS IS OK
BELOW ONE OF THEM ARE TOO MUCH, YOU MUST HAVE ONLY ONE (GIVEN BELOW)
'## Make sure to uncomment one of the strConnString lines!
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitzforums.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitzforums.mdb;" '## MS Access 2000
THE FOLLOWING ARE OK
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
Well, if you have different directory structures in local and remote server (I mean for the database) you need to have different config.asp files. After uploding the files via FTP, just edit the config.asp file at the remote server. To be able to write the correct configuration, I need to know where the database is in each case. But lets take hypothetical examples:
LOCAL:
Say, you have the forum files in c:\emdream (which keeps your site locally), and the databases are at c:\emdreamdb, then your config asp needs ONLY use (there must be a comment at the beginnning on other)
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\emdreamdb\snitzforums.mdb;" '## MS Access 2000
REMOTE:
Say, your host has the folloving structure: The html files in e:\users\emdream.com\html\ (which keeps your site), and the databases are at e:\users\emdream.com\db\, then your config.asp on the remote server needs ONLY use (there must be a comment at the beginnning on others)
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ce:\users\emdream.com\db\snitzforums.mdb;" '## MS Access 2000
Hope this helps...
Bulent Ozden
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 May 2001 : 14:06:36
|
quote:
The Microsoft Jet database engine cannot find the input table or query 'FORUM_A_TOPICS'. Make sure it exists and that its name is spelled correctly.
You get that error because you are using the ALpha version of the forums. Please go here: http://forum.snitz.com/alpha.asp and read the "Special Instructions" section. And please remember the Disclaimer:
Alpha Versions are not supported in any way. They are not Upgradeable. They are not recomended for any use other than testing. They are intended as a means for the Development team to iron out early bugs in the software before they reach the open beta stages of development when the test base is much larger. Use at your own risk.
|
|
|
| |
Topic |
|
Topic Locked
