-----Original Message----- From: yazid [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 1:51 PM To: [email protected] Subject: [indopb] Re: Dw dari dua database transaction Ok.. sudah direvisi, tapi tetep belum connect jg ke SQLCA2,.. ??? ==== transaction SQLCA2 SQLCA2 = CREATE transaction dw_1_list.GetTrans(SQLCA2) klo gak salah gak perlu statement ini. SQLCA2.DBMS = "ODBC" SQLCA2.AutoCommit = False SQLCA2.DBParm = "ConnectString='DSN=Payroll8;UID=user01;PWD=pass01; CursorLock='OptValue''" Maaf parameter ini untuk apa ya? SQLCA2.ServerName = "hrd_laut" Apa anda buat aplikasi Client Server? Atau Standalone? Tolong dicek lagi nama server-nya. 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 http://groups.yahoo.com/group/indopb/ [EMAIL PROTECTED] http://docs.yahoo.com/info/terms/ [Non-text portions of this message have been removed] ----------------------------------------------- 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/
