Connect without a TNSNames File entry

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
tbassett
Posts: 5
Joined: Tue 04 Nov 2008 17:56

Connect without a TNSNames File entry

Post by tbassett » Tue 04 Nov 2008 17:59

Can I connect to a database without using a tnsnames file entry use the OraDirect components?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 05 Nov 2008 11:05

Try using the folowing information instead of the server name in your connection string:

Code: Select all

"Server=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *Your_Host*)(PORT = *Your_Port*)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = *Your_Sid*))"

Post Reply