asked on

(CRPE32.DLL) - PELogOnServer. Can't connect with Oracle 10g Client

I use the crpe32.dll in order to utilise Crystal Reports from my software.
I log on via the PELogOnServer function. I have been using this with Oracle 9i Server and Client for good while.

Recently I have set up a machine on Vista, which meant I had to install Oracle 10g client instead of 9i.

My connection to Crystal Reports no longer works. It just returns 0.
Anyone know if there is a known constraint with 10g client?? Is there any workaround?

ASKER CERTIFIED SOLUTION

wykabryan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

obrienj

ASKER

Yes, Oracle 10g client to Oracle 9i database. The problem is that 9i client doesn't work with Vista, so it doesn't appear to be an option to use the 9i client at all. Is there some workaround to this?

wykabryan

yeah, there is the issue right there. They are two different set up all together. In my oracle folder I have ora92 and product (which contains 10.2.0). I am not sure if there is a work around. You are probably going to need to post a question in the Oracle area.

obrienj

ASKER

I dont really get you. Are you saying you have 9i client on a vista machine? How did you manage to do this?

wykabryan

Yes, I have both install. So install 9 first. Then install 10. The difference here is I am on XP and you are on Vista. Here is a screen shot.
oracle.bmp

obrienj

ASKER

Ah, sorry, I thought you were on Vista as well.

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

obrienj

ASKER

Okay, I decided to run a test to see if it would work with 10g client to 10g server and it does.
So, the problem only lies in the different oracle versions. Probably nothing I can do about it.
Cheers.
James

obrienj

ASKER

Shoot...really sorry, thought all answers were from the same person. Can I change this to split the points out please?