Wednesday, May 23, 2007

Direct tnsNames.ora style ConnectionString for Oracle from .NET

1. tnsping (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))

2. if step 1 is successful, then
ConnectionString="Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)));uid=;pwd=;"

3. Location for tnsNames.ora file C:\oracle\ora817\network\ADMIN
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)