Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection String VB dot net

693840Jul 17 2010 — edited Jul 17 2010
hi,

i am making application on VB.NET 2008 and oracle database 10g

for connection of my application to my database i am using this connection string

Dim oradb As String = "Data Source=orcl;User Id=dsseag;Password=mypassword;"
Dim conn As New OracleConnection(oradb)

This is my database tnsname.ora file

*# TNSNAMES.ORA Network Configuration File: D:\oracle_developer\product\10.2.0\db_1\network\admin\tnsnames.ora*
*# Generated by Oracle configuration tools.*

ORCL =
*(DESCRIPTION =*
*(ADDRESS_LIST =*
*(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.93.93)(PORT = 1521))*
*)*
*(CONNECT_DATA =*
*(SERVICE_NAME = orcl)*
*)*
*)*



and its working fine..

Here is the Problem

my application is on server side

i want to use my database from my application when my network cable is unplugged. but the problem is when my network becomes unplugged, my Listner also becomes shutdown. and thats why i could'nt connect.

please tell how to connect my application to the database when my network cable is unplugged.

if connection-string is the problem ,kindly tell me

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2010
Added on Jul 17 2010
5 comments
1,611 views