Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 OLE DB Provider error messages		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

BugLaden
Starting Member

45 Posts
Posted - 27 July 2001 :  18:01:16  Show Profile  Visit BugLaden's Homepage  Send BugLaden an AOL message
After installing what I thought was a flawless upgrade to 3.3.002, I get this message when attempting to view a member profile:
--------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/forum/pop_profile.asp, line 110
--------------------------

And this when I sent a topic to an email address, then attempted to open the link from the email.

--------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.

/forum/inc_functions.asp, line 1089
--------------------------

I double-checked my config.asp settings. They appear normal and all the other functions seem to be working. Any thoughts?

BugLaden
Starting Member

45 Posts
Posted - 29 July 2001 :  17:43:24  Show Profile  Visit BugLaden's Homepage  Send BugLaden an AOL message
--------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/forum/pop_profile.asp, line 110

--------------------------


I fixed the above problem myself by

1) Commenting out lines 74-103, which were individual fields in the select
2) Inserting at line 74
strSQL = "SELECT *"

Any info as to why this would fix the problem? Would this be a configuration shortcoming of my host?

-=BugLaden
CCG Workshop Developer
http://www.ccgworkshop.com
Go to Top of Page

kitsune-udon
Starting Member

5 Posts
Posted - 29 July 2001 :  18:02:25  Show Profile
I have the same problem unfortunately, using SQL server 7

Go to Top of Page

BugLaden
Starting Member

45 Posts
Posted - 29 July 2001 :  20:43:35  Show Profile  Visit BugLaden's Homepage  Send BugLaden an AOL message
SQL 7 is what I am running. So maybe this is a bug in Snitz???

Perform the above steps. It will fix it until they release a patch.

-=BugLaden
CCG Workshop Developer
http://www.ccgworkshop.com

Edited by - BugLaden on 29 July 2001 20:44:03
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 29 July 2001 :  22:46:32  Show Profile
Here are some links that may apply to the error.

MULTIPLE-STEP OLE DB OPERATION GENERATED ERRORS 7/29/2001
=========================================================

Here are some links on this error:

http://support.microsoft.com/support/kb/articles/q269/4/95.asp 'About registry key problemS
http://support.microsoft.com/support/kb/articles/q257/5/56.asp 'Unlikely TABLE_TYPE ODBC http://support.microsoft.com/support/kb/articles/q253/1/57.asp 'AddNew problem with SQL 7
http://support.microsoft.com/support/kb/articles/q228/9/35.asp 'OLE DB 3.51 and MDAC 2.5

END OF FILE
===========


======
Doug G
======
Go to Top of Page

stephen
Starting Member

9 Posts
Posted - 01 August 2001 :  11:54:55  Show Profile
Upgrading my MDAC to 2.61 fixed the problem. I am running SQL 2000 on Win2000.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07