I have a small & simple application written in VB.net 2005 using version 3 of the Pervasive.Data.SQLClient adapter, runtime version 2.0.50727 which I downloaded from the PSQL 10 website.
In the above snippet, I have changed my dsn and my server name but they match the DSNs on the database server and the DSNs on the local machines exactly.
On my 32-bit client machines, this works fine, the connection opens to the database, no problemo!
On my Windows 2008 servers, I get an exception on the DBConn.Open() --- "Arithemetic operation resulted in an overflow." And a fairly lengthy stack trace.
The application works on Windows Vista Business (32-bit). I do not have a 64-bit Windows 2003 box on which to test or a 2008 box on a 32bit chip in which to test.
Has anybody run across this or have an idea / can point out the silly mistake I'm making?
Code:
Imports Pervasive.Data.SqlClient
...
Dim DBConn As PsqlConnection
...
DBConn = New PsqlConnection("ServerDSN=myServerDSN;Server=mydbserver;")
...
Try
DBConn.Open()
Catch ex As Exception
MessageBox.Show(ex.Message(), "DBConn.Open")
End TryIn the above snippet, I have changed my dsn and my server name but they match the DSNs on the database server and the DSNs on the local machines exactly.
On my 32-bit client machines, this works fine, the connection opens to the database, no problemo!
On my Windows 2008 servers, I get an exception on the DBConn.Open() --- "Arithemetic operation resulted in an overflow." And a fairly lengthy stack trace.
The application works on Windows Vista Business (32-bit). I do not have a 64-bit Windows 2003 box on which to test or a 2008 box on a 32bit chip in which to test.
Has anybody run across this or have an idea / can point out the silly mistake I'm making?