This topic is READ ONLY
import-bot (20211) [Avatar] Offline
#1
[Originally posted by ronb]

Enjoyed your book so far.

Referencing Chap. 3 basic steps: Everything works fine and data is returned
from the datastore to the browser as long as I'm using the Powersoft demo DB.

If I modify the DSN connection string to Oracle 7.3 or Oracle 8 using a single
table datawindow(grid), I receive only the text labels in the browser and no
data returned.

This is the listing in the df_get_client_list of the user object.

// Populate the transaction object
//lto_mytrans.DBMS= "OR8 ORACLE 8.0"
lto_mytrans.DBMS= "O73 ORACLE 7.3"
lto_mytrans.DbParm= &
"ConnectString='DSN=Web Development;"+&
"UID=xxx;PWD=xxx'"
//lto_mytrans.DbParm= &
//"ConnectString='DSN=Wise Personal Oracle;"+&
//"UID=wise;PWD=wise'"

Any suggestions would be appreciated. Thanks
import-bot (20211) [Avatar] Offline
#2
Re: Retrieve problem
[Originally posted by yannick]

When you preview your DW in PowerBuilder, does it retrieve ok? What is the
return value of your retrieve() statement?

> Enjoyed your book so far.
>
> Referencing Chap. 3 basic steps: Everything works fine and data is returned
> from the datastore to the browser as long as I'm using the Powersoft demo DB.
>
> If I modify the DSN connection string to Oracle 7.3 or Oracle 8 using a single
> table datawindow(grid), I receive only the text labels in the browser and no
> data returned.
>
> This is the listing in the df_get_client_list of the user object.
>
> // Populate the transaction object
> //lto_mytrans.DBMS= "OR8 ORACLE 8.0"
> lto_mytrans.DBMS= "O73 ORACLE 7.3"
> lto_mytrans.DbParm= &
> "ConnectString='DSN=Web Development;"+&
> "UID=xxx;PWD=xxx'"
> //lto_mytrans.DbParm= &
> //"ConnectString='DSN=Wise Personal Oracle;"+&
> //"UID=wise;PWD=wise'"
>
> Any suggestions would be appreciated. Thanks