Hello to all, I'm using GWP V8i with a database Oracle 10.2g. My configuration see the GWP Server is installed on the same machine with the database. I'm learning GWP using the tutorial, when I lunch my custom bat file to create tables and convert graphic files I can't connect to the database, the script shows me "Unable to connect to database". It's strange because I can connect and make select or update with sql+. I search a guide to resolve this problem, but I did't found it. Someone can help me?
Greetings. Cristiano
Hi. GeoWebPublisher V8i requires an Oracle 11g client to run properly. It accesses the database through the OCCI api so it needs those dlls. Since you have a 10g database, you GeoWebPublisher doesn't find the required dlls and thus will not support Oracle requests.
I don't know if it's possible to install an 11g client on the same machine as the Oracle server. However, I know that it is possible to install two versions of the Oracle client on the same machine. However in that case, care must be taken to configure the clients so that the 11g version is the first on the PATH, otherwise GWP will not find the correct version.
Finally, please note that it is not recommended to run both the ORacle server and the GWP server on the same machine for performance reasons.
Thanks,
Martin
Hello Martin,
thanks for your reply. Before to install GWP and Oracle 10.2g I read the documentation about the software where wrote that Bentley Geo Web Publisher V8i has been certified with Oracle Spatial 11 and Oracle Spatial 10g Release 2. So I used the Oracle Client 102.g to connect with the Oracle Server. Anyway I can try to use the Oracle Client 11.
Thanks a lot.
Cristiano
Ah, I see. What you read meant that GeoWebPublisher is certified to run properly against both versions of the Oracle server. However, in both cases we require the 11g client installed on the GeoWebPublisher machine to access those Oracel servers.
Ok, now I installed Oracle Client 11 but when I use the script for the tutorial I receive the message "Unable to connect to database". so, I tried to call iDPRcnv.exe with the string -db=ORACLE,scott/tiger@pippo.
Where pippo is the name of my DB. I don't know where is the mistake.