Firebird .Net Provider issue

I have been hearing about the Firebird server so our IT department thought it a good idea to test the server firsthand and compare it to our MSSQL servers that we currently use (and pay obscene amounts of money for). So, we downloaded the server, downloaded the .Net provider and downloaded a trial version of the database workbench from upscene.

First, the installs were very seamless and no problems on fire up of the server. Took a few minutes to figure out the registering of the server using the workbench, but found the help docs to be useful. I was even able to import a backup of one of our MSSQL dbs very quickly (matter of minutes). So now I have a database (registered through workbench) and data within it, I have the server running.

Well, I thought it to be wise to start with a VB.net app first and attempt to connect to the db on the Firebird server. Only thing is I'm getting an error when trying to import the FirebirdSql library into the code.

I may be wrong in assuming I had to just install the .Net provider and then start coding away, but if I can't import the library and I can't connect to the db and see how powerful this thing is. I would appreciate any assistance provided. Better yet, if anyone has any online docs on how to get the code to recognize the library using VB.net, that would be superb.

Dear all,

Have you ever configured correctly in Web.config?
What kind of error statements did you get?

Once you have configured your connection string correctly in web.config and added a firebird .net provider reference to your project, you won't see any issues or problems.

I am using MSSQL2000 and FB, and I can tell that you won't see any difference in performance at all. I really love this database server.

- JH

Actually I'm not creating a web app, so I didn't need to configure web.config, but last night I was attempting to add the reference and couldn't find it (it was also two in the morning). But I just checked after your post and added the reference. Appreciate the help. I hope it works as well as I've been hearing about so we can get out from under MSSQL, but I'm always concerned about the security, have you had any security issues?? Thanks again.

Dear all,

Since this FireBird was born from InterBase v6 when Borland renamed its company "Inprise", I am bet FB is very secure to use.

There are so many clients using InterBase as their backend database server, and there are many users using this FB as their server silently....... you will get many answers for your questions from the user group too.

So far, I don't have any security issue at all.
FB also has a good set of documents (PDFs) too.

Thank you.

- JH

I need Firebird .NET Compact Framework Data Provider to access from Pocket PC to Firebird DB