Oracle Driver for CR 9?

[Slonoma]

Hey all,
I am trying to access an Oracle database and I get an error message: "Could not find crdb_oracle.dll" I looked at Oracle's page as well as installed Hot Fixes and searched all of Crystal's site. Anyone know where I can find this dll?

Thanks,

Slo No

 

[lyanch]

On my computer it is in:

C:\Program Files\Common Files\Crystal Decisions\2.0\bin

You need to tell Crystal to install the Oracle stuff, it won't do it in a default install. You also need to have the Oracle client installed. I have found the whole install goes better if I install the clients first.

Lisa

 

[Slonoma]

OK,
I was looking for a quick fix but it looks like I'll need to reinstall at least part of the software. Thanks for your help Lisa.

Slo No

 

[davidread]

I can find the .dll and it's where Crystal says it should be, I just can't get it to recognize it. I have downloaded Hotfixes, etc.

Any other suggestions?

 

[lyanch]

You need to have the oracle client installed as well.

Lisa

 

[davidread]

I have Oracle Client installed. The only unique thing about my PC vs. any other PC at our company is that it had CR 8.5 installed previously. I have de-installed that, but it seems as if that's the common thread here.

Thanks,

David

 

[lyanch]

Naw... I started with 8 on this computer and I am up to 10 now. My oracle still works. The best suggestion I can give is to update your crystal install to include the orcale stuff again. You may need to uninstall then reinstall. Don't forget the service packs. Oh... you should probably make sure your client works outside of crystal first.. I use toad but you can use anything includeing the standard oracle tools.

Lisa

 

[davidread]

Thanks Lisa...

I have tried all that and I use PL/SQL developer all the time.

I think I need to regclean something, but not sure what to remove.

The one thing I haven't done is the service packs. I'll try that. They look like a little overkill.

David