Sure, consider it done ;)
--
View this message in context:
http://www.nabble.com/still-FbRemoteEvent-tp18607434p18727033.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-
This SF.Net email is s
Jiri Cincura wrote:
>
> Hello,
> can you post this into tracker. Thanks.
>
Me? I mean, we have discussed here so many things besides FbRemoteEvent :-D
--
View this message in context:
http://www.nabble.com/RemoteEventCounts-in-FbRemoteEvent-tp18531448p18727023.html
Sent from the firebird-net
Hi Jiri,
is it possible to somehow implement an IDisposable pattern for
FbRemoteEvent? There are a lot of small problems now. For instance:
if i pass an connection object to the FbRemoteEvent constructor there are as
far as i understand two possibilities
1) i as owner responsible for destroying
Hi Jiri, so I managed it faster as supposed.
The original problem: Suppose we have following code in for instance Windows
Forms window.
public Form1()
{
InitializeComponent();
FbConnection conn = new FbConnection("some connection");
conn.Open();
Hi Jiri, i have one question:
It seems like handling of RemoteEventCounts-Event of the FbRemoteEvent class
occurs in other than calling thread. It means, accessing some outside
objects inside FbRemoteEventEventHandler is not thread safe (and this fact
is not obvious). Can you consider it as Featu
Hi Jiri,
There is one small typo in line 329 of FbDataAdapter.cs
throw new InvalidOperationException("RowUpdatingEvent: Errors occurred; no
additional is information available.");
--
View this message in context:
http://www.nabble.com/typo-error-tp17779009p17779009.html
Sent from the firebi
It was an error in firebird server - has something to do with default
procedure parameters. Vlad says, 2.0 should be also affected. Anyway, it is
fixed in daily firebird build at
http://www.firebirdsql.org/download/snapshot_builds/
http://www.firebirdsql.org/download/snapshot_builds/ . At least f
Hi Jiri, i think we might have a problem with GTTs. I can't reproduce error
in a simple scenario, but i work on it.
So, what i have: Fb 2.1 final, FbProvider 2.5 from svn and following code:
using (FbConnection conn = new
FbConnection(@"charset=WIN1252;connectionlifetime=30;database=192.168.10
Jiri Cincura wrote:
>
> Read tracker: http://tracker.firebirdsql.org/browse/DNET-156 or use
> stable version of provider.
>
In addition to workaround, mentioned in tracker, i propose calling
FbConnection.ClearAllPools() on application exit, it has the benefit of
still using connection pooling a
I also don't think installation, that only copies dll to GAC, makes much
sense. But if it's not difficult, there can be still two packages,
installation and zip (or whatever) - it is common practice, isn't it? And
yes, ddex-installation automation would be of great importance, because many
guys do
Sorry, didn't see your messages till today :) ,it's okay with nick and name
(doesn't matter really, i don't seek after glory :-D)
--
View this message in context:
http://www.nabble.com/Connection.GetSchema%28%22DataTypes%22%29-tp15850227p15867933.html
Sent from the firebird-net-provider mailin
Hi Jiri,
i found one little bug in table, returned from
Connection.GetSchema("DataTypes"). Firebird type "float" corresponds to .NET
Framework type "System.Single", not "System.Float" as it stays now. Am i
right? At least there is no System.Float at all :)
Regards,
Pavel
--
View this message i
Hi Paul, it is not ExecuteScalar, that is guilty, but you ;) .
Look at this code
fbcommand.ExecuteScalar().ToString().Trim()
think about it - if there is no procedure with such name, null will be
returned. And now you try to call null.ToString(). Sure you get exception.
You should check the re
Jiri Cincura wrote:
>
>
> I don't know. Right now tracker is working
>
>
right now indeed :) ...i left some words, we can talk about it, if find my
suggestions reasonable (or vice versa) :)
--
View this message in context:
http://www.nabble.com/DBConcurrencyException-tp13530573p15083943.ht
Hi Jiri, i cannot access tracker right now, is there any maintenance
scheduled? I try it once more later.
--
View this message in context:
http://www.nabble.com/DBConcurrencyException-tp13530573p15082607.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
Jiri Cincura wrote:
>
> It's because when you specify parth to fbembed.dll, we have to
> generate some small assembly to load it (in normal way it's searched
> in standard paths).
>
sure, but according to the source code comments, it must not be saved to
disk in release
#if DEBUG
// In
Hi Jiri,
i found some funny thing in latest 2.5 build (i made the build against
latest source from svn, but seems to me it concerns also the last build on
your www-page). The problem is - two dlls (DynamicAssembly.dll and
Fb_.dll) are generated in application folder when i use fbembedd.
Acco
Hi Jiri,
i found one little mistake in GetSchemaCommandText() function of
FbDataReader (i downloaded source and binary just few minutes ago)
so, we have following sql statement
SELECT
fld.rdb$computed_blr AS computed_blr,
fld.rdb$compu
Jiri Cincura wrote:
>
> We're only people. :) Please create a ticket in tracker. I'll solve
> this tonight. Thanks.
>
Sure, i have no objections :-) , i didn't know that this method doesn't work
either, because i never used it, i always did just the same manually,
changed dbname, and reconnecte
Hi Jiri and Carlos, i found one little error in FbConnection.ChangeDatabase
(at least in 2.5.0 alpha1)
here is the code
try
{
FbConnectionStringBuilder csb = new
FbConnectionStringBuilder(this.connectionString);
/* Close current connectio
I've got confirmation, that SqlDataAdapter do throws DBConcurrencyException
when all row updates fail in ContinueUpdateOnError=true mode, and erroneous
rows are not committed (RowVersion remains Modified).
--
View this message in context:
http://www.nabble.com/DBConcurrencyException-tf473195
Jiri Cincura wrote:
>
> On 11/2/07, paha <[EMAIL PROTECTED]> wrote:
>> Correct, but i would like to get from provider original localized
>> messages
>> for standard exceptions like concurrency to identify the exception
>> itself,
>> not to show it d
paha wrote:
>
> Could you give me direct link to bugtracker please :)
>
I found it
--
View this message in context:
http://www.nabble.com/DBConcurrencyException-tf4731950.html#a13544215
Sent from the firebird-net-provider mailing list archive at N
Jiri Cincura wrote:
>
> On 11/2/07, Carlos <[EMAIL PROTECTED]> wrote:
>> putting them into the tracker will be the best.
>
> OK. Please, Paha, can you put every single problme into tracker, with
> description (try to use as much as possible info from this thread,
&g
Jiri Cincura wrote:
>
> On 11/2/07, paha <[EMAIL PROTECTED]> wrote:
>> You are 100% right, i asked the same questions yesterday on russian forum
>> to
>> know, how sqladapter performs, but still no response. What i can say for
>> sure, if you get DBConcurr
Jiri Cincura wrote:
>
> Oh, now I understand. I was almost sleeping, so I was thinking wrong.
> So the main idea behind this is, "when I get error, let the row
> untouched (without AcceptChanges) so I'll be able to repeat the call
> to DB", right?
>
Bingo :)) . I don't know if SqlDataAdapter do
Carlos Guzmán Álvarez ™ wrote:
>
> Hello:
>
>> This may be not big problem to change. If there's no objection, I can do
>> this.
>
> We should echeck what is being done by Sql Client if possible, and do
> the same thing.
>
You are 100% right, i asked the same questions yesterday on russian fo
Concerning the second part of my suggestion. Of course i can achieve desired
goals by setting AcceptChangesDuringUpdate= false and then after Update
looping throw rows committing "good" rows, and leaving "bad" rows aside. Of
course it would mean one extra loop for me what is not a problem for smal
Jiri Cincura wrote:
>
>> One more little question, also about this Exceptions. What do you think
>> about throwing localized messages? (I mean storing once (new
>> DBConcurrencyException()).Message, (new DataException()).Message and so
>> on
>> somewhere in local dictionary, and using them inste
Jiri Cincura wrote:
>
> On 11/1/07, paha <[EMAIL PROTECTED]> wrote:
>>
>> I've also read an interesting remark to DBConcurrencyException in MSDN
>>
>> When performing batch updates with the ContinueUpdateOnError property of
>> the
>> DataAda
I've also read an interesting remark to DBConcurrencyException in MSDN
When performing batch updates with the ContinueUpdateOnError property of the
DataAdapter set to true, this exception is thrown if all row updates fail.
In this case, this DBConcurrencyException contains DataRow objects for all
Hi, there is following code in provider (at least in the version i have, it's
possibly not brand new but i updated it not so long ago)
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new DBConcurrencyException("An attempt to execute an INSERT,
UPDATE, or DELETE sta
Jiri Cincura wrote:
>
> It's not possible. Embedded version is not listening for network
> connection.
>
i believe you, that's why i was surprised, but I'll try it on weekend again
--
View this message in context:
http://www.nabble.com/Visual-C--and-Firebird-embedded-database-connection-fail
Dean Harding wrote:
>
>> i mean it works whether i write 127.0.0.1:c:\my.fdb or c:\my.fdb
>> , i'm eager why :-) ?
>
> Do you have a firebird server running as well? If you specify
> 127.0.0.1:c:\my.fdb then you'll be connect via the server (the fbembed DLL
> can act as a regular network client
build the connection string with FbConnectionStringBuilder. Set
FbConnectionStringBuilder["ClientLibrary"] =
PathToFbEmbeddDLLIncludingFileName (try it with and without extension, for
me works without)
2 Jiri
Have one question about embedded, suprisingly this "First is the necessity
to connect t
Andre, check that fields, containing those memo records, also use win1252
and don't forget about collation, it should be PXW_INTL850, not win1252 ,
because you will have wrong sort order with umlauts ;-)
--
View this message in context:
http://www.nabble.com/unexpected-problem-with-Euro-sign-
Ok, i think i understand :-) (i didn't look in provider code, that's why i
could only make guesses) - if i understand the provider only "provides"
schema to FW, and it makes the rest, so if you set IsKey - FW knows - the
column belongs to PK (and there can be only one PK in table). If you set
IsU
maybe i don't understand what is made behind the curtain, but ... when
provider populates schema for table, it checks if primary key for the table
consists of 1..x fields (if any pk at all :-) ), and creates an array of
DataColumn for the PrimaryKey property of DataTable, doesn't it? Could he do
j
Jiri Cincura wrote:
>
> I hope for commiting these statements before running test with provider.
> :)
>
I did this either ;-) , i'm eager if you can reproduce this issue. It is not
critical, actually, one can just add complex index with unique flag, that
will do the job, but ... if i already o
I've done everything in IBexperts, i mean, i created test table, added
constraints and filled it with test data, tested if constraint works as
supposed. After that i just copied first table structure and then data to my
post. So the described bug has nothing to do with commits. Of course they
sho
I've tested, doesn't work either
the code
FbConnection conn = new FbConnection(Db.ConnectionString);
FbCommand comm = new FbCommand("select * from test", conn);
FbDataAdapter da = new FbDataAdapter(comm);
da.MissingSchemaAction = MissingSchemaActio
ok, i test the case with Fb - classes and send result
--
View this message in context:
http://www.nabble.com/Unique-Constraint-Bug-tf3637383.html#a10158235
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-
Jiri Cincura wrote:
>
> da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
> This is doing wrong job. :)
>
Why? Worked always for me, without this there are no constraints at all. Is
there any option to this?
Jiri Cincura wrote:
>
> Can you try this with MS SQL? I don't have here VS t
Jiri Cincura wrote:
>
> How are you creating DataSet/DataTable? Is created from design-time?
>
no, just in runtime, but i use common types (can it be problem? i will test
it without common types)
DbTransaction Transaction = CreateTransaction(); //Here will be returned
FbTransaction
DbCommand c
Hi, can anybody confirm such bug???
.net Provider 2.1.0.0 beta3
Create test table
CREATE TABLE TEST (
F1 INTEGER,
F2 INTEGER
);
ALTER TABLE TEST ADD CONSTRAINT UNQ1_TEST UNIQUE (F1, F2);
Fill it with data
INSERT INTO TEST (F1, F2) VALUES (1, 1);
INSERT INTO TEST (F1, F2) VALUES (1,
Just load all needed tables into DataSet or DataTables and assign them as
datasource with SetDatasource method of Crystal Report ReportDocument in
runtime, for design time you can use ODBC connection as model for table
structure
--
View this message in context:
http://www.nabble.com/How-can-I-c
Hi, sorry if i'm missing something
I try to run for example 18000 inserts. If i make it with FbBatchExecution,
it takes appr. 100 seconds
If i add the same 18000 rows to DataTable and then just save it with
FbDataAdapter.Update, it takes near 30 seconds. Is it normal behavior? I
thought, FbBatchEx
Trofimich wrote:
>
>> Use IDataAdapter's RowUpdated event.
>
> Did you use ADO.NET 2.0? Maby i'm stupid but i can't find even something
> similar there...
>
> I want to make form for editing table. I connected to database and
> generated DataSet, BindingSource and TableAdapter.
>
> Now i ne
Trofimich wrote:
>
>
> Generally you can inhetit strip elemets, but you can't change them in
> inherited form, so for me this equal to feature absence.
> And you CAN'T CHANGE BindindNavigator and DataGridView too.
>
> So at list:
> MonuStrip disabled
> PopupMenuStrip disabled
> ToolStrip disa
Trofimich wrote:
>
> PS Do you know that Visual Studio 2005 does not support visual
> inherirtance for .NET 2.0 controls such as DataGridView? This future
> worked since Delphi 2 and VS 2003 and i thought it works in VS 2005 but
> no, microsoft decide that we can make all changes manually!!!
Ok, i tried it with newer version 1.5.3, it survived 3-4 shutdowns/onlines,
and i switched off Database restart during debugging, so hope the problem is
partially solved. really looking forward to firebird 2.0 version.
Thanks, anyway
--
View this message in context:
http://www.nabble.com/Databa
Hi, it's not actually a problem of FirebirdProvider, but i had a hope, that
some experienced users could help me (please please)
So, i make Database Shutdown/Online using FbConfiguration with "Forced"
Paramater - i do it to update some metadata like Foreign Keys and avoid
"object in use" message.
If i've got what you mean, you should run this query with
FbCommand.ExecuteScalar
"select gen_id(my_global_generator_name,1) from rdb$database"- you will
increase the generator value by 1, and get this new value at client
--
View this message in context:
http://www.nabble.com/How-to-get-Generat
Hi, why not implementing this functionality in your DataLayer class? You can
pass string or StringBuilder or better own SqlScript class to method, that
will split it into separate queries, establish connection get all the tables
and return either list of DataTables or DataSet or fill DataSet, pass
>It makes perfect sense, the exact same query would work as expected (i.e.
>you'd get three DataTables inside your DataSet) on SQL Server.
>It would only provide (noticeable) benefit if you're running Firebird in
>server mode, though. Executing your query like that, rather than three
>separate co
P.S. Sorry, my fault, better would be the information about all
FbTransactionOptions Flags, IsolationLevel has less options
--
View this message in context:
http://www.nabble.com/IsolationLevel-info-needed-tf2514021.html#a7011418
Sent from the firebird-net-provider mailing list archive at Nabbl
Hi can anybody please share a link to documentation with description for all
possible IsolationLevels in FbTransaction of .NET FirebirdProvider 2.0.1
--
View this message in context:
http://www.nabble.com/IsolationLevel-info-needed-tf2514021.html#a7011281
Sent from the firebird-net-provider mail
Hi pal, you are really in the wrong place here, next time ask such questions
here http://www.gotdotnet.com/Community/MessageBoard/MessageBoard.aspx?ID=6
or here http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=8&SiteID=1,
there are a lot of places for newbies to ask their question
But pleas
>Strange, did you have a single version of the provider installed and
>configured in the machine.config right ??
Usually i get only dlls from http://netprovider.cincura.net/, last time i
got full installation of 2.0.1rc2, so i uninstalled previous version, and
installed the new one.
Registry and
>This looks as working fine for me:
>
> DbProviderFactory DbFactory =
>DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient");
> DbConnection con1 = DbFactory.CreateConnection();
> FbConnection con2 = (FbConnection)con1;
I just checked it again, st
It's definitiv a Problem of machine.config file, my friend had the same
issue, i cannot say now what exactly was wrong, but something like Public
token, anyway - that was the reason why
--
View this message in context:
http://www.nabble.com/install-problems-tf2426217.html#a6770487
Sent from the
Hi, i found the following Problem
it аpplies to FbConnection, but maybe also to other Objects, i didn't
tested, so:
two cases
1)
DbConnection con1 = FirebirdClientFactory.Instance.CreateConnection();
FbConnection con2 = (FbConnection)con1; // works just fine
2)
DbProviderFactory DbFactory =
DbP
>You can write your own class, which will encapsulate some DB-specific but
>little bit generic procedures (like doing backup, etc.). This allows you to
>make your SW independent on specific classes, you will only change the
>internals of encapsulating class. It's a widely used "solution".
So i
Hello:
Thanks for the answer
>That, the Services api, the isql support, etc .. are Firebird Specific
>features that is the reason
>you can't use the DbProviderFactory ( that is a base class ) to create
>them.
I knew that :-D, but i wanted to have my thoughts confirmed by somebody like
you :-
Hi, have some questions, may be somebody can help :-)
As I understand the usage of DbProviderFactory instead of using FbObjects to
create connections, commands and so on, makes the code more common and make
it possible to quickly change the provider if necessary without code
changes. But there are
I also had this issue with getting error when restore follows backup - the
only solution i found, that seems to me better than Thread.Sleep is to set
in FBBackup Object .Verbose = true - that will slow down the process, but
will ensure, that to the moment of restore call, backup has finished his j
Hi, is it possible to stop/start remote firebird service with means of
Firebird .NET Provider?
--
View this message in context:
http://www.nabble.com/Restart-FB-Service-tf1883018.html#a5147464
Sent from the firebird-net-provider forum at Nabble.com.
Using Tomcat but need to do more? Need to s
Got some information, maybe it can tell something
1) with FbParameter it works
2) it works also with simple SQL-Query if table has an index on the field in
"where" clause
in other cases it doesn't seem to work for me
--
View this message in context:
http://www.nabble.com/Charset-t1548735.html#a4
>>Looks as working fine for me using Firebird 2.0 RC 1 ... huummm ...
I've tried it with older versions of FB Provider, but ...never mind, should
be some stupid system issue
>>can you do a test using parametrized queries ??
i can try, this problem isn't important on the current stage of my
devel
Hi,
>Please can you send a test case to my private email ??
Done
--
View this message in context:
http://www.nabble.com/Charset-t1548735.html#a4276765
Sent from the firebird-net-provider forum at Nabble.com.
---
Using Tomcat but need to do
I was supposing something like that ;-)
So, if you have integer field (i hope smallint) , add
DataGridViewCheckBoxColumn and assosiate it with this Field - that should
work just fine out-of-the-box. For me works :-)
Even if you have had strings like "Yes" and "No" - you could handle
Cellormating
If I understood you correct, you should retrieve DataTable as always and then
just convert the integer value of the field with Convert.ToBoolean(object)
I'm pretty noob, so i'm not sure if i may advise you but...
I usually do so
public static class DBConvert
{
public static bool isNu
Sorry for previous POST, got it in HTML without
Hi, need help, i'm s stupid, but i can't solve it:
I have next function to execute SQL command
public bool ExecSQL(string SQL)
{
bool result = true;
try
{
if (m_fbConnection.State ==
Hi, i need help, i'm s stupid, i can't solve the problem:
I have next function to execute SQL command
public bool ExecSQL(string SQL)
{
bool result = true;
try
{
if (m_fbConnection.State == System.Data.ConnectionState.Open) m_fbConn
74 matches
Mail list logo