Firebird .NET provider team is proud to announce next version of ADO.NET provider for Firebird – 2.6.0.
This version contains various bug fixes as well as new features and improvements. And of course support for some of new Firebird server features. Highlights:
- .NET 4 Client Profile support
- Entity Framework 4 support
- Command cancellation support
- Support for UTF8 filenames
All changes can be found at tracker.firebirdsql.org.
You can download it at http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.6.0/ or http://www.firebirdsql.org/index.php?op=files&id=netprovider.
Thanks to all who helped improving and hunting issues.
Pingback: Firebird News » ADO.NET provider 2.6.0 for Firebird released
Pingback: Tweets that mention ADO.NET provider 2.6.0 for Firebird released | Jiří {x2} Činčura -- Topsy.com
That’s great! Many thanks for that.
Thanks for this new version, I needed it to work with Entity Framework 4
However, I have an issue when I generate a model (.edmx) from my Firebird database: all the columns are detected as primary key and so are generated as Entity key. This of course generates error about the columns not being ‘not null’ and for the generation of the relationships.
I’m using Firebird 2.1.3, VS2010 and .Net 4.0
Thanks in advance for your help.
http://blog.cincura.net/id/230290/#comment-1563
Excellent! I’ve been using the weekly builds for months to get .NET 4 Client Support. It’s great to have it in an official release. Great work!
Thank you cincura.net for your answer. I followed the link you gave me, and followed other links, unfortunately I didn’t understood exactly the answer. I understood it’s a problem on the Firebird Server, isn’t it? Does it mean that Firebird 2.1.3 is too old? Which minimum version of Firebird Server do I need?
For proper model generation you need FB2.5 (at least). For the rest 2.1 is OK.
Thanks,
for providing this provicer.
I’m testing the linux mono version since october.
Since wednesday last week (18 november) my middleware client for firebird did not work anymore.
(I Needed System.Transactions the 4.0.0 version.) This is only in the 2.6.0 version.
After evenings of debugging I discovered that the 2.5.2 version still works.
Maybe it is due to my programming skill maybe it is a bug.
But again thanks for your provider.
Regards Chrsi Gradussen
i can’t use it with a .net 2.0 project (vs 2005) but 2.5.2 works great.
it’s possible to compile it to work also with the runtime 2.0?
thanks
@kk The build for .NET 2.0 is available at download page as well.
Could you please tell me how to install this driver ( 2.6.0.0) into VS2008 and VS2010 ?
I know there are some documents on this issue but they seem to be outdated.
I managed to get it into the GAC, I did update machine.config but using VS there is no way to choose for firebird as my database. Is it a registry setting ? A short but complete guide would be helpfull
I’m struggling for the last 4 hours with it, haha
Leon
Alas,
I did it all. 32 bit + 64 bit, vs2008 and vs2010, import of registry settings for 32 and 64 bit…still no firebird datasource to choose from.
You need to install DDEX. There’s a readme.txt, follow it ***rigorously***, really (I’ve answered way too many questions about it, just because somebody wasn’t actually *reading* it).
It works on VS2010 now.
There was 1 thing not clear to me so perhaps it would be a good idea to add this to your installation guide: ( but it could me me ):
changing %path% in the regfiles to the actual path of de DLL’s ( or else an instruction about where to copy those dll’s to )
Thanks
Leon
I can’t install it into GAC with Windows 7 x64. I also tried using gacutil and got this error “Failure adding assembly to the cache: This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.”
It says “This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.”, I think that’s exactly the reason. Either download build for .NET 2 runtime or install .NET 4.
i also have the problem, i am using visual studio 2005, and i can not use 2.6.0 to reference, but 2.5.2 works well. i think 2.6.0 supports vs 2005. But when i added FirebirdSql.Data.FirebirdClient.dll, there is a error icon above it, and for its properties Runtime, Path all blank. What’s the problem?
Thank you!
Hi from Italy. First steps with EF4. I’ve got some issues with fb2.5 (net provider 2.6.0) vs2010 .net4.0
I’m in trouble with views mapping..after select view object, vs2010 tells me there is no pk in the view
Ok, so I add it by hand. Then it tells me more about missing ConceptualModels and then again Mappings..
I read a lot over the web about that and now I can configure the edmx file by adding some xml code manually. Obviously the problem is updating model from db! Is there a solution ? Is it a my own issue or is it something known ?
Hi again. I’ve read now about #PK_GEN# column’s comment but I guess that’s for tables only…Any help ..?
You need to create PK manually in model. Views cannot have PK. Related info http://blog.cincura.net/id/230207 .
Hi,
I’m trying to use Netfirebird on mono running on linux. But I can’t I downloaded the mono & linux from sourcefourge. When I try to use it the exception was throw:
Unhandled Exception: System.TypeInitializationException: An exception was thrown by the type initializer for FirebirdSql.Data.Common.Charset —> System.ArgumentException: Encoding name ‘iso-2022-jp’ not supported
So, I checkout the last version 2.6.1 from svn an compiled and when I try again to run same error is showed.
The simple application that I wrote to test was:
using System;
using System.Data;
using FirebirdSql.Data.FirebirdClient;
namespace TesteFirebird
{
class MainClass
{
public static void Main (string[] args)
{
string connectionString = “Server=172.25.101.18; Database=banco2; User=admin; password=admin; Charset=utf8″;
IDbConnection conn = new FbConnection (connectionString);
conn.Open ();
Console.WriteLine (“connectado”);
Console.ReadKey ();
}
}
}
The firebird 2.1 is running on linux ubuntu 10.04
I tried to run the client (application above) on openSuse 11.3, ubuntu 10.04 e Mac OS.
I WOULD LIKE TO RUN IT ON LINUX
First of all, there’s no 2.6.1 version, so hard to guess what are you using. Anyway looks like your Mono isn’t up to date, supposing you’re using Mono & Linux build.
Hi,
Sorry! After I try to use the mono & linux build and I can’t to connect I took the source from svn. Because it I talk 2.6.1 (I saw on tracker 2.6.1 unreleased).
I’m using the last version of mono 2.8. on MAC OS X and Open suse 11.3
I Can’t to connect. But I know that it is possible because I saw at jiri blog the connection did on monodroid
Sorry for my English.
I was testing it with Mono 2.8.1 and 2.8.0 on Slackware, but maybe Mac version is missing some charsets. Simply comment out the line in FirebirdSql.Data.Common.Charset.
Gooood!
I comment out each line that result in exception on FirebirdSql.Data.Common.Charset then the build
works on openSuse 11.3 and MAC OS X running mono 2.8.
I connect and list the content from one table. I will test others features.
very thanks!
For proper model generation you need FB2.5 (at least). For the rest 2.1 is OK.
Solution for “Failure adding assembly to the cache: This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.” you should using gacutil.exe build against .NET 4.0, you can find here C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 Tools\ or C:\Program Files\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 Tools\
hope this help.
I’m new to firebird dot net. It hard to install Net Provider 2.6.MSI for VS2008 with help in ddex.zip.
Now i’m install is finish. But charset for me not found. I’m can’t open solution of source with vs2008.
How to add charset TIS620 to Add Connection Dialog ?
Thank You.
Charsets are fixed. You can’t add your own.
I’m running into the same problem as reported here: http://tracker.firebirdsql.org/browse/DNET-274. I’m attempting to create about 5000 records where each of these records has 14 detail records. Even if I create a new context for each master record Firebird runs out of memory. mon$statements table shows thousands of EXECUTE BLOCK entries for the insert. Is there a way to definitively close a connection to clear these out?
Thanks for your help.
The DNET-274 is fixed. So either you’re using old version or you have problem somewhere else. I don’t know why to create context for each master, anyway, if you don’t use pooling, after closing context, the connection is closed too. If you use pooling you can force closing connection(s) calling ClearAllPools.
I confirmed that I am using 2.6. I disabled connection pooling and it works fine. I don’t want to create a context for each master record I was just trying to track down the cause of the memory issue. With pooling turned off I’m able to use a single context for all records.
Thanks for the connection pool tip.
Hello, first I want to thank you for your good work!
Now to my problem
I would like to use the ADO.NET provider in MS Dynamics NAV (I need to connect to a Firebird DB) but I don’t know if i could so. I have searched for similar problems on the internet but didn’t find anything.
When I want to connect to MS SQL server, there is no problem, the connection string looks like this:
ADOConnection.ConnectionString(‘Provider=sqloledb;Data Source=192.168.1.4;’
+ ‘Initial Catalog=CronusNAV5;USER ID=sysdba;Password=passphrase’);
ADOConnection.Open;
where Initial Catalog means Database. There is necessary to specify the Provider parameter. Similarly I can put the connection string for Firebird:
ADOConnection.ConnectionString(‘Provider=?my_question?;Data Source=127.0.0.1;’
+ ‘Database=C:\database.fdb;User=sysdba;Password=masterkey’);
ADOConnection.Open;
But the problem is that I don’t know what I should to specify for the Provider parameter. Without this parameter I get an error message
“The call to member Open failed. Microsoft OLE DB Provider for ODBC Drivers returned the following message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.”
What I did is that I have specified the DSN Data Source Name (in the ODBC Data Sources Manager) named “FBlocalhost” and I simply call this connectionstring:
ADOConnection.ConnectionString(‘FBlocalhost’);
ADOConnection.Open;
and the connection is successfully established but this solution is not too elegant. :-/
I don’t really know how to solve it. Can you help me? Thanks a lot!
Peter
I don’t get it. Why are you using ADOConnection?
I have a problem when using the provider in a SQL Server Integration Project with VS 2008. The problem is that the Import/Export wizard calls cancel when previewing the data and this causes a NotSupportedException to be thrown. I understand that this is because I am running a Firebird instance lower than 2.5, but is there a way to just ignore the cancel call?
A connection object can still be created however, and I am using the .NET provider now instead of FBExport to pump data into our warehouse. Its infinitely more performant and more convenient because of the available meta data.
No, there’s no way to ignore the call. But you can create your own build.