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" <[EMAIL PROTECTED]> 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: [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 ----------------------------------------------- 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/
