DOTNET connection FB Embedded Server version
Firebird is divided into two versions. One is an embedded version for the installation version. In order to deploy the program, you can choose an embedded version. To use embedded versions to need "fbembed.dll" and "fbintl.dll" two DLL setup support. These two files must be copied from the Embedded Server version, and the files in the installation version cannot be used.
The specific path stored in two files:
App_folder / fbembed.dll
(
1.5.2
The version of the file is 1489KB)
App_folder / INTL / FBINTL.DLL
(
1.5.2
The version of the file is 640KB)
Instructions:
According to the top of the directory structure, the copy file to the corresponding directory. Then use the FB.NET Provider (1.6 or more version), Embedded finally sets the ServerType property to "1" in the connection string. Other unchanged.
The local version of FB can be used in the application through the above settings.
Post connection string code (for reference only)
FBConnectionstringBuilder CS = New fbconnectionstringbuilder ();
cs.datasource = "localconnect";
CS.DATABASE = @ "f: / project files / testfiles / firebird / firebirddemo / bin / debug / tasks.gdb";
Cs.Servertype = 1; // The key is here, it must be set to 1 to 1 to connect the embedded version.
CS.Userid = "sysdba";
cs.password = "masterkey";
cs.dialev = 3;
Some websites about FB
http://firebird.sourceforge.net
http://www.firebirdsql.org
http://www.ibphoenix.com/
http://wiki.sunyear.com.tw/index.php?title=firebirdsql (a traditional Chinese website, not bad)
http://www.dotNetfirebird.org/
Solve the problem of Chinese as garbled in C #
When connecting the FB database, it is found that all Chinese characters are displayed as garbled. This is a character code is not compained. It is easy to solve this problem.
a. Setting the database's Charset to GB_2312 to solve the problem of garbled code when the new database is set to GB_2312.
