troubleshooting Question

create a new database // ZEOS & MSSQL

Avatar of BdLm
BdLmFlag for Germany asked on
Delphi
5 Comments1 Solution2522 ViewsLast Modified:
found the so9lution below to create a Direbird database at run time, how look the solution for MSSQL ?  (ZEOS + MSSQL)
ZConnection1.Database := 'd:\db1.fdb';
   ZConnection1.Protocol := 'firebird-1.5';
   ZConnection1.Properties.Add ('CreateNewDatabase=CREATE DATABASE ' +
      QuotedStr ('d:\db1.fdb') + ' USER ' +
      QuotedStr ('sysdba') + ' PASSWORD ' + QuotedStr ('masterkey') +
      ' PAGE_SIZE 4096 DEFAULT CHARACTER SET ISO8859_1');
   ZConnection1.Connect;
   :
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros