Re: connecting via oo4o [message #100384] |
Wed, 27 November 2002 10:49 |
Carla_Py
Messages: 1 Registered: November 2002
|
Junior Member |
|
|
I think u have to , first, declare the mOraDataBase as object and the mOraSession , i normally do this on a .bas module. (so i make sure is for all the application.
To declare them do the following:
(on the .bas)
Global (or public) OraSession as Object
Global OraData as Object
Then on ur VB form have to go like this:
Set mOraSession = CreateObject("OracleInProcServer.XOraSession") <--with this you´d be creating a session.
Set mOraDatabase =mOraSession.OpenDatabase("Name_of_the_DB","user/password",0&)<--i don´t know why u r using 1.
If r having problems u can see examples at the OO4O folder on your Oracle installation, there are examples of VB forms. I´m sure this would help.
I´m sure u have this directory, i have an oracle personal edition and i have it.
Well , enjoy the fun! :)
|
|
|