Old Powerbuilder app, trying to run on Windows 7 64bit with SQL2008 Connectivity

So we've an old circa 2000 Powerbuilder App that we've been maintaining all this time. Its been working great until I tried to get it going on my new Windows 7 64-bit machi开发者_如何转开发ne.

First, the old SQL 2000 client install we always have used won't install. Second, after installed SQL 2008 connectivity tools, the app fails to connect to our database.

The error is "DBMS is not supported in your current installation"

Im worried that the 32bit PBMSS90.dll just cannot deal with the 64bit SQL drivers. I have no idea what to do at this point.

If you can offer any help, its greatly appreciated. Thank you

Just load the 32-bit connectivity software for SQL Server. The 32-bit and 64-bit should be able to co-exist nicely, and PowerBuilder (and any other 32-bit software that accesses SQL Server) will be able to use 32-bit.

Good luck,

Terry.

Windows 7 comes with a virtual machine IIRC that can emulate all MS operating systems back to Windows 95. If this is an OS environment problem try loading your app in an XP virtual machine.

The problem I encountered is that the ancient Microsoft SQL Server driver we had been using (MSS) cannot be installed on a 64bit machine.

To make matters worse, the current SQL Native Client driver (SNC) is not at all compatible with the Powerbuilder 9.0 app we had.

The solution was to installed SNC and recompile the application in Powerbuilder 11.5 or later (in our case we used 12).

The application now runs, and connects to the database. There are a few issues to work out yet, as MSS and SNC regard char type variables differently, but the major hurdle was covered.

Thanks for your help.