-
September 13th, 2012, 12:31 AM
#1
Runtime error '440': unable to make connection,ORA-06413
Urgent issue
this is my code
Code:
Private Sub Command1_Click()
'Declare variables
Dim OraSession As Object
Dim OraDatabase As Object
Dim OraDynaset As Object
'Create the OraSession Object.
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
'Create the OraDatabase Object by opening a connection to Oracle.
Set OraDatabase = OraSession.OpenDatabase("sampleDBname", "username/password", 0&)
'Display the username and database to which you have connected.
MsgBox "Connected to " & OraDatabase.Connect & "@" & OraDatabase.DatabaseName
End Sub
Using this application. the exe file runs fine in program files but its fails in program files(x86)
system details:
windows 7 64bit
oracle 11g
please help me out
advance thanks
Last edited by WizBang; September 15th, 2012 at 08:47 AM.
Reason: Added [code] tags
-
September 15th, 2012, 08:51 AM
#2
Re: Runtime error '440': unable to make connection,ORA-06413
Not familiar with Oracle, but my first thought is a windows OS permissions issue. Have you set the exe file to run with admin level permissions?
Please remember to rate the posts and threads that you find useful.
How can something be both new and improved at the same time?
-
September 16th, 2012, 08:11 AM
#3
Re: Runtime error '440': unable to make connection,ORA-06413
thanks for the reply..
yes i have the admin level permission...
using DAO connecting to oracle 11g...
-
September 16th, 2012, 01:23 PM
#4
Re: Runtime error '440': unable to make connection,ORA-06413
I have not done anything with Oracle and have not used DAO for about 10 years so I can't say what the problem could be. I would think your life would be a lot simplier if you were to use ADO rather than DAO. To the best of my knowledge ADO does not require you to jump through hoops to connect to Oracle or any other ODBC compliant database engine. Typically it is just a matter of using the proper connection string after that all the functions are pretty much the same no matter which DB engine you are using.
Always use [code][/code] tags when posting code.
-
September 16th, 2012, 02:45 PM
#5
Re: Runtime error '440': unable to make connection,ORA-06413
Look it up on ORACLE's site. They probably have samples in a variety of languages. VB6 and/or DAO are both very old, and newer IDE's can automatically find things like that. NuGet for example...
-
September 17th, 2012, 04:30 PM
#6
Re: Runtime error '440': unable to make connection,ORA-06413
as Datamiser suggested .use Ado it is Thousend time better .any Way the following way i connect the oracle database .
whether it is 9i,10g & 11g Database .that is really no Issue .and it is working in our hundreds of application .
Code:
dim con as adodb.connection
Dim constr as string
Set con = New ADODB.Connection
constr = " Provider = OraOLEDB.Oracle;Data Source=172.25.124.51:1521/RMS;User Id=RORMS;Password=rorms"
con.Open constr
MsgBox "Connected to " & RMS & "database"
Last edited by firoz.raj; September 17th, 2012 at 04:38 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|