| Author |
 Topic  |
|
|
GeneDoc
Starting Member
3 Posts |
 Posted - 29 March 2004 : 07:58:27
|
Hello,
Hopefully I've encountered an error that isn't too obtuse.
I tried setting up a standard forum using Snitz 3.4.04, without mods, on a Windows server and got the following error message:
--------------------------------------
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'ReadLastHereDate'
/forum/default.asp, line 51
--------------------------------------
Based on the Readme.html file, here was my install process:
1. My ISP does support ASP.
2. My database choice is Access.
3. I unzipped all files onto my desktop computer.
4. I edited the 'config.asp' file using Araneae to set the database type to uncomment the strDBType = "access" line.
4a. I renamed the snitz_forums_2000.mdb database to a new name using only numbers and letters, in all caps or in all lower case, and ending with .mdb.
4b. I chose two different connection strings, each without success (yes, uncommented appropriate line with both attempts, leaving only one line uncommented):
- 1st, tried physical path using the 'whereami.asp' file
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<drive>:\<dir1>\<subdir1>\handymed.com\fpdb\<database_name>.mdb" '## MS Access 2000
[NOTE: When I tried using
http://www.handymed.com/fpdb/whereami.asp?dbname=<database_name>.mdb
I still got back
<drive>:\<dir1>\<subdir1>\handymed.com\fpdb\whereami.asp
Shouldn't I have gotten
<drive>:\<dir1>\<subdir1>\handymed.com\fpdb\<database_name>.mdb]
- 2nd, tried then tried a virtual path (uploaded new 'config.asp' file after making change):
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/<database_name>.mdb") '## MS Access 2000 using virtual path
5. I skipped setting table prefixes since I am only setting up one forum.
6. I uploaded all files, except tools.zip and <database_name>.mdb, to:
http://www.HandyMed.com/forum
I did use FrontPage for the transfer, but I checked Tools | Options to ensure that .asp and .js files were transferred using ASCII transfer mode.
7. I uploaded my <database_name>.mdb file to '/fpdb' sub-directory of my site.
[I know the Tip says to NOT place this as a subdirectory, but I couldn't get WS_FTP to let me modify my site, even though it would let me log in.]
7a. I called my ISP to ensure the /fpdb folder had Read|Write permissions set for a forum database. The guy doing this really didn't know if he did this correctly and said I should call back if it wasn't done properly.
8. I tried to open the forum using:
http://www.HandyMed.com/forum and got the error:
--------------------------------------
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'ReadLastHereDate'
/forum/default.asp, line 51
--------------------------------------
So, I don't actually get the forum up 'n running at all. I'm sure there's a fundamental issue here that I'm overlooking, so any help you can provide would be appreciated. Searching for "ReadLastHereDate" didn't give me any solution to this problem on the forum, so I figured I'd ask for help. I hope I've given enough information. Thanks for any help you can provide. |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 March 2004 : 08:04:24
|
could you recheck that your dbtype is set correctly in config.asp runing setup.asp gives the following error
Your strDBType is not set, please edit your config.asp
to reflect your database type.
make sure you only uncommented one of them
|
 |
|
|
GeneDoc
Starting Member
3 Posts |
Posted - 29 March 2004 : 08:29:13
|
Thanks for the quick reply. Here is the appropriate portion of my config.asp 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("/fpdb/<database_name>.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=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<drive>:\<dir1>\<subdir1>\handymed.com\fpdb\<database_name>.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=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## 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
------------------------
So, I think I do only have one dbtype, right? |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 March 2004 : 10:05:22
|
| Only other thing I can suggest is to get your Host to check permissions on your fpdb directory |
|
|
|
GeneDoc
Starting Member
3 Posts |
Posted - 29 March 2004 : 13:49:13
|
Well, I called my ISP to follow up on the permissions and it turns out they were NOT set. I knew the person last night didn't know if he'd done it properly and it turns out he didn't. So, I'll need to wait a day or so 'til the settings are changed. I'll be crossing my fingers that it'll be good to go.
I just need to figure out how to move the folder to a parallel directory to my root www directory instead of actually being a subdirectory -- WITHOUT using FTP. Turns out my server plan doesn't have FTP access (didn't know that) and only has FrontPage access.
Thanks for your time and help. |
|
|
|
huck5
Starting Member
4 Posts |
Posted - 18 June 2004 : 06:27:00
|
We just recently migrated to another server, and when we did so, we are now receiving the same exact message in the thread:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'ReadLastHereDate'
/forum/default.asp, line 51
Config.asp was changed to give the path that is now showing in the whereami.asp script, and the code (for specifying an access .mdb has not changed. All paths, files are the same. Nothing to the structure has changed.
Interesting enough, if you are accessing the forum through a proxy server, the forum works ok, but if you are not behind a proxy, you receive this error. Could this be a cookie problem? If so, how do you remedy? Thanks for your help. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
huck5
Starting Member
4 Posts |
Posted - 18 June 2004 : 10:10:37
|
Yes I did, but received:
"Your strDBType is not set, please edit your config.asp
to reflect your database type."
strDBtype is set to "access"
Verified that .asp has started on the server, tried ALL of the different connection types, still no results.
We used the Jet 4.0 connection before. Double checked with the provider to ensure that Jet 4.0 was installed, it's installed.
|
Edited by - huck5 on 18 June 2004 10:13:51 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 June 2004 : 10:22:01
|
| Use whereami.asp as explained in the readme file to find out the connection string to use. You need to run setup.asp without errors before being able to get rid of that first error you reported. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
huck5
Starting Member
4 Posts |
Posted - 18 June 2004 : 10:54:24
|
I have followed the install readme file. I did run whereami.asp, set all options up like we did when we installed forum on original server. When you look in the config.asp file, the strDBType is listed as you can see below:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
|
|
|
|
huck5
Starting Member
4 Posts |
Posted - 18 June 2004 : 12:30:25
|
To test, we created another forum in another folder, and it worked like a charm on the new server. Apparently, something is still incorrect for the initial folder permissions, and we're have the host provided check it out.
Thanks for your help... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
