Oracleinprocserver.xorasession Error 429
Contents |
Visual Studio Languages , .NET Framework > Visual Basic Question 0 Sign in to vote Hi, I am using below code in vb6 application but this is throwing an "Runtime Error '429': ActiveX component can't create object" error. CreateObject("OracleInProcServer.XoraSession") is that createobject( oracleinprocserver.xorasession ) windows 7 due to any dll or reference error ? please share your solution Thanks in advance Thursday,
Oracle Objects For Ole 11g Download
May 09, 2013 11:08 AM Reply | Quote Answers 0 Sign in to vote Are the Oracle Objects for OLE installed and registered? oracleinprocserver xorasession vba reference http://www.oracle.com/technetwork/database/windows/index-092246.html Paul ~~~~ Microsoft MVP (Visual Basic) Marked as answer by Youen ZenModerator Thursday, May 23, 2013 8:41 AM Thursday, May 09, 2013 11:51 AM Reply | Quote All replies 0 Sign in to vote Are the Oracle Objects
Oracle Objects For Ole (oo4o) Download 11g
for OLE installed and registered? http://www.oracle.com/technetwork/database/windows/index-092246.html Paul ~~~~ Microsoft MVP (Visual Basic) Marked as answer by Youen ZenModerator Thursday, May 23, 2013 8:41 AM Thursday, May 09, 2013 11:51 AM Reply | Quote 0 Sign in to vote Hi, The error suggests that the underlying dll is not registeredon your machine. You might have to register the dll that has this class in it using regsvr32. Let us know how it goes. Regards, Rahul Please remember to mark the runtime error 429 activex component can't create object replies as answers if they help. Thursday, May 09, 2013 11:53 AM Reply | Quote 0 Sign in to vote The system Have regsvr32 dll and also registered in registry. Thursday, May 09, 2013 12:25 PM Reply | Quote 0 Sign in to vote Make sure all of the dependent components have been registered: http://jagdeepmankotia.blogspot.com/2012/07/set-orasession-createobjectoracleinproc.html#!/2012/07/set-orasession-createobjectoracleinproc.html Paul ~~~~ Microsoft MVP (Visual Basic) Thursday, May 09, 2013 12:44 PM Reply | Quote 0 Sign in to vote Hi paul, i registered all the dll's oo4ocodewiz.dll odbtreeview.ocx oo4oaddin.dll oip9.dll butODAC92070.exeis not available in the system which one you mentioned in your first reply. thanks. Thursday, May 09, 2013 1:23 PM Reply | Quote 0 Sign in to vote Hi, My System doesn't have "OracleInProcServer.XOrasession" in the registry. is that the reason for this issue ? Thursday, May 09, 2013 3:16 PM Reply | Quote 0 Sign in to vote Yes, that would be the problem. It sounds like you need to install the Oracle Objects for OLE.Paul ~~~~ Microsoft MVP (Visual Basic) Thursday, May 09, 2013 3:33 PM Reply | Quote 0 Sign in to vote Thanks paul. can you tell me the way to install oracle objects for OLE if you have an idea. Thanks in advance. Thursday, May 09, 2013 5:05 PM Reply | Quote 0 Sign in to vote Did you check the link in my first post?Paul ~~~~ Microsoft MVP (Visual Bas
Page 1 of 1 New Topic/Question Reply 8 Replies - 21921 Views - Last Post: 10 May 2013 - 06:28 PM Rate Topic: #1 kannan1986 New D.I.C Head Reputation: 0 Posts: 4 Joined: 22-March 10 Runtime Error '429': ActiveX component can't create object Posted 09 May 2013 - 04:02 AM Hi, I am using below code in vb6 application but this is throwing an "Runtime Error '429': ActiveX component can't create object" error. CreateObject("OracleInProcServer.XoraSession") is that due to any dll or reference error ? please share your solution Thanks in advance Is This A Good Question/Topic? 0 Back to top MultiQuote Quote + Reply Replies To: Runtime Error '429': ActiveX component can't create object #2 andrewsw don't rely on secrecy Reputation: 5962 Posts: 23,491 Joined: 12-December https://social.msdn.microsoft.com/Forums/vstudio/en-US/5d424996-e3f3-4b18-a1ad-f18f1b6937ef/runtime-error-429-activex-component-cant-create-object?forum=vbgeneral 12 Re: Runtime Error '429': ActiveX component can't create object Posted 09 May 2013 - 04:28 AM Have you added a reference (Project, References) to the Oracle InProc Server Type Library? Oracle docs Is the server up-and-running (if required)? This post has been edited by andrewsw: 09 May 2013 - 04:29 AM Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #3 kannan1986 New D.I.C Head Reputation: 0 Posts: 4 Joined: 22-March 10 Re: Runtime Error http://www.dreamincode.net/forums/topic/320643-runtime-error-429-activex-component-cant-create-object/ '429': ActiveX component can't create object Posted 09 May 2013 - 05:28 AM Hi, I added all the references. the same source code running in one system and it giving error in another system. is it any dll reference ? Thanks Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #4 andrewsw don't rely on secrecy Reputation: 5962 Posts: 23,491 Joined: 12-December 12 Re: Runtime Error '429': ActiveX component can't create object Posted 09 May 2013 - 05:55 AM I don't know, sorry. If it were me I would consider un-installing and re-installing software, and possibly look into using regsvr32 to register dlls, but maybe someone else will contribute. Mind you, as you are using obsolete VB6 software, it might take a bit of research [Edited: Perhaps I shouldn't use the term obsolete . Deprecated, unsupported.] This post has been edited by andrewsw: 09 May 2013 - 06:05 AM Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #5 kannan1986 New D.I.C Head Reputation: 0 Posts: 4 Joined: 22-March 10 Re: Runtime Error '429': ActiveX component can't create object Posted 09 May 2013 - 08:15 AM Hi, My System doesn't have "OracleInProcServer.XOrasession" in the registry. is that the reason for this issue ? Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #6 andrewsw don't rely on secrecy Reputation: 5962 Posts: 23,491 Joined: 12-December 12 Re:
Forum Visual Basic Programming Visual Basic 6.0 Programming Runtime Error '429': ActiveX component can't create object If this is your first visit, be sure to check http://forums.codeguru.com/showthread.php?536885-Runtime-Error-429-ActiveX-component-can-t-create-object out the FAQ by clicking the link above. You may have to register http://www.forumtopics.com/busobj/viewtopic.php?t=28157&sid=9b2b124dc8dd19c4918c487cecc72926 or Login before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Runtime Error '429': ActiveX component can't create object Tweet Thread Tools Show Printable Version Email this error 429 Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 9th, 2013,06:03 AM #1 kannan1986 View Profile View Forum Posts Junior Member Join Date May 2013 Posts 2 Runtime Error '429': ActiveX component can't create object Hi, I am using below code in vb6 application but this is throwing an "Runtime Error '429': ActiveX component can't create object" error. oracle objects for CreateObject("OracleInProcServer.XoraSession") is that due to any dll or reference error ? please share your solution Thanks in advance Reply With Quote May 9th, 2013,08:43 AM #2 HanneSThEGreaT View Profile View Forum Posts CG Bouncer Power Poster Join Date Jul 2001 Location Sunny South Africa Posts 11,223 Re: Runtime Error '429': ActiveX component can't create object Is that DLL registered on the machine? All my Articles Hannes Reply With Quote May 10th, 2013,06:29 AM #3 kannan1986 View Profile View Forum Posts Junior Member Join Date May 2013 Posts 2 Re: Runtime Error '429': ActiveX component can't create object no.. is there any alternate source code is available ? Reply With Quote May 10th, 2013,08:47 AM #4 HanneSThEGreaT View Profile View Forum Posts CG Bouncer Power Poster Join Date Jul 2001 Location Sunny South Africa Posts 11,223 Re: Runtime Error '429': ActiveX component can't create object How do you mean "No"? Wasn't my answer satisfactory? Or, isn't the DLL Registered? If it is the latter, your only option is to Register the DLL on the machine. Full stop. Do you know how to register DLLS? Last edited by HanneSThEGreaT; May 10th, 2013 at 08:51 AM.
BI, Melbourne: Oct 23, FLBOUG, Clearwater: Oct 28, ASUG Northern California: Nov 2, ASUG Arizona Chapter: Nov 3, ASUG All Texas Chapter Meeting: Nov 11. Run-time error '429' : ActiveX object can't create object Search this topic...|Search SDK (VBA/ASP/JSP)...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> SDK (VBA/ASP/JSP) Author Message sailaForum MemberJoined: 11 Feb 2004Posts: 9 Posted: Thu Apr 08, 2004 9:22 amPost subject: Run-time error '429' : ActiveX object can't create object Hi all, I get the error : Run-time error '429' : ActiveX object can't create object when i try to run the add-in from BO.I have this add-in installed and working on several other servers as well. I dont know where to investigate on this as there's no specific action described anywhere.The code seems to be ok as its working on other servers.The O/S is windows 2000 -service pack 4 and BO version is 5.1.3 Do let me know if anyone has faced the same issue and if any resolutions. Thanks all! Note: Attached is the code and where the debug stops : Public Sub main() Dim ScriptPath As String Dim OraSession As Object Dim OraDatabase As Object Dim OraDynaset As Object Dim OraSql As String Dim cpt As Integer Dim cpt2 As Integer Dim cpt3 As Integer Dim init As Integer Dim trial_no() As String OraSql = IESHXTSQL(Application.Variables("BOUSER").Value) Set OraSession = Nothing Set OraDatabase = Nothing Set OraDynaset = Nothing Quote: Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.OpenDatabase("xxxxxxx", "uid/pwd", 0&) Set OraDynaset = OraDatabase.CreateDynaset(OraSql, 0&) cpt2 = 1 cpt3 = 1 Erase trial_no() ReDim Preserve trial_no(1) While Not (OraDynaset.EOF) If cpt2 = 1 And cpt3 = 1 Then init = OraDynaset.fields("trial_no").Value End If If cpt3 = 1 Then trial_no(cpt2) = OraDynaset.fields("trial_no").Value Else trial_no(cpt2) = trial_no(cpt2) & ";" & OraDynaset.fields("trial_no").Value End If OraDynaset.MoveNext If cpt3 = 1000 Then cpt2 = cpt2 + 1 ReDim Preserve trial_no(cpt2) cpt3 = 1 Else cpt3 = cpt3 + 1 End If Wend For cpt = 1 To 5 ReDim Preserve list_trial_no(cpt) If cpt > UBound(trial_no) Then list_trial_no(cpt) = init Else list_trial_no(cpt) = trial_no(cpt) End If Next cpt Set OraDynaset = Nothing