cancel
Showing results for 
Search instead for 
Did you mean: 

PowerBuilder 12.5.2 and ADO.net

Former Member
0 Kudos


So, question two of the day.

Running PowerBuilder 12.5.2 build 5006 running on Windows 7 64bit.  Trying to configure an ado.net connection but keep getting an error message "Uable to load the requested database interface.  Please make sure both the interface and client software are properly installed.".  I have removed and reinstalled the ado.net option in PowerBuilder (that's how I lost my license this morning) so I'm hoping that it is installed and working properly.  I have Microsoft .net 4 Framework installed.

Any suggestions?

- - Shane - -

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Shane;

   The PB IDE and its generated Application.EXE's are still only 32bit in nature.

So make sure that when you install the DBMS client ADO.Net drivers you select the 32bit version.

HTH

Regards ... Chris

Former Member
0 Kudos

Hi Chris,

Don't think that was my issue but I did solve it.  When PowerBuilder was installed on this VM image (our developer image) we had a lengthy discussion on also installing PowerBuilder .Net or just the PowerBuilder classic.  It was decided that we would just be using classic so we didn't install PowerBuilder .Net.  Although ado.net was selected in the PowerBuilder install, it didn't completly install.  Once I added PowerBuilder .net to the VM, the ado.net interface worked in PowerBuilder classic.

I think this could be a bug in the installer as if ado.net is selected, should tell you to also select PowerBuilder .net as a pre-req

- - SHane - -

Former Member
0 Kudos

Hi Shane;

  I'm glad that you got it working!

FWIW: PB.Net has nothing specific to do with general ADO.Net access to any DBMS. I suspect that you are correct and the PB installer may have an issue installing ADO.net depending on what options you select at the onset.

Regards ... Chris

Former Member
0 Kudos

FYI: Just finished a big study on native drivers versus ADO.Net on my BLOB imaging project. The average DB response time for a 4K average blob image was 109ms for ADO.net and 16ms for the native driver. The testing was conducted using PB Classic and PB.Net v12.1 over to ASE 15.3 & 15.7.  DB write times for the Blob Updates averaged 31ms for the native driver and 174ms for ADO.Net

  BTW: PB Classic was timed at 33% faster than PB.Net on the same blob test (read & write) over 114K rows.

Interesting .... n'est pas?