Devart Forums

Sorry for the delay. Our DBA was on holiday and I couldn't get help until yesterday (my user didn't have enough privileges to access v$session)

Our Oracle version is the same as yours, oracle 12.c release 2.

I have checked the query you told me and the result is always 'SHARED' (In SQLDeveloper connections I get 'DEDICATED' as expected)

Thank you for your attention.

If it helps: I have checked both Delphi 7 and XE 10.2 using the latest version of your DLLs ( 6.10.15.0 )

Thanks for your help, but it didn't work.

I have tried and I can connect with parameters in TNS style, but the connection is still shared. If it helps, this is my code:

SQLConnection.Params.Values['DataBase'] := '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<service name>)))';

But when the program connects to Oracle, what Oracle gets is this:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service ame>)(CID=(PROGRAM=<exe name>)(HOST=<my PC's name>)(USER=<my Windows username>))))

It seems that, no matter what the value for SERVER is, it is always omitted in the connection.

Any other idea to try?

I am using dbexpress in direct mode. Is it possible to establish a dedicated connection?

I have not been able to find anything about it in the documentation or forum.

Thanks in advance.