Connection String VB dot net
693840Jul 17 2010 — edited Jul 17 2010hi,
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.