Oracle database connection error by database connectors

Question

question

Libby asked Aug 13, '19 Phil BoBo edited Sep 19, '19

Oracle database connection error by database connectors

hi , I have problem when I use database connectors to connect to an oracle database.

When using ODBC to create a DNS as below I can test connection successfully,and I can use command "dbopen","dbsqlquery" to read data.

But when using database connectors to get data(both ORACLE and ODBC) will shows error below

Software Version:

FlexSim 19.1.0

database connector oracle

p1.png (52.0 KiB)

p2.png (17.6 KiB)

p3.png (17.7 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

tannerp commented · Sep 18, 2019 at 09:21 PM

Hi @Libby,

We apologize this question was overlooked. Not many users are familiar with the Database Connector and this error is more of a database problem and not a FlexSim problem. My recommendation is to make sure you have installed the database and granted authorization to all appropriate users. You can find additional information about the connection error here. Hopefully this helps and is not too delayed a response.

0 ·

Answer 1 · 2019-09-19T20:59:12Z

Phil BoBo answered Sep 19, '19 Phil BoBo edited Sep 19, '19

The dbopen() command and the Database Connector tool use two different methods for communicating with databases.

The Database Connector uses a library that can connect with multiple different kinds of databases directly. Based on your screenshot, it is trying to use an Oracle dll called oci.dll. FlexSim doesn't ship with that dll. You need to install something from Oracle to install that dll into the correct location so that the SQL library that FlexSim's Database Connector uses can find it and use it. Probably something from: https://www.oracle.com/database/technologies/instant-client.html

FlexSim doesn't ship with all the dependencies needed to connect to an Oracle database. You need to install stuff from Oracle to make it work.

question