Using Multiple MySQL Ports in the Same Application

This is a code example of this command:

SET_DATABASE_PORT OF MYSQL TO PORT

Login <server1> <user> <passwd> "mdsmysql"


SET_DATABASE_PORT OF MYSQL TO 5576

Login <server2> <user> <passwd> "mdsmysql"
Open Test1
Showln "Test1 - Server1"
Clear Test1
Repeat
Find Gt Test1 By Index.1
[ Found ] Begin
Showln Test1.Customer_Number " - " Test1.Name
Indicate Found True
End

Until [ Not Found ]
Open Test2
Showln
Showln "Test2 - Server2"
Clear Test2
Repeat
Find Gt Test2 By Index.1
[ Found ] Begin
Showln Test2.Customer_Number " - " Test2.Name
Indicate Found True
End

Until [ Not Found ]
Showln
Showln "ok ..."
Inkey Pageend

 

Data Security with Flex2SQL and BTR2SQL Connectivity Products

Data Security with Flex2SQL and BTR2SQL Connectivity Products

The most common reason for Enterprises looking to migrate from legacy Btrieve or DataFlex databases is the urgent need to address security and...

Read More
Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...

Read More
Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases

COBOL applications are the foundation of numerous essential business functions, especially within the banking, insurance, and government sectors....

Read More