Home » Infrastructure » Windows » oracle 11g (64 bit) client on windows 7
oracle 11g (64 bit) client on windows 7 [message #505590] Wed, 04 May 2011 02:02 Go to next message
meg_2411
Messages: 11
Registered: August 2009
Location: India
Junior Member
hi

I have a VB application which uses oo4o to connect to Oracle database (10g) using Oracle client v 8.1.7. All was working well till we migrated to windows 7. On windows 7 (64 bit), we have oracle client 11g (64 bit). but the Vb application cannot make connection with the database although i can query the database using SQL Plus.

Pls help.

Megha
Re: oracle 11g (64 bit) client on windows 7 [message #505597 is a reply to message #505590] Wed, 04 May 2011 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the Vb application cannot make connection with the database

What does this mean? Any error? Copy and paste what you get.

Regards
Michel
Re: oracle 11g (64 bit) client on windows 7 [message #505609 is a reply to message #505597] Wed, 04 May 2011 03:54 Go to previous messageGo to next message
meg_2411
Messages: 11
Registered: August 2009
Location: India
Junior Member
In VB, connection is being made as shown below:

m_OracleSession = CreateObject("OracleInProcServer.XOraSession")

The error is customised in application code as below:

If m_OracleSession Is Nothing Then
MsgBox "ERROR CREATING THE ORACLE SESSION",.

I have installed my application in folder other than (x86) although it is a 32 bit application.

Re: oracle 11g (64 bit) client on windows 7 [message #505620 is a reply to message #505609] Wed, 04 May 2011 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without the actual code actual error no one can say what the error is.

Your statement "CreateObject("OracleInProcServer.XOraSession")" has nothing to do with the database and connection, it just locally creates the Oracle VB object.
Display the actual VB error message.

Regards
Michel
Re: oracle 11g (64 bit) client on windows 7 [message #505622 is a reply to message #505620] Wed, 04 May 2011 05:23 Go to previous messageGo to next message
meg_2411
Messages: 11
Registered: August 2009
Location: India
Junior Member
Ok,I will try to explain in detail:

On windows 7, when i try to run my VB appliation using Oracle 8.1.7 client, it is working fine.

When I do the same using Oracle 11g client (64 bit version), I am not able to connect to database. I am not getting any specific oracle error which I can post. The VB class just fails to make a connection.

I want to know if applications that use Oracle Object for OLE (OO4O) for database connectivity valid in Windows 7 and Oracle cleint 11g (64 bit version). If yes, please suggest what changes do I need to make in order to make things work.

Really appreciate your help Razz
Re: oracle 11g (64 bit) client on windows 7 [message #505624 is a reply to message #505622] Wed, 04 May 2011 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
. I am not getting any specific oracle error which I can post

Of course, your code hide it. Remove/comment any error handler.

Quote:
The VB class just fails to make a connection

From waht you posted, it does not even try to connect, it does not succeed to create the object. Once again this has nothing to do with the database or its connection.

Quote:
I want to know if applications that use Oracle Object for OLE (OO4O) for database connectivity valid in Windows 7 and Oracle cleint 11g (64 bit version).

Yes.

Quote:
If yes, please suggest what changes do I need to make in order to make things work

The FIRST thing is to know what is the error.

Regards
Michel
Re: oracle 11g (64 bit) client on windows 7 [message #505639 is a reply to message #505624] Wed, 04 May 2011 06:49 Go to previous messageGo to next message
meg_2411
Messages: 11
Registered: August 2009
Location: India
Junior Member
it is not possible to debug or change source code since I am testing on a remote machine which does not have VB installed on it.And on my machine I have Windows XP but VB is installed.

I will try to procure the environment where I can override the error returned by code and get back to you with actual error msg.

However, now I am assuming that there is no issue with OO4O while working on Oracle 11g client on Windows 7. but why in the Oracle folder (which gets installed in C:), there is no oo4o folder as in case of Oracle 8 client. Is it clubbed in some other folder?

Thanks a tonne for your assistance!

Regards,
Megha
Re: oracle 11g (64 bit) client on windows 7 [message #505655 is a reply to message #505639] Wed, 04 May 2011 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but why in the Oracle folder (which gets installed in C:), there is no oo4o folder as in case of Oracle 8 client

Because you didn't install OO4O and this explain the error on object creation.

Regards
Michel
Re: oracle 11g (64 bit) client on windows 7 [message #505658 is a reply to message #505655] Wed, 04 May 2011 07:15 Go to previous messageGo to next message
meg_2411
Messages: 11
Registered: August 2009
Location: India
Junior Member
So you mean to say Oracle 8 client installation has oo4o by default but with Oracle 11g, we need to install separately?
Re: oracle 11g (64 bit) client on windows 7 [message #505663 is a reply to message #505658] Wed, 04 May 2011 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No I just mean you didn't install it.

Regards
Michel
Re: oracle 11g (64 bit) client on windows 7 [message #506372 is a reply to message #505663] Mon, 09 May 2011 00:51 Go to previous messageGo to next message
meg_2411
Messages: 11
Registered: August 2009
Location: India
Junior Member
got your point ,Michel.

can u help me with the exact location from where I can download oo4o for 11g (64 bit)? on oracle site , i see oo4o available for upto 10g 32 bit only.

Thanks again.
Re: oracle 11g (64 bit) client on windows 7 [message #506386 is a reply to message #506372] Mon, 09 May 2011 01:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is on the client part, that is on the same CD you already installed the Oracle client.

Regards
Michel
Previous Topic: 11.2g Installation - Prereqsites Checks Failed
Next Topic: ORA-12500... (Oracle Service does not start Access denied Error 5) (2 threads merged by bb)
Goto Forum:
  


Current Time: Fri Mar 29 06:00:40 CDT 2024