of freshly inserted records working.
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49 2389
I don't see my posting from this afternoon, yet.
Nevertheless, don't bother, please.
Maybe you know the feeling that testing something strange for days and
days won't bring you further, you ask someone for help - like I did
with this list this afternoon - and then you suddenly have the idea
I am facing a issue in connection of Firebird database which is
kept in a shared drive. Physically I am able to access the file and
it has full permission for read/write.
Can you give more details please?
What character has the issue?
What did you try so far and what does not work as
/233429-ado-net-provider-for-firebird-4-0-0-0-is-ready/
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240
Yes.
Are you creating the FbDataAdapter in code?
--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and
the
FbDataAdapter derives from. I don't know a place where this casing
etc. in FirebirdClient would happen.
On Wed, Oct 2, 2013 at 10:47 AM, André Knappstein
knappst...@beta-eigenheim.de wrote:
Yes.
Are you creating the FbDataAdapter in code
Hi Gang,
this is probably something WAD / inherited, but nonetheless it is
undesirable and I'd like to know if there is something one can do to
avoid it.
I was helping a company to move from dBase/DBF to C#/Firebird, but
their IT already made a migration of the huge DBFs to Firebird.
to be interesting for real
business use, and of course I'd like to provide my colleagues with a
mobile subset of our application.
André Knappstein schrieb am 17.07.2013 um 17:31 (+0200):
Before I start writing apps for Windows Phone 8, can anybody
confirm that I can use FB Embed
@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
said that life as a developer has to be free
from obstacles all the time, and if you never change anything you
won't ever improve something.
best regards,
André Knappstein
Hi *,
maybe you remember the thread Releasing more often???. Yeah and
nothing happened. :) Because
from the pool.
best regards,
André Knappstein
--
Try New Relic Now We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics
://lists.sourceforge.net/lists/listinfo/firebird-net-provider
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49
);
}
Hello everyone
I have a question, when using the fbbackup on .net have a way to
know if the backup was completely sucesfull???
And wirh fbreatore??
Enviado pelo meu Windows Phone
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
On Wed, Jan 23, 2013 at 2:18 PM, André Knappstein
knappst...@beta-eigenheim.de wrote:
If my opinion also counts:
Maybe better to comment in tracker, because this email is from tracker.
Yes-Sir! As soon as I find out where and how this works :-)
mit freundlichen Grüßen,
André
What is the problem? I don't see an actual problem described in your
message.
Let me help you :-)
The dialog is closing at once when any input is made in any entryfield
or textbox. So you can't specify any connection details.
This *also* happens when using the correct MSI installers, *if*
On Tue, Nov 20, 2012 at 6:29 PM, André Knappstein
knappst...@beta-eigenheim.de wrote:
It turned out that MS moved XML stuff around libraries and so you
will get completely another exception instead of the expected
FBException.
???
ahem...
I will try to reproduce it again
On Wed, Nov 21, 2012 at 10:19 AM, André Knappstein
knappst...@beta-eigenheim.de wrote:
As far as I understood this is because MS has put the classes required
for Extension into another namespace in 4.5 than it was in 4.0
I don't think MS did that. It would break the application even from
No. not using *any* RAD tools in addition to what is offered by
.net/C#/VS
Are you using DevExpress XPO ?
I had a similar problem, because FbErrorCollection does not implement
ICollection.
--
Monitor your
... and you have to download appropriate build.
Aah! Ye! Now I see...
This posting also helped me find one thing I chased without success
the whole day.
I blindly installed the new 3.x provider on each machine.
Using only .net 4.0 - and not the current 4.5 - I also have
I noticed a change which I did not read about before.
Maybe I missed it, maybe it was not announced.
My last installed version was 2.6. on most seats, 2.75 on some.
If Role = (empty string), the connection string now is invalid.
I will have to roll back to 2.6 for now, because I will first
;
Connection timeout=15;
Pooling=True;
Packet Size=8192;
How the complete connection string looks like?
On Mon, Nov 5, 2012 at 12:14 PM, André Knappstein
knappst...@beta-eigenheim.de wrote:
I noticed a change which I did not read about before.
Maybe I missed it, maybe it was not announced.
My
connection string looks like?
On Mon, Nov 5, 2012 at 12:14 PM, André Knappstein
knappst...@beta-eigenheim.de wrote:
I noticed a change which I did not read about before.
Maybe I missed it, maybe it was not announced.
My last installed version was 2.6. on most seats, 2.75 on some.
If Role = (empty
to empty. So this might indeed be your problem.
-Oorspronkelijk bericht-
Van: André Knappstein [mailto:knappst...@beta-eigenheim.de]
Verzonden: maandag 5 november 2012 14:48
Aan: For users and developers of the Firebird .NET providers
Onderwerp: Re: [Firebird-net-provider] Empty
Hi Gang!
Using Provider 2.6.0, I played around with FBBackup/FBRestore and it all works
very good. Thanks for all the good work Jiri, Carlos and others!!
I did not understand, though, how I can get some output or feedback from the
backup/restore processes. On calling execute() the process
If this is something known, can somebody please point me to relevant
discussions, or if this is unknown, can you tell me what info you
would need from me to analyse this?
JC It's expected. Look at this list archives to find some related threads.
OK, found some time to search the archives;
Hello,
now I successfully ported our project from .net 2.0 to .net 4.0.
I am using provider 2.5.2.
I have something strange, though.
When I'm reading data from a firebird database (Server 1.5) and the
field type is Time, I get an error when using a data adapter to fill
a table with a datacolumn
JC On Mon, Sep 13, 2010 at 16:09, André Knappstein, Controlling
JC knappst...@beta-eigenheim.de wrote:
System.StackOverflowException
JC Do you have a stack trace for it?
Sorry for coming back to this so late.
No, unfortunately right now I can't seem to get one.
I have deleted the first
excuse the signature following below...
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49 2389
k select userinfo0_.id as x0_0_
k from user_infos userinfo0_
k where (@p0 in(select views1_.View_Id from User_Views_Map views1_
k where userinfo0_.id=views1_.User_Id))
I have such an idea, that you cannot use a dynamic parameter at this
place. But I can be wrong.
k note 2: if i do the query
can connect.
We had this issue on several machines in the last weeks.
mit freundlichen Grüßen,
André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon
For what it's worth, I am making excessive use of parameters with type
Decimal, and I am experiencing _no_ problem at all.
I am in the process of eliminating the last non-Firebird portions of
databases our softare is based upon and only then will I be able to
migrate from 1.5.x to the current 2.x
I would second what Jiri wrote.
We have been using 8859_1 widely. This works okay with ODBC.
Using .net, some things did not work correctly. Or rather they worked
correctly but not as we expected :)
ISO8859_1 does - for example - not really specify a solution for
displaying the Euro symbol (€).
databases are still on FB 1.5 due to technical limitations of the
old programming tools. Only recently I converted another big part over
to C#/.net and will hopefully be done completely this summer.
ciao,
André
--
~~~Ihre Nachricht~~~
JC On Thu, Jan 7, 2010 at 16:54, André Knappstein
I don't know if the following method really is better, but it's worth
a try, because from old school I would rather not create and destroy
too many objects unnecessarily.
Dbcmd = Dbconn.CreateCommand();
Dbcmd.Transaction = Dbtrans;
Dbcmd.Connection = Dbconn;
Dbcmd.CommandType = CommandType.Text;
Hello together,
this is the first real problem I have with .net provider for more than
2 years; great work! Thanx!
But this one is really scaring me.
I get an FBException arithmetic exception, numeric overflow or string
truncation, suddenly.
And I only get it in .net using provider 2.0.1, the
Hello,
also check out this link:
http://www.firebirdsql.org/dotnetfirebird/blob-reading-example-csharp.html
It is for C#, but the principle is the same and you should be able to
transfer it with very small changes to VB.net
ciao,
André
~~~Ihre Nachricht~~~
tgc dear All,
tgc i want to insert
Hello Steve,
join InvoiceDetail d ON (d.InvoiceID = :InvoiceID)
join InvoicePayment p ON (p.InvoiceID = :InvoiceID)
where (i.InvoiceID = :InvoiceID)
Are parameters supposed to work that way in ADO.net??
I always use @ for a parameter identifier instead of :
regards,
André
Hello Helen,
HB FYI, we have very few people (all volunteers) trying to
HB manage a large number of lists and it is a time-consuming and
HB THANKLESS task.
this cannot go uncommented, I think. I do know about what you're
talking there, because I made the same experience in other fields,
where I
of
indexing was sometimes necessary to make acceptable orders, Firebird
is sometimes indeed performing better withOUT an index.
- Did you probably put different indexes on the same field? Such could
make the plan-optimizer in Firebird just go crazy.
--
Mit freundlichen Grüssen,
André
and to specify
the same CS in your connection.
Try that and see if it helps. I do have a lot of special characters
and have no problems using Win1252 on both sides.
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta
clients, I guess.
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
Hafenweg 4
59192 Bergkamen-Rünthe
Durchwahl: +49 2389 9240 140
results to
you tomorrow. I will be setting up something using the good old
employee.fdb.
If it works, I will send the project to you by e-mail.
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
Hafenweg 4
server.
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
Hafenweg 4
59192 Bergkamen-Rünthe
Durchwahl: +49 2389 9240 140
~~~Ihre Nachricht~~~
AC Hello André,
AC My Fb server is 2.0.1 and I'm using
what you want and need is a (new?) property NOT_NULL_SET which
could result to false for the column while is_nullable still _CAN_
return false because of the underlying domain.
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
Hello Jiri,
Maybe what you want and need is a (new?) property NOT_NULL_SET which
could result to false for the column while is_nullable still _CAN_
return false because of the underlying domain.
JC Isn't this just negation of is_nullable? BTW in schema table are some
JC well-known columns so
Now when ever more than 11 users log in simultaneously on FB the server
crashes. The log file generated tell that cannot handle this many uses
at a time.
Even several 100 users should not crash a Firebird server.
Is the application installed on every client machine, or are you
running remote
2.1. BTW no matter wheter you have VS SDK you can use ...Less.reg, isn't it?
3. What about installation. Maybe should provide some no so common
path like %ProgramFiles%\FirebirdClient, 'cause there're *.txt files
with same name from FirebirdClient installation, so during install
some can be
My somewhat restricted knowledge of Firebird internals might lead me
wrong here, but wouldn't you have to run GRANT statements against
the target database, instead of against the security.fdb ???
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und
coming back to that topic, if anybody reading this will try the same.
found out that all stored procedures have to be recompiled, otherwise
there will be transliteration errors.
After recompiling offending stored procs, everything is fine.
--
Mit freundlichen Grüssen,
André Knappstein
Just for confirmation:
I was testing with a backup of several production databases. All
results were the same: changing charset from ISO8859_1 to WIN1252 for
all objects in the database does the trick.
I can then read and write the Euro-sign not only via ODBC and .net for
ODBC and via other
if it is not, which _IS_ a good charset for this?
Thanks in advance
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
Hafenweg 4
59192 Bergkamen-Rünthe
Durchwahl: +49 2389 9240 140
You should use unicode (UTF8) in connection string, on 99% you're
putting data from .NET in Unicode.
Thanks, Jiri.
I will give that a try this afternoon.
But the data was mostly not entered via my .net-application.
-
Damn, I missed, that you're not inserting (but the connection string
should be changed at all). What exception you get?
No problem, because for the nearest future I definitely do plan to
insert data via the (new) .net application. I am doing the latest
tests and now stumbled over that
Now you got me, Jiri :)
I have once and never again used ISQL when I started converting DBF to
Firebird 4 years ago. If I need to use it to make further tests, I
will get the documents and use it.
Carlos' Answer might be helping out as well, thanks.
~~~Ihre Nachricht~~~
JC It's definetely
Thanks for the answer, Carlos.
So, I should use Win1252 and be well? That's not too big a problem.
I have about 300 tables, but most of the objects do not override the
database's charset. Can I change the database's charset by restoring
a backed up db into an (empty) database with another
FBCommand();
fbCommand1.CommandType = CommandType.StoredProcedure;
if (!fbCommand1.Exists) {fbCommand.Recreate()};
What do you think about ???
TIA,
Paul
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
that Paul also has to keep
in mind.
--
Mit freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
Hafenweg 4
59192 Bergkamen-Rünthe
Durchwahl: +49 2389 9240 140
Peter,
not an expert myself, but in your code I am missing a statement like:
daDuePacks.SelectCommand = FbCmdDuePacks;
so far you are setting the parameter to the command-object, and to the
adapter-object you are just copying the select command text.
Don't know if that is the culprit in your
freundlichen Grüssen,
André Knappstein, EDV und Controlling
Verwaltungs- und Erlebniszentrum Marina Rünthe
beta Eigenheim GmbH
Hafenweg 4
59192 Bergkamen-Rünthe
Durchwahl: +49 2389 9240 140
~~~Ihre Nachricht~~~
PD Thank you André
PD Works perfectly!
PD I don't really understand your
59 matches
Mail list logo
