Skip to Main Content
Forums

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

the driver doesn't support the version of ODBC

543354Jan 22 2008 — edited Jan 23 2008
Hi:

We have been working with timesten client on a windows, we had not have any problem, the number of clients had not connect more than 80 clients, but today we connected 125 clients and we got this error directly to the client application.

ERROR [08001] [TimesTen][TimesTen 7.0.1.0.0 CLIENT]Unable to connect to data source (DSN: SentraProdDSN; Network Address: 10.100.134.24; Port Number: 16003). ENOTSOCK: Invalid socket or socket closed.

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).


But on the server error log the messages were:

14:52:02.75 Err : SRV: 8974: EventID=5| Socket recv() failed. Error (131): Con
nection reset by peer. File: /olympus/build/release_20070911/VisiChannel/oc/src/
vostcpip.cpp; Line: 632
14:52:02.75 Err : SRV: 8974: EventID=68| Failed to read request from client. Cl
osing connection without reply.
14:52:06.38 Err : SRV: 9078: EventID=5| Socket recv() failed. Error (131): Con
nection reset by peer. File: /olympus/build/release_20070911/VisiChannel/oc/src/
vostcpip.cpp; Line: 632
14:52:06.38 Err : SRV: 9083: EventID=5| Socket recv() failed. Error (131): Con
nection reset by peer. File: /olympus/build/release_20070911/VisiChannel/oc/src/
vostcpip.cpp; Line: 632
14:52:06.38 Err : SRV: 9078: EventID=68| Failed to read request from client. Cl
osing connection without reply.
14:52:06.38 Err : SRV: 9083: EventID=68| Failed to read request from client. Cl
osing connection without reply.
14:52:06.81 Err : SRV: 9116: EventID=3| Socket send() failed. Error (32): Brok
en pipe. File: /olympus/build/release_20070911/VisiChannel/oc/src/vostcpip.cpp;
Line: 728
14:52:06.81 Err : SRV: 9116: EventID=5| Socket recv() failed. Error (131): Con
nection reset by peer. File: /olympus/build/release_20070911/VisiChannel/oc/src/
vostcpip.cpp; Line: 632
14:52:06.81 Err : SRV: 9116: EventID=68| Failed to read request from client. Cl
osing connection without reply.
14:52:07.13 Err : SRV: 16186: EventID=5| Socket recv() failed. Error (146): Con
nection refused. File: /olympus/build/release_20070911/VisiChannel/oc/src/vostcp
ip.cpp; Line: 632
14:52:07.57 Err : SRV: 16186: EventID=5| Socket recv() failed. Error (146): Con
nection refused. File: /olympus/build/release_20070911/VisiChannel/oc/src/vostcp
ip.cpp; Line: 632

So we don't know if this error could happen because the number of connections were exceeded, but when this has happened the error messages is different.

Let me tell you that the application client was developed using C#. So could it be that the C# on .NET could have a instruction that the timesten ODBC could not manage?

Comments

543354
I forget some important information:

Cliente Timesten Version: 7.0.0.1
Server TimesTen Version: 7.0.0.3

Regards
600280
i have the seem problem
Slaw-Oracle
Is this problem reproducable? i.e. Does it occur whenever you get close to 125 clients connecting to TimesTen? Next time when it happens again, can you check to see whether you can establish a new client/server connection locally on the TimesTen server machine?

Each TimesTen Client connection requires one server process, and by default, a server process is spawned when a client requests a connection. It is possible that you may have too many processes running on the server, hence it cannot spawn additional server processes to handle the new connections. The good news is that in 7.0.3, the TimesTen server is now multi-threaded and each process can handle multiple client connections (this number is configurable), so it's possible to have fewer server processes for the same number of client connections compared to previous releases.

Please check out "Specifying multiple connections to the TimesTen Server" in the 7.0.3 Oracle TimesTen Operations Guide for more information on how to turn on the multithreaded mode.

Regards

Simon
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 20 2008
Added on Jan 22 2008
#database-key-features, #timesten-in-memory-database
3 comments
3,384 views