Home > Cannot Change > Cannot Change The Active Connection Property Of A Recordset

Cannot Change The Active Connection Property Of A Recordset

It does this via a c… Document Imaging Document Management Adobe Acrobat Images and Photos Photos / Graphics Software How to Receive an eFax Video by: j2 Global Internet Business Fax For Command objects, the ActiveConnection property is read/write. This information can be a data source name (DSN) or a detailed connection string containing a series of argument=value statements separated by semicolons. In the past, uninstalling and reinstalling the COM+ applications and a reset of IIS has seemed to fix this problem. this content

current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Is there a wage gap between smokers and non-smokers? Decide. However when I am logged3707 Cannot change the ActiveConnection property of a Recordset objectwhichPost by Damienhas a command object as its sourceThe recordset does have a command as its source, but

It's clear itcan be done.ThanksDamien Veign 2005-05-13 17:28:26 UTC PermalinkRaw Message Post some code and point out the line causing the problem.--Chris Hanscom - Microsoft MVP (VB)Veign's Resource Centerhttp://www.veign.com/vrc_main.asp--Read. Try using .nextrecordset on the recordset object. Although I think the answer to "What does this mean?" is "Time to move to .Net" –NotMe Oct 26 '10 at 22:52 1 Moving to .NET is something I'd like On verses, from major Hindu texts, similar in purport to those found in the Bhagawat Gita Are “Referendum” and “Plebiscite” the same in the meaning, or different in the meaning and

Login. Else fight the flow sageer_kazi Starting Member 2 Posts Posted-11/24/2004: 12:46:04 But i need to get the resultset and other related values from the inserted values in the tablePlz Having examined the properties of the recordset justdatabase Property Value Attributelive: Asynchronous Rowset Processing 16 1537dev: Asynchronous Rowset Processing 0 1537live: Updatability 0 1532dev: Updatability 7 1532Any ideas as why the ActiveX® Data Objects (ADO) supports several standard ADO-defined arguments for the ActiveConnection property as listed in the following table.

I have an SQL7 database and a VB6 app, linked via ADO 2.5 - one particular stored procedure builds a temp table then returns said table as a recordset. resultSet.Open CmdARMaster, , adOpenStatic, adLockReadOnly resultSet.ActiveConnection = Nothing <----------------- Set record = resultSet change this to say cmdARMaster.ActiveConnection = nothing Because the recordset uses a command object, it has no active All rights reserved. What is it for ? 3 20 151d Help with stored procedure 30 45 83d show region if a selection is made on a drop down menu 3 43 78d Speeding

I am using an ADO Command object. And how can I disconnect myrecordset in the dev environment without triggering the error? Advanced Search Forum ASP Technology ASP Cannot change the ActiveConnection property of a R If this is your first visit, be sure to check out the FAQ by clicking the link Our new SQL Server Forums are live!

Reply With Quote 03-03-2003,11:00 AM #2 Rune Bivrin Guest Re: Changing an SP causes a Recordset object error. Since you didn't post the code of the utilityfunction that creates the recordset, we can't really go much further. 1 Reply 87 Views Switch to linear view Disable enhanced parsing Permalink Again this is only for the stored procedure that Selects from a temp table. Is it safe to use cheap USB data cables?

This property sets or returns a String containing the definition for a connection or a Connection object. news Join them; it only takes a minute: Sign up What does the “Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source” error mean? If you attempt to call the Execute method on a Command object before setting the ActiveConnection property to an open Connection object or valid connection string, an error occurs. Reply With Quote 05-17-200505:21 PM #2 Bill Wilkinson View Profile View Forum Posts Private Message Senior Member Join Date Dec 1969 Posts 96,118 Not true...

This works fine whenlogged into my production database. Anyway, once you have the recordset that you want, then you can close the connection. You may have to register before you can post: click the register link above to proceed. have a peek at these guys I'd assumed that the old ActiveConnection property was somehow being held in memory and the workaround was flushing it out.

Advertisements Latest Threads WCG Stats Sunday 06 November 2016 WCG Stats posted Nov 6, 2016 at 7:00 AM Realtek Audio Terry James posted Nov 5, 2016 at 8:20 PM Well I You also need to check the recordset.state property to see if the recordset is open or not. Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful?

Then I get to one of the stored procedure runs and I get the error "Cannot change the ActiveConnection property of a Recordset object which has a Command object as its

In this case, the OLE DB Provider creates a new Connection object using this definition and opens the connection. Some providers allow you to change the ActiveConnection property setting from one Connection to another, without having to first set the property to Nothing. You can set the ActiveConnection property to a valid Connection object or to a valid connection string. Else fight the flow jen Flowing Fount of Yak Knowledge Sweden 4110 Posts Posted-11/25/2004: 01:45:59 quote:Originally posted by sageer_kaziPlease Help.

Just click the sign up button to choose a username and then you can ask your own questions on the forum. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud This documentation is archived and is not being maintained. check my blog P.S.

Register Help Remember Me? You may have to call it twice, one for each cursor. I have a strange problem occuring. Programmer's Reference Data Integration Programmer's Reference ADO Programmer's Reference ADO Programmer's Reference ActiveConnection Property (ADO) ActiveConnection Property (ADO) ActiveConnection Property (ADO) ActiveCommand Property (ADO) ActiveConnection Property (ADO) ActiveConnection Property Support Using

thanks venkat 0 LVL 3 Overall: Level 3 ASP 1 Message Accepted Solution by:Simongh2003-05-27 I would say the line indicated is the problem. Browse other questions tagged tsql asp-classic ado or ask your own question. I encountered this before, it usually happens when if you are using disconnected recordsets. Member Login Remember Me Forgot your password?

We've got lots of great SQL Server experts to answer whatever question you can come up with. PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER! Thanks all. Therelationships and indexes aren't set up in the dev, could this be connected?Post by VeignPost some code and point out the line causing the problem.--Chris Hanscom - Microsoft MVP (VB)Veign's Resource

Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily. close the recordset "Set rs = Nothing".

No, you are not closing the recordset. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! However, if I take another procedure later on down the page and place it right in front of it, it runs fine as well.