Page 1 of 1

ServiceName instead of SID

Posted: Fri 22 Apr 2011 15:12
by Peca
Hi, we use D2007 and DBExpress OracleDirect ver. 2.8.

We can connect to database by its SID, like this way server:port:sid

Is it possible to connect this database by its service name? We tried replace sid by servicename, but it not work.

Thanks

Posted: Tue 26 Apr 2011 12:13
by AlexP
Hello,

Support for connection with using Service Name in the Direct mode was added starting from the 4.80.24 version of dbExpress driver for Oracle.
To connect using ServiceName, you should use the following syntax:

Server:Port:SN=ServiceName