Oracle Exception Network error

Oracle Exception Network error

Postby tvr » Wed 20 Jun 2007 21:05

My company recently purchased OraDirect to connect directly to our database instead of going though a WebService. Now that we are using it, we are getting different network errors. Example: Network error: 200, Network error: (Could not find resource assembly), & Network error: ( An operation was attempted on something that is not a socket.). I'm closing all the connections.

Below is one of the errors exactly:

MAT_ADCI.exe
OracleException
Network error: (An operaton was attempted on something that is not a socket)

CoreLab1Oracleb::a+0xbd
CoreLab1Oracleau::a+0x75
CoreLab1Oraclen::a+0x31
CoreLab1Oraclen::b+0x31
CoreLab1Oraclen::e+0x26
CoreLab1Oraclei:d+0xb
CoreLab1Oracleah::b+0x10
CoreLab1Oraclead::a+0x51
CoreLab1Oracleu::l+0x16
OracleCursor::a+0x13
OracleCursor::Finalize+0x7


Do you have any ideas why we are getting this now using OraDirect for Mobile? Any help will be greatly appreciated. Thanks!

tvr :(
tvr
 
Posts: 18
Joined: Fri 22 Sep 2006 21:56

Postby Alexey » Thu 21 Jun 2007 06:04

What is the exact version of OraDirect .NET Mobile you use (X.XX.XX.X)?
Try to use the latest one.
If it is possible, send me a small test project to reproduce the problem. It is desirable to use 'scott' schema objects, otherwise include definition of your own database objects. Do not use third party components.
Use e-mail address provided in the Readme file.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby tvr » Thu 21 Jun 2007 11:53

We have Oradirect 3.55.18.1. Our project is in C# VS 2003, created to run on our Symbol PDT8100 hand-held scanner terminals (HHT). Everything works fine on the emulator, I think because we are not connecting and disconnecting.

You mentioned a third party software not to use. What exactly are you referring to. I will send you a sample of what we are doing. Thanks in advance.

tvr
tvr
 
Posts: 18
Joined: Fri 22 Sep 2006 21:56

Postby tvr » Thu 21 Jun 2007 13:52

How do we go about upgrading to the latest versions? Can we upgrade to 3.55.22 and is this part of the maintenance to the version we just purchased.

tvr
tvr
 
Posts: 18
Joined: Fri 22 Sep 2006 21:56

Postby tvr » Fri 22 Jun 2007 11:03

I e-mailed the file yesterday, any ideas yet. I have a serious deadline. Thanks again for you help in advance.

tvr
tvr
 
Posts: 18
Joined: Fri 22 Sep 2006 21:56

Postby Alexey » Fri 22 Jun 2007 15:00

tvr wrote:How do we go about upgrading to the latest versions? Can we upgrade to 3.55.22 and is this part of the maintenance to the version we just purchased.
You should download the latest version from the registered users area. The link must have been provided in the registration letter. Please try it, because the problem might be fixed in the latest version.
tvr wrote:I e-mailed the file yesterday, any ideas yet. I have a serious deadline.
If the problem persists with the latest version, please send me you project with valid database objects definitions, so that I could at least run the project.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby tvr » Fri 22 Jun 2007 15:38

Thanks for your response.

The weird thing with this is that it sends and retrieve data from the database with no problems. The error pops up intermittently, even when I'm not send or retrieving data, and it kicks me out the application.
tvr
 
Posts: 18
Joined: Fri 22 Sep 2006 21:56

Postby Alexey » Sat 23 Jun 2007 07:09

Does this happen when connection is already closed? Do you know why it is closed? If you close connection yourself, then we could fix the problem. If connection closes itself, you need to find out why.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby tvr » Mon 25 Jun 2007 16:27

This happens when we have closed the connection. The application closes the connection when each process that requires db connectivity has finished.

We are unable to download the upgrades due to circumstances beyond our control, so we would really appreciate a fix if you have one.
tvr
 
Posts: 18
Joined: Fri 22 Sep 2006 21:56

Postby Alexey » Wed 27 Jun 2007 12:44

OK, we will try to fix this.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Wed 04 Jul 2007 09:35

Please try OraDirect .NET version 3.55.23 which is available for download now.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle