How to connect two SQL databases at the same time

I'll give you a copy :

PB connects to multiple databases.

2007-11-29 13:54:23|Category: PB |Tags: |Font size: Large, Medium and Small subscription.

Declare multiple transaction variables.

transaction sqlca, sqlcb;

sqlca = create

transaction;

sqlcb = create

transaction;

Then configure accordingly.

odbc"false

connectstring='dsn=***uid=***pwd=***"

odbc"false

connectstring='dsn=***uid=***pwd=***'"

When you use it, you can directly use Connect Using SQL Ca to connect to the database corresponding to SQL Ca and use Connect Using

SQLCB can connect to the database corresponding to SQLCB, and can maintain a connection to multiple databases at the same time in the program, without disconnecting after the connection is used up, because frequent use of CONNECT and Disconnect may cause many unexpected problems.

It should be noted that when we use SQL statements such as SELECT in the program, PB uses SQL CA for database connection by default, so when using SQL statements such as SELECT, we must add using at the end

For example, select name

into: ls_name

from students

where number = :ls_number

using newtransaction;

Post the source code and take a look

PB uses one transaction object for each database connection.

Usually we use SQLCA is the default transaction object.

You can define multiple transaction objects, such as transactionmytran

You set the connection parameters again, just like you set the connection parameters of sqlca, and finally connect, of course, is to use connectusingmytran;

If you do not add usingmytran at the end, the system uses sqlca to connect by default.

This will connect you to another database, and you can define several more databases, so that when you work with different databases (sql**), you will add one (using transaction potato infiltration object name) to the end

And the cheating data window is set in the step number of ().

You can try.

Write an ini file specifying the address of your server, and write a read in the program.