firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde E. <ct...@gm...>]

1) The filename was zzFirebirdTest.fdb.  The end result is
ZZFIREBIRDTEST.FDB.

Here is solution converting the UPPERCASE back to the original:

    string stPATHFILENAME = stPathFilename.ToUpper();
    System.IO.File.Move(@stPATHFILENAME, @stPathFilename);

On Sun, Mar 19, 2017 at 6:07 AM, Mark Rotteveel <ma...@la...> wrote:
> On 19-3-2017 11:56, Jiří Činčura wrote:
>>> Firebird Embedded on windows does not check for username and password,
>>> so you can leave them out. For a normal Firebird server, username is
>>> case insensitive, but password - of course - is case sensitive.
>>
>> But the grants are still followed. So username/role is important,
>> password not much.
>>
>
> You are right, forgot about that :)
>
> --
> Mark Rotteveel
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Create Database Tables

[Clyde E. <ct...@gm...>]

1) I think it would be

    string stOpenConn = new FbConnectionStringBuilder {
        Database = stPathFilename,
        UserID = stUserID,
        Password = stPassword,
        ServerType = FbServerType.Embedded,
        ClientLibrary = stCLIENT_LIBRARY
    }.ToString();
    using (FbConnection fbConn = new FbConnection(stOpenConn)) {
        try {
            fbConn.Open();

On Thu, Mar 23, 2017 at 8:30 AM, Clyde Eisenbeis <ct...@gm...> wrote:
> 1) It's not obvious to me where to put the 'using' with 'try'.  Could
> you provide an example using the code in my first email?
>
> 2) Is this what you recommend?
>
> where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
> fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
> KEY )".
>
> What do I use for 'x'?  This should be variable.
>
> 3)  BLOB SUB_TYPE TEXT is non-Unicode.  The field 'fstInfo' needs to
> handle German.
>
> On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <ji...@ci...> wrote:
>>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>>> followed by one fbTransaction.Commit()?
>>
>> Yes. Also use `using` block for disposable resource.
>>
>>> 2) I want to be able to handle German vowels, such as umlauts, for
>>> fstInfo.  I don't think VARCHAR is the correct choice as it is
>>> non-unicode.
>>
>> You can use CHARACTER SET clause. Best is probably to use UTF8.
>>
>>> 3) I also want variable lengths, without a max, for fstInfo.  What do
>>> I use in place of the "100"?
>>
>> Then you have to use BLOB SUB_TYPE TEXT.
>>
>> --
>> Mgr. Jiří Činčura
>> https://www.tabsoverspaces.com/
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Create Database Tables

[Clyde E. <ct...@gm...>]

1) It's not obvious to me where to put the 'using' with 'try'.  Could
you provide an example using the code in my first email?

2) Is this what you recommend?

where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY
KEY )".

What do I use for 'x'?  This should be variable.

3)  BLOB SUB_TYPE TEXT is non-Unicode.  The field 'fstInfo' needs to
handle German.

On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <ji...@ci...> wrote:
>> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
>> followed by one fbTransaction.Commit()?
>
> Yes. Also use `using` block for disposable resource.
>
>> 2) I want to be able to handle German vowels, such as umlauts, for
>> fstInfo.  I don't think VARCHAR is the correct choice as it is
>> non-unicode.
>
> You can use CHARACTER SET clause. Best is probably to use UTF8.
>
>> 3) I also want variable lengths, without a max, for fstInfo.  What do
>> I use in place of the "100"?
>
> Then you have to use BLOB SUB_TYPE TEXT.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-744) Unable to connect bundled embedded database on macOS

[Daniel M. (JIRA) <tr...@fi...>]

Unable to connect bundled embedded database on macOS
----------------------------------------------------

                 Key: DNET-744
                 URL: http://tracker.firebirdsql.org/browse/DNET-744
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.8.1.0
         Environment: macOS Sierra, Firebird 2.5.6 embedded, Mono 4.8
            Reporter: Daniel Martin
            Assignee: Jiri Cincura


