| Author |
 Topic  |
|
|
alanwhitney
Starting Member
3 Posts |
 Posted - 08 May 2001 : 15:14:19
|
I am trying to get the forum up and running on my host's system but can't get the connection string to work. I am hosted on Interland, which provides a tool for created the connection string. This gave me:
Provider=Microsoft.Jet.OLEDB.4.0; Network Library=dbmssocn; Data Source=D:\64.226.189.54\snitzforum\data\snitz_forums_2000.mdb;User ID=;Password=;
The location of the forum files is:
/64.226.189.54/snitzforum
and the data is in:
/64.226.189.54/snitzforum/data/snitz_forums_2000.mdb
When I use this string and go to the Snitz Forum default page (default.asp) I get a non-specific server error (HTTP 500 - Internal server error). I tried creating a small test page that would read the database:
<%@ Language=VBScript %>
<%
Dim rsADO
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Network Library=dbmssocn; Data Source=D:\64.226.189.54\snitzforum\data\snitz_forums_2000.mdb;User ID=;Password=;"
'ConnectionString = "DSN=FORUM"
Set rsADO = Server.CreateObject("ADODB.Recordset")
Source = "SELECT * FROM FORUM_FORUM"
rsADO.Open Source, ConnectionString
if not rsADO.EOF then
Response.Write rsADO("CAT_ID")
Response.Write rsADO("F_SUBJECT")
end if
set rsADO = nothing
%>
This file gives me the following error when I run it with the connection string recommended by Interland:
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/snitzforum/test.asp, line 20
If I use the DNS connection instead the file runs and returns the values in the database. Any help that you can give to sort out the connection problem will be greatly appeciated!
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 May 2001 : 16:19:16
|
Just try using
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/snitzforum/data/snitz_forums_2000.mdb")
64.226.189.54 is your IP address not a physical path
|
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 May 2001 : 16:22:21
|
quote:
64.226.189.54 is your IP address not a physical path
D:\64.226.189.54\snitzforum\data\snitz_forums_2000.mdb may be a physical path as well, at least on NT/W2K servers.
======
Doug G
====== |
|
|
|
alanwhitney
Starting Member
3 Posts |
Posted - 08 May 2001 : 18:53:52
|
I am running on a WIN2K server so the connection string I listed should have worked. I went back and tried the virtual path:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/snitzforum/data/snitz_forums_2000.mdb")
This allows me to access the database from my test program but the default.asp still doesn't work. I also tested the follwoing by themselves:
config.asp - works
inc_functions.asp - works
Unfortunately, the server doesn't return any information when default.asp doesn't run; I don't know if it gets through the inc_top.asp file or bombs in the default file itself. Everything works on my computer running IIS and localhost - it just won't run on Interlands.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 May 2001 : 19:01:44
|
in IE, select the Tools|Internet Options from the menu, then select the advanced Tab. scroll down the list of options until you find
'Show friendly Http errors' make sure the box is NOT checked, press the OK button, and then try your forum again
|
|
|
|
alanwhitney
Starting Member
3 Posts |
Posted - 08 May 2001 : 19:19:15
|
Thanks! That has been a problem for a long time.
The error message is:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'ReadLastHereDate'
/snitzforum/default.asp, line 59
so the default.asp is stopping at this section:
if IsEmpty(Session(strCookieURL & "last_here_date")) then
Session(strCookieURL & "last_here_date") = ReadLastHereDate(strDBNTUserName)
end if
Any suggestions?
|
|
|
| |
Topic |
|
Topic Locked
