Ok.. sudah direvisi, tapi tetep belum connect jg ke SQLCA2,.. ???
====
transaction SQLCA2
SQLCA2 = CREATE transaction
dw_1_list.GetTrans(SQLCA2)
SQLCA2.DBMS = "ODBC"
SQLCA2.AutoCommit = False
SQLCA2.DBParm = "ConnectString='DSN=Payroll8;UID=user01;PWD=pass01;
CursorLock='OptValue''"
SQLCA2.ServerName = "hrd_laut"
connect using SQLCA2;
IF SQLCA2.SQLCode <> 0 THEN
MessageBox("Connect Failed", &
"Cannot connect to database." + SQLCA2.SQLErrText)
ELSE
dw_1_list.SetTransObject(SQLCA2)
dw_1_list.Retrieve(is_npwp)
END IF
=====
--- In [email protected], "Prayugi" <[EMAIL PROTECTED]> wrote:
>
>
> seharusnya :
> IF SQLCA2.SQLCode <> 0 THEN
> ....
> bukan
> IF SQLCA.SQLCode <> 0 THEN
>
> -----Original Message-----
> From: yazid [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 06, 2006 12:58 PM
> To: [email protected]
> Subject: [indopb] Re: Dw dari dua database transaction
>
>
> Saya sudah buat transaction baru, tapi yg ke retrieve masih yg dari
> transaction pertama (SQLCA), adakah yg salah? atau yg kurang?
>
> //=============
> transaction SQLCA2
> SQLCA2 = CREATE transaction
>
> SQLCA2.DBMS = "ODBC"
> SQLCA2.AutoCommit = False
> SQLCA2.DBParm = "ConnectString='DSN=Payroll8'"
> SQLCA2.Userid = "user01"
> SQLCA2.DBPass = "pass01"
> SQLCA2.ServerName = "server2"
>
> dw_1_list.SetTransObject(sqlca2)
>
> connect using sqlca2;
> IF SQLCA.SQLCode <> 0 THEN
> MessageBox("Connect Failed", &
> "Cannot connect to database." + SQLCA.SQLErrText)
> ELSE
> dw_1_list.Retrieve(is_npwp)
> END IF
> //========================================
>
>
> thanks
>
> --- In [email protected], "Wahyu Kurniawan" <wahyu.kurniawan@>
> wrote:
> >
> > Anda harus buat database transaction baru untuk retrieve dari db2.
> >
> > Maaf klo salah. Begini syntax-nya.
> >
> > Transaction sqlca2
> > Sqlca2 = create object transaction
> > Sqlca2.userid = ...
> > Sqlca2.pass = ...
> > .
> > .
> > .
> > Dst sesuai dengan parameter yang dibutuhkan untuk koneksi ke ASA8.
> >
> >
> > -----Original Message-----
> > From: yazid [mailto:[EMAIL PROTECTED]
> > Sent: Monday, February 06, 2006 12:06 PM
> > To: [email protected]
> > Subject: [indopb] Dw dari dua database transaction
> >
> > Guys..
> >
> > Saya punya 2 database ASA8 yg dijalankan terpisah mis(db1 - db2)
> > Saat ini saya ingin ketika aplikasi me-retrieve dw, selain data
dari
> > db1, juga data db2 bisa ke retrieve.
> >
> > Db1 di retrieve menggunakan transaction standard SQLCA. Apakah
harus
> > dibuat database transcation kedua mis:SQLCA2 utk bisa connect ke
> Db2.
> >
> > Bagaimana syntax database transaction utk SQLCA2? Krn yg standard
> > disetup dari window wizard.
> >
> > Or.. Any suggestion ?
> >
> > Thanks
> >
> >
> >
> >
> >
> > -----------------------------------------------
> > IndoPB - Indonesia PB User Group
> > To Post a message, send it to: indopb@
> > To Unsubscribe,send a blank message to: indopb-unsubscribe@
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
>
> -----------------------------------------------
> IndoPB - Indonesia PB User Group
> To Post a message, send it to: [EMAIL PROTECTED]
> To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
> Yahoo! Groups Links
>
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