When bundling the Firebird database with a mono application, one must not provide a user and a password in the connection string as otherwise the libfbembed.dylib (Firebird binary) attempts to attach to the systems security2.fdb.
The FbConnectionString class forces the client to provide a user and password if LINUX is defined, as trusted auth does no exist on non-windows platforms.

This was locally fixed by checking the FbConnectionString.ServerType property in FbConnectionString.Validate and FbConnectionString.FallIntoTrustedAuth.
See the provided methods below for details.

I'm not sure whether this is the correct solution or if it creates any side effects.

----
internal bool FallIntoTrustedAuth
		{
			// on non-Win the UserID/Password is checked in Validate method
			get { return ServerType != FbServerType.Embedded && string.IsNullOrEmpty(UserID) && string.IsNullOrEmpty(Password); } // Embedded does not require a password
		}
---
		public void Validate()
		{
			if (!ContextConnection)
			{
				if (
#if (LINUX)  // on Linux Trusted Auth isn't available
					(ServerType != FbServerType.Embedded && (string.IsNullOrEmpty(this.UserID) || // Embedded does not require a password
					string.IsNullOrEmpty(this.Password))) ||
#endif
(string.IsNullOrEmpty(Database) && !_isServiceConnectionString) ||
					(string.IsNullOrEmpty(DataSource) && ServerType != FbServerType.Embedded) ||
					(string.IsNullOrEmpty(Charset)) ||
					(Port == 0) ||
					(!Enum.IsDefined(typeof(FbServerType), ServerType)) ||
					(MinPoolSize > MaxPoolSize)
				   )
				{
					throw new ArgumentException("An invalid connection string argument has been supplied or a required connection string argument has not been supplied.");
				}
				if (Dialect < 1 || Dialect > 3)
				{
					throw new ArgumentException("Incorrect database dialect it should be 1, 2, or 3.");
				}
				if (PacketSize < 512 || PacketSize > 32767)
				{
					throw new ArgumentException(string.Format(CultureInfo.CurrentCulture, "'Packet Size' value of {0} is not valid.{1}The value should be an integer >= 512 and <= 32767.", PacketSize, Environment.NewLine));
				}
				if (DbCachePages < 0)
				{
					throw new ArgumentException(string.Format(CultureInfo.CurrentCulture, "'Db Cache Pages' value of {0} is not valid.{1}The value should be an integer >= 0.", DbCachePages, Environment.NewLine));
				}
				if (Pooling && NoDatabaseTriggers)
				{
					throw new ArgumentException("Cannot use Pooling and NoDBTriggers together.");
				}

				CheckIsolationLevel();
			}
		}
---

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Create Database Tables

[Jiří Č. <ji...@ci...>]

> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
> followed by one fbTransaction.Commit()?

Yes. Also use `using` block for disposable resource.

> 2) I want to be able to handle German vowels, such as umlauts, for
> fstInfo.  I don't think VARCHAR is the correct choice as it is
> non-unicode.

You can use CHARACTER SET clause. Best is probably to use UTF8.
 
> 3) I also want variable lengths, without a max, for fstInfo.  What do
> I use in place of the "100"?

Then you have to use BLOB SUB_TYPE TEXT.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[Firebird-net-provider] Create Database Tables

[Clyde E. <ct...@gm...>]

To create a table:
-----------------------------
    int iTablesCount = liststTableNames.Count();
    try {
        string stOpenConn = new FbConnectionStringBuilder {
            Database = stPathFilename,
            UserID = stUserID,
            Password = stPassword,
            ServerType = FbServerType.Embedded,
            ClientLibrary = stCLIENT_LIBRARY
        }.ToString();
        FbConnection fbConn = new FbConnection(stOpenConn);
        fbConn.Open();

        FbTransaction fbTransaction = fbConn.BeginTransaction();
        for (int ii = 0; ii < iTablesCount; ii++) {
            string stSql = "CREATE TABLE " + liststTableNames[ii] + "(
" + liststFieldDefinitions[ii] + ")";
            FbCommand fbCmd = new FbCommand(stSql, fbConn, fbTransaction);
            fbCmd.ExecuteNonQuery();
        }
        fbTransaction.Commit();
