메뉴 건너뛰기

검색창 닫기

XEDITION

C#

How to programmatically create firebird database?

proin 2020.03.30 03:00 조회 수 : 1

https://stackoverflow.com/questions/16354712/how-to-programmatically-create-firebird-database

I have COMPUTER_WITH_DATABASE where is superserver firebird (windows) installed. Now i need to make c# application which will connect to this COMPUTER_WITH_DATABASE and create file .fdb like for example database.fdb to be later able to connect from other computers using for example part of string like:

COMPUTER_WITH_DATABASE\c:\database.fdb

But how to do it using fb API in c#?

  •  
6

with this code you can create a database:

...
using FirebirdSql.Data.Firebird;
...

FbConnectionStringBuilder builder = new FbConnectionStringBuilder();
builder.DataSource = "COMPUTER_WITH_DATABASE";
builder.UserID = "SYSDBA";
builder.Password = "m*******y";
builder.Database = @"c:\database.fdb";
builder.ServerType = FbServerType.Default;

FbConnection.CreateDatabase(builder.ConnectionString);
  •  
    FbConnection.CreateDatabase wants string (basically), not a Hashtable, hence this code is not completely correct. – cincura.net Jul 3 '14 at 10:05
  •  
    Thank you, FbConnectionStringBuilder is best to use to create the connection string. – jadelgado Oct 29 '14 at 21:04
  •  
    What if the database already exists. Does 'Create Database' deletes the old one? – TomeeNS Dec 10 '15 at 2:09 
  •  
    you can just code >>>>>>>> string curFile = @"c:\database.fdb"; if (File.Exists(curFile) == true) { MessageBox.Show("Database is already existing!"); }<<<<<<<<<<< to detect if database is already available hope this help – Mandz Apr 24 '18 at 5:56 

 

 

 

이 게시물을
목록
쓰기 태그
위로