UPDATED!! - For those who still experience " argument of wrong type" error after following my documentations:
A piece of advice : unfortunately, you didn' t successfully enable " application" .
On the server I am using, application can be created in the way i described in the document. However, on one of my other host, application can' t be created no matter what via frontpage (it has to do with host' s security configuration--in other words, they don' t supply full functionalities of frontpage)
This has to be the cause because I examined the two lines in regpro.asp and logpro.asp that caused the error and they both happened to be the statements that open recordset. There are two arguments " adCmdText" and " adCmdStoredProc" in either line, which reference a typeLib in global.asa. If you didn' t create application state properly, global.asa won' t run-> typeLib won' t get referenced->error occur.
the best solution to this is to find your web host and let them enable application on the forum' s folder for you. I have to do this on another host of mine too. There is no other ways around.
12/09/2001 Turn On global.asa in Win95/98 with PWS This is a paragraph I got from the net, and I am unsure of the original author. I am in no way claiming that I am the author of the following paragraphs. Now, read on:
I' ve been getting a lot of email about this article and originally thought that it was all just because the article was new and a lot of people were reading it... well it' s around nine months later and I' m still getting them so I' m adding this to try and explain the issue a little.
In order for the web server to know to look for and process this global.asa file you need to set up your directory as an application in IIS. This is done by navigating to the appropriate web site or directory in Internet Services Manager and right clicking on it and selecting " Properties" from the pop up menu. Then select the " Directory" or " Home Directory" tab and on the bottom half of that window you will see the " Application Settings" section. If it' s not already, you need to make the directory an application by pressing the " Create" button. Click " Ok" to save the setting and exit.
In PWS on Windows 95/98 this is done differently. You need to go to the Personal Web Manager and then click on " Advanced" in the bottom left. In the directory tree you should see an entry named <Home>. Select it and click the " Edit Properties..." button. In the resulting dialog box ensure that all three checkboxes are checked (Read, Execute, and Scripts). Click " Ok" to save the setting and exit. This will enable processing of the global.asa in PWS.
12/10/2001 ========================================================================
It is time for me to address several issues most users found when installing my forum because I received many e-mails everyday almost asking same questions.
The guidelines to a successful installation: 1) You have to read through the
online documentation before installing this app. It includes how you can set up " application" state as well as basic system requirements
2) You have to read through the readme.txt file included in the zip (I attached it here which can be found at the end of this message). It has details on how to migrate to a new database (very easy, very straight forward, and very short). This readme file explains something that has not been written in the online documentation. (I don' t have time to update the online documentation, so most of the new details are written here)
Common issues that haven' t been addressed in the above two documents: 1) Date time format. The downloadable Access version supports US Long date format, and nothing but US Long date format. There is a flaw in the current implementation of the datetime format in Access version. A lot of work has been done in the upcoming SQL version to eliminate *ALL* problems in the presentation of datetime. I have tried a least 3 different approaches and finally settled for an ideal one. It will allow you to specify all date arrangements using symbols based on your need.
2) PWS and NT4(IIS 4). My forum will work as long as you turn Response Buffer on in your system " manually" , and install current MDAC and VBScript versions in your system. (MDAC 2.6, VBScript 5.5, as detailed in the document)
3) Sort Order of messages. The sort order is based on the date of post of the topic, and not " Last Post of the entire thread" . My forum features two interfaces, so I need to go for the current implementation, and it is fixed in order to preserve performance. If you have read thru my posts in this forum, you will see how much I have put in this Access version to ensure maximal performance. The problems most people encounter with other Access-based message forums are that once their forums start to become popular, their forums fail. Why? because message board authors don' t take performance as their top priority. Due to the nature of Access, it can' t do much without proper paging algorithm, sophisticate caching algorithms, and balance between client/server load. They can put all features they think might be useful in their forums without careful considerations regarding overhead/performance issues their features or their implementations may have imposed to the overal functionality/usability of their forums. In ASP Playground, all features are optimized one way or the other to the maximal extent for Access. So, what do I do to change the sort order IF I REALLY WANT TO? ANSWER: change my code.
4) Can I port this Access version to SQL server? No, you can' t without heavy modification. Why? Because I build this version to use all possible and reasonable optimization techniques for Access, which SQL server either doen' t have or has but in complete different forms. I know some of the forums use inline-SQL that allow you to port them to ACCESS or SQL or even mySQL (basically all RDBMS' s). This approach is not good in my opinion. They will suffer big times sooner or later no matter what backends they use. God, this is a long story, so I will leave it here. The reason for separate backend codes for different RDBMS' s is that I can optimize the forum using all features available in any particular backend.
5) What is different in the upcoming SQL version? Features with 5000% performance based on " requests/second" counter with 100,000 topics in any particular forum. It means that no matter how popular your message board is gonna reasonably be, it will not suffer because of performance. " USEFUL" features for forum system that will not sacrifice performance too significantly are all parts of the SQL version, including " Favorite" , " Subscription" , " Short message" , " Different registration schemes" , " Much Improved configurability of the forum" , " Member picture uploading" , " Online User status" , " Post Ranking" , " Advanced Search" , " Avatars" etc.
6) PGDCode/HTML. If you enable HTML for a particular forum, PGDCode is disabled for that forum . All PGDCode will still work in other forums. In the upcoming SQL version, all HTML will be disabled and a richer set of PGDCode will be provided to allow formatting for security reasons.
7) I can' t access the admin panel? You will need to login before using admin functions. The default is admin:admin (login:password)
If there is anything I haven' t answered in this long message, please e-mail me or post in this forum. I am open to any comment and suggestion. More importantly, if you have any specific concerns about the database design (normalization level, indexing, or anything), please feel free to post in this forum, and I will be happy to answer/discuss with you.
_____________________________
< Message edited by samuel -- 2002-07-16 22:40:03 >