Re: [Firebird-net-provider] Transliteration problem with table locks
Den 2018-09-19 kl. 09:35, skrev Mark Rotteveel: Note that your sending this to the old firebird-net-provider mailing list (on source forge) not to the new one (on Google Groups). On 2018-09-18 20:43, Kjell Rilbe wrote: In firebird-devel, Mark Rotteveel pointed out that the .NET provider seems to use Encoding.Default for TPB, which is not a good choice, considering it's system dependent. I assume TPB want a specific encoding, regardless of client platform. Please consider replacing with Encoding.UTF8, as indicated in the same firebird-devel thread, for all strings in TPB. It is not that simple: for Firebird 2.5 and earlier, using UTF8 for strings in the TPB is incorrect unless the connection character set is UTF8. Alright, but the most important point is to never use Ecoding.Default directly or indirectly (e.g. via string.ToUpper), because it's platform dependent and may turn out right sometimes, but sometimes not. Use well defined encodings everywhere. Regards, Kjell <>___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Transliteration problem with table locks
Den 2018-09-18 kl. 09:00, skrev Kjell Rilbe:
Hi,
I've been using Firebird since a long time, using quoted identifiers
with Swedish characters åäö in them. I am now at version 3.0.3 (on
Windows Server 2016, 64 bit).
Now I tried this code in C# using FirebirClient 6.3.0.0:
/*-*/
Dictionary locks = new
Dictionary() {
{ "KörningInstans", FbTransactionBehavior.Protected |
FbTransactionBehavior.LockWrite },
{ "Körning", FbTransactionBehavior.Protected |
FbTransactionBehavior.LockWrite }
};
FbTransaction trans = connection.BeginTransaction(new
FbTransactionOptions() {
LockTables = locks,
TransactionBehavior = FbTransactionBehavior.Consistency |
FbTransactionBehavior.Write
});
/*-*/
The BeginTransaction call fails with an exception "arithmetic
exception, numeric overflow, or string truncation
Cannot transliterate character between character sets". Error code in
the exception is 335544321. SQLSTATE 22000. It contains 3 errors:
1. type 1, error code 335544321, no message.
2. type 1, error code 335544565, no message.
3. type 0, error code 335544321, message "arithmetic exception,
numeric overflow, or string truncation\r\nCannot transliterate
character between character sets".
The database is created like this in isql:
create database 'KorningarDev' user DEV password '***' page_size 4096
set names 'UTF8' default character set UTF8 collation UNICODE;
And the connection string looks like this:
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=***
So, I see no reason why there would be any transliteratio problems:
Windows unicode -> UTF8, and then UTF8 all the way, right?
What might be going on here? Anything I might be doing wrong? Bug in
.NET FirebirdClient? Bug in Firebird itself?
Regards,
Kjell Rilbe
In firebird-devel, Mark Rotteveel pointed out that the .NET provider
seems to use Encoding.Default for TPB, which is not a good choice,
considering it's system dependent. I assume TPB want a specific
encoding, regardless of client platform.
Please consider replacing with Encoding.UTF8, as indicated in the same
firebird-devel thread, for all strings in TPB.
Also, please consider replacing ALL string.ToUpper() and other string
methods with methods that use a well defined (not platform dependent)
encoding, i.e. string.ToUpperInvariant(). string.ToUpper() also uses
Encoding.Default, an so has the same problems as with TPB above.
Finally, when designing test cases, I hope support for non-ascii
characters in various places are considered and covered.
I wish I could help out better, i.e. fix stuff myslef and submit pull
requests, but I'm afraid I would need to study the innards of FIrebird
communication a few years before being able to fix more than I destroy. :-)
Regards,
Kjell
<>___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Transliteration problem with table locks
Hi,
I've been using Firebird since a long time, using quoted identifiers
with Swedish characters åäö in them. I am now at version 3.0.3 (on
Windows Server 2016, 64 bit).
Now I tried this code in C# using FirebirClient 6.3.0.0:
/*-*/
Dictionary locks = new DictionaryFbTransactionBehavior>() {
{ "KörningInstans", FbTransactionBehavior.Protected |
FbTransactionBehavior.LockWrite },
{ "Körning", FbTransactionBehavior.Protected |
FbTransactionBehavior.LockWrite }
};
FbTransaction trans = connection.BeginTransaction(new
FbTransactionOptions() {
LockTables = locks,
TransactionBehavior = FbTransactionBehavior.Consistency |
FbTransactionBehavior.Write
});
/*-*/
The BeginTransaction call fails with an exception "arithmetic exception,
numeric overflow, or string truncation
Cannot transliterate character between character sets". Error code in
the exception is 335544321. SQLSTATE 22000. It contains 3 errors:
1. type 1, error code 335544321, no message.
2. type 1, error code 335544565, no message.
3. type 0, error code 335544321, message "arithmetic exception, numeric
overflow, or string truncation\r\nCannot transliterate character between
character sets".
The database is created like this in isql:
create database 'KorningarDev' user DEV password '***' page_size 4096
set names 'UTF8' default character set UTF8 collation UNICODE;
And the connection string looks like this:
Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=***
So, I see no reason why there would be any transliteratio problems:
Windows unicode -> UTF8, and then UTF8 all the way, right?
What might be going on here? Anything I might be doing wrong? Bug in
.NET FirebirdClient? Bug in Firebird itself?
Regards,
Kjell Rilbe
<>___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-851) Can't connect with mixed case user name
Can't connect with mixed case user name --- Key: DNET-851 URL: http://tracker.firebirdsql.org/browse/DNET-851 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 6.3.0.0 Environment: Firebird 3.0.3 64 bit, Windows Server 2016 64 bit, .NET Framework 4.7.1, Visual Studio 2017 Community, C# console application. Reporter: Kjell Rilbe Assignee: Jiri Cincura Priority: Minor I created a user and database in isql connected to security3.db: create user "KorningarDev" password '***'; create database 'KorningarDev' user "KorningarDev" password '***' page_size 4096 set names 'UTF8' default character set UTF8 collation UNICODE; I can use this database from FlameRobin, specifying the user name with quotes "KorningarDev". But I can't connect to it from the FirebirdClient. I've tried several different variations of connection string, but nothing works. With a uppercase user, this connection string works: Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=DEV;Password=*** With the mixed case user name, none of these semm to work: Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User=KorningarDev;Password=*** Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User="KorningarDev";Password=*** Server=xxx.xxx.xxx.xxx;Port=3050;Database=KorningarDev;Charset=UTF8;User='KorningarDev';Password=*** I would assume that the FirebirdClient, along the way, loses the quotes on the user name, causing the login request to attemt login with an uppercased username KORNINGARDEV. -- 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 mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Choose isolation level using System.Data.IsolationLevel?
Jiří Činčura skrev: > The ReadCommitted is RecVersion: > > case IsolationLevel.ReadCommitted: > case IsolationLevel.ReadUncommitted: > default: > options.TransactionBehavior |= > FbTransactionBehavior.ReadCommitted; > options.TransactionBehavior |= > FbTransactionBehavior.RecVersion; > break; > Oh, that's interesting. I'll have to check again then. The thing is that I noticed NoRecVersion reported by Sinática Monitor for queries executed by the framework. Has the mapping from IsolationLevel.ReadCommitted to TransactionBehavior changed? I have neglected to update it for quite some time. I seem to be at version 2.6.5. Guess I should upgrade, huh? :-) Regards, Kjell -- ------ Kjell Rilbe <kj...@rilbe.se> Home: +46 8 7610734 Mobile: +46 733 442464 -- "If there's a price for bein' me, that's one I'll have to pay" Aaron Tippin -- -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Choose isolation level using System.Data.IsolationLevel?
Hi, Using a framework that's "database agnostic", I am able to choose a value for transaction isolation level using the System.Data.IsolationLevel enum. I can't find a way to enter a FbTransationOptions struct or FbTransactionBehavior value. Using System.Data.IsolationLevel, it seems I get transactions with behavior ReadCommitted + NoRecVersion. I would like to have RecVersion instead of NoRecVersion. Any suggestions? Regards, Kjell Rilbe -- Marknadsinformation logotyp Kjell Rilbe Telefon: 08-761 06 55 Mobil: 0733-44 24 64 Marknadsinformation i Sverige AB Ulvsundavägen 106C 168 67 Bromma www.marknadsinformation.se <http://www.marknadsinformation.se> 08-514 905 90 Företagskontakt.se <http://xn--fretagskontakt-vpb.se> Personkontakt.se <http://personkontakt.se> -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Choose isolation level using System.Data.IsolationLevel?
Hi, Using a framework that's "database agnostic", I am able to choose a value for transaction isolation level using the System.Data.IsolationLevel enum. I can't find a way to enter a FbTransationOptions struct or FbTransactionBehavior value. Using System.Data.IsolationLevel, it seems I get transactions with behavior ReadCommitted + NoRecVersion. I would like to have RecVersion instead of NoRecVersion. Any suggestions? Regards, Kjell Rilbe -- Marknadsinformation logotyp Kjell Rilbe Telefon: 08-761 06 55 Mobil: 0733-44 24 64 Marknadsinformation i Sverige AB Ulvsundavägen 106C 168 67 Bromma www.marknadsinformation.se <http://www.marknadsinformation.se> 08-514 905 90 Företagskontakt.se <http://xn--fretagskontakt-vpb.se> Personkontakt.se <http://personkontakt.se> -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Choose isolation level using System.Data.IsolationLevel?
den 2016-01-30 20:23, skrev Геннадий Забула: > On 30 January 2016 at 12:44, Kjell Rilbe <kj...@rilbe.se> wrote: >> Hi, >> >> Using a framework that's "database agnostic", I am able to choose a >> value for transaction isolation level using the >> System.Data.IsolationLevel enum. I can't find a way to enter a >> FbTransationOptions struct or FbTransactionBehavior value. >> >> Using System.Data.IsolationLevel, it seems I get transactions with >> behavior ReadCommitted + NoRecVersion. I would like to have RecVersion >> instead of NoRecVersion. >> >> Any suggestions? >> >> > I'm using custom extension function, that takes DbContext and > depending on Database.Connection type creates manually tuned > transaction for FB case. > https://gist.github.com/zabulus/1e46010094e1b6678729 > Here is snippet Nice, but I assume this is a function that you manually call in your own code, instead of the regular DbConnection.BeginTransaction? The problem is that the framework I'm using does it all under the hood: opens connection, starts and ends transactions and executes SQL. I add the DbConnection component I need to my form, in my case an FbConnection, and configure my framework's persistence handler to use that connection. The persistence handler has a lot of settings for the SQL connection, but for fetch and write transaction mode it uses the standard System.Data.IsolationLevel enum type, so there's no way to configure FireBird specific transaction options. What I need is some way to hook into the FbConnection's call to start a transaction, or "globally" configure it to a specific transaction option/mode/isolation level, either overriding the System.Data.IsolationLevel that the framework's persitence handler passes in, or map it in a different way than apparently is standard for the Firebird .Net provider. I.e. map ReadCommitted to ReadCommitted + RecVersion + NoWait rather than ReadCommitted + NoRecVersion + NoWait. Possible? Inherit from FbCOnnection and override BeginTransaction and use that (derived) component in place of FbConnection? Kjell -- --- Kjell Rilbe <kj...@rilbe.se> Telefon: 0733-44 24 64 (+46 733 442464) --- "If there's a price for bein' me, that's one I'll have to pay" Aaron Tippin --- -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] FbTransactionBehavior values docs/info?
Hi, I am unable to find info about some of the FbTransactionBehavior values. Would be nice with some pointers or info. :-) Consistency = 1, // What's this? Concurrency = 2, // What's this? Shared = 4, // Used only for pre locking of tables?? Protected = 8, // Used only for pre locking of tables?? Exclusive = 16, // Used only for pre locking of tables?? Wait = 32, // Wait specified amount of time if operation needs resource locked by other transaction. NoWait = 64, // Throw exception immediately if operation needs resource locked by other transaction. Read = 128, // Used only for pre locking of tables?? Write = 256, // Used only for pre locking of tables?? LockRead = 512, // Used only for pre locking of tables?? LockWrite = 1024, // Used only for pre locking of tables?? ReadCommitted = 2048, // Changes committed by other trans are seen, uncommitted changes are not seen, conflict only on write of same record. Autocommit = 4096, // What's this? RecVersion = 8192, // MVCC is used, so rec changed by other transaction can be read (but old version). NoRecVersion = 16384, // MVCC "not used", so can't read rec changed by other transaction. RestartRequests = 32768, // What's this? NoAutoUndo = 65536, // What's this? Thanks! Kjell Rilbe -- Marknadsinformation logotyp Kjell Rilbe Telefon: 08-761 06 55 Mobil: 0733-44 24 64 Marknadsinformation i Sverige AB Ulvsundavägen 106C 168 67 Bromma www.marknadsinformation.se <http://www.marknadsinformation.se> 08-514 905 90 Företagskontakt.se <http://xn--fretagskontakt-vpb.se> Personkontakt.se <http://personkontakt.se> -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Why is table in use after close commit?
Den 2013-11-26 19:28 skrev Jiri Cincura såhär: On Tue, Nov 26, 2013 at 5:00 PM, Kjell Rilbe kjell.ri...@datadia.se wrote: Server=localhost;Database=My_DB_Alias;Charset=UTF8;User=My_User;Password=My_Password Anything missing there? You're using connection pooling. That might be the reason. The connection is kept open on your behalf. Umm... 1. Doing a conn.Close + conn.Open does solve the problem, which seems to indicate that the connection is actually closed, not kept open. 2. For testing, how would I disable pooling? Thanks, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Why is table in use after close commit?
Den 2013-11-26 17:25 skrev Danny Gorton såhär: DbCommand objects are disposable and therefore this pattern can most easily be addressed with the 'using' pattern. I see you are using it for your reader, you can also use it for your command objects. Or you can write out your own try...finally blocks if you want (what 'using' actually emits). For that matter, the code you posted could also use some protective logic to clean up the connection in case of catastrophy. Thanks. I'll give it a try, and then also create a separate FbCommand for each operation - I currently reuse the same one. I do have try/finally/catch to protect connection and transactions, but I omitted it in the post for brevity and clarity re. the normal flow of operations. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Why is table in use after close commit?
Den 2013-11-26 20:45 skrev Mark Rotteveel såhär:
On 26-11-2013 14:58, Kjell Rilbe wrote:
Please consider this code, which essentially creates a table, commits,
fills data and does a select with joins, closes the query, commits, then
drops the table in a new transaction.
The problem is that without the conn.Close + conn.Open before starting
the drop transaction, the drop fails saying the object is in use.
Why is the Close/Open required?
...
FbCommand cmd = conn.CreateCommand();
...
cmd.CommandText = select /*...*/ from \Tmp\ inner join /*...*/ where
/*...*/;;
cmd.Parameters.Clear();
using (FbDataReader rd =
cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow))
{
rd.Read();
for (int colnum = 0; colnum rd.FieldCount; colnum++)
{
string colname = rd.GetName(colnum);
int count = rd.GetInt32(colnum);
if (count 0)
result.Counts[colname] = count;
}
rd.Close();
}
An rd.Close() is unnecessary when you use using. It will dispose the
object when it exits the block (which closed the reader).
I added it just to see if it would help. :-)
The problem is that you did not close the command, which means it is
still prepared, which marks the table as used. Now when you close the
connection, the command will be closed as well.
I looked for an Unprepare method, and didn't find it. Thought oh well.
Didn't think to look for Close. I'll give that a try.
So the solution is to wrap the command (and everything that uses the
command) in a using block as well.
Or call cmd.Close explicitly?
trans.Commit();
conn.Close();
conn.Open();
trans = conn.BeginTransaction(new FbTransactionOptions() {
TransactionBehavior = FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion | FbTransactionBehavior.Wait });
FbCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Transaction = trans;
cmd.CommandText = drop table \Tmp\;;
cmd.ExecuteNonQuery();
trans.Commit();
BTW: You really should use using for your connections and for
transactions as well. This will rollback the transaction if no commit
was called when it exits the block (either because no commit() was in
the code or an exception occurred before the end of the block).
Basic rule: if something is IDisposable, then use using.
I do have try/finally/catch for conn.Close and trans.Rollback, but
omitted it in the post for brevity and clarity re. the normal flow of
operations. My point was to understand why the table is in use in the
normal case. The exception/error case was not the problem.
I wasn't aware that using {...} will do a rollback on trans. Might use
that instead of try/catch then - looks a little slimmer in the code,
albeit possibly slightly less clear to read since it assumes that the
person studying the code knows that the end of the using block will
rollback the trans if still open.
Thanks,
Kjell
--
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
--
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Why is table in use after close commit?
Please consider this code, which essentially creates a table, commits,
fills data and does a select with joins, closes the query, commits, then
drops the table in a new transaction.
The problem is that without the conn.Close + conn.Open before starting
the drop transaction, the drop fails saying the object is in use.
Why is the Close/Open required?
FbConnection conn = new FbConnection(connstr);
FbTransaction trans = conn.BeginTransaction(new FbTransactionOptions() {
TransactionBehavior = FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion | FbTransactionBehavior.Wait });
FbCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Transaction = trans;
cmd.CommandText = create table \Tmp\ (/*...*/));;
cmd.ExecuteNonQuery();
trans.Commit();
trans = conn.BeginTransaction(new FbTransactionOptions() {
TransactionBehavior = FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion | FbTransactionBehavior.Wait });
cmd.Transaction = trans;
cmd.CommandText = insert into \Tmp\ (/*...*/) values (/*...*/);;
cmd.Parameters.Add(new FbParameter(..., FbDbType.BigInt) { Direction =
System.Data.ParameterDirection.Input, IsNullable = false });
cmd.Parameters.Add(new FbParameter(..., FbDbType.VarChar, 101) {
Direction = System.Data.ParameterDirection.Input, IsNullable = false,
Charset = FbCharset.Utf8 });
cmd.Prepare();
foreach (/*...*/)
{
cmd.Parameters[...].Value = /*...*/;
/*...*/
cmd.ExecuteNonQuery();
}
cmd.CommandText = select /*...*/ from \Tmp\ inner join /*...*/ where
/*...*/;;
cmd.Parameters.Clear();
using (FbDataReader rd =
cmd.ExecuteReader(System.Data.CommandBehavior.SingleRow))
{
rd.Read();
for (int colnum = 0; colnum rd.FieldCount; colnum++)
{
string colname = rd.GetName(colnum);
int count = rd.GetInt32(colnum);
if (count 0)
result.Counts[colname] = count;
}
rd.Close();
}
trans.Commit();
conn.Close();
conn.Open();
trans = conn.BeginTransaction(new FbTransactionOptions() {
TransactionBehavior = FbTransactionBehavior.ReadCommitted |
FbTransactionBehavior.RecVersion | FbTransactionBehavior.Wait });
FbCommand cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Transaction = trans;
cmd.CommandText = drop table \Tmp\;;
cmd.ExecuteNonQuery();
trans.Commit();
Regards,
Kjell
--
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
--
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Why is table in use after close commit?
Den 2013-11-26 15:46 skrev Jiri Cincura såhär: How the connection string looks like? Server=localhost;Database=My_DB_Alias;Charset=UTF8;User=My_User;Password=My_Password Anything missing there? Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Why is table in use after close commit?
Den 2013-11-26 15:46 skrev Jiri Cincura såhär: How the connection string looks like? Please refer to the thread in firebird-support about this issue: Object in use... wtf??? I got a couple of replies there, from Ann Harrison among others. I probably need to make sure somehow that the FbCommand is disposed so that it releases/closes the statement in FB. How...? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Single transaction per connection?
Hi, Does the .Net provider support multiple active transactions on a single FbConnection? I am on version 2.6 or 2.7 I think... Thanks, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Single transaction per connection?
Den 2012-06-08 13:52 skrev Michael Ludwig såhär: Kjell Rilbe schrieb am 08.06.2012 um 12:59 (+0200): it seems my existing transaction is ended by a framework that's using the same connection). What framework? ECO, www.capableobjects.com. Why? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Single transaction per connection?
Den 2012-06-08 14:42 skrev Daniel Rail såhär: At June-08-12, 8:58 AM, Kjell Rilbe wrote: Den 2012-06-08 13:52 skrev Michael Ludwig såhär: Kjell Rilbe schrieb am 08.06.2012 um 12:59 (+0200): it seems my existing transaction is ended by a framework that's using the same connection). What framework? ECO, www.capableobjects.com. Why? In those cases I use one connection for ECO and another connection for anything outside of ECO. Yes, fine. I just thought it was a bit surprising. In this perticular case I chose to reqorder things a bit so I know Eco won't touch the DB while I borrow the connection for a few moments. It does require that I load about 1 million 64 bit integers into a list instead of just a few hundred at a time, but that's not too big a deal. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Setting cmd trans buggy?
Hi,
Please regard the following code snippet, from my app:
FbTransaction trans = cmdData.Connection.BeginTransaction();
try
{
cmdData.Transaction = trans; // (1)
cmdÄgare.Transaction = trans; // (2)
cmdIdn.Transaction = trans; // (3)
...
}
When executing this, cmdData.Transaction becomes == trans after
executing (1) as expected.
But when executing (2), cmdData.Transaction becomes == null again, while
cmdÄgare.Transaction becomes == trans.
Then, again, when executing (3) cmdÄgare.Transaction becomes == null and
cmdIdn.Transaction becomes == trans.
At this stage, if I use the VS 2008 debugger to set (1) as next
statement, and re-execute (1)-(3), everything works as originally
expected, and all .Transaction == trans.
I haven't done ANYTHING unusual with these FbCommands, I just create
then from th connection object, assign CommandText and add parameters,
then prepare them. Then the above snippet executes.
After re-executing (1)-(3) to get all Transaction properties set to
trans and committing the transaction, all subsequent executions of the
code work fine.
So, what might be going on here?
Kjell
--
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
--
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Setting cmd trans buggy?
Den 2011-08-15 16:38 skrev Kjell Rilbe såhär:
Hi,
Please regard the following code snippet, from my app:
FbTransaction trans = cmdData.Connection.BeginTransaction();
try
{
cmdData.Transaction = trans; // (1)
cmdÄgare.Transaction = trans; // (2)
cmdIdn.Transaction = trans; // (3)
...
}
[snip]
But when executing (2), cmdData.Transaction becomes == null again, while
cmdÄgare.Transaction becomes == trans.
Then, again, when executing (3) cmdÄgare.Transaction becomes == null and
cmdIdn.Transaction becomes == trans.
I tried duplicating the three lines with assignments:
cmdData.Transaction = trans;
cmdÄgare.Transaction = trans;
cmdIdn.Transaction = trans;
cmdData.Transaction = trans;
cmdÄgare.Transaction = trans;
cmdIdn.Transaction = trans;
Now it works!
This, on the other hand, does NOT work:
cmdData.Transaction = trans;
cmdData.Transaction = trans;
cmdÄgare.Transaction = trans;
cmdÄgare.Transaction = trans;
cmdIdn.Transaction = trans;
cmdIdn.Transaction = trans;
Tried this:
cmdData.Transaction = trans;
cmdÄgare.Transaction = trans;
cmdData.Transaction = trans;
cmdIdn.Transaction = trans;
This looks alright after executing the first three, but when I execute
the fourth line, both cmdData and cmdÄgare lose thier Transaction
(becomes null).
Weird!
Kjell
--
--
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
--
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Can't sonnect if fiel contains ö?
Hi, I just tried to connect to a database with the following connection string: Server=localhost;Database=D:\\DataDIA\\Diamonds\\DiamondsSök.fdb;Charset=UTF8;User=sysdba;Password=masterkey Note the ö (o with dots) in the database filename. Id doesn't work: Error while trying to open file. I first thought it was a problem with insufficient privileges, this being an ASP.Net app, but it still doesn't work with Full control assigned to Everyone. But then I tried changing the ö to o in both filename and connection string. Now it works! So, where does it go wrong because of the ö, and how can I fix it? Platform Win7 64 bit with FB 2.1.3 64 bit and .Net provider 2.5.0. Do I need to upgrade anything to make it work? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Version for VS 2008?
Hi, My app is still under VS 2008 and .Net framework 3.5. If I want the latest provider that works with this environment and app, which download should I use? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Version for VS 2008?
Den 2011-08-10 17:25 skrev Kjell Rilbe såhär: My app is still under VS 2008 and .Net framework 3.5. If I want the latest provider that works with this environment and app, which download should I use? Seems to work with 2.6.5.0 build for .Net 3.5, i.e. this file: NETProvider-2.6.5-NET35.7z Installed in GAC and entered this into devenv.exe.config and config files for all apps that ref this assembly (thanks to Daniel Rail!): runtime assemblyBinding xmlns=urn:schemas-microsoft-com:asm.v1 dependentAssembly assemblyIdentity name=FirebirdSql.Data.FirebirdClient publicKeyToken=3750abcc3150b00c / bindingRedirect oldVersion=1.0.0.0-2.5.1.0 newVersion=2.5.2.0 / /dependentAssembly /assemblyBinding /runtime Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Can't sonnect if fiel contains ö?
Den 2011-08-10 17:09 skrev Kjell Rilbe såhär: Hi, I just tried to connect to a database with the following connection string: Server=localhost;Database=D:\\DataDIA\\Diamonds\\DiamondsSök.fdb;Charset=UTF8;User=sysdba;Password=masterkey Note the ö (o with dots) in the database filename. Id doesn't work: Error while trying to open file. I first thought it was a problem with insufficient privileges, this being an ASP.Net app, but it still doesn't work with Full control assigned to Everyone. But then I tried changing the ö to o in both filename and connection string. Now it works! So, where does it go wrong because of the ö, and how can I fix it? Platform Win7 64 bit with FB 2.1.3 64 bit and .Net provider 2.5.0. Do I need to upgrade anything to make it work? Ah, it seems to be fixed in 2.6.5.0. Great! But the first time I tried, I had forgotten to rename the db file back from DiamondsSok.fdb with an o without dots. Of course it couldn't find the file, but the error string was not correctly encoded. The ö in the sought filename displayed as a black diamond with a question mark or something inside. Where would I file a bug report regarding this little detail? Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Getting an assembly to accept more than one provider version?
Hi, Maybe this is more a .Net question than a FB provider question, but I think it may be of interest to most people using the provider. My problem is that I have an assembly that in the sources specifies SpecificVersion = false for the Fb provider assembly, i.e. it should accept any version of the provider. But the built assembly (the dll) becomes bound to the provider version present when it is compiled, in my case 2.5.0.0. Now, I'd like to upgrade to the latest provider version (2.5.2.0). Is there any way I can get the other assembly to accept the newer provider assembly without having to rebuild it from sources? If you reply with RTFM I'd appreciate pointers to relevant docs. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Getting an assembly to accept more than one provider version?
Den 2011-03-07 15:14 skrev Daniel Rail såhär: Is there any way I can get the other assembly to accept the newer provider assembly without having to rebuild it from sources? Add this to your application's config file, under the configuration section: runtime assemblyBinding xmlns=urn:schemas-microsoft-com:asm.v1 dependentAssembly assemblyIdentity name=FirebirdSql.Data.FirebirdClient publicKeyToken=3750abcc3150b00c / bindingRedirect oldVersion=1.0.0.0-2.5.1.0 newVersion=2.5.2.0 / /dependentAssembly /runtime I also added the same thing to Visual Studio's devenv.exe.config file, because of ECO. OK, excellent, thanks! I also use ECO. :-) Have you joined the ECO fan group on Facebook? Fans of ECO Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Can't find fbConnection component in toolbox
Den 2011-03-04 09:05 skrev Jiri Cincura såhär: On Fri, Mar 4, 2011 at 00:09, Kjell Rilbekjell.ri...@datadia.se wrote: I can't find FbConnection in the Toolbox and I can't find it enywhere in the lists in the Choose Toolbox Items dialog. This was dropped couple of years ago as it's superseded by DDEX. OK. I'm not at all familiar with DDEX, nor whatever fbConnection is part of as opposed to DDEX. All I know is that for the OO framework (and more) ECO, there is a need for a design time db connection for the ECO persistence mapper to be able to evolve the schema and do some other stuff design time. For Firebird, the component used for this purpose is fbConnection. So, in view of what you wrote, how *should* I solve this using DDEX? If this is a RTFM question, then I'd be grateful for a link to relevant docs to start reading. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Can't find fbConnection component in toolbox
Hi, Running VS2008 on Win7 64 bit. Installed FB .Net provider 2.5.1 as well as FirebirdDDEXProvider-2.0.5 as per the readme included in the DDEX package. The provider is in the GAC - I've checked. My project references FirebirdSql.Data.FirebirdClient and that all seems OK. But now how do I add a FbConnection component to my form (actually an non-visual component container for an ECO EcoSpace, but that's beside the point). I can't find FbConnection in the Toolbox and I can't find it enywhere in the lists in the Choose Toolbox Items dialog. What have I missed? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Can't find fbConnection component in toolbox
Den 2011-03-04 00:09 skrev Kjell Rilbe såhär: Hi, Running VS2008 on Win7 64 bit. Installed FB .Net provider 2.5.1 as well as FirebirdDDEXProvider-2.0.5 as per the readme included in the DDEX package. The provider is in the GAC - I've checked. My project references FirebirdSql.Data.FirebirdClient and that all seems OK. But now how do I add a FbConnection component to my form (actually an non-visual component container for an ECO EcoSpace, but that's beside the point). I can't find FbConnection in the Toolbox and I can't find it enywhere in the lists in the Choose Toolbox Items dialog. Perhaps I should mention that in that dialog I can see e.g. SqlConnection, but I see no components that appear to be FB related. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trace API use cases
Jiri Cincura skriver: if there's somebody using trace API from fbtracemgr or 3rd party tools, can you share your scenarios, your goals, your usage, ...? I implemented in .NET provider, but I'm now thinking how to do the public classes etc. the best most useful way. So any feedback is appreciated. A bit late, but since you receive no other replies... I am currently not using the trace API in any way, but I am using Firebird from a .NET application and your provider. The primary use case I can imagine for my application in the not so distant future is tot race and log all SQL passed to the server along with query plan, timings and parameter values. I would probably want to do this per connection. So I would probably want to be able to pass a fbConnection to a trace initiator and then receive trace output whenever that connection does something. It could call an event handler, which would interpret the trace data and save it to a log of my choice. I don't know if this would work at all, since I'm not familiar with the trace API provided, but I can always comment on it if you state what can and cannot be done. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trace API use cases
Jiri Cincura skriver: On Thu, Dec 16, 2010 at 09:02, Kjell Rilbekjell.ri...@datadia.se wrote: I would probably want to do this per connection. Not possible (directly) with current API. Is it possible to see in the trace output which connection was used for each statement? I guess I can accept to get all but it's less than optimal for my purposes. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] .NET 4
Jiri Cincura wrote: On Sun, Jan 3, 2010 at 21:44, Kjell Rilbe kjell.ri...@datadia.se wrote: I would assume that those who are still on 2.0 for various reasons would find it rather disappointing if 2.0 were to be dropped completely. Might be a reason to switch away from FB? For me personally, our project is on 3.5 so as long as 3.5 is supported we're happy. Also, I suppose we would be able to upgrade to 4.0 as soon as ECO (www.capableobjects.com) supports it. I think you don't understand the relation between .NET 3.5 and .NET 2.0. The 3.5 is just extended 2.0, the runtime is the same as well as the base libraries. What I'm talking about is to drop just 2.0 support, but keep 3.5. i.e. using .NET 4 and .NET 3.5's features. Yes, I am a .Net novice and have a very vague grasp of the various versions. But I find your statement somewhat contradictory. On the one hand, you say that 3.0 and 3.5 are just extensions to 2.0, which would seem to indicate that dropping 2.0 support would imply also dropping 3.0 and 3.5 support. But on the other hand you say the opposite: that you intend to drop only 2.0 support, but keep 3.5 (and 3.0?) support. Can you clarify, just make sure I (and possibly others) don't misunderstand you? Thank you, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] R: .NET 4
Jiri Cincura wrote: On Mon, Jan 4, 2010 at 11:34, Luigi Piccinni luigi.picci...@computeraid.it wrote: Programmers who uses .NET 2.0 (for example because they cannot upgrade the software in production from 2.0 to 3.5 or 4) have to get the provider's source code every new release and recompile it using VS2010 (thanks to the multi-framework functionality), or a specific .NET 2.0 compiler (VS2005, CSC2, ...) It will not work. First because the new C# language features (like object initializers) and second because of new .NET objects (i.e. Func or L2O). So it's not an option to maintain a common 2.0 and 4.0 codebase. Apparently it *is* possible to maintain a common 3.5 and 4.0 codebase, since that's what you said is your intention. So, are those language features available in 3.5 already? 3.0 too? No matter what, I suggest again that you branch off a version for .Net 2.0, which would be kept alive for bugfixes but no new features. Poll your userbase a few times a year, and when interest in 2.0 support seems to have died off or it's judged to be very stable, stop maintaining it but keep it at the download site as is. Would that be a good approach? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] .NET 4
Jiri Cincura wrote: 1. Dropping .NET 2.0 support. Could there be a .Net 2.0 branch that would be kept alive for bugfixing for a year or two, but no new features? I would assume that those who are still on 2.0 for various reasons would find it rather disappointing if 2.0 were to be dropped completely. Might be a reason to switch away from FB? For me personally, our project is on 3.5 so as long as 3.5 is supported we're happy. Also, I suppose we would be able to upgrade to 4.0 as soon as ECO (www.capableobjects.com) supports it. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS to Firebird
For what it's worth, I recently tried to get SQL Server 2005's import/export wizard to find and use the Firebird .NET driver. I also stumbled upon several problems, one of which was to even find gacutil.exe, considering I didn't have VS installed on the machine in question. I failed. So, I also think that it would be very relevant to have an installer for the .Net driver that would actually install the driver on the system in a way that it's available to any application. It is, unfortunately beyond my capabilities, within reasonable time, to create such an installer, otherwise I would probably have already done so. If ever I find time to educate myself in installer technologies and how .Net drivers are supposed to be installed, I will hopefully also be able to find time to create an installer for this driver. I just can't see that happening. :-( Regards, Kjell Will Ferguson wrote: I have problems connecting to firebird from within Visual Studio. I have some difficulty understanding the precise steps required in the provided ddex readme files. I also have some problems being considered some sort of moron by the firebird group for suggesting the instructions are not as helpful as they could be. So , in order that you understand I’m not some hairy arsed kid that fell out of a tree I’ll toot my own horn briefly I am 43. When I was 16 I wrote my first stock control progam in BASIC Since 2000 I have been coding in C# and VB and ASP I have used VS2003 2005 2008 and I currently use VS2010 beta 2 as well as Coldfusion I created an ERP/CRM system that traverses the LAN and WEB for a company with a turnover of over 20 Million a year and services their customers, suppliers and Remote users including smart phone an iPhone apps. I am currently coding WPF and Silverlight apps for major companies and an international Charity organization. I now want to integrate some of our LOB with third party firebird databases that exist on our servers. 2 years ago I tried without luck. Today I discover the same readme files.. the same confusion How often do I use the gacutil?.. hardly ever. How often do I need to run a registry hack to get a connection to work ?.. hardly ever How often do I need to edit the machine.config file without fucking up my systems. Well Once is more than enough I reckon. I want detailed, specifc, instructions on how to connect to a firebird database from within Visual Studio. Is that too much to ask? If I’m asking for too much then I’m happy to provide instruction on how to pull your head out of your own arse. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2010 dat providers
Jiri Cincura wrote: On Tue, Nov 17, 2009 at 02:29, Will Ferguson willfergu...@westruss.com.au wrote: This readme is not what I’d call exact steps. Then keep trying. Read it again and again. When confronted with criticism, you can react in either of two ways: 1. Aha, maybe there's room for improvement, and this is a great opportunity to find out where and how. 2. This is a moron who doesn't understand anything or just can't read instructions. I'll ignore him. Which one is better? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] FirebirdClient for .Net 2.0
Hi, I need to install the FirebirdClient for .Net for .Net version 2.0 (as it seems SQL Server 2005 import/export supports 2.0 and not 3.5). How do I do that? Install 3.5 then copy the dll for 2.0 to Program Files\FirebirdClient? Anything else? The imp/exp wizard for SQL Server doesn't list Firebird as a soure... Anything else I need to do? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient for .Net 2.0
Jiri Cincura wrote: On Thu, Oct 22, 2009 at 12:41, Kjell Rilbe kjell.ri...@datadia.se wrote: I need to install the FirebirdClient for .Net for .Net version 2.0 (as it seems SQL Server 2005 import/export supports 2.0 and not 3.5). The 3.5 is only added stuff to 2.0. Hence if on that machone 3.5 is available you don't need to worry. Not sure .net 3.5 is installed on this system. Can i just replace the DLL or will that break anything? The imp/exp wizard for SQL Server doesn't list Firebird as a soure... Anything else I need to do? I don't know the wizard, but did you added record into machine.config? 99% applications depends on this information. Where is this? Is it a file with that name? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient for .Net 2.0
Found the file and four drivers, three of which appear in the guide, and if I change the description, it appears changed in the guid. So thats where to add the FB provider. But... what should I add, in detail? The current provider says: add name=SqlClient Data Provider invariant=System.Data.SqlClient description=.Net Framework Data Provider for SqlServer type=System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 / What's the right entry for FB? add name=FirebirdClient Data Provider invariant=System.Data.FirebirdClient description=.Net Framework Data Provider for Firebird type=System.Data.FirebirdClient.FirebirdClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 / Please help Thank you! Kjell Kjell Rilbe wrote: Jiri Cincura wrote: On Thu, Oct 22, 2009 at 12:41, Kjell Rilbe kjell.ri...@datadia.se wrote: I need to install the FirebirdClient for .Net for .Net version 2.0 (as it seems SQL Server 2005 import/export supports 2.0 and not 3.5). The 3.5 is only added stuff to 2.0. Hence if on that machone 3.5 is available you don't need to worry. Not sure .net 3.5 is installed on this system. Can i just replace the DLL or will that break anything? The imp/exp wizard for SQL Server doesn't list Firebird as a soure... Anything else I need to do? I don't know the wizard, but did you added record into machine.config? 99% applications depends on this information. Where is this? Is it a file with that name? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient for .Net 2.0
Jiri Cincura wrote: http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/DataDesignerExtensibility/ReadMe.txt?view=markup Thank you! Finally found the same info on the web, but had real problems finding gacutil.exe. This is not a dev system and I don't have VS available. So, how am I REALLY supposed to find thiese things out if I just want to get the Firebird provider installed on a non-dev system and into machine.config? Seems odd that this info is tucked away in a VS related location, since it seems to have nothing to do with VS per se. Also, after doing all that, the import/export wizard still fails, becuase it can't extract column info from FB. It says Specified method is not supported. Could this be some (still) missing config, or is it a feature that the FB provider doen not implement? I have no idea what method the wizard was trying to call I'm afraid. Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
