ERROR CONNECTING TO ORACLE. SOCKET OPERATION ENCOUNTERED A DEAD NETWORK

[aissa gonzalez]

Hello
I need some help. I´m using a pocket pc with OraDirect.net and

I'm getting THIS ERROR WHEN I TRY TO OPEN A CONNECTION (ORACLE).
A SOCKET OPERATION ENCOUNTERED A DEAD NETWORK



Imports CoreLab.Oracle

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


Dim connectionString As String = GetConnectionString()
Dim queryString As String = _
"SELECT * FROM BD.IF_CATEGORIAS"
Dim connection As New OracleConnection(connectionString)
Dim command As OracleCommand = connection.CreateCommand()
command.CommandText = queryString
Try
connection.Close()

connection.Open()
Dim dataReader As OracleDataReader = _
command.ExecuteReader()
Do While dataReader.Read()
Console.WriteLine(vbTab & "{0}" & vbTab & "{1}", _
dataReader(0), dataReader(1))
Loop

dataReader.Close()

Catch ex As OracleException

Dim errorMessage As String = "Code: " & ex.ErrorCode & vbCrLf & _
"Message: " & ex.Message

End Try

End Sub

Private Shared Function GetConnectionString() As String

Return ("Data Source=local;Persist Security Info=True;User ID=USER;password=PASS;Unicode=True;SID=ORCL")



End Function
End Class

thanks in advance for your help

[Alexey.mdr]

Could you please specify the version and edition of OraDirect .NET, Visual Studio, Oracle server and .NET Framework (CF)?

[aissa gonzalez]

Could you please specify the version and edition of OraDirect .NET, Visual Studio, Oracle server and .NET Framework (CF)?

OraDirect.Net 4.60.33
Oracle server 9i
Compact Framework 2.0
visual Studio 2005

thanks

[Alexey.mdr]

Do you have Active Sync installed?
Do you have a device connected?
Try pinging your localhost (“Run” -> “ping 127.0.0.1”)
Try running the “Ping” sample from %Program Files%CoreLab\OraDirect.NET2 Mobile\Samples\Ping
Do you have your firewall on (try turning it off, or allow using the needed port)?

Usually, the problem is in Virtual PC Network driver which, as a matter of fact,
has been removed from the default setup of Visual Studio 2005.
So you need to install some specific software.
The application you should look for is ActiveSync (version 4.0. or higher).

[aissa gonzalez]

Do you have Active Sync installed?
Do you have a device connected?
Try pinging your localhost (“Run” -> “ping 127.0.0.1”)
Try running the “Ping” sample from %Program Files%CoreLab\OraDirect.NET2 Mobile\Samples\Ping
Do you have your firewall on (try turning it off, or allow using the needed port)?

Usually, the problem is in Virtual PC Network driver which, as a matter of fact,
has been removed from the default setup of Visual Studio 2005.
So you need to install some specific software.
The application you should look for is ActiveSync (version 4.0. or higher).

Rigth now My application and the oracle database are hosted in the same computer,
and the last error message was "An existing connection was forcibly closed by the remote host".

Testing the application in a different machine, using Pocket Pc emulator
and PDT syncronized with the PC, using USB cable, I got connected and everything was ok.

Now i try to connect wireless from the PDT and the error is TNS:No listener.

tsnames.ora file

# TNSNAMES.ORA Network Configuration File: C:\oracle92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.ISTECH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.209)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)

INST1_HTTP.ISTECH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = agonzalez)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)



listener.ora
# LISTENER.ORA Network Configuration File: C:\oracle92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.209)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle92)
(SID_NAME = ORCL)
)
)

I have Active SYNC VERSION 4.5
None of the CoreLab OraDirect.NET2 Mobile Samples works in my machine.
The firewall is deactivated
I can ping 127.0.0.1


In conclusion i need to connect from my pdt to oracle and the error is TNS no listener.



thanks for helping me out

Thanks from Panama

[Alexey.mdr]

It looks like the problem is in the network
(device network adaptor, emulator network adaptor, network driver).
Try running the Ping sample with:
HOST =192.168.1.209
SID = ORCL
PORT = 1521

As long as the sample does not work correctly, the problem is in the network.