[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1213
  • Last Modified:

(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?  
0
obrienj
Asked:
obrienj
  • 5
  • 3
2 Solutions
 
wykabryanCommented:
You are trying to use an Oracle 10g setup to access a Oracle 9i database? I believe you will still need to have the oracle 9 client setup on your machine. In my current company, we run both as well and when I look at the Oracle folder I see one for 9 and one folder for 10.
0
 
obrienjAuthor Commented:
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?
0
 
wykabryanCommented:
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.
0
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
obrienjAuthor Commented:
I dont really get you.  Are you saying you have 9i client on a vista machine?  How did you manage to do this?
0
 
wykabryanCommented:
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
0
 
obrienjAuthor Commented:
Ah, sorry, I thought you were on Vista as well.  
0
 
mlmccCommented:
If the Oracle 9i client won't install on Vista you basically have 2 choices
1. Setup a different machine using XP and have 2 development machines

2.  Use a different connection type OLE/ODBC to connect to the database from Vista

mlmcc
0
 
obrienjAuthor Commented:
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
0
 
obrienjAuthor Commented:
Shoot...really sorry, thought all answers were from the same person.  Can I change this to split the points out please?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now