Taod Data Point Connection error

Toad Data Point
1

hello I am trying to connect to an Oracle database using Toad Data Point v 6.3. It works for my production connection but when trying to connect to lower environments i am getting the below error:

System.ArithmeticException
Invalid bytes count
Stack Trace:
at Devart.Data.Oracle.by.a(List`1 A_0, SshOptions A_1, SslOptions A_2, Boolean A_3)
at Devart.Data.Oracle.cz.a(ea A_0, Boolean A_1)
at Devart.Data.Oracle.cz.a(ea A_0, b1 A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(ea connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.ei.a(z A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0, z A_1)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.Oracle.OracleToadConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

I am using a direct connection (not oracle client). This connection has also previously worked but recently started throwing this error and i cannot figure out why.

Any suggestions?

2

I am a Toad for Oracle developer, but I happened to see this post. This is the same as a bug we had in Toad for Oracle.

See here for cause and workarounds.

That's a long thread so I'll summarize:

  • Oracle was updated (or you are connecting to a new version)
  • You have one of the following in server-side sqlnet.ora
SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED
SQLNET.ENCRYPTION_SERVER=REQUIRED
  • You are connecting without an Oracle client.

Change any of these, and it will work.

I'm sure the TDP folks will have it fixed soon. Note to TDP folks: Update your Devart components. :slight_smile:

1 Like