Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there any issue with using ODBC to access the data in the Oracle Database on a Shared Oracle Server?

April 26, 2017Data ISSUE ODBC Oracle oracle database server Shared

0

Posted

Is there any issue with using ODBC to access the data in the Oracle Database on a Shared Oracle Server?

1 Answer

0

Posted

Your application server will need to have the Oracle ODBC driver installed. The ODBC driver is linked against the Oracle client library. The driver changes the ODBC calls to oracle OCI calls and connects to the database as any other Oracle connection. The database does not need know anything about OBDC. You web/application server usually needs to have the Oracle client libraries installed. The libraries are not available for FreeBSD. The libraries are available on Solaris VPS or you can run you application under Linux compatibility mode on FreeBSD.