Index:
- What version of MicroStation V8 requires this Bentley Oracle 9i client?
- How do I connect to an Oracle 9i database through MicroStation V8 versions 08.01.00 to 08.01.01?
- After I download the files and install the patch, how do I connect to my database?
- When I try to connect to an Oracle 9i database, why do I receive the following error message? "This current MicroStation Database Server requires an Oracle 9i client. Please check the Oracle_Home path and the MicroStation Database server."
Question 1: What version of MicroStation V8 requires this Bentley Oracle 9i client?
Answer: MicroStation V8 version 08.01.00.07 through 08.01.01.09 require this patch in order to connect to Oracle 9i. Beginning with MicroStation V8 version 08.01.02.15, the patch is no longer required. MicroStation uses a combination of the registry and the configuration variable MS_ORACLE_HOME to determine the version of Oracle client that is present on the machine. Support for Oracle 8 and 9 are delivered with MicroStation, so no additional files are required.
Question 2: How do I connect to an Oracle 9i database through MicroStation V8 versions 08.01.00 to 08.01.01?
Answer: You must first download the Bentley Oracle 9i client file from the download area of SELECTservices Online. Set the Category to Enhancements & Updates and the Discipline to Foundation Products.
When the products are listed, scroll down until you find the Bentley Oracle9i Client listed. Click the download button to place the files on your local machine.
In the Web Downloads Search dialog, for Application Group, choose Enhancements & Updates, then accept all the defaults and choose Search. When the products are listed, scroll down until you find MicroStation V8 Oracle 9i Enhancement. Choose Download and download the .exe to your local machine.
Once the .exe is downloaded, run the .exe file. When prompted, either choose to unpack the files to a temporary location or browse to a desired location. After the files are unpacked you will be prompted to unzip files, choose the following path to extract the files to:
\Program\MicroStation\mdlsys\asneeded
You will receive a prompt telling you that files are being overwritten. By choosing Yes, the following files will be overwritten: oralddlm.ma, orserver.rsc and orservrd.dll. These files are overwriting the existing MicroStation database server files and will now allow you to connect to Oracle 9i.
Back to Index
Question 3: After I download the files and install the patch, how do I connect to my database?
Answer: : The connection is the same as in previous versions of MicroStation. See FAQ 6203 for more information. When in MicroStation, choose Settings > Database > Connect. Make sure the Server is set to Oracle and in the connect string type the following: <username>/<password>@<host string>. For example, if your username was gis and your password was gis and the service name/host string was bentley, you would type the following in as the connect string:
gis/gis@bentley.
Question 4: When I try to connect to an Oracle 9i database, why do I receive the following error message: "This current MicroStation Database Server requires an Oracle 9i client. Please check the Oracle_Home path and the MicroStation Database server"?
Answer: Several things could be occurring. Possibly, the Oracle 9i client has not been installed. MicroStation needs the Oracle 9i Required Support Files to connect directly through Oracle. Please consult your Oracle 9i CD.
Another reason may be that you have two different versions of the Oracle Client installed. When you have two versions of the client installed, MicroStation does not know which client to connect to so it gives you this error message. You can overcome this by creating a variable in MicroStation (WorkSpace > Configuration) called MS_ORACLE_HOME and defining the variable the path where Oracle 9i client is located.
In certain versions of MicroStation V8, the variable will already be defined for you but not set, in the Oracle.cfg file. Simply define the variable where the Oracle 9i client is installed.
Back to Index