Oracle Connection

[Former Member]

Hi All,

I am using cr 2011 sp2 and OS is windows 7 with 64 bit.I am unble to see oracle server connection in cr.

Please suggest how to get that

[abhilash_kumar · Accepted solution]

Hi Divya,

You need to install the '32-bit Oracle client' drivers that can connect to your database. Once you install these drivers, the 'Oracle Server' connection type should be visible under 'Database Expert' (assuming the Path variable is also correctly pointing to the 32-bit Oracle home).

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Can you suggest where i can get that

[abhilash_kumar · Accepted solution]

Oracle's download center of course!

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I have downloaded the zip file from oracle here

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

and i extracted it and it is showing contents like this.

After that what i have to do.

Please suggest

[abhilash_kumar · Accepted solution]

You've downloaded the Instant Client and from my experience that is Not the best driver to have!

Please get in touch with your Oracle Admin and request for the Full Client. Also ask them to setup the Path statement (if there are any issues) and TNS entries.

-Abhilash

[Former Member]

You should have oracle server connection under the New connections in database expert. All you need is the connection string name, username and password. You can get this details from your BO Admin.

Thanks,

Abhi