OraFAQ Forum: Windows » oracle 11g (64 bit) client on windows 7

Home » Infrastructure » Windows » oracle 11g (64 bit) client on windows 7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle 11g (64 bit) client on windows 7 [message #505590]

Wed, 04 May 2011 02:02

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505597 is a reply to message #505590]

Wed, 04 May 2011 02:40

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505609 is a reply to message #505597]

Wed, 04 May 2011 03:54

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.

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505620 is a reply to message #505609]

Wed, 04 May 2011 05:12

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505622 is a reply to message #505620]

Wed, 04 May 2011 05:23

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505624 is a reply to message #505622]

Wed, 04 May 2011 05:35

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505639 is a reply to message #505624]

Wed, 04 May 2011 06:49

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505655 is a reply to message #505639]

Wed, 04 May 2011 07:06

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505658 is a reply to message #505655]

Wed, 04 May 2011 07:15

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?

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #505663 is a reply to message #505658]

Wed, 04 May 2011 07:53

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No I just mean you didn't install it.

Regards
Michel

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #506372 is a reply to message #505663]

Mon, 09 May 2011 00:51

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.

Report message to a moderator

Re: oracle 11g (64 bit) client on windows 7 [message #506386 is a reply to message #506372]

Mon, 09 May 2011 01:33

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is on the client part, that is on the same CD you already installed the Oracle client.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 08:40:59 CDT 2025