Access violation on oracle

[jrheisler]

Since version 6 of UNIDAC one of our customers can not login to oracle from our application using UNIDAC.

It happens on UniConnection.Open

This happens no matter if we use direct connect or not. On the same machine, UNIDAC 5 and below work fine using the OCI adaptor.

I'm not even sure how to debug this.

Help!

[MaximG]

To investigate the issue, please describe the following points in more details:

- What IDE version are you using in your project?
- What platform is your developed project running on?
- The used Oracle version;
- Send a query sample leading to an error on opening and the script for creating database objects mentioned in this query to maximg*devart*com
- What exact error occurs on query opening (in OCI Mode and Direct Mode).

[jrheisler]

Sorry for waiting so long, but it has taken time to reevaluate this customer's issue.

The problem is actually with Direct Mode. While investigating it turns out that from the DBA's machine, they can direct connect to one database but get that access violation when trying to connect to their other database. Both using the same client application.

This is a Delphi 7 application. One of the databases uses port 1521. The database that yields the access violation uses port 1524. The databases are on different servers.

What could cause this?

[AlexP]

We can't reproduce the issue on our test servers. If you can give us access to your server, we will test this behavior directly on it.

[jrheisler]

I will check with our customer and see what can be done. Thank you!