ServiceName instead of SID

Peca · Post by **Peca** » Fri 22 Apr 2011 15:12

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

AlexP · Post by **AlexP** » Tue 26 Apr 2011 12:13

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