Skip to Content
0
Former Member
Apr 01, 2014 at 03:48 PM

Access ACUODBC from Powerbuilder

57 Views

Hi,

i have a PB12.5 App and want to access data from microfocus.

There is an ODBC Driver available called ACUODBC.

It works fine for selects on full tables but it gives no result if a where clause is provided.

select a,b,c from table works fine but

select a,b,c from table where a=xy gives no error code and no result; just as if there would be no data.

When i change settings in the ODBC configuration i could manage to get data back but the response time is not acceptable, it does a full-table-scan and does not use indexes.

my configuration is:

SQLCA.DBMS = "ODBC"

SQLCA.AutoCommit = False

SQLCA.DBParm = "ConnectString='DSN=REALTEST',Block=1"

I have tried already with disablebind but this has no effect.

Other tools like MSQUery can access this data perfectly, also the where clause works fine there but from PowerBuilder i couldn't manage to get it working.

Does anyone have an idea?

Thanks,

Regards

Harald