Greetings,
We have developed an ASP .NET app using VS Studio 2005. The database
in our test environment is Pervasive 9.5, but the same problem has
occured in a Pervasive 9.1 environment. We are using ODBC to access
the data. A simplified example:

Dim oConnection As OdbcConnection = New OdbcConnection(GET CONNSTRING
HERE)
Dim oCommand As OdbcCommand = New OdbcCommand()
sSQL = "SELECT field1, field2, field3"
sSQL = sSQL & " FROM (table1"
sSQL = sSQL & " LEFT OUTER JOIN table2 ON field1 = w.cpersonnamelink)"
sSQL = sSQL & " WHERE field3 = " & somevalue
oCommand.CommandText = sSQL
oCommand.Connection = oConnection
oCommand.CommandType = Data.CommandType.Text
oConnection.Open()
Dim result As OdbcDataReader =
oCommand.ExecuteReader(CommandBehavior.CloseConnec tion)
While result.Read
....

The SQL selects aren't that complex but in both environments we
randomly get a timeout error:

[OdbcException (0x80131937): ERROR [HYT00] [Pervasive][ODBC Client
Interface][LNA][Pervasive][ODBC Engine Interface]S1T00Timeout
expired.]
[InvalidOperationException: The connection has been disabled.]
System.Data.Odbc.OdbcConnection.ConnectionIsAlive( Exception
innerException) +1191211

I can't figure out what's wrong. As I said, the SQL clauses are quite
straight forward so I can't get why
most times the SQL execution is done within a second ot 2, but now and
again I get this error.
Any good tips where to look?

regards, Joacim

Check out OdbcCommand.Timeout property.

<jecko68 (AT) gmail (DOT) com> wrote