Page 1 of 1

Access violation on oracle

Posted: Tue 26 Jan 2016 23:56
by 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!

Re: Access violation on oracle

Posted: Thu 28 Jan 2016 09:42
by 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).

Re: Access violation on oracle

Posted: Sun 06 Mar 2016 17:39
by 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?

Re: Access violation on oracle

Posted: Mon 07 Mar 2016 08:47
by 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.

Re: Access violation on oracle

Posted: Mon 07 Mar 2016 15:38
by jrheisler
I will check with our customer and see what can be done. Thank you!