Subject | Creating Database on the Fly Part Deux |
---|---|
Author | Paul Schmidt |
Post date | 2001-07-19T16:04:30Z |
Hello List:
Finally got this to work, and BTW it should be:
CREATE DATABASE 'servername:/path/file.gdb' USER 'username' PASSWORD
'password';
However I now have a problem, I need to create it using SQL DIALECT
1, and that presents a problem, how do I tell it to use dialect 1?
Sending the "SET SQL DIALECT 1' command in the script, doesn't pass
this on to the server.
The reason for this is I am using Firebird, and the client has to use
IB 5.6, and I don't want to have to create seperate versions of the
SQL.
Paul
Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com
Finally got this to work, and BTW it should be:
CREATE DATABASE 'servername:/path/file.gdb' USER 'username' PASSWORD
'password';
However I now have a problem, I need to create it using SQL DIALECT
1, and that presents a problem, how do I tell it to use dialect 1?
Sending the "SET SQL DIALECT 1' command in the script, doesn't pass
this on to the server.
The reason for this is I am using Firebird, and the client has to use
IB 5.6, and I don't want to have to create seperate versions of the
SQL.
Paul
Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com