ServiceName instead of SID

ServiceName instead of SID

Postby 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
Peca
 
Posts: 4
Joined: Sun 30 Sep 2007 21:56

Postby 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
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle