Create Database with Zeos V7
Posted: 17.04.2012, 16:18
Hello,
For creating a new database and tabes with Zeos V6.6.6, I have set in
TZConnection.Database := '';
And then use the command "CREATE DATABASE" in a TZQuery.
But it does not work with Zeos V7, it will/must have a Database.
The Workaround:
For MySQL: TZConnection.Database := 'information_schema';
For PostgreSQL: TZConnection.Database := 'postgres';
SQLite is no problem, the DLL make self always a new Database.
Regards, Markus.
PS: Now, I use the ZeosV7 SVN1159 from here:
https://zeoslib.svn.sourceforge.net/svn ... gonhugeist
For creating a new database and tabes with Zeos V6.6.6, I have set in
TZConnection.Database := '';
And then use the command "CREATE DATABASE" in a TZQuery.
But it does not work with Zeos V7, it will/must have a Database.
The Workaround:
For MySQL: TZConnection.Database := 'information_schema';
For PostgreSQL: TZConnection.Database := 'postgres';
SQLite is no problem, the DLL make self always a new Database.
Regards, Markus.
PS: Now, I use the ZeosV7 SVN1159 from here:
https://zeoslib.svn.sourceforge.net/svn ... gonhugeist