Windows 10 Pro, 20H2
MicroStation V8, 32 bit (Scenario 1):MicroStation V8i (SS10), Version 08.11.09.919, EnglishOracle Client: , Version 12.2.0.1.0Oracle Server: Oracle Database 18c Express Edition , Version 18.4.0.0.0
MicroStation Connect, 64 bit (Scenario 2):MicroStation Connect Update 14, Version 10.14.00.109, EnglishOracle Client:. Version 19.0.0.0.0Oracle Server: Oracle Database 19c Enterprise Edition , Version 19.3.0.0.0
In each scenario the following environment variables are set on system level (OS):
Scenario 1:ORACLE_HOME = C:\oracle32\product\12.2.0\client_1PATH = C:\oracle32\product\12.2.0\client_1\bin
Scenario 2:ORACLE_HOME = C:\oracle\product\19.0.0\client_1PATH = C:\oracle\product\19.0.0\client_1\bin
In each scenario the following MicroStation configuration variables are set:
MS_DBDLM = 1MS_LINKTYPE = ORACLEMS_NOMSFORMSTABLE = 1MS_ORACLE_HOME = c:/oracle32/product/12.2.0/client_1 (Scenario 1)MS_ORACLE_HOME = c:/oracle/product/19.0.0/client_1 (Scenario 2)MS_SERVER : oralddlmMS_DGNAPPS > server
II'm working with Scenario 1 and with Scenario 2 on the other hand.
In each scenario I'm trying to setup an Oracle database connection by keying in the following command at the MicroStation Keyin window:
ACTIVE DATABASE <user_name>/<password>@<alias from tnsnames.ora>
And these are my results:
Scenario 1:Database successfully connected.
Scenario 2:No connection established. I always get the message: Unsuccessful CONNECT statement
In each scenario it is possible to setup a successful database connection by each of the following tools:
tnspingsqlplusOracle Net ManagerOracle SQL Developer
So, question is: What is going wrong in Scenario 2 inside MicroStation Connect ????
Any hints, suggestions, etc. are very appreciated.
Thanks,
Martin
Martin Gitschel said:C:\oracle\product\19.0.0\client_1\bin
Is that a 64-bit version of the Oracle client?
Regards, Jon Summers LA Solutions
Yes, this is 64 bit ...
Martin Gitschel said: C:\oracle\product\19.0.0
The compatible database wiki is well out of date. We can't tell if Oracle 19 client is supported.
May be the bentley guys will give an appropriate statement concerning this question ???
Martin Gitschel said:May be the bentley guys will give an appropriate statement concerning this question ?
File a Service Request. That at least records the date when some defect was reported.