using two databases in one application

jkuiper · Post by **jkuiper** » Mon 18 May 2009 12:03

We want to expand our application with CRM. But these module must be separated from the original application and gets it's own CRM database. But the core application can put some records into the CRM database, depending when it exists.
Do I need two connections in Delphi on connection two databases?

Dimon · Post by **Dimon** » Wed 20 May 2009 08:37

In order to connect simultaneously to two MySQL databases you should use two TMyConnection components.

jkuiper · Post by **jkuiper** » Mon 25 May 2009 08:10

oke, thanks.

eduardosic · Post by **eduardosic** » Wed 27 May 2009 01:10

jkuiper wrote:oke, thanks.

using 1 TMyConnection you can access two or more database..

try this..

Select
Field1, Field2
From
DatabaseName.Table1,
DatabaseName2.Table2

jkuiper · Post by **jkuiper** » Thu 28 May 2009 09:35

Yes, I know. I just made an example with one connection and two databases.
The most imported thing is how the privileges are set.