|
|
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=26799&image=1&table=forumreplies' class='bbc_emoticon' alt=':angry:' />
When trying to register a user on a very simple test site with two tables: - Categories, 30 records, Cat_ID=PK,
- Members, 1243 RECORDS, User_ID=PK.
Fill in Registration Page for a NEW USER (testing only), click Submit and I get the following:
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/aspr/register.asp, line 240
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Embedded Web Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648)
Page:
POST 1036 bytes to /aspr/register.asp
POST Data:
error '80020009'
Google of the interweb yeilds this link:
http://support.microsoft.com/kb/q278604/
Read page from MS:
***SYMPTOMS
When you attempt to access a provider from within an Active Server Pages (ASP) page, you may receive the following error in the browser:
HTTP 500.100 - Internal Server Error - ASP error Internet Information Services
If friendly HTTP error messages are disabled, you may receive the following error message when you attempt to run the ASP page:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/Nwind.asp, line 10 (AUTHOR NOTE: This is an example of an ASP page in this MS Article).
Back to the top
CAUSE
This error occurs because a dynamic-link library (DLL) that is required by the Microsoft Data Access Components is not registered.
Back to the top
RESOLUTION
NOTE: This resolution uses a SQL Server OLE Provider DLL (Sqloledb.dll) as an example. Because the unregistered DLL may vary based on the OLE DB Provider that you are using, modify step 2 accordingly.
To resolve this problem, reregister the faulty DLL as follows:
- At a command prompt, change to the C:\Program Files\Common Files\System\Ole DB folder.
- At a command prompt, type the following command:
regsvr32 sqloledb.dll
- You should receive confirmation that the DLL is registered successfully.***
I checked to see if SQLOLEDB.DLL is registered - YES.
AND what is http://bsalsa.com, why it there a link or something in the code generated to refer to this site. This site develops freeware solutions for Delphi. Never used Delphi, never will and I have no idea what this is.
My system is ABSOLUTELY Bot, Virus and Torjan Free. Always has been, always will be.
Now this all works fine in ASPmaker, and has for about 6 months. I can't get this to work in ASPrunner. In addition, I still get all kinds of "Errors to do with MULTI-UPDATE!!!"
I logged in with a user that already exists in the DB and that works. I just can't register a NEW USER.
So, I nuke this project, cleaned up my Test virtual site, nuked it in IIS, recreated it in IIS. Created a NEW PROJECT and same thing - EXACTLY.
I created a test project with ASPmaker and Codecharge Studio to do exactly the same thing. They both worked fine, no problems or errors.
I certainly don't intend to harp about other products, I mention them for completeness of information this post. Indeed, I am seriously looking at moving my company to this product as I believe it has great potential and seems a lot easier to generate the bulk of the code we need to our clients and my own company requirements.
As a potential new purchaser I always evaluate software first, particularly when we are taking about a few hundred dollars with the likely hood of 6 or more copies. So far (and I've made about 6 posts in 2 days) this is not faring well.
I've been an MS MCSE MVP and Developer for over 35 years and this is getting to me and two of my developers. I/we always check everything I can think of, Forums, NGs and all my experieces before I post.
Will someone please point me to a fix for ASPrunner. This has nothing to do with my system nor my SQL, nor my IIS, nor anything. In my mind, this is clearly an ASPrunner issue.
ADDITIONAL INFORMATION:
I ran this code through my ASPstudio 2006 debugger (set this project up as Default and set breakpoints in Registration.asp). Here is the error message returned by my debugger:
Error as displayed in IE6 and Firefox Browser Page:
ASP Server Finds errors during running,
the following are the details for the errors:
Microsoft VBsrcipt runtime error
error code: 0x800A0009
Error Source: if trim(ctarray(0) = "multipart/form-data" then
error description: Subscript out of range: '[number: 0]'
FileName: e:\aspr\include\commonfunctions.asp
Line No: 2334
In my ASPstudio Debugger, the popup balloon message is the same.
SO, there is a problem in the code generated/used by commonfunctions.asp.
Maybe someone can help now!
|