-----------------------------
where stSql = "CREATE TABLE  TableOrg (  fstPriority VARCHAR(10),
fstInfo VARCHAR(100), fiKeyID INTEGER PRIMARY KEY )".

1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
followed by one fbTransaction.Commit()?

2) I want to be able to handle German vowels, such as umlauts, for
fstInfo.  I don't think VARCHAR is the correct choice as it is
non-unicode.

3) I also want variable lengths, without a max, for fstInfo.  What do
I use in place of the "100"?

[Firebird-net-provider] [FB-Tracker] Created: (DNET-743) Memory leak in Firebird 3 on implicit transaction

[Alexander L. (JIRA) <tr...@fi...>]

Memory leak in Firebird 3 on implicit transaction 
--------------------------------------------------

                 Key: DNET-743
                 URL: http://tracker.firebirdsql.org/browse/DNET-743
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: Firebird: 3.0.1.32609, .NET Provider: 5.8, .NET 4.6, Win 10 x64
            Reporter: Alexander Lipatov
            Assignee: Jiri Cincura


Implicit transactions in Firebird 3 cause a massive memory leak on the server part. 
It is detected only on Firebird 3. 
If transaction is performed manually the memory leak is not happened.

Example:
var connection = new FbConnection(connectionString);
connection.Open();
while (true)
{
    using (var cmd = connection.CreateCommand())
    {
        cmd.CommandText = "SELECT * FROM TABLE_NAME";
        cmd.ExecuteNonQuery();
    }
}

I fixed this issue as follows:
The calls isc_commit_transaction and isc_dsql_free_statement was swapped.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-742) GdsConnection.Connect() should not always call TryEnableLoopbackFastPath

[Tudor C. (JIRA) <tr...@fi...>]

GdsConnection.Connect() should not always call TryEnableLoopbackFastPath
------------------------------------------------------------------------

                 Key: DNET-742
                 URL: http://tracker.firebirdsql.org/browse/DNET-742
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: WIndows 7, .Net 4.5
            Reporter: Tudor Costin
            Assignee: Jiri Cincura
            Priority: Minor


Loopback fast path only works when connecting to the same computer. This is rarely going to be the case. It also never works on Windows 7 or below. Not only is it a waste of time to try, but the resulting SocketException will trigger a break into the debugger if it is set to always break on these types of exceptions. This is very annoying for developers using the ADO provider.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark R. <ma...@la...>]

On 19-3-2017 11:56, Jiří Činčura wrote:
>> Firebird Embedded on windows does not check for username and password,
>> so you can leave them out. For a normal Firebird server, username is
>> case insensitive, but password - of course - is case sensitive.
>
> But the grants are still followed. So username/role is important,
> password not much.
>

You are right, forgot about that :)

-- 
Mark Rotteveel

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Jiří Č. <ji...@ci...>]

> Firebird Embedded on windows does not check for username and password, 
> so you can leave them out. For a normal Firebird server, username is 
> case insensitive, but password - of course - is case sensitive.

But the grants are still followed. So username/role is important,
password not much.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark R. <ma...@la...>]

On 18-3-2017 16:21, Clyde Eisenbeis wrote:
> Mark,
>
> I'm not sure how to reply via StackOverflow, so I'll email.

Here is fine.

> Thanks!  Your description creates an .fdb file. (I think .fdb is the
> correct format acronym).

You can choose whatever you want for the file extension, but fdb is 
indeed to common choice.

> 1) The filename was zzFirebirdTest.fdb.  The end result is
> ZZFIREBIRDTEST.FDB.  How do I keep TitleCase for the name?

Unfortunately there is no way, Firebird internally uppercases the 
filename on Windows. If you really want to preserve case, you would 
first need to create the database and then rename it.

> 2) UserID = "SYSDBA", Password = "masterkey".  I presume there is no
> risk in using anything I want.  Are they case sensitive?

Firebird Embedded on windows does not check for username and password, 
so you can leave them out. For a normal Firebird server, username is 
case insensitive, but password - of course - is case sensitive.

> 3) Is the pageSize = 4096, a good common practice?

It depends, 4kb is common, but the max is 16kb for current Firebird 
versions. A larger page size allows for larger index keys, other than 
that it depends: large pages means more records fit on a single page, 
and as buffers/caches are defined in pages, you'll have more data in 
cache, on the other hand storing blobs can have more space overhead: 
you'll need less pages per blob, but say you store blob is around 16KB, 
then you need 5 pages of 4KB and you will waste +/- 3500 - 400 bytes 
because it only needs a few bytes (+ bytes for the page header) of the 
last page, while with a 16KB, you'll need 2 pages of 16KB and waste 
about 16000 bytes.

> 4) I'm struggling to find details about FbConnection.CreateDatabase on
> the Firebird Document site.

You'd need to ask Jiri who maintains the project. The documentation on 
the Firebird ADO.net provider is rather sparse in my opinion, but you 
can always check the source: 
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient

> Apparently the order is ... connection details (string), page size
> (int), force writes (bool), overwrite (bool).

public static void CreateDatabase(string connectionString, int pageSize 
= 4096, bool forcedWrites = true, bool overwrite = false)

> The connection string has reserved words, Database, ServerType, etc.
>
> Is there a site that clarifies all of the reserved words / options /
> defaults?  I'd like to document this info while it is still fresh in
> my mind ... for future projects.

See the Description annotations on FbConnectionStringBuilder

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionStringBuilder.cs

Mark
-- 
Mark Rotteveel

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Jiří Č. <ji...@ci...>]

> 4) I'm struggling to find details about FbConnection.CreateDatabase on
> the Firebird Document site.
> 
> Apparently the order is ... connection details (string), page size
> (int), force writes (bool), overwrite (bool).

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs#L64
 
> The connection string has reserved words, Database, ServerType, etc.
> 
> Is there a site that clarifies all of the reserved words / options /
> defaults?  I'd like to document this info while it is still fresh in
> my mind ... for future projects.

https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionString.cs#L88

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde E. <ct...@gm...>]

Mark,

I'm not sure how to reply via StackOverflow, so I'll email.

Thanks!  Your description creates an .fdb file. (I think .fdb is the
correct format acronym).

1) The filename was zzFirebirdTest.fdb.  The end result is
ZZFIREBIRDTEST.FDB.  How do I keep TitleCase for the name?

2) UserID = "SYSDBA", Password = "masterkey".  I presume there is no
risk in using anything I want.  Are they case sensitive?

3) Is the pageSize = 4096, a good common practice?

4) I'm struggling to find details about FbConnection.CreateDatabase on
the Firebird Document site.

Apparently the order is ... connection details (string), page size
(int), force writes (bool), overwrite (bool).

The connection string has reserved words, Database, ServerType, etc.

Is there a site that clarifies all of the reserved words / options /
defaults?  I'd like to document this info while it is still fresh in
my mind ... for future projects.


On Sat, Mar 18, 2017 at 4:07 AM, Mark Rotteveel <ma...@la...> wrote:
> On 17-3-2017 20:38, Mark Rotteveel wrote:
>> As I said on stack overflow, I'll try to post a more complete answer
>> later this weekend. Also check the other answer posted recently, the
>> links in that mail handle some older versions, but should still apply in
>> general.
>
> I have posted on answer on Stack Overflow:
> http://stackoverflow.com/a/42872385/466862
>
> I hope it helps.
>
> Mark
> --
> Mark Rotteveel
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark R. <ma...@la...>]

On 17-3-2017 20:38, Mark Rotteveel wrote:
> As I said on stack overflow, I'll try to post a more complete answer
> later this weekend. Also check the other answer posted recently, the
> links in that mail handle some older versions, but should still apply in
> general.

I have posted on answer on Stack Overflow: 
http://stackoverflow.com/a/42872385/466862

I hope it helps.

Mark
-- 
Mark Rotteveel

[Firebird-net-provider] [FB-Tracker] Created: (DNET-741) WIN1251 support in Firebird .net provider 5.8.0.0

[Eugene L. (JIRA) <tr...@fi...>]

WIN1251 support in Firebird .net provider 5.8.0.0
-------------------------------------------------

                 Key: DNET-741
                 URL: http://tracker.firebirdsql.org/browse/DNET-741
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
            Reporter: Eugene Leontev
            Assignee: Jiri Cincura


I got this exception after update firebird .net provider from 5.1.0.0 to 5.8.0.0

"I/O error during \"CreateFile (open)\" operation for file \"F:\\Рабочая\\Р'Р"\\March 2016\\POSTSERV.IB\"\r\nError while trying to open file"

Where connection string is :

server type=Default;
data source=localhost;
port number=3050;
initial catalog=\"F:\\Рабочая\\БД\\March 2016\\POSTSERV.IB\";
user id=SYSDBA;
password=masterkey;
dialect=3;character 
set=WIN1251;
client library=;
connection lifetime=0;
pooling=True;
min pool size=0;
max pool size=50"

With 5.1.0.0 it works fine.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark R. <ma...@la...>]

On 2017-03-17 20:16, Clyde Eisenbeis wrote:
> I clearly misunderstood.
> 
> To be certain I understand the terminology, an embedded server is one
> that is accessible via the Internet?

No, Firebird Embedded is a (native) client API that directly accesses a 
Firebird database engine in the same process, it does not open ports 
that make the database server externally accessible.

As a simplification, a normal Firebird server is a component that 
listens on the network (eg through TCP/IP) and accesses the database 
engine. When an application access this server through the native client 
API, this API translates the calls to the (TCP/IP) wire protocol, and 
the server-side translates this back to native calls that go to the 
database engine.

On the other hand in Firebird embedded, the network part is skipped, so 
the native client access goes directly to the database engine.

> I do want this database to eventually be accessible via the Internet.

A Firebird Embedded is not network accessible.

> I know which tables I want ... and which fields I want in each table.
> 
> By dependencies, does that mean table names, field names, passwords, 
> sizes?

No, by dependencies I mean other files (dlls) that are necessary for the 
Firebird database engine to run inside your C# process.

> How do I create, or download, the Firebird embedded server?
> 
> How do I create this database?

As I said on stack overflow, I'll try to post a more complete answer 
later this weekend. Also check the other answer posted recently, the 
links in that mail handle some older versions, but should still apply in 
general.

Mark

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde E. <ct...@gm...>]

I clearly misunderstood.

To be certain I understand the terminology, an embedded server is one
that is accessible via the Internet?

I do want this database to eventually be accessible via the Internet.

I know which tables I want ... and which fields I want in each table.

By dependencies, does that mean table names, field names, passwords, sizes?

How do I create, or download, the Firebird embedded server?

How do I create this database?

On Fri, Mar 17, 2017 at 1:51 PM, Mark Rotteveel <ma...@la...> wrote:
> On 2017-03-17 17:26, Clyde Eisenbeis wrote:
>> I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in
>> my Debug subdir.
>>
>> The exception is "Unable to find an entry point named
>> 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".
>
> You are missing a crucial point, the Firebird ADO.net provider is not
> like Sqlite, it is **not** a Firebird server, it is only a client to
> connect to a Firebird server, by default through a pure C#
> implementation, alternatively using the native client or to an embedded
> server.
>
> The first option has no dependencies, but the second and third option
> have native dependencies that you need to provide yourself (it is not
> part of the FirebirdSql.Data.FirebirdClient).

> For native you need
> fbclient.dll, for Firebird embedded you need Firebird embedded: for
> Firebird 2.5 and earlier: fbembed.dll and dependencies, for Firebird 3
> fbclient.dll + engine12.dll and dependencies.
>
> If you want to use Firebird embedded, you need to put it in the same
> folder as your application (or at least on the search path).
>
>> On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura <ji...@ci...> wrote:
>>> If you are not using the server, then location of your embedded
>>> Firebird
>>> library.
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Mark R. <ma...@la...>]

On 2017-03-17 17:26, Clyde Eisenbeis wrote:
> I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in
> my Debug subdir.
> 
> The exception is "Unable to find an entry point named
> 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".

You are missing a crucial point, the Firebird ADO.net provider is not 
like Sqlite, it is **not** a Firebird server, it is only a client to 
connect to a Firebird server, by default through a pure C# 
implementation, alternatively using the native client or to an embedded 
server.

The first option has no dependencies, but the second and third option 
have native dependencies that you need to provide yourself (it is not 
part of the FirebirdSql.Data.FirebirdClient). For native you need 
fbclient.dll, for Firebird embedded you need Firebird embedded: for 
Firebird 2.5 and earlier: fbembed.dll and dependencies, for Firebird 3 
fbclient.dll + engine12.dll and dependencies.

If you want to use Firebird embedded, you need to put it in the same 
folder as your application (or at least on the search path).

> On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura <ji...@ci...> wrote:
>> If you are not using the server, then location of your embedded 
>> Firebird
>> library.

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Wolfgang R. <Wol...@ri...>]

Hi,

these helped me:

https://blog.cincura.net/224165-firebird-embedded-and-net/
http://stackoverflow.com/questions/8725546/how-to-create-an-embedded-database-using-firebird-in-c-sharp
http://stackoverflow.com/questions/16354712/how-to-programmatically-create-firebird-database

I have this working, but my language (X#) would not help you too much:

	FBConnection.CreateDatabase( cConnString, false )

Where FBConnection is 

public sealed class FirebirdSql.Data.FirebirdClient.FbConnection inherit DbConnection implements Icloneable

Wolfgang
	
--
-- Wolfgang Riedmann 
-- Riedmann GmbH - srl.
-- Individuelle EDV-Lösungen - Soluzioni informatiche personalizzate
-- I-39012 Meran, Postgranz 16b
-- Telefon +39 0473 201 239
-- http://www.riedmann.it - wol...@ri...

-----Ursprüngliche Nachricht-----
Von: Clyde Eisenbeis [mailto:ct...@gm...] 
Gesendet: Freitag, 17. März 2017 17:26
An: For users and developers of the Firebird .NET providers
Betreff: Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in my Debug subdir.

The exception is "Unable to find an entry point named 'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".

On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura <ji...@ci...> wrote:
> If you are not using the server, then location of your embedded 
> Firebird library.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> On Thu, Mar 16, 2017, at 16:04, Clyde Eisenbeis wrote:
>> t) I've tried FbConnection.CreateDatabase ... using info from
>> StackOverflow:
>>
>>     int pageSize = 4096;
>>     bool forcedWrites = true;
>>     bool overwrite = false;
>>     var connectionString = new FbConnectionStringBuilder
>>     {
>>         Database = stPathFilename,
>>         ServerType = FbServerType.Embedded,
>>         UserID = "SYSDBA",
>>         Password = "masterkey",
>>         ClientLibrary = "fbclient.dll"
>>     }.ToString();
>>     FbConnection.CreateDatabase(connectionString, pageSize, 
>> forcedWrites, overwrite);
>>
>> I had presumed this is standard, except for the stPathFilename.
>>
>> However, this code throughs an exception ... complains about 
>> fbclient.dll.  I'm not sure what to use for Client Library.
>>
>> On Wed, Mar 15, 2017 at 1:54 PM, Jiří Činčura <ji...@ci...> wrote:
>> >> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>> >
>> > To be precise, it's provider, not Firebird.
>> >
>> >> 1) Was the the correct procedure?
>> >
>> > Yes.
>> >
>> >> 2) How do I create a Firebird database file? ... as I did with 
>> >> SQLite ... 
>> >> System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
>> >> where the filename ends with .sqlite.
>> >
>> > FbConnection.CreateDatabase.
>> >
>> > --
>> > Mgr. Jiří Činčura
>> > https://www.tabsoverspaces.com/
>> >
>> >
>> > -------------------------------------------------------------------
>> > ----------- Check out the vibrant tech community on one of the 
>> > world's most engaging tech sites, Slashdot.org! 
>> > http://sdm.link/slashdot 
>> > _______________________________________________
>> > Firebird-net-provider mailing list
>> > Fir...@li...
>> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>> ---------------------------------------------------------------------
>> --------- Check out the vibrant tech community on one of the world's 
>> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot 
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ----------------------------------------------------------------------
> -------- Check out the vibrant tech community on one of the world's 
> most engaging tech sites, Slashdot.org! http://sdm.link/slashdot 
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde E. <ct...@gm...>]

I used "FirebirdSql.Data.FirebirdClient.dll" ... which is located in
my Debug subdir.

The exception is "Unable to find an entry point named
'isc_create_database' in DLL 'FirebirdSql.Data.FirebirdClient.dll".

On Thu, Mar 16, 2017 at 2:07 PM, Jiří Činčura <ji...@ci...> wrote:
> If you are not using the server, then location of your embedded Firebird
> library.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> On Thu, Mar 16, 2017, at 16:04, Clyde Eisenbeis wrote:
>> t) I've tried FbConnection.CreateDatabase ... using info from
>> StackOverflow:
>>
>>     int pageSize = 4096;
>>     bool forcedWrites = true;
>>     bool overwrite = false;
>>     var connectionString = new FbConnectionStringBuilder
>>     {
>>         Database = stPathFilename,
>>         ServerType = FbServerType.Embedded,
>>         UserID = "SYSDBA",
>>         Password = "masterkey",
>>         ClientLibrary = "fbclient.dll"
>>     }.ToString();
>>     FbConnection.CreateDatabase(connectionString, pageSize,
>> forcedWrites, overwrite);
>>
>> I had presumed this is standard, except for the stPathFilename.
>>
>> However, this code throughs an exception ... complains about
>> fbclient.dll.  I'm not sure what to use for Client Library.
>>
>> On Wed, Mar 15, 2017 at 1:54 PM, Jiří Činčura <ji...@ci...> wrote:
>> >> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>> >
>> > To be precise, it's provider, not Firebird.
>> >
>> >> 1) Was the the correct procedure?
>> >
>> > Yes.
>> >
>> >> 2) How do I create a Firebird database file? ... as I did with SQLite
>> >> ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
>> >> where the filename ends with .sqlite.
>> >
>> > FbConnection.CreateDatabase.
>> >
>> > --
>> > Mgr. Jiří Činčura
>> > https://www.tabsoverspaces.com/
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > Check out the vibrant tech community on one of the world's most
>> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> > _______________________________________________
>> > Firebird-net-provider mailing list
>> > Fir...@li...
>> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Jiří Č. <ji...@ci...>]

If you are not using the server, then location of your embedded
Firebird library.


--

Mgr. Jiří Činčura

https://www.tabsoverspaces.com/





On Thu, Mar 16, 2017, at 16:04, Clyde Eisenbeis wrote:

> t) I've tried FbConnection.CreateDatabase ... using info from

> StackOverflow:

>

>     int pageSize = 4096;

>     bool forcedWrites = true;

>     bool overwrite = false;

>     var connectionString = new FbConnectionStringBuilder

>     {

>         Database = stPathFilename,

>         ServerType = FbServerType.Embedded,

>         UserID = "SYSDBA",

>         Password = "masterkey",

>         ClientLibrary = "fbclient.dll"

>     }.ToString();

>     FbConnection.CreateDatabase(connectionString, pageSize,

> forcedWrites, overwrite);

>

> I had presumed this is standard, except for the stPathFilename.

>

> However, this code throughs an exception ... complains about

> fbclient.dll.  I'm not sure what to use for Client Library.

>

> On Wed, Mar 15, 2017 at 1:54 PM, Jiří Činčura
> <ji...@ci...> wrote:
> >> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird
> >> .dll's.
> >

> > To be precise, it's provider, not Firebird.

> >

> >> 1) Was the the correct procedure?

> >

> > Yes.

> >

> >> 2) How do I create a Firebird database file? ... as I did with
> >>    SQLite
> >> ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
> >> where the filename ends with .sqlite.

> >

> > FbConnection.CreateDatabase.

> >

> > --

> > Mgr. Jiří Činčura

> > https://www.tabsoverspaces.com/

> >

> > --------------------------------------------------------------------
> > ----------
> > Check out the vibrant tech community on one of the world's most

> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot

> > _______________________________________________

> > Firebird-net-provider mailing list

> > Fir...@li...

> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

>

> ----------------------------------------------------------------------
> --------
> Check out the vibrant tech community on one of the world's most

> engaging tech sites, Slashdot.org! http://sdm.link/slashdot

> _______________________________________________

> Firebird-net-provider mailing list

> Fir...@li...

> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde E. <ct...@gm...>]

t) I've tried FbConnection.CreateDatabase ... using info from StackOverflow:

    int pageSize = 4096;
    bool forcedWrites = true;
    bool overwrite = false;
    var connectionString = new FbConnectionStringBuilder
    {
        Database = stPathFilename,
        ServerType = FbServerType.Embedded,
        UserID = "SYSDBA",
        Password = "masterkey",
        ClientLibrary = "fbclient.dll"
    }.ToString();
    FbConnection.CreateDatabase(connectionString, pageSize,
forcedWrites, overwrite);

I had presumed this is standard, except for the stPathFilename.

However, this code throughs an exception ... complains about
fbclient.dll.  I'm not sure what to use for Client Library.

On Wed, Mar 15, 2017 at 1:54 PM, Jiří Činčura <ji...@ci...> wrote:
>> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>
> To be precise, it's provider, not Firebird.
>
>> 1) Was the the correct procedure?
>
> Yes.
>
>> 2) How do I create a Firebird database file? ... as I did with SQLite
>> ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
>> where the filename ends with .sqlite.
>
> FbConnection.CreateDatabase.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Jiří Č. <ji...@ci...>]

> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.

To be precise, it's provider, not Firebird.
 
> 1) Was the the correct procedure?

Yes.

> 2) How do I create a Firebird database file? ... as I did with SQLite
> ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
> where the filename ends with .sqlite.

FbConnection.CreateDatabase.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[Firebird-net-provider] [firebird net] Install Firebird / Create Database File

[Clyde E. <ct...@gm...>]

I've recently written code using SQLite (C# .NET, System.Data.SQLite)
... decided to try Firebird.

To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. ---------- then Tools -> Library Package Manager -> Manage NuGet
Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).

Resulted in a) References -> FirebirdSql.Data.FirebirdClient, and b)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.

1) Was the the correct procedure?

2) How do I create a Firebird database file? ... as I did with SQLite
... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename)
where the filename ends with .sqlite.

[Firebird-net-provider] [FB-Tracker] Created: (DNET-740) Thread safe broken while fetching rows

[Toni M. (JIRA) <tr...@fi...>]

Thread safe broken while fetching rows
--------------------------------------

                 Key: DNET-740
                 URL: http://tracker.firebirdsql.org/browse/DNET-740
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.0.0
         Environment: Microsoft Windows .Net application
            Reporter: Toni Martir
            Assignee: Jiri Cincura
            Priority: Minor


Also, in single thread there is a big performance issue in latest verion.
Steps to reproduce.

- Fetch rows using different FbCommands, same connection and transaction in diferent threads, 5.1 working, 5.8 broken
- Fetch rows from any big table, by using FbCommand.ExecuteReader and  FbDataReader.Read, compare times 5.1 and 5.8

A simple windows forms is provided that attach to employee database, dropbox link: https://dl.dropboxusercontent.com/u/54600297/WindowsFormsApplication1.zip
You can switch nuget package version to test the working version.
Tested on Firebird 2.5 and Firebird 3.0.1

Timed results on Debug and Release

Version		 1 thread	        4 threads

5.1       	         3 seconds 	        9 seconds

5.8   		10 seconds 	        random exception



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira