Crystal Reports 8.5 will not install Native Oracle Drivers

[phylliswithfox]

Hello all,
I hope you can help me as i am at my wits end.
I am trying to install Crystal reports on a computer that has Oracle 8i client installed.
No matter what i do i cannot get the Oracle Native drivers to install.
Has anyone else had this problem and resolved it?

Thanks for any help
phyllis@fox

 

[synapsevampire]

I've installed it numerous times without a hitch.

Are you looking under More Data Sources->Oracle Server?

How do you knwo that it's not installed?

Are you sure that the Oracle client is properly installed?

What verision of Oracle?

-k

 

[phylliswithfox]

Yes I am looking Under More Data Sources > for Oracle Server.

This is why i think it is not installed.

I have a report that is already written and has been working for years off of an Oracle Stored porcedure, and uses the Native Oracle Driver. When i open this report in my new computer i get "Physical Database not found"


My Oracle Client version is 8.1.7
and i can connect to Oracle thru Sql Plus and can tnsping the instance.

 

[Turkbear]

Hi,
What CR8.5 are you using..In the Standard edition the Oracle stuff will not appear,it takes the Professional or Developer edition to use them...

 

[phylliswithfox]

I have been thinking about this and was wondering if it could be this.
The driver that comes with Crystal 8.5 is an Oracle 7 driver and i do not have Oracle 7 client installed. I have Oracle 8i client installed.
And I do have the professional version of 8.5 not the Developer.

I recently purchased the developer upgrade for 10.0. So I could install the upgrade and get the drivers correct? Any comments on how well that version works?

Thanks so much for all the input.

 

[Turkbear]

Hi,
Sorry folks about the duplicate postings..I'll try and remove one of them ( network glitch made me think I had not posted yet)...

The update 'should' install the correct drivers( you need to use Custom Install and select them, I believe)

CR10 has significant changes in the look-and-feel and in some operational functionality.
It will work with all your existing reports and will convert them to V10 format whan saved..
If you plan to publish to Crystal Enterprise, that version must be 10 as well..

 

[phylliswithfox]

Hi,
I found a Developer edition of CR 8.5 and will try a custom install with it.


Do you think there is any validity to my thought on Oracle 7 client vs Oracle 8?

:->

 

[Turkbear]

Hi,
I am not sure..I thought CR was compatible with that version, since it just uses a 'pass-through' to the Native Oracle SqlNet layer...Perhaps the install program does not recognize it, or the install ( if Typical was used) does not install them..

 

[phylliswithfox]

That must me it, I have installed from these same cd's before and had no problem, but the machines had Oracle 7 that was upgraded to Oracle 8. This is a new machine with only Oracle 8 client installed.

I did do a custom install ( more than once) and made sure I picked all the data access options.

The reason I need this particualar driver is that we have this report being called from our ERP system using a vb program. If I change to a different Data Source say the CROR8V36 ODBC driver,then when the people on the floor try to run the report they get an Oracle 01456 error.
May not perform insert/delete/update operation on a READ ONLY transaction. I have tried all the ODBC drivers I have and none seem to work, they all get the same error.

The report is using an Oracle Stored procedure and has no errors with the native driver.

I will keep plugging at it.

Thanks

 

[synapsevampire]

I have Oracle 9 and CR 8.5 installed on one machine, with no previous versions of Oracle and the Oracle drivers installed.

But that might work, give it a whirl.

-k

 

[phylliswithfox]

Hmmm - so my theory does not hold water.

I think i will uninstall and re-install one more time.

Thanks again for all the great feedback.

 

[synapsevampire]

Just make sure that the Oracle client is installed first, works correcly, and that the user that's installing Crystal has the proper rights to the Oracle install as well.

Not sure why you're having problems, good luck and please keep us aprised.

-k

 

[andyskinner]

Crystal is dependant on the Oracle client interface files, namely the OCI*.DLLs on the machine. Oracle, for backwards compatibility installs historic versions of these, for older versions of Oracle, so the fact that you have an Oracle7 Native driver should be ok.

The database connectivity options you see in Crystal are built dynamically depending on the database clients you have installed, so it`s either a problem that the OCI*.DLL`s aren`t installed, or aren`t installed in a place where Crystal can find them. So would could also check your environment variables to see if the directory these files are in, are in the system PATH.

Andy.

 

[phylliswithfox]

The OCI*.dlls are in the system path.

I uninstalled Crystal,re-installed Oracle (programmer option) just in case it missed something needed with application users option.

Reinstalled Crystel reports and the Native Oracle Drivers will not install.

Just don't know what to try next.

 

[MJRBIM]

phylliswithfox -

Is this machine you are trying to install on running terminal services? We had a similar problem with installing on a terminal services machine a few months ago.

Look for DLLs that start with CROR on your C:\WINT\system32 directory. Those are the Crystal Oracle drivers - if they are in the directory, then they may not be correct in the registry.

 

[phylliswithfox]

Yes it is running terminal services.
Thanks I will check that out.

 

[MJRBIM]

Try Copying the CROR dll files from

c:\winnt\crystal\

to

C:\WINT\system32\

Depending on the version of Crystal and Oracle you are running the files may have different names.

 

[MJRBIM]

Look for

p2lora7.dll
and
p2sora7.dll

 

[kskid]

Not sure if this is even related but I couldn't get connected until I went into the Control Panel.... Administrative Tools... Data Sources (ODBC) and added the Oracle ODBC driver

 

[phylliswithfox]

i am trying to install the Native Oracle drivers that come with crystal.

the odbc connection works fine.

The p2sora7.dll and the p2lora7.dll files are there, but it is like Crystal does not see them.

Where do i look in the registry to see if these are installed?