on 02-25-2014 5:48 PM
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 - -
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 - -
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?
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.