Recent

Author Topic: Why can't I change hte SQLConnetor to point to another database  (Read 244 times)

WimVan

  • Jr. Member
  • **
  • Posts: 70
Why can't I change hte SQLConnetor to point to another database
« on: December 20, 2018, 10:28:00 pm »
I want using an application to access several databases.  Why can't I do that ?

I use win10, Lazarus 1.8.4
TSQLconnector, dataabse Mysql 5.7 and have the correct libmysql.Dll

Here is the code
Code: Pascal  [Select]
  1.   MasterQuery.Close;
  2.   MasterQuery.Close;
  3.   MasterSQLTransaction.Active := False;
  4.   DBConnection.Connected      := False;
  5.   DBConnection.close(true);
  6.   DBConnection.DatabaseName   := 'pmoisr';
  7.   DBConnection.HostName       := 'Localhost';
  8.   DBConnection.UserName       := 'root';
  9.   DBConnection.Connected      := True;
  10.   DBConnection.Open;
  11.   MasterSQLTransaction.Active := True;
  12.   MasterQuery.Active          := True;
  13.  

There is no compile or build-error
Application pops up and closed directly.

What's wrong ?