Does one load the dlls that are the providers into c++ the standard way
dlls
are loaded into c++, or are the com (object oriented) and have to be
loaded
a different way, and if so, what way
The Firebird.Net DLLs are .NET assemblies and if you want to integrate them
into a C++ application,
It's not? Even if you keep a 1-1 relationship between threads and
connections (i.e. use a separate connection per thread)?
If you have separate connections for each thread, why bother about
thread safety? Thread safe is about using one connection in multiple
threads.
Yeah, sorry, that's
FbClient is threadsafe, no worries there.
FirebirdClient isn't thread safe.
It's not? Even if you keep a 1-1 relationship between threads and
connections (i.e. use a separate connection per thread)?
Dean.
--
The DPB for embedded on Windows doesn't expect a username and password,
Jiri.
AFAIK, embedded server will simply ignore it. You're able to login
with any username/password.
The empty login and password as signal to try trusted auth is taken
from standard FB tools. For now the trusted auth
I would suggest a new property in FbConnectionStringBuilder to
explicitly turn trusted auth on would be the way to go, otherwise
it would just use whatever it used before?
This is what I was trying to avoid. Yet another connection string param.
I can understand that desire, but I don't
I think, FbBatchScript not support CREATE DATABASE in Embedded Server?
Right. As I said, the embedded server works on database files directly, so
you need to create the database with FbConnection.CreateDatabase. You can
still use FbBatchScript to populate the database with tables and so on.
I can send it to you because I think it will have to be published
somehow (we can do it ourselves) in order to stick with the license, but
I'm sure it won't make sense for most of you... :-(
IANAL, but as I understand the terms, you only need to make your changes
available to the people you
Sven wrote:
Hello,
I will start to develop a multi user windows forms application with firebird
as database and visual studio 2005 as development system.
I use datasets in my application and have problems when multiple users
change data in database.
My question is:
how do you handle the
giorgi giorgi wrote:
2. Yes, there are ascending indexes.
Is it three separate indexes, or is it one index for all of them? The
problem is your SQL statement, it's not the data provider.
You can use the SET PLAN (or SET PLANONLY) commands in isql to work out
which indexes (if any) the optimizer
Sumit Vij wrote:
I am using the latest version of FB client i.e. 2.1.0.0
http://2.1.0.0. By looking the the code, all the handles type are of
type 'int' which will not work on x64. And statusvector is also of type
int which is of type int[].
Am i missing something? Can you point me to the
kixzo wrote:
My question is, how many concurrent connection do the database server
will allow if I want to connect to the database Server using the same
user name and password in the network?
As many as the server can handle. The actual answer depends on lots of
factors (including whether
Sorry, what's the name? Do you have a link?
Dean.
Steve Faleiro wrote:
I have started a new project in SourceForge with the same name.
Regards,
Steve
-
This SF.Net email is sponsored by the Moblin Your Move
Pham Huu Le Quoc Phuc wrote:
Anybody fall into this problem. Please help me.
It's only been a few hours, have patience. Many people on this list will
be asleep at the moment.
In the meantime, I would suggest you try to provide some more
information about the problem you're seeing. As a quick
Pham Huu Le Quoc Phuc wrote:
Thanks for your reply,
When my program catches exception, it gets message property from Exception.
I sure 100% I write correct code because it works OK! on SuperServer.
But when I connect by Embedded(with the same connection string, I just
modify server type),
Pham Huu Le Quoc Phuc wrote:
There's a ctor with TextReader param.
I write a client - server program. At client, user select a script sql file,
my program read and send script to server. At server, I want new FbScript
with ctor parameter is script(not TextReader). I can't pass TextReader to
Pham Huu Le Quoc Phuc wrote:
Thank for your reply,
Please tell me more TextReader?
http://msdn.microsoft.com/en-us/library/system.io.textreader.aspx
And, specifically for your case:
http://msdn.microsoft.com/en-us/library/system.io.stringreader.aspx
Dean.
Jiri Cincura wrote:
On Mon, Jul 21, 2008 at 8:27 PM, Luis Madaleno | magnisoftR
[EMAIL PROTECTED] wrote:
I have just a little question. Why doesn't the |DataDirectory| placeholder
work in the connection string?
Well, because it's not handled by provider at all. :)
I have never used it
Zvjezdan Tomicevic wrote:
I downloaded latest provider (from weekly build)
and it seesm that it is built in VS2008 and targeted for 3.5.
Since I dont have 3.5 on most of my servers, i downloaded source and
targeted it to 2.0 with no problems so far.
Is there any 3.5 specific code in
Jiri Cincura wrote:
On Sun, Jun 29, 2008 at 1:05 PM, Jiri Cincura [EMAIL PROTECTED] wrote:
Has anybody here problem with this?
If there will be no objection till friday, I'll commit the fix.
I definitely think the fix is more important than whatever it might break.
Dean.
Kixzo Database Team wrote:
Hello All,
The problem is that it is taking 3 to 4 seconds to connect with server.
Even I have reinstall it for 3 to 4 times.
Can you show the code you're using to connect, including the connection
string?
Dean.
Rick Roen wrote:
I have just upgraded to a Vista Business laptop and have installed the
.net provider. Now when I try to modify the machine.config to add the
FB provided, I cannot save because access is denied. I have opened a
Windows explorer as Administrator and then opened the
Jiri Cincura wrote:
On 4/11/08, Teymur Hajiyev [EMAIL PROTECTED] wrote:
So, it is not possible to search inside TEXT field???
First, this is question for fb-support list, not for this. Second, why
don't you just try to run command in isql? Third, in FB2+ you can use
txt blobs for some
Mercea Paul wrote:
If I execute this SP in ISQL I get all results as numeric (15,4) but
from c# I get more than 4 decimals (1013,7557642)!
What does your C# code look like?
Dean.
-
Check out the new SourceForge.net
Jiri Cincura wrote:
On 3/17/08, Scott Price [EMAIL PROTECTED] wrote:
You only need to add it to machine.config for your development machines
VS designer's benefit, I believe.
If you wanna to be able to list installed providers, then you need to
modify machine.config.
Actually, you don't
Mercea Paul wrote:
fbcs.ClientLibrary = apppath + @\fb\fbembed.dll; - if I
comment this and copy all needed files to app folder, error disapear
Don't include the .dll on the end of the ClientLibrary just fbembed.
This is cross-platform, and it's .dll on Windows, .so on Linux.
nasim wrote:
i have one question. i work with data provider of firebird and my
program work very well. but when i setup from my project and move to
other pc it doesn't work.
my question is, is it need to install dat provider in every coputer that
it want use firebird database?
You can
Steve Miller wrote:
well, you know, it depends on the test, but I can tell you that I'm getting
much better results out of SQL Server right now, but I'm working on this, my
intention is having a fb backend much faster than anything else... and yes,
I didn't see any different from Express or
Jiri Cincura wrote:
I have a great news for you. :) I've got offer from Paul Beach to
continue with developement of NETProvider as lead and maintaining it
etc. I've accepted and I've got some privileges to do the maintaining
work. So the project isn't dead. I hope we'll kick-up the FB .NET.
André Knappstein wrote:
I am a bit worried, in any case, that you would expect different
results for the 2 cases, because in both cases the column literally
is not nullable.
Maybe what you want and need is a (new?) property NOT_NULL_SET which
could result to false for the column while
Jiri Cincura wrote:
This is right, imo. The NOT NULL work like this:
1. If the domain is not null not null = true
2. If the domain isn't not null, look at the column definition; if the
column definition is not null not null = true
3. Othervise.
So you cannot override not null to null on
John Martinez wrote:
add name=MyConnString
connectionString=
userid=SYSDBA;password=masterkey;database=c:\mydb.fdb;datasource=Localhost;port=3050;charset=NONE;Role=;Connection
lifetime=0;Connection
timeout=15;Pooling=True;MinPoolSize=10;MaxPoolSize=20;Connection
Vladislav Panteleev wrote:
But when I run the application and rise the function many
times per minute I've grtting Timeout exceed exception write on
conn.Open() method rising. I think this because of I havn't
close the connection and garbage collector do not clean the
memory quickly
pablosantosluac wrote:
Hi there!
I'm running stress tests on Plastic with a Fb backend, and as soon as the
server starts attending several clients, we've a huge performance hit! Just
configuring plastic to use SQL Server solves the problem.
Um, what is plastic?
The thing is: I run a
Pham Huu Le Quoc Phuc wrote:
Hi all!
Is there anybody used ClickOnce deployment and firebird embedded? Please
share me anythings.
Because firebird embedded is implemented via P/Invoke, you do need
FullTrust for it to work. That's not impossible to achieve with
ClickOnce, but you've just
Mike Scott wrote:
OK, thanks, I'll take a look. I'm curious, though, what are your opinions
about implementing IQueryable etc. as discussed in the articles here:
http://blogs.msdn.com/mattwar/archive/2007/07/30/linq-building-an-iqueryable
-provider-part-i.aspx
What are the
Yogi Yang 007 wrote:
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.
What is the actual log message that you get?
Dean.
Philippe Schlier wrote:
Creating a Firebird database crashes on some machines with error: This line
returns Value cannot be null. Parameter name: keyword.
Here's the code used:
Dim sConnect As String = GetFbConnectionString(, sDb, , )
FbConnection.CreateDatabase(sConnect)
Carlos wrote:
Hello:
Yes. Dean did great work!
Sure :)
My pleasure :-) I've been using Firebird + .NET provider for a while
now, so it's nice to be able to contribute back.
Dean.
-
This SF.net email is sponsored
Marfonya wrote:
yes ,
I'm working with it (64bit embedded on vista 64)
It work fine butnot at all ...
When triing to get values BUUUM ...
dbDatareader.Read() or getting with datatable doesn't work at all
??? why ???
I have recompiled the net provider in 64bit but nothing
Hi everyone,
So I was playing around with the data provider and the 64-bit version of
2.1 beta 2 embedded this weekend, and I managed to get it to work.
I've got a .zip containing my changes (as applied to the provider
2.5.0-alpha1) here:
harpal singh wrote:
hello all,
we have migrate from ms-sql to firebird2.0(super server)
for .net.but it is very slower than ms-sql.
plz help me
What, specifically, is slower? I'd like to see:
1. The statement used to create the relevant tables indexes (both from
Carlos wrote:
Where do you have downloaded the 64-bit version of the embedded server ??
I ask because i'm seeing the sourceforge downloads and the embedded
server is there only for 32 bit platforms ( unless i'm missing
something )
It was only released in the last couple of days as part of
Carlos wrote:
We well need to review if the actual embedded GDS implementation uses
the correct data types to work against the 64 bit embedded server ( i
will doubt it a lot but ... )
If not, there will be the need of a new GDS for the 64 bit embedded server.
Heh, I just replied to your
Carlos wrote:
I don't know if the problem is specific to the .NET data provider, or if
it's some bug in fbembed.dll itself, though...
I maybe wrong but i think the embedded server for 64 bits will need a
new GDS implementation.
Well, I was just browsing through the code, and I can see some
Viatcheslav Valerievitch Vassiliev wrote:
First tests of ADO.Net on Firebird 2.1 beta 2 for Win64 are successfull.
C# application runs in 64bit mode and executes simple actions
with embedded Firebird. (I rebuilt ADO.Net provider, without changes in
code for tests, may be official
Peter Gissel wrote:
I am using the Firebird .Net driver for database io in Visual Studio 2005
.Net 2.0 C#. I have three different threads accessing data. I keep getting
Dynamic SQL Error Exceptions. The error is fairly random but usually
involves an odd character out of place for a field or
Tao Lin wrote:
Hi,
I am using FB.Net 2.0.1.0 http://2.0.1.0. And I try to use FbCommand
do the follow query: SELECT * FROM USERS WHERE ROLEID IN (10,20)
So my query in FbCommand like this: SELECT * FROM USERS WHERE ROLEID
IN (@ROLELIST)
At first, I try to set FbParameter ROLELIST as
Issue Type: Improvement
Components: ADO.NET Provider
Environment: All
Reporter: Dean Harding
Assignee: Carlos Guzman Alvarez
Priority: Minor
I am proposing that we replace any instances of:
IPAddress addr = Dns.GetHostEntry(hostname
The change is, that you're first doing stuff with DNS and else the IP
direct. Maybe trying first IP (we can expect, that if somebody
provides IP, (s)he's know it and knows what's doing), so we needn't to
check anything else. The possible error in fact will occur during
connection anyway.
if (!IPAddress.TryParse(dataSource, out ipaddress))
{
return ipaddress;
}
Should be:
if (IPAddress.TryParse(dataSource, out ipaddress))
{
return ipaddress;
}
Otherwise, great :-)
Dean.
-Original Message-
Yep, but internally. Then you get back your IP (the IP you provided)
and maybe some others. But this isn't the problem. He has 2 NICs on
client not on server (if I understand).
But that has not been my experience: I have seen it return a *different* IP.
Also, if you do not have reverse DNS set
I've tested this. I provided IP, that definetelly isn't active in my
netwrok and isn't on my DNS. I got result without problems. I can send
you video. :)
Alright. Here is a program that I ran on my computer:
public static void Main(string[] args)
{
string address = args[0];
I have 2 NICs in my notebook too. I don't have this problem. And the
Dns.GetHostEntry() returns (should) for IP the same IP, that's all.
Actually, that's not true. Dns.GetHostEntry() actually queries the DNS
server to get the name corresponding to that IP, and then returns all the IP
addresses
I'll bet you are right, but what does this mean as more and more folks
move to VISTA, will all my users have to have admin rights to run any
software that accesses Firebird embedded? As more and more businesses
are locking down admin rights, our software opportunities will be more
and more
Anybody knows a good reference to implement Linq providers ??
This seems like a good start:
http://blogs.msdn.com/kevin_halverson/archive/2007/07/10/how-to-implement-iq
ueryable.aspx
It's VB but shouldn't be hard to translate :-)
Dean.
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 as well)
And i also heard, that
Microsoft Visual C# codename Orcas Version 9.0 Beta 1
Correct me if i'm wrong but Orcas didn't use the .NET Framework 2.0
right ??
It uses 3.5 but it should be backwards compatible from what I understand.
You can also set it to target 2.0 apps specifically in your project
settings.
Dean.
Download Dependency Walker* and open up fbembed.dll in it. Does dependency
walker give you any errors? If you're running on 64-bit windows, for
example, you need to set your project type to be x86 explicitly, because
embedded firebird does not (yet!!) support 64-bit.
Actually, I'm not sure the
I want to see all the transactions made aginst the datase like:
All the Select, Insert Update, Delete statements with Time.
This is not really a Firebird.NET question, but I think your best bet would
be to use triggers. Whenever a SELECT, UPDATE, INSERT or DELETE statement is
executed, set
One questions remains, though.
If ISO8859_1 is not suitable for that purpose, why have I never been
noticing this before? I mean, why do the other drivers/providers
translate those bytes correctly to a Euro sign?
ISO 8859-1 and WIN-1252 are almost exactly the same, except that where ISO
Anyway, 2 query is needed to get the results. 1 to see if SP exist 1 to
run. Best is to have a stored proc or function to give a true or false
result for me.
But how would that function work if not by making a roundtrip to the
database?
I think Jiri's idea is the best: just try executing it,
I'm using .Net 1.1, Fb 1.5 and Firebird Net Provider 1.7 maybe it works
with new versions?
I wouldn't think so, T and F are not recognised by .NET as strings
representing true or false (i.e. Convert.ToBoolean(T) or
Convert.ToBoolean(F) are what is throwing that exception).
You've got three
Connection string is same charset.
What are you trying to insert, and what do you get back instead?
Also, what code are you using to insert/select?
And finally, what do you see if you use isql?
That should be enough information for us to work something out :-)
Dean.
Connection string is same charset.
What are you trying to insert, and what do you get back instead?
Dean.
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
Which is exactly correct. It's only confusing to those who don't
understand that not all characters/character sets encode characters
with single-byte encodings.
It's confusing because the n represents a buffer size. Even allocating
four bytes you cannot store 1 character because a character
Is é a character?
Yes. And it is a different character from e, ê or è.
Obviously, but the character é can be represented by the single Unicode
codepoint U+00E9 (aka LATIN SMALL LETTER E WITH ACUTE) or by the sequence
U+0065 U+0301 (aka, LATIN SMALL LETTER E, COMBINING ACUTE ACCENT). My
The error happens during application startup, there are many SELECT
from (only SELECT), but I don't know which one, because error message
don't show them. On my development machine, where I can debug, is
everything ok
In that case, I would suggest logging each statement *just before*
Well, we have run our internal tests, and also the profiler, and changing
this code gains 20%, so it doesn't seem to be doing exactly the same. The
old code running through the switch several times, and creating an
encoding object thousands of times too.
Well, I meant the same in terms of
It's a question for me since a long time. If I create a transaction and
just do select statements in it, I'm sure that I didn't change anything
in the database.
I never know wich is best at the end of the transaction commit or
rollback ? Or is just don't matter ...
In general (that is, in
A subquery generated by NHibernate caused a database exception. After
some debugging, I could track down the problem to the .Net-Provider
layer.
You could also try replacing the line:
cmd.Parameters.Add(@p0, 0);
with:
cmd.Parameters.AddWithValue(@p0, 0);
The reason that new AddWithValue
Sorry, I know this is off-topic.
But the address giuliano asioli@tin.it is valid according to RFC822, the
RFC that deals with SMTP and email...
Dean.
-
Take Surveys. Earn Cash. Influence the Future of IT
Join
An attempt was made to load a program with an incorrect format. (Exception
from HRESULT: 0x8007000B)
Firebird embedded on x64 is not supported (on Windows, at least) - yet.
You need to specify in your main application's executable that it should be
compiled as 32-bit (x86), rather than the
Yes, but this will not work with DllImport. It accepts only constant
string as param. And using LoadLibrary will work only on Windows, so for
Linux/Mono it will be out.
You can make it work using Reflection.Emit and dynamically generating the
FirebirdSql.Data.Client.Embedded.FbClient class at
This would probably be easier than using LoadLibrary directly (and
especially GetProcAddress - in fact, is GetProcAddress even callable from
C#?) PLUS it would be just as cross-platform as before!
Oh, I just answered my own question: you can call GetProcAddress in C#,
using the new (in .NET
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Connection string enhancing
Dean Harding wrote:
I'm not saying it HAS to be changed, but it WOULD be a neat feature. If
the
argument is that we shouldn't add new features just because it would
involve
But MS SQL also supports quoted identifiers in and []. I'm using in
my MS SQL databases fields with names equals to reserved words. For
example i have few fields with name Name and i think sql provider will
handle this names correctly.
The fact that quoted identifiers are case-sensitive is a
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dean Harding
Sent: Monday, January 01, 2007 8:09 PM
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] Connection string for embedded firebird
Personally, I prefer the use
I'm sorry to keep bugging you on this but doesn't super-server lock the
database file? If so, doesn't it have the same drawbacks as embedded?
But since super server mode is a server - that is, a separate process to IIS
- there's no trouble. There's only ever one super-server mode server
ADO is built on top of OLEDB, and neither of those technologies have
anything to do with the Firebird .NET provider. ADO and OLEDB are COM-based
technologies (and I wouldn't say they were recommended by Microsoft -
certainly not for .NET development).
The Firebird .NET provider is based off the
My understanding is that Firebird 2.0 implements the full Unicode Collating
Algorithm when your character set is utf8 so my guess is its for that.
Itll be even nicer if it supported customizations per locale of the UCA,
but I guess theres always Firebird 3.0 :)
Dean.
_
The way its implemented on SQL Server is that the caching infrastructure on
the client keeps a connection open to the server, and there's basically a
stored procedure that it calls which only returns when there is a change
notification on the server.
The tricky part is the implementation of the
] On Behalf Of
Dean Harding
Sent: Tuesday, 21 November 2006 2:48 pm
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] FbScript delimiter character
As far as I can see, the FbScript class has the delimiter character
hard-coded to ';'. I assume it wouldn't be too
|string sql =
Select * from Tbl_Lu_Priorities Order By PriorityTitle;
Select * from Tbl_Lu_Statuses Order By Status;
Select * from Tbl_Ma_Users Order By Username;;
DataSet ds = new DataSet();
FbDataAdapter cnAdapter = new FbDataAdapter(sql, cnConnection)
cnAdapter(ds);
That's because firebird is a 32-bit DLL, and your .NET application is
running as a 64-bit process by default. You cannot load 32-bit DLLs into
64-bit processes.
There're two solutions. The simplest is to run your .NET app as a 32-bit
process. This one will work today, and simply requires that you
Even were it possible to do it the way you've written, I would avoid doing
it like that anyway.
The reason is that because the TableAdapter calls will create one connection
each to the database, the TransactionScope call will promote the transaction
from the location transaction manager to MS
85 matches
Mail list logo