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
Hi Gang, I don't remember anyone posting this before, so I thought I'd
inform you. I am updating my application to use .net 4 with VS 2010.
Using the conversion wizard (opening a 3.5 or 2.0 project in VS2010),
the wizard is doing changes to code using FB provider, which then
leads to stack
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
MS has put a nasty Easter-Egg into XP/SP3 installations of the latest
generation.
If - during installation of XP-VM - you chose to have the firewall
turned off, the GUI displays the firewall indeed as being off, but
that is _not_ the case.
Turn it on, reboot, turn it off again, and see if you
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
Matthias,
please be kind with me if the following advice is boring for you, but
you mentioned that you are migrating from Access.
I am active in teaching developers how to migrate from dBase DBFs,
which in general have a lot of similarities with Access MDBs.
The biggest mistake I have to
Hello,
you are already CREATING the database using CS NONE.
IBExpert is sometimes using nasty tricks :)
I am not too much expert in that but I made the following experience:
If there is no pressing need to define CS NONE as default for the
database, then it would be good to define one Charset
On my LAN the same code is OK. This issue just happens
on my VPN clients and just with Date/DateTime fields.
Alex,
I must admit that I do not know if the normal client.dll
(fbclient.dll or gds32.dll) still is involved when using the .net
provider.
But I had exactly the same issue as you
myserver:3050 instead of 10.7.0.X from my VPN), so
AC definitely is the OpenVPN server, but for some unknown
AC reason Firebird has issues with it.
AC Regards,
AC --- André Knappstein, Controlling
AC [EMAIL PROTECTED] escribió:
On my LAN the same code is OK. This issue just
happens
on my VPN
issues with it.
AC Regards,
AC --- André Knappstein, Controlling
AC [EMAIL PROTECTED] escribió:
On my LAN the same code is OK. This issue just
happens
on my VPN clients and just with Date/DateTime
fields.
Alex,
I must admit that I do not know if the normal
client.dll
(fbclient.dll or gds32
Jürgen,
reading this I am quite glad that I have not needed this property in
.net provider so far, because I admit it would exceed my comprehension
of FB internals.
Just in case I need it in future, I would like to get an additional
clarification:
Looking at a column which is not nullable
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
, 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~~~
JC On 7/20/07, André Knappstein, Controlling
JC [EMAIL PROTECTED] wrote:
1.)
update
rdb$database
set
rdb
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
Hello Gang,
I am a bit puzzled about a problem which came quite unexpected to me.
It seems that I cannot get our Euro-sign (ALT+0128) through to the
client GUI via the .net Provider.
Database standard for character type fields is ISO8859_1,
Database-fields are ISO8859_1,
Charset of Connection is
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
Paul,
I still did not find a way to reply to this mail-list thingy from
behind our proxy, so I hope this message will get through to you.
The function you wish for does not belong into a command-feature or
new method, but you can easily implement it yourself.
To do that, connect with sufficient
In addition I think I remember that only with classic server engine a
listed stored proc is active already for the next connection to the
database.
JC What do you mean with listed?
If I create a new SP, I will find it then listed in RDB$Procedures.
On ClassicEngine, next user will be able to
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
information to improve my
PD understanding of this?
PD Thanks for your time,
PD Peter.
PD -Original Message-
PD From: [EMAIL PROTECTED]
PD [mailto:[EMAIL PROTECTED] On Behalf Of
PD André Knappstein, Controlling
PD Sent: Thursday, 19 April 2007 6:15 PM
PD To: firebird-net-provider
36 matches
Mail list logo
