Home > Cannot Change > Cannot Change The Activeconnection Property

Cannot Change The Activeconnection Property

If you're having a computer problem, ask on our forum for advice. Jeff Johnson [MVP: VB] 2004-06-23 13:44:23 UTC PermalinkRaw Message Post by Kristina NielsenADODB.Recordset (0x800A0E7B)Cannot change the ActiveConnection property of a Recordset object which hasa Command object as its source./webasp/Sales/credit_app.asp, line 175Public Phase that crap out as fast as you can :) share|improve this answer edited Jun 22 '12 at 6:51 answered Oct 26 '10 at 22:24 Andomar 155k23227274 1 +1 for How to deal with a coworker that writes software to give him job security instead of solving problems? this content

With sqlCmd .ActiveConnection = sqlConn .CommandText = ExecuteSP.Name .CommandType = adCmdStoredProc .Parameters.Refresh 'Load the parameters If IsArrayAllocated(ExecuteSP.arrParameters) Then For N = LBound(ExecuteSP.arrParameters) To UBound(ExecuteSP.arrParameters) .Parameters("@" & ExecuteSP.arrParameters(N, 0)).Value = ExecuteSP.arrParameters(N, 1) Decide. If you have any questions, then please Write a Comment below! All rights reserved.

The default is a Null object reference. To start viewing messages, select the forum that you want to visit from the selection below. Sign the petition to Microsoft.http://classicvb.org/petition/Post by DamienI'm trying to disconnect an ADO Recordset in VB6.

Solved "Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source" error Posted on 2003-05-25 ASP 1 Verified Solution 5 Comments 5,549 Views Last Get yourself a copy of the The Holy Book order has no physical Brett in The meaning of a Kaiser . -database data Reply With Quote 12-23-03,09:55 #3 DavidGrimes View Profile PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER! User IDSpecifies a valid mainframe or AS/400 user name to use when opening the connection.

You can then associate the Command object with the same or another Connection object. Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are Copy command.ActiveConnection = connectionString activeConnectionString = recordset.ActiveConnection Remarks The ActiveConnection property is used to determine the Connection object over which the specified Command object will execute or the specified Recordset will have a peek at these guys can anybody tell me the reason for this error and how to eliminate it ...

Anyone know what it is? This information can be a data source name (DSN) or a detailed connection string containing a series of argument=value statements separated by semicolons. I'm amazed that you have a COM+ application that's actually used in 2010. And how can I disconnect myrecordset in the dev environment without triggering the error?

This section contains: ActiveConnection Property Support Using the OLE DB Provider for AS/400 and VSAM ActiveConnection Property Support Using the OLE DB Provider for DB2 ActiveConnection Property Support Using the ODBC This documentation is archived and is not being maintained. ASP.NET Article by: aurelianco I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... 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.

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: http://electrictricycle.net/cannot-change/cannot-change-readonly-property-for-the-expression.html Has anything changed recently? 0 Message Author Comment by:venkatcg2003-05-26 hai simon, thanks for the help.but can u tell me the change i have to If I call the sp from Query Analyzer it works fine, but calling it from the VB app (which uses a command and recordset object) gives Error 3707: "cannot change the I'm currently looking at rewriting it without cursors though so it may be ok.

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 Here is the code: On Error GoTo ErrHandler Dim rstResults As ADODB.Recordset Dim conSQL As ADODB.Connection Dim comFetch As ADODB.Command Set conSQL = New Connection conSQL.Open gstrAdminConn '-- Associate the Command DevX Home Today's HeadlinesArticles ArchiveTip BankForums Register Help Remember Me? have a peek at these guys I have a strange problem occuring.

P.S. Today, no such luck. Where you create the connections, instantiatethe objects - basically show the context of the line of code causing theproblem--Chris Hanscom - Microsoft MVP (VB)Veign's Resource Centerhttp://www.veign.com/vrc_main.asp--Read.

No problem.

This argument cannot be used if a Provider argument is passed. close the recordset "Set rs = Nothing".

No, you are not closing the recordset. File NameSpecifies the name of the provider-specific file containing preset connection information. Join our community for more solutions or to ask questions.

Not the answer you're looking for? Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. In this case, the OLE DB Provider creates a new Connection object using this definition and opens the connection. check my blog This is probably happening because by adding the cursors, you have created more recordsets that are being returned to ADO.

Username: Password: Save Password Forgot your Password? Let me explain. The time now is 07:46 AM. microsoft.public.vb.general.discussion Discussion: Cannot change the ActiveConnection property of a Recordset (too old to reply) Kristina Nielsen 2004-06-22 19:59:39 UTC PermalinkRaw Message I get the following error:Error Type:ADODB.Recordset (0x800A0E7B)Cannot change the ActiveConnection

Dev centers Windows Office Visual Studio Microsoft Azure More... Otherwise, it is read/write. thanks venkat 0 Question by:venkatcg Facebook Twitter LinkedIn Google LVL 3 Best Solution bySimongh I would say the line indicated is the problem. I encountered this before, it usually happens when if you are using disconnected recordsets.

PasswordSpecifies a valid mainframe or AS/400 password to use when opening the connection. 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. However, if I take another procedure later on down the page and place it right in front of it, it runs fine as well. Decide.

Interconnectivity How small could an animal be before it is consciously aware of the effects of quantum mechanics? 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 Additionally, the provider may set this property to the new Connection object to give you a way to access the Connection object for extended error information or to execute other commands. 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.