Page 1 of 1

Connect without a TNSNames File entry

Posted: Tue 04 Nov 2008 17:59
by tbassett
Can I connect to a database without using a tnsnames file entry use the OraDirect components?

Posted: Wed 05 Nov 2008 11:05
by AndreyR
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*))"