I am now connecting to a database in pb also want to connect to the database b, how can I do
Have a ask, if I want to have a list in the database a guide into database b, could you tell me how to write the code, then thanked for a while in xie first
CodePudding user response:
How no one to help, if I can't talk, you don't want to back, or other reasons!CodePudding user response:
A new transaction object, connect the new database, to aThe Transaction mytrans
Mytrans=create Transaction
//Profile mydb
Mytrans. DBMS="MSS Microsoft SQL Server"
Mytrans. Database="mydb"
Mytrans. LogPass=& lt; * * * * * & gt;
Mytrans. ServerName="127.0.0.1"
Mytrans. LogId="sa"
.
Connect using mytrans;
To use the new database, using the transaction object!
2, PB has a tool data pipeline, specially for the data transfer. Can read!
CodePudding user response:
Thank you very much! Blood is still not cold __ Microsoft UFOBut I'm not very understand, her little brother, I am just learning to pb
Also please comment
1. The 200 libraries I have connected, but there is one, and even called 300, don't know how to connect
//Profile 200
The SQLCA. DBMS="O90 Oracle9i (9.0.1)"
The SQLCA. LogPass="gzsb2006"
The SQLCA. ServerName="200"
The SQLCA. LogId="gzsb2006"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="PBCatalogOwner='gzsb2006'"
The connect.
Open (w_zm)
And I want to have a list of 200 repository ab_du database tables to 300, want to use the buttons to do this, could you tell me how to write the code button,
CodePudding user response:
Which eldest brother elder sister help me a little nastyThe younger brother while pb
CodePudding user response:
I have said how to connect the new database!The sqlca isn't connect old data!
The mytrans is new to the database!
"And I want to have a list of 200 repository ab_du database tables to 300, want to use the keys to achieve"
This also said, is the simplest data pipeline! The book is! Say other way more don't understand you!
You have to read a book! You have to make fundamental thing to understand!