Page 1 of 1
using two databases in one application
Posted: Mon 18 May 2009 12:03
by jkuiper
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?
Posted: Wed 20 May 2009 08:37
by Dimon
In order to connect simultaneously to two MySQL databases you should use two TMyConnection components.
Posted: Mon 25 May 2009 08:10
by jkuiper
oke, thanks.
Posted: Wed 27 May 2009 01:10
by eduardosic
jkuiper wrote:oke, thanks.
using 1 TMyConnection you can access two or more database..
try this..
Select
Field1, Field2
From
DatabaseName.Table1,
DatabaseName2.Table2
Posted: Thu 28 May 2009 09:35
by jkuiper
Yes, I know. I just made an example with one connection and two databases.
The most imported thing is how the privileges are set.