Home > General > 0x800a0e78


http://www.syntech.com.au NBDesign Posts: 15 Posted: 09/08/2007, 7:55 AM Quote Edd: NBDesign, Your problem is in your SQL SELECT product_id, quantity, product_price FROM nbdCart_Items WHERE a.product_id=b.product_id AND shopping_cart_id = " & Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Would the Ancient One have defended the Earth from a Chitauri invasion in the Avengers absence? By joining you are opting in to receive e-mail.

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. View Replies View Related Error 500 How Can I Solve It I'm receiving an error 500 when trying to dsiplay an ASP page with IIS. Try inserting the following code after all your execute statements. Make sure that you have an open connection before attempting to execute the query.

Sinple table, only 6 fields including the unique ID. Also one last thing, put OPTION EXPLICIT at the top of you page, you can remove it once you go live but this will make you declare all variables(good programming practice) I included (3) because I tested it successfully and thought it worth a try.

I used first the code above then the error appears. I'm new in ASP programming and try to understand also learn more about ASP. Last edited by buntine; 06-03-2005 at 04:55 AM. Can any one help me?

I am trying to get information passed to PayPal. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Forum Program Your Site Classic ASP Operation is not allowed when the object is closed. I removed the a and b reference and just left & "WHERE shopping_cart_id = " & DBnbdCart.ToSQL(Request.Cookies("nbdCart_id"),ccsInteger) I used your code and this is the error I am getting.

Dim order_date Dim last_order_id Dim RecordSet Dim SQL Dim OrderTotal Dim cid Dim cip cip = Request.ServerVariables("REMOTE_ADDR") cid = Session("CartUserID") ' Count Order Total SQL = "SELECT SUM(product_price*quantity) as total " Beginner Guide Portal Beginner Guide to Education Free Software and More Free Softwares, Real Estate Online Finder Quick Navigation Classic ASP Top Site Areas Settings Private Messages Subscriptions Who's Online Search Code: View Replies View Related ADODB.Recordset Error '800a0cc1' Clear the code away. I find the possibility to test assumptions interactively in a gui to be helpful.

Join UsClose Topics HTML CSS JS PHP Ruby Mobile UX Design Store Forums Subscribe Home Forum What's New? http://www.tek-tips.com/viewthread.cfm?qid=190798 To start viewing messages, select the forum that you want to visit from the selection below. Simple geometry. RE: ADODB.Recordset (0x800A0E78) link9 (Programmer) 11 Jan 02 17:38 Well, since I don't know DTC, then I'm afraid I can't offer advice there.However, I can tell you exactly what's wrong, and

You can now find them here. To do this, in SQL Management Studio, right click the server, Properties, and on the Security tab, check 'SQL Server and Windows Authentication mode' share|improve this answer answered May 13 '11 i cannot follow your code at all. thanks Faq Reply With Quote August 5th, 2003,03:18 PM #2 No Profile Picture nopoints View Profile View Forum Posts Visit Homepage  Contributing User Devshed Newbie (0 - 499 posts)

Join them; it only takes a minute: Sign up ADODB.Connection (0x800A0E78) up vote 1 down vote favorite Original connectionstring whitch working on MSSQL 2000: Provider=SQLOLEDB.1; Persist Security Info=True; User ID=XXXXXXXX; Initial How do you combine the elements in Sheldon's T-shirt? Error is in line 31 .I attach you the code in orden to have a look!!!!The problem happends when I use an INSERT statemen; if I use a SELECT statement nothing I am using an editable grid to pass the info to PayPal and an "On-Click" to remove the information from the temp cart.

My Blog | My Twitter | My Company | SitePoint Podcast *** Matt Mullenweg on the SitePoint Podcast *** Jul 20, 2006,19:56 #3 mahesha View Profile View Forum Posts SitePoint Enthusiast NOTE: Creating an IMPLICIT recordset has its pros and cons be sure to read about them. This tool uses JavaScript and much of it will not work correctly without it enabled.

I created him from my administrator account, after that i set password and read/write for IntrenetApps database.

Can any one help me? Here is the entire piece of code.... Other reason can be your client are attempting to access the email via IMAP clients. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum!

Typically you cannot use SQL extensions (PL\SQL or Transact-SQL) in the UMP or the sql_response probe. Sincerely Vlince Faq Reply With Quote August 5th, 2003,03:47 PM #4 karsh44 View Profile View Forum Posts  Just another guy Devshed Frequenter (2500 - 2999 posts)     This is my connection string var MM_NACUS_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; Dbq=" & Server.MapPath(".") & "cclfixt.mdb;" View Replies View Related ADODB.Recordset Error '800a0e78' could some1 tell me which connection string Thanks for any idea Reply With Quote 06-03-2005,09:57 AM #9 lmf232s View Profile View Forum Posts Registered User Join Date Jun 2004 Location Kansas City, MO Posts 1,607 Try this, sorry

I think the error comes when the instruction RS.Update is executed. All rights reserved. © 2016 Jive Software | Powered by Jive SoftwareHome | Top of page | HelpJive Software Version: 2016.2.5.1, revision: 20160908201010.1a61f7a.hotfix_2016.2.5.1 To use Google Groups Discussions, please enable JavaScript Code: View Replies View Related ADODB.Recordset (0x800A0E78) Operation Is Not Allowed When The Object Is Closed I have a problem with my programm and get the error above. View Replies View Related ADODB.Recordset (0x800A0CC1) Error Here is the scenario:The page (call this page1) itself (its a online shopping advisor) works without any problem, given that no other broswer windows

Thanks. shouldn't be that? Hope that helps. Registration on or use of this site constitutes acceptance of our Privacy Policy.

You should use this info to produce the code necessary to create the parameters explictly in your production code.Paul - no, I do not recollect a way to refresh the parameters Reply With Quote 06-03-2005,04:35 AM #6 faamugol View Profile View Forum Posts Registered User Join Date Mar 2004 Location Holland Posts 139 thank you lmf232s It is not fixed yet. Reply With Quote 06-03-2005,12:15 PM #12 wmif View Profile View Forum Posts Registered User Join Date Apr 2005 Location kali Posts 308 ^^ what lmf said with the recordset. RE: ADODB.Recordset (0x800A0E78) bryant89 (Programmer) (OP) 14 Jan 02 16:50 I enclosed my parameters in brackets as suggested and I got the following errorItem cannot be found in the collection corresponding

Reply With Quote 06-02-2005,05:23 PM #4 wmif View Profile View Forum Posts Registered User Join Date Apr 2005 Location kali Posts 308 you open your database and then close it a asked 5 years ago viewed 2316 times active 5 years ago Upcoming Events 2016 Community Moderator Election ends in 5 days Blog How We Make Money at Stack Overflow: 2016 Edition Thru this method some come through and some do not. That why i use command update table_y.

If field id in table_x same with field id in table_y all data from table_x (paymentdate, no_resit, status) must be fill in table_y with same id. Ok first thing, *ALWAYS* wait till the *LAST* minute before you create a connection and/or a recordset object. God bless all of you Reply With Quote Quick Navigation ASP Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Client-Side Development HTML XML CSS Graphics Register FAQ/Rules My SitePoint Forum Actions Mark Forums Read Quick Links View Forum Leaders Remember Me?