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

Re: [Firebird-net-provider] Stored procedures etc. in .NET

[Rick R. <ric...@gm...>]

I'm using FB3 for a new commercial app now and I'm interested.  For me,
there are many occasions where I have had to write something in an SP that
would have been much easier in .NET simply because I use it every day and
SQL less often.
Keep us informed on the progress.

Regards,
Rick

On Mon, Jun 27, 2016 at 2:50 PM Alexander Muylaert-Gelein <
amu...@ho...> wrote:

> Hi Jiri
>
> There is interest on our behalf.  But we will only switch to FB 3... after
> release 2 or something like that.
> That doesn't mean we are not interested in kicking this into motion.
>
> Thanks
>
> Alexander
>
> > From: ji...@ci...
> > To: fir...@li...
> > Date: Mon, 27 Jun 2016 20:51:31 +0200
> > CC: fir...@li...
> > Subject: [Firebird-net-provider] Stored procedures etc. in .NET
>
> >
> > Hi *,
> >
> > there's something I've been working on for a few evenings and weekends.
> > As you might know, from Firebird 3 there's and interface to write a
> > plugin that allows to execute any code as stored procedure, function or
> > trigger.
> >
> > So why not to have these in .NET, right? I have a working plugin right
> > now. Currently only stored procedures are supported. No blobs at the
> > moment as well.
> >
> > You can check small example at the end of this email.
> >
> > Now the important part. Is there enough interest in this to keep working
> > it? The hardest part is mostly over. Now it's just adding support for
> > more objects and polishing it, hardening it and probably adding features
> > based on requests (like security).
> >
> > * SP:
> > recreate procedure demo (
> > in_int integer,
> > in_s varchar(20),
> > in_long bigint,
> > in_short smallint,
> > in_char char(20)
> > )
> > returns (
> > out_int integer,
> > out_s varchar(20),
> > out_long bigint,
> > out_short smallint,
> > out_char char(20)
> > )
> > external name 'Example!Example.Procedures.Demo'
> > engine dotnet;
> > * Code (not sure about the tuples yet):
> > public static IEnumerator<Tuple<int?, string, long?, short?, string>>
> > Demo(int? i, string s, long? @long, short? @short, string @char)
> > {
> > yield return Tuple.Create(i, s, @long, @short, @char);
> > yield return Tuple.Create(i + 1, s + nameof(Demo), @long + 1,
> > (short?)(@short + 1), @char);
> > }
> >
> > --
> > Mgr. Jiří Činčura
> > Independent IT Specialist
> >
> >
> ------------------------------------------------------------------------------
> > Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> > Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> > present their vision of the future. This family event has something for
> > everyone, including kids. Get more information and register today.
> > http://sdm.link/attshape
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape_______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Stored procedures etc. in .NET

[Alexander Muylaert-G. <amu...@ho...>]

Hi Jiri
There is interest on our behalf.  But we will only switch to FB 3... after release 2 or something like that.That doesn't mean we are not interested in kicking this into motion.

Thanks
Alexander

> From: ji...@ci...
> To: fir...@li...
> Date: Mon, 27 Jun 2016 20:51:31 +0200
> CC: fir...@li...
> Subject: [Firebird-net-provider] Stored procedures etc. in .NET
> 
> Hi *,
> 
> there's something I've been working on for a few evenings and weekends.
> As you might know, from Firebird 3 there's and interface to write a
> plugin that allows to execute any code as stored procedure, function or
> trigger.
> 
> So why not to have these in .NET, right? I have a working plugin right
> now. Currently only stored procedures are supported. No blobs at the
> moment as well.
> 
> You can check small example at the end of this email.
> 
> Now the important part. Is there enough interest in this to keep working
> it? The hardest part is mostly over. Now it's just adding support for
> more objects and polishing it, hardening it and probably adding features
> based on requests (like security).
> 
> * SP:
> recreate procedure demo (
>   in_int integer,
>   in_s varchar(20),
>   in_long bigint,
>   in_short smallint,
>   in_char char(20)
> ) 
> returns (
>   out_int integer,
>   out_s varchar(20),
>   out_long bigint,
>   out_short smallint,
>   out_char char(20)
> )
> external name 'Example!Example.Procedures.Demo'
> engine dotnet;
> * Code (not sure about the tuples yet):
> public static IEnumerator<Tuple<int?, string, long?, short?, string>>
> Demo(int? i, string s, long? @long, short? @short, string @char)
> {
> 	yield return Tuple.Create(i, s, @long, @short, @char);
> 	yield return Tuple.Create(i + 1, s + nameof(Demo), @long + 1,
> 	(short?)(@short + 1), @char);
> }
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 		 	   		  

[Firebird-net-provider] Stored procedures etc. in .NET

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

Hi *,

there's something I've been working on for a few evenings and weekends.
As you might know, from Firebird 3 there's and interface to write a
plugin that allows to execute any code as stored procedure, function or
trigger.

So why not to have these in .NET, right? I have a working plugin right
now. Currently only stored procedures are supported. No blobs at the
moment as well.

You can check small example at the end of this email.

Now the important part. Is there enough interest in this to keep working
it? The hardest part is mostly over. Now it's just adding support for
more objects and polishing it, hardening it and probably adding features
based on requests (like security).

* SP:
recreate procedure demo (
  in_int integer,
  in_s varchar(20),
  in_long bigint,
  in_short smallint,
  in_char char(20)
) 
returns (
  out_int integer,
  out_s varchar(20),
  out_long bigint,
  out_short smallint,
  out_char char(20)
)
external name 'Example!Example.Procedures.Demo'
engine dotnet;
* Code (not sure about the tuples yet):
public static IEnumerator<Tuple<int?, string, long?, short?, string>>
Demo(int? i, string s, long? @long, short? @short, string @char)
{
	yield return Tuple.Create(i, s, @long, @short, @char);
	yield return Tuple.Create(i + 1, s + nameof(Demo), @long + 1,
	(short?)(@short + 1), @char);
}

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] current source code that builds with Visual Studio 2013

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

> what is the latest release that can be built with VS2013?

Huh. Maybe like 4.8.0.0. Although I'm just guessing.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] current source code that builds with Visual Studio 2013

[Ralf J. <ral...@ma...>]

Hi,
what is the latest release that can be built with VS2013?

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

[Ralf J. <ral...@ma...>]

Seems to work in a short test. 
I will go that route further and see if there are some major stumbling blocks in the way (the provider's connection pooling for example).

-----Original Message-----
From: Jiří Činčura [mailto:ji...@ci...] 
Sent: Mittwoch, 22. Juni 2016 11:12
To: fir...@li...
Subject: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

> Should that work? Can both libraries coexist? Can the Net. Provider 
> cope with that scenario?

I think yes. Just use the ClientLibrary and point it to correct DLLs. 

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

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

> Should that work? Can both libraries coexist? Can the Net. Provider cope
> with that scenario?

I think yes. Just use the ClientLibrary and point it to correct DLLs. 

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently

[Ralf J. <ral...@ma...>]

Hi,

I'm in the process of migrating a large .Net application that is using firebird embedded 2.5 to 3.0. To get a smooth transition with a minimum of user hassle and downtime it would be helpful to have both client libraries (2.5 and 3.0) used concurrently in the same process.
There are presumably dozens of databases used by the process and I would like to migrate them one by one while the other databases keep running either via the 2.5 client or the 3.0 client library.

Should that work? Can both libraries coexist? Can the Net. Provider cope with that scenario?

Re: [Firebird-net-provider] Zlib library

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

One thing I realized now. We might also consider is future .NET
Core/CoreCLR support...

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Zlib library

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

> There is also ILMerge option to include dependency in a package.

Somebody would probably need to study the license, whether that's
allowed. Also hiding it is nice, but giving "some credits" isn't a bad
thing either (and I don't mean some line in README).

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Zlib library

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

> SharpZipLib looks to be more actively maintained and with clearer and
> more
> permissive licensing. It's a dependency of most of my project anyway so I
> would not mind it.

Kind of. On the other hand when it's done, like *done*, there's not much
to change.

> An alternative to an external dependency is an intree copy with
> unnecesary
> bits(eg. bzip2,tar) removed.

Depends on the license. But that's option as well. Only problem is
maintaining it up to date...

> Out of curiosity why is DeflateStream/GZipStream not enough?

Deflate is raw data compression. Zlib that core guys used, needs some
zlib headers etc. Same as gzip, that has different headers etc. 

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Zlib library

[Геннадий З. <zab...@gm...>]

There is also ILMerge option to include dependency in a package.

On 21 June 2016 at 11:02, Gerdus van Zyl <ger...@gm...> wrote:
> SharpZipLib looks to be more actively maintained and with clearer and more
> permissive licensing. It's a dependency of most of my project anyway so I
> would not mind it.
> An alternative to an external dependency is an intree copy with unnecesary
> bits(eg. bzip2,tar) removed.
>
> Out of curiosity why is DeflateStream/GZipStream not enough?
>
> On Mon, Jun 20, 2016 at 6:57 PM, Jiří Činčura <ji...@ci...> wrote:
>>
>> Hi *,
>>
>> Other topic to think about. The compression is Firebird is based on zlib
>> compression. That one is not in the framework. So unless somebody
>> contributes solid and proven implementation, when and if the compression
>> will make it to master, I'd have to introduce dependency. Maybe some sort of
>> optional.
>>
>> I successfully tested zlib from Ionic and SharpZipLib libraries.
>>
>> Discuss… ;)
>>
>> --
>> Mgr. Jiří Činčura
>> Independent IT Specialist
>>
>>
>> ------------------------------------------------------------------------------
>> What NetFlow Analyzer can do for you? Monitors network bandwidth and
>> traffic
>> patterns at an interface-level. Reveals which users, apps, and protocols
>> are
>> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
>> J-Flow, sFlow and other flows. Make informed decisions using capacity
>> planning
>> reports. http://sdm.link/zohomanageengine
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
>
> --
> ------------------------------------------------------------------------
> Gerdus van Zyl
> www.infireal.com
>
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Zlib library

[Gerdus v. Z. <ger...@gm...>]

SharpZipLib looks to be more actively maintained and with clearer and more
permissive licensing. It's a dependency of most of my project anyway so I
would not mind it.
An alternative to an external dependency is an intree copy with unnecesary
bits(eg. bzip2,tar) removed.

Out of curiosity why is DeflateStream/GZipStream not enough?

On Mon, Jun 20, 2016 at 6:57 PM, Jiří Činčura <ji...@ci...> wrote:

> Hi *,
>
> Other topic to think about. The compression is Firebird is based on zlib
> compression. That one is not in the framework. So unless somebody
> contributes solid and proven implementation, when and if the compression
> will make it to master, I'd have to introduce dependency. Maybe some sort
> of optional.
>
> I successfully tested zlib from Ionic and SharpZipLib libraries.
>
> Discuss… ;)
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports. http://sdm.link/zohomanageengine
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
------------------------------------------------------------------------
Gerdus van Zyl
www.infireal.com

[Firebird-net-provider] Zlib library

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

Hi *,

Other topic to think about. The compression is Firebird is based on zlib compression. That one is not in the framework. So unless somebody contributes solid and proven implementation, when and if the compression will make it to master, I'd have to introduce dependency. Maybe some sort of optional. 

I successfully tested zlib from Ionic and SharpZipLib libraries. 

Discuss… ;)

-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] Compression's default value

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

On 2016-06-20 15:27, Jiří Činčura wrote:
> Hi *,
>
> I have some very preliminary, but working, support for FB3's 
> compression
> in .NET provider. It will be controlled via connection string's value 
> as
> usual. But what do *you* think the default value should be?

I suggest to disable it by default; at least for now. Maybe when there 
is more experience, and if it turns out it is also better for local 
connections (as in: same network), then setting it to default enabled 
might be an option.

Mark

Re: [Firebird-net-provider] Compression's default value

[Norbert S. G. <ns...@te...>]

Jirí Cincura a écrit :
> Hi *,
>
> I have some very preliminary, but working, support for FB3's compression
> in .NET provider. It will be controlled via connection string's value as
> usual. But what do *you* think the default value should be?

false for me :-)

-- 
Norbert Saint Georges
http://tetrasys.fi

[Firebird-net-provider] Compression's default value

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

Hi *,

I have some very preliminary, but working, support for FB3's compression
in .NET provider. It will be controlled via connection string's value as
usual. But what do *you* think the default value should be?

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] [FB-Tracker] Created: (DNET-686) Unify SPB and DPB creation for common parameters

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

Unify SPB and DPB creation for common parameters
------------------------------------------------

                 Key: DNET-686
                 URL: http://tracker.firebirdsql.org/browse/DNET-686
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 5.0.5.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura




-- 
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-685) NOT NULL alteration in EF Migrations

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

NOT NULL alteration in EF Migrations
------------------------------------

                 Key: DNET-685
                 URL: http://tracker.firebirdsql.org/browse/DNET-685
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 5.0.5.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura




-- 
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-684) System.NullReferenceException in FirebirdSql.Data.Common.Extensions.TryGetTarget

[André Z. (J. <tr...@fi...>]

System.NullReferenceException in FirebirdSql.Data.Common.Extensions.TryGetTarget
--------------------------------------------------------------------------------

                 Key: DNET-684
                 URL: http://tracker.firebirdsql.org/browse/DNET-684
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.0.5.0
         Environment: Windows 8 (x64), .Net 4.5.2
            Reporter: André Ziegler
            Assignee: Jiri Cincura


While testing my app I got a crash and analyzing the dmp shows a System.NullReferenceException in FirebirdSql.Data.Common.Extensions.TryGetTarget:


PROBLEM_CLASSES: 

CLR_EXCEPTION
    Tid    [0x2]
    Frame  [0x00]

    String [System.NullReferenceException]
    Failure Bucketing
    Data Bucketing

FINALIZER
    Tid    [0x2348]
    Frame  [0x0b]: clr!FastCallFinalize
    Failure Bucketing


BUGCHECK_STR:  CLR_EXCEPTION_FINALIZER_System.NullReferenceException

DEFAULT_BUCKET_ID:  CLR_EXCEPTION_FINALIZER_System.NullReferenceException

STACK_TEXT:  
049ff1bc 51f20f89 firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]+0x25
049ff1d4 51f3faee firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.FirebirdClient.FbConnectionInternal.RemovePreparedCommand+0x6e
049ff20c 51f41751 firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.FirebirdClient.FbCommand.Release+0x4d
049ff21c 51f409fc firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.FirebirdClient.FbCommand.Dispose+0x50


FAILURE_IMAGE_NAME:  FirebirdSql.Data.FirebirdClient.ni.dll

FAILURE_FUNCTION_NAME:  FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

BUCKET_ID_FUNCTION_STR:  FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

FAILURE_SYMBOL_NAME:  FirebirdSql.Data.FirebirdClient.ni.dll!FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

FAILURE_BUCKET_ID:  CLR_EXCEPTION_FINALIZER_System.NullReferenceException_80004003_FirebirdSql.Data.FirebirdClient.ni.dll!FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]


-- 
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] Connecting to embedded server

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

Just use the distribution package and you're fine.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

On Mon, Jun 6, 2016, at 15:21, Danie Brink wrote:
> Does anyone have distribution info to install FB3 to run as embedded
> server
> with .net (which files are required/file locations/config file
> changes/etc)? Can't find anything online & trial & error is not getting
> me
> anywhere. The latest error I get is: "Could not find acceptable ICU
> library" ... icudt52.dll, icuin52.dll & icuuc52.dll are in the
> application
> folder.
> 
> PS: FB 2.5 is installed on the machine and FB3 is distributed as an
> embedded server with a few apps.
> 
> On Mon, Jun 6, 2016 at 12:55 PM, Jiří Činčura <ji...@ci...> wrote:
> 
> > > with isql in embedded mode. Is the .net provider working with FB 3 in
> > > embedded mode yet?
> >
> > Yes it is. You're not saying version so you might have mismatch between
> > SRP and legacy auth.
> >
> > --
> > Mgr. Jiří Činčura
> > Independent IT Specialist
> >
> >
> > ------------------------------------------------------------------------------
> > What NetFlow Analyzer can do for you? Monitors network bandwidth and
> > traffic
> > patterns at an interface-level. Reveals which users, apps, and protocols
> > are
> > consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> > J-Flow, sFlow and other flows. Make informed decisions using capacity
> > planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> 
> 
> 
> -- 
> Cell: +27 71 750 9859
> Fax: +27 86 551 5721
> Email: dan...@gm...
> 
> 101010
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are 
> consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
> J-Flow, sFlow and other flows. Make informed decisions using capacity 
> planning reports.
> https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Connecting to embedded server

[Danie B. <dan...@gm...>]

Does anyone have distribution info to install FB3 to run as embedded server
with .net (which files are required/file locations/config file
changes/etc)? Can't find anything online & trial & error is not getting me
anywhere. The latest error I get is: "Could not find acceptable ICU
library" ... icudt52.dll, icuin52.dll & icuuc52.dll are in the application
folder.

PS: FB 2.5 is installed on the machine and FB3 is distributed as an
embedded server with a few apps.

On Mon, Jun 6, 2016 at 12:55 PM, Jiří Činčura <ji...@ci...> wrote:

> > with isql in embedded mode. Is the .net provider working with FB 3 in
> > embedded mode yet?
>
> Yes it is. You're not saying version so you might have mismatch between
> SRP and legacy auth.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>



-- 
Cell: +27 71 750 9859
Fax: +27 86 551 5721
Email: dan...@gm...

101010

Re: [Firebird-net-provider] Connecting to embedded server

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

> with isql in embedded mode. Is the .net provider working with FB 3 in
> embedded mode yet?

Yes it is. You're not saying version so you might have mismatch between
SRP and legacy auth.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

[Firebird-net-provider] Connecting to embedded server

[Danie B. <dan...@gm...>]

I'm trying to connect to a DB using FB 3 in embedded mode using the
connection string
"Database=C:\\ProgramData\\TcpCommsCache\\Cache.fdb;ServerType=1;user
id=sysdba;password=masterkey;"

but keep getting "Your user name and password are not defined. Ask your
database administrator to set up a Firebird login.", trying to do a
CreateDatabase gives the same error. I have not problems doing the same
with isql in embedded mode. Is the .net provider working with FB 3 in
embedded mode yet?

-- 
Cell: +27 71 750 9859
Fax: +27 86 551 5721
Email: dan...@gm...

101010

Re: [Firebird-net-provider] Aliases not working

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

On 5-6-2016 02:47, Paul Dryden wrote:
> Thanks, I'll try Firebird 3. It's affordable.

My question was a troubleshooting question, not a solution to your 
problem (as it stands, I'm not sure what your problem is!)

Mark
-- 
Mark Rotteveel