Home > Cannot Change > Cannot Change The Active Connection Property

Cannot Change The Active Connection Property

I have made changes to the sp (the main one being that it now uses two cursors to collate and append more data to the temp table). I'm currently looking at rewriting it without cursors though so it may be ok. Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new Kind regards, Marc , Dec 9, 2006 #1 Advertisements Guest I believe the error message is occuring when there is more than one SP parameter, since all SP's taking a check over here

You may have to call it twice, one for each cursor. Member Login Remember Me Forgot your password? This user name is used to validate that the user can log on to the target host system and has appropriate access rights to the file. As to why changes you've done elsewhere would affect this, I can't say.

To start viewing messages, select the forum that you want to visit from the selection below. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Join our community for more solutions or to ask questions. Please > login and try again.", vbExclamation, "Database Error" > ExecuteSP.bSuccess = False > > Else > > sqlConn.ConnectionString = CurrentProject.Connection > sqlConn.Open > > sqlConn.CursorLocation = adUseClient 'Cache data locally

I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 Stay logged in Welcome to PC Review! You can set the ActiveConnection property to a valid Connection object or to a valid connection string. All rights reserved.

I will leave a recommendation in the Cleanup topic area that this question is: Accept Answer by Simongh Please leave any comments here within the next seven days. More About Us... iam calling vb objects in my asp page using MTS and this vb object turn calls the stored procedure any help.. why not find out more This password is used to validate that the user can log on to the target host system and has appropriate access rights to the file.

How can I prove its value? It's clearitPost by Damiencan be done.ThanksDamien Veign 2005-05-14 16:36:02 UTC PermalinkRaw Message Post code around the issue. I am not doing anything > differently so why is the function behavining so awkwardly? > > Kind regards, > Marc , Dec 9, 2006 #2 Advertisements Show Ignored Content Let me know how it works for you --Glenn "Keith" wrote in message news:[email protected] > > I have an SQL7 database and a VB6 app, linked via ADO 2.5 -

Top 2 post • Page:1 of 1 All times are UTC Board index Spam Report http://www.pcreview.co.uk/threads/cannot-change-the-activeconnection-property-of-a-recordset-object.2787430/ Forgot your password? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed If the ActiveConnection parameter of the Open method is used to open a Recordset object, the ActiveConnection property will inherit the value of the argument.

UrgentError message displayed on the ASP Page:"ADODB.Recordset error '800a0e7b'Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source."SQL Stored Proc:ALTER procedure procGetHotDealsRotation_HomePageasINSERT INTO tbl_Product_Details_TEMPSELECT http://electrictricycle.net/cannot-change/cannot-change-readonly-property-for-the-expression.html We've restricted the ability to create new threads on these forums. The results set being passed top VB is a select from the temp table. My manager said I spend too much time on Stack Exchange.

No problem. The time now is 07:32. UrgentError message displayed on the ASP Page:"ADODB.Recordset error '800a0e7b'Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source."SQL Stored Proc:ALTER procedure procGetHotDealsRotation_HomePageasINSERT INTO tbl_Product_Details_TEMPSELECT this content It takes just 2 minutes to sign up (and it's free!).

Having examined the properties of the recordset justbefore the error I see the following differences in it's properties:database Property Value Attributelive: Asynchronous Rowset Processing 16 1537dev: Asynchronous Rowset Processing 0 1537live: And how can I disconnect myrecordset in the dev environment without triggering the error? the 90% of the time I refered to in my previous post).

You can then associate the Command object with the same or another Connection object.

This works fine whenlogged into my production database. In the past, uninstalling and reinstalling the COM+ applications and a reset of IIS has seemed to fix this problem. ActiveConnection Property (ADO) The ActiveConnection property on a Command or Recordset object indicates to which Connection object the specified Command or Recordset object currently belongs. Rune Bivrin "Keith" wrote: > >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

And how can I disconnect myrecordset in the dev environment without triggering the error? Covered by US Patent. Thanks anyway!! "Rune Bivrin" wrote: > >My guess is ADO gets confused by the rowcounts being generated by the statements >prior to the actual SELECT that returns data. have a peek at these guys It works 90% of the time, with and without passed parameters but sometimes I get the aforementioned error message.

We appreciate your feedback. This works fine whenlogged into my production database. It's clearitPost by Damiencan be done.ThanksDamien 3 Replies 108 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation Damien 2005-05-13 15:58:24 UTC Veign 2005-05-13 17:28:26 UTC 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