INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

.NET Application Error with Pervasive on 64-bit 2008 Server

.NET Application Error with Pervasive on 64-bit 2008 Server

(OP)
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.

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 Try

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?

RE: .NET Application Error with Pervasive on 64-bit 2008 Server

(OP)
one more thing:

PSQL 10.10 64-bit Server
the machine with the error is on a PSQL 10.10 64-bit client

 

RE: .NET Application Error with Pervasive on 64-bit 2008 Server

What's the exact version of the Pervasive.Data.SqlClient.dll?  
I've done some 64 bit work with the provider and haven't had any problems.  
How are you compiling the program?  What do you have set for the "Platform"?  in the "Debug" tab of the project properties?  
 

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: .NET Application Error with Pervasive on 64-bit 2008 Server

(OP)
Mirtheil -

I got the issue figured out (after many hours of pulling my hair out, checksumming and digging through file system changes).   The original Pervasive 10 CD shipped to me was not 10.10,  I downloaded 10.10 from the Pervasive website which I used to ugprade my database server and install all my clients.  When I installed my Terminal Server I installed the 64-bit client which was unpacked with the rest of what I got from the pervasive website for 10.10.  This installed no problem but I didn't have PCC, the utilities etc.  So I said I must have clicked the wrong button and installed the 32bit version and got the tools and such; in doing so overwrote the 64-bit dll's I guess.   Blah - so this is now really bad.  Uninstall and rip everything pervasive out (go go System Restore!)   Say OK, let me install off the disk my reseller sent me so I install on my fairly clean install (the checkpoint I restored to was just after the machine was joined to the domain) and get the same thing with the 64-bit client installer from the CD (pre 10.10) thinking for sure the CD will be good and then I'll install the upgrade I downloaded to bring it current.  Yeah, no love from the installer.  System Restore again. So this time I use the installer I used every place else and install the 32-bit client on the 64bit box the first time, do a custom install and do not install the data access components.  Let the 32-bit installer finish THEN go back and run the 64-bit installer using custom; the only install options / configurations I have are the installation paths but nothing else and I guess whatever the 64-bit installer "installs" it adds the stuff necessary for the previously posted code snippets to run.

Very weird but I think its working.  My in house .NET utilities are running, the application we use has its btreive stuff working, its classic vb stuff and most of its vb.net portions (but nto sure if all of them are working or not).  

I'm still a few days from tyring to rollout the terminal server, I guess I know what my time is goign to be spent on testing!

Mark / TNGPicard

RE: .NET Application Error with Pervasive on 64-bit 2008 Server

Glad you got it all sorted.  One thing to remember with the 64 bit PSQL products.  The 64 bit client installs only the 64 bit Btrieve parts.  It does not include any utilities, ODBC drivers, or other access methods.   The 64 bit Server does include all of those files though.  The PSQL Relational engine is only 32 bit.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close