Devart Forums

Is Oracle Client required to run this software?

I forgot to mention we are using OraDirect .NET Mobile 4.0.15.1.

No, Oracle client is not to be used with OraDirect .NET Mobile.

We have two different work sites getting two different results.

1st Site:
Have Oracle Client on the workstation using a regular server with the following connection:
string sConnection = "User Id=" + sServerUserId
+ ";Password=" + sServerPassword
+ ";Port=" + iPort
+ ";Server=" + sServer
+ ";Sid=" + sSid.ToUpper();

OracleConnection(sConnection)Everything works fine.

2nd Site:
Does not have Oracle Client on the workstation using a multi-threaded server with the same connection string as above. They are getting the following error message:

Error Msg -
Header : "Unhandled Exception"
Body: Error loading user data: Network error:: Could not find resource assembly.

Does the connection need to be different, because of the multi-threaded server? Do they need to establish a DEDICATED server connection to get through the firewall.

Any idea would be greatly appreciated.

You cannot execute more than one command on the same connection simultaneously in direct mode. You need to create new connection in each thread.

I'm sorry if I was not clear. I'm not using the same connection. I talking about two totally different locations using the same software and exactly the same way.

I understood you. I am talking about second site. You are using direct mode of OraDirect .NET on a multi-threaded server. In this case you need to open new connection for each command. When do you get the error?

I have a new connection for each command. The error is happening immediately.

Could you provide me with the stack trace?

Can you send me an example the connect string? The stack trace ??? how do we create this?

Here is the example of the connectiong string:
The call stack you should get along with the error message.