Re: [Firebird-net-provider] integrating net dlls in a c++ application
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, you'll need to use C++/CLI. If you're not already using C++/CLI, you probably want to use the native client library (which is included in the main firebird download package: http://www.firebirdsql.org/index.php?op=filesid=engine) Dean. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] A way to monitor connection state
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 what I thought. I know some DBMSs allow multiple transactions at the same time in one connection, but it's not what you'd call a normal feature... Dean. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] A way to monitor connection state
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. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta
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 isn't done on embedded (I haven't tested whether it works), but I think that (if it works) it must be handled. Because you can have permissions on database objects applied to domain logins. Thus if you don't wanna to fall into trusted auth, you have to specify some username (I think sysdba will be ok ;)). That's the reason why it works like it works right now. That seems backwards to me, though. Shouldn't you have to do something to get it to try trusted auth? I mean, my code for embedded looks basically the same as Paul's, and I would assume that even were trusted auth to be implemented, I wouldn't be using it. 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? You don't want to change the behaviour of currently-working code for no good reason, I think. So you'd have to set fbcs.TrustedAuth = true; in order to get trusted auth - whether in embedded or server... Dean. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta
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 see how you can do it without breaking existing clients (unless you just disabled trusted auth in embedded). Maybe you could make is so that you have to explicitly set the user name to an empty string, as opposed to just not specifying anything? Also, it's not really an *extra* parameter, because you would specify it *instead of* a username/password, if you get my meaning. Dean. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbBatchScript can't CREATE DATABASEin Embedded server
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. Dean. -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] 1.7 FesStatement.Fetch() optimization
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 give/sell your product to. That means if the normal distribution of your product is via a CD, you could just include your modified source on that CD -- you wouldn't have to publish it per-se. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Server Engine`?
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 dataset problem? You mean if user A and user B load the data set and the same time, the user A modifies one row and commits, then user B modifies a different row and commits user B overwrites user A's changes? .NET already has a mechanism to handle that. The steps are, basically: 1. Build and fill a DataSet with data from a data source using a FbDataAdapter. 2. Change the data in individual DataTable objects by adding, updating, or deleting DataRow objects. 3. Call DataSet.GetChanges to create a second DataSet that features only the changes to the data. 4. Call the Update method of the FbDataAdapter, passing the second DataSet as an argument. Check out the documentation for the DataAdapter class (which FbDataAdapter inherits from) for more information. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
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 is choosing to use for your command. So my follow-up questions would be: What indexes are actually on the table? What does the output after using SET PLANONLY say? The things the other guys mentioned (creating one FbCommand and executing it multiple times rather than creating one FbCommand per execution) will help, but I think the bigger problem is in your database, not in your code. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird embedded(ver 2.1) 64 bit support with DotNetFirebird client
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 Fblclient that works on 64 bit platform? I think somebody already mentioned that you'll need 2.5.0 (which is currently in alpha): http://firebirdsql.org/index.php?op=filesid=netprovider However, I've been successfully using 2.5 in production for a while now without issues (I don't use any of the more esoteric features where bugs are probably more likely, however..) Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] concurrent connection
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 you're using SuperServer or Classic Server, how much memory you have, how you've configured the server, etc, etc). Also, there is no difference if all connections use the same username/password or if they all use a different username/password. The username is only used for authentication/authorization. The server doesn't treat connections with the same username any differently to connections with a different username. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enterprise Library for Firebird
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 Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider . - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded
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 guess, I'd say this is something to raise on the .net provider list, but you'll need to include some more information first. For example: 1. What does the stored procedure code look like? 2. What does your C# code that is catching the exception look like? 3. What does the message display as when it works (from SuperServer) 4. What does the message display as when it does not work (from Embedded) UTF-8 *is* unicode, so your assertion that UNICODE and UTF-8 are somehow different does not make sense. UTF-8 is one method of encoding unicode and I'm assuming when you say UNICODE you actually mean UTF-16. Additionally, string in .NET are opaque data structures -- there is no such thing as a UTF-8 string or a UTF-16 string in C#. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [firebird-support] Not convert to UNICODE in Embeded
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), message of Exception still UTF8. In my opinion, this bug in Firebird .Net Please include a sample of the messages you get from SuperServer and from Embedded. As I mentioned in the last email, there is no such thing as a UTF-8 string in .NET -- strings are opaque. It is possible that .net provider is interpreting the encoding incorrectly and you end up with garbage instead, but I would need to see samples of the strings to confirm. Also, on including samples of your code -- it's not about whether you've written correct code or not, I do not doubt you. However code samples help the developers to reproduce the problem themselves much more simply than just a vague description. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions?
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 server. Um, you need to look up the documentation for TextReader. It's exactly what you are after. 3. Function: RemoveComments(string source) of Fbscrip should change from private to public. I want remove commmends on script without init FbScript Reason? The source code for FbScript is available, if you need your own version, just use it. You can't make every method public just because someone, somewhere, might one day want it. You'd be creating a maintenance nightmare for yourself. Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions?
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. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ConnectionString and |DataDirectory|
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 before, and I don't even remember anybody asking about it in list. Do you know any documentation about this? I have no problem to implement it, but I need to see some behavioral description, preferable from msdn etc. It was introduced in ADO.NET 2.0. I think it'd definitely be a nice-to-have. Documented here (about half-way down): http://msdn.microsoft.com/en-us/library/ms254500.aspx You can see how it's implemented by SqlClient using reflector on the System.Data.Common.DbConnectionOptions class's ExpandDataDirectory method. I believe the main point is that it uses the AppDomain.CurrentDomain.GetData(DataDirectory) method call to set it up correctly based on the kind of application (that is, ASP.NET sets that value to be the App_Data folder automatically). Dean. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] 2.5.0.0 provider and framework 3.5
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 provider? There is, but only if NET_35 and ENTITY_FRAMEWORK are defined. I presume when 2.5 is released, there'll be two versions: one for .NET 2.0 and one for .NET 3.5. Or maybe two separate DLLs? I'm not sure what the maintainer's plans are. Dean. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Possible breaking change for bug fix DNET-167
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. - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Regarding connection speed with .Net
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. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] access denied to Vista machine.config
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 machine.config from here, but no go on the save. You need to run notepad (or whatever you're using to edit the machine.config) as Administrator. The easiest way is to right-click on the Notepad shortcut in the start menu, choose Run as Administrator and then use File-Open... to open the machine.config. Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Unicode Text search
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 operations, but only items that fit varchar(32k): create table abc (t blob sub_type text); insert into abc values ('abcba'); commit; select * from abc where t like '%c%'; PLAN (ABC NATURAL) By the way, while that may be *possible*, I wouldn't ever recommend it. You're much better off going with Lucene.NET or something like that and allowing for full-text searching. Dean. - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Where from I get so many decimals?
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 Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird DBFactory
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 *have to* add it to the machine.config. Adding it to machine.config just gives you global access to it (i.e. from any application). If you only have one application, you can just add it to your application's local app.config: configuration system.data DbProviderFactories add name=Firebird Data Provider invariant=FirebirdSql.Data.FirebirdClient description=.Net Framework Data Provider for Firebird type=.../ /DbProviderFactories /system.data /configuration That has the added benefit of not requiring admin privileges to install as well :-) Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] I get Error when I specify ClientLibrary for embeded FB2.1
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. Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] (no subject)
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 just copy FirebirdSql.Data.FirebirdClient.dll into your application's directory. There's no real *need* to install it into the GAC. Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird scalability under heavy load
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 no-express... Are you sure it only uses one processor? According to Microsoft's documentation, Express supports up to 1 CPU. http://download.microsoft.com/download/4/2/c/42c6af76-a28c-4560-8269-e8fe906ea675/SQLExpressdatasheet.pdf Of course, one CPU doesn't mean 1-connection-at-a-time... My guess is you'd still need a fair number of simultaneous connections before one CPU became the bottleneck. Don't forget also that if you're running Firebird in Superserver mode, it'll only make use of one CPU as well. Still, comparing database performance *in general* can be tricky. Some databases are better at some workloads than others, and vice versa. All you can do is compare them on the *particular* load your application creates. That does not (necessarily) mean your results are valid under ALL workloads. Having said that, there's certainly no harm in doing the comparison. Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] OT: Project continuation
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. :) Bam! You were certainly the logical choice :-) Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Bug in FbConnection.GetSchema(Columns)
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 is_nullable still _CAN_ return false because of the underlying domain. I think the problem here is all the double-negatives :-) So let's get this straight... A column is nullable by default, so if you don't specify anything at all, is_nullable should be 1. HOWEVER, if you specify NOT NULL on *either* the domain *or* the column, is_nullable should be 0. I hope we can all agree on that, at least... Now, whether that is actually the case, is something that I think we need to test. But I don't have a test environment on which I can test this right now :-) Dean. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Bug in FbConnection.GetSchema(Columns)
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 not null domain. I guess the question is, though, is that the behavior of Firebird server? Obviously, GetSchema(Columns) should be returning whatever Firebird *actually does*. I agree that the way you describes makes the most sense, though :-) Dean. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection Pooling Options With Firebird
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 Lifetime=5;dialect=1;Packet Size=8192;server type=0; providerName=FirebirdSql.Data.FirebirdClient/ I would suggest you remove the connection pooling stuff from the connection string. Connection pooling is on by default, and the default parameters have been chosen to provide the best results in most situations. The simple code below is similar to what I'm calling to open / close a connection when needed: procedure Ttest.Page_Load(sender: System.Object; e: System.EventArgs); var conn : FirebirdSql.Data.FirebirdClient.FbConnection; begin // TODO: Put user code to initialize the page here conn := FirebirdSql.Data.FirebirdClient.FbConnection.Create; conn.ConnectionString := System.Configuration.ConfigurationManager.ConnectionStrings['MyConnString'].ToString; conn.Open; Response.Write ('Connection openBR'); Response.Write ('Connection Pools Count = ' + conn.ConnectionPoolsCount.ToString + 'BR'); conn.Close; Response.Write('Connection closeBR'); Response.Write('Connection Pools Count = ' + conn.ConnectionPoolsCount.ToString + 'BR'); Assuming you do an actual database call between the open and close, then yes, that is the correct way to be doing it. Dean. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] (no subject)
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 enought, but I can't to rise conn.Close() You should never rely on the garbage collection to close database connections! before I return reader. So what should I do to solve this problem? If you pass CommandBehavior.CloseConnection to the ExecuteReader() method, then the FbDataReader will automatically close the connection when you call it's IDispose.Dispose method. So you can do something like this: using(FbDataReader reader = getReader(blah)) { // Use FbDataReader here } // On this line, FbDataReader will automatically close the connection Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird scalability under heavy load
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 query which takes X seconds to complete. Well, two threads doing the same in parallel takes 2xX which doesn't look like a good scalability factor. Do you know the queries it is trying to execute? Can you execute them some other way (e.g. isql). That'll let you figure out if there problem is in the provider or in the server. My psychic powers tell me it's probably something to do with locking in the server, but without know what the actual queries are, it's hard to know for sure... Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ClickOnce and Firebird Embedded
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 got to keep it in mind. Other than that, as long as you've got all the required DLLs in your manifest, you should be fine. Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] LINQ IQueryable Provider
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 benefits/drawbacks to using the entity framework as opposed to implementing IQueryable? As I understand it, when you implement IQueryable, you've tied all your client code to *that specific implementation*. Whereas with the entities framework, you can simply swap out the entity provider for a different one. It's basically one level higher than IQueryable. That means you can write your code against Firebird (or whatever), and later swap in another ADO.NET data provider without too much trouble. You can even do it dynamically at runtime. Additionally, it allows the IDE to generate all kinds of graphical representations of your data source (which are mapped to entities) so you build up your business data object via a graphical UI, and then use them in your code. Personally, I've never been a fan of this kind of programming... but that's just me :-) Dean. - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FireBird Crashes when users log onto it using my .NET software
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. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Crash during Database creation: This line returns Value cannot be null. Parameter name: keyword
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) What does GetFbConnectionString do? And what's the full exception (including stack trace?) Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] patches for 64-bit data provider + embedded (2.1 beta 2)
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 by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Embedded on 64 bit ?? almost fine . damn !!
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 !!! I can create db and tables but not query them at all... mmm worst !!! damn !! Did you get the latest source code from SVN? It was only committed today... :-) If you're already running the latest from SVN, what is the exception you're getting? Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] patches for 64-bit data provider + embedded (2.1 beta 2)
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: http://codeka.com/tmp/firebird.net-2.5.0-alpha1-64bit-patches.zip There wasn't a lot of changes required, really, though there is one that kind of worries me. The hardest thing for me to figure out was the fact that the XSQLVAR structures were being offset incorrectly in a 64-bit build. I don't know if it's due to a bug in the structure packing of the embedded DLL or what, but I had to change the XsqldaMarshaler.ComputeLength to read: private int ComputeLength(int n) { int length = (Marshal.SizeOf(typeof(XSQLDA)) + n * Marshal.SizeOf(typeof(XSQLVAR))); if (IntPtr.Size == 8) length += 4; return length; } Basically, we need to offset the first XSQLVAR structure by 4 in a 64-bit build. Other than that, the only other thing I had to change was the StatusVector stuff in IDbClient so that it's an IntPtr instead of an int. Now, I've only tested this against my little test app that I linked to last week, as well as doing a quick test on our own internal app (which does not make use of many of firebird's features *by far* so there's plenty of opportunity for other things to be screwed up still :-) but at least we're part of the way there... Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] firbird .net provider performance issue
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 SQL Server and Firebird) 2. The statement that is running slower in Firebird than on SQL Server. Also, are you running both databases on equivalent hardware? Are you running on a multi-core/multi-CPU machine? Super server can only use a single core, so if you've got multiple CPUs, you're better off with classic server (at least, until Firebird 3.0 is released). Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ADO.Net on x64
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 2.1 beta 2. http://www.firebirdsql.org/index.php?op=filesid=fb210_beta02 Or, specifically: http://downloads.sourceforge.net/firebird/Firebird-2.1.0.16780-0_x64_embed.zip Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ADO.Net on x64
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 other email, and it looks like that's exactly the problem :-) I don't think you need a *whole new* GDS implementation, as long as the data types match up when running under both 64-bit and 32-bit i.e. use IntPtr instead of int), you should still be able to continue using the existing implementation. Still, might be a fair amount of work there... Works the provider built for 64 bit platform against the 2.1 beta 2 stand alone server or not ?? I believe so. I had it working against 2.1 beta 1, it's just that beta 1 did not include the embedded server, so I'd never tried the embedded server before today. Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ADO.Net on x64
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 places where the P/Invoke signatures have specified int whereas in the Firebird header files, it's specified as an intptr_t (the most obvious example of this is the ISC_STATUS type -- defined as intptr_t in ibase.h, but just plain vanilla int in the P/Invoke signatures). That could certainly cause memory corruption errors! If I get a chance next week, I'll have a look at fixing it up, but no guarantees :-) Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ADO.Net on x64
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 compilation will work too). That's not what I'm seeing actually. I'm getting memory corruption errors when running with the 64-bit fbembed.dll -- 32-bit works fine. I've tried it with three different version of the provider: 2.0.1, 2.1 RC2 and 2.5 Alpha 1. I've created a small test program that demonstrates it, which you can download from here: http://codeka.com/tmp/FbEmbed64BitTest.zip Unzip that somewhere, copy the 32-bit and 64-bit fbembed.dll (and supporting DLLs) into the x86 and x64 folders respectively, then compile it in both the x86 and x64 configurations and you can see the difference. I get the following exception as soon as I try to execute any statements in the 64-bit build: System.BadImageFormatException: Invalid access to memory location. (Exception from HRESULT: 0x800703E6) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Runtime.InteropServices.Marshal.FreeHGlobal(IntPtr hglobal) at FirebirdSql.Data.Client.Common.XsqldaMarshaler.CleanUpNativeData(IntPtr pNativeData) at FirebirdSql.Data.Client.Native.FesStatement.DescribeParameters() at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at FbEmbed64BitTest.Program.Main(String[] args) in D:\Projects\FbEmbed64BitTest\Program.cs:line 57 (It's the Invalid access to memory location. that worries me... I don't know why it's throwing a System.BadImageFormatException -- maybe that's a clue? -- but it's definitely loading the fbembed.dll successfully, because I can see other method calls into fbembed.dll working, it's only when it calls that XsqldaMarshaler.CleanUpNativeData that it has problems... perhaps some sort of memory corruption?) 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... As an aside, I have also noticed that if I don't call FbConnection.ClearAllPools, my process never exits (you can see that happening in the sample project I posted above -- it doesn't call FbConnection.ClearAllPools() so the process hangs when it exits) Will ADO.Net provider officially support x64 compilations? I would certainly hope so!! :-) Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird and Threads
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 table name, resulting in an error. I have tried using a separate connections for each thread, and I have tried putting all database IO inside Monitor.Enter()/Monitor.Exit blocks, but the error still occurs. If I put all my code into one thread and run things sequentially the errors go away. I get these errors using a server or embedded. As far as I can tell, this type of access should be safe as long as I use a unique connection in each thread. I have tried the some thing with SQL Server 2005 but could not duplicate the error. Is there a thread-safe way to access data using Firebird .Net? Each connection can only have one command executing at once, but you should be using connection pooling anyway (i.e. open connection; execute command; close connection) so that shouldn't ever be a problem. What is the code you're using to generate the commands? and when you get the error, what does the statement look like? Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Parameter 'in' statement
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 DBType.String, and value as 10,20,30, but it seems not working. Can anyone give me some suggestion please? Firebird (nor any DBMS that I know of) does not support specifying a list of parameters like that. Remember the @param is not a simple string-replacement operator -- they are allowed only where actual query parameters are allowed. For example, you *could* do it like this: SELECT * FROM USERS WHERE ROLEID IN (@rid1, @rid2) But then you're obviously limited to specifying exactly two parameters. Generally, however, an IN query is not exactly efficient, so the performance benefits of command parameters is not really there. It's also fairly easy to validate the input string yourself (seeing as you know it's only supposed to be numbers separated by commas). With that in mind, you may as well just go: SELECT * FROM USERS WHERE ROLEID IN ( + rolelist + ) Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-112) Should try to explicitly IPAddress.TryParse before calling Dns.GetHostEntry
Should try to explicitly IPAddress.TryParse before calling Dns.GetHostEntry --- Key: DNET-112 URL: http://tracker.firebirdsql.org/browse/DNET-112 Project: .NET Data provider 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).AddressList[0]; With the following: IPAddress addr; if (!IPAddress.Parse(hostname, out addr)) { addr = Dns.GetHostEntry(hostname).AddressList[0]; } The call to Dns.GetHostEntry requires a DNS resolve, which can be costly if there is no reverse DNS set up for the IP and it has also been known to return different results to the IP you input. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
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. That's correct. Also, just to beat this dead horse a little more, here's the result of my test program on one of our servers that has two network cards: C:\temp test 10.1.0.135 Testing: 10.1.0.135 Hostname: gbasmsa1-nelson.dload.live Address: 10.1.0.135 Address: 10.0.1.135 C:\temp test 10.0.1.135 Testing: 10.0.1.135 Hostname: gbasmsa1-nelson.dload.live Address: 10.1.0.135 Address: 10.0.1.135 Notice that in this case it returns the addresses in the same order, regardless of what IP I originally pass to Dns.GetHostEntry. From my testing, this only seems to occur when you enter an IP that resolves to the local host -- if I run the program from a different host, I only get the one result back. It may be a problem with our DNS set up, or something else, but that's clearly not what you would expect! I've added it to JIRA, but it's up to you guys what you want to do with it anyway :-) Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
if (!IPAddress.TryParse(dataSource, out ipaddress)) { return ipaddress; } Should be: if (IPAddress.TryParse(dataSource, out ipaddress)) { return ipaddress; } Otherwise, great :-) Dean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Wednesday, 22 August 2007 12:30 AM Cc: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Connection problem from Win Hello: Sorry this way ;) private IPAddress GetIPAddress(string dataSource, AddressFamily addressFamily) { IPAddress ipaddress = null; if (!IPAddress.TryParse(dataSource, out ipaddress)) { return ipaddress; } IPAddress[] addresses = Dns.GetHostEntry(dataSource).AddressList; // Try to avoid problems with IPV6 addresses foreach (IPAddress address in addresses) { if (address.AddressFamily == addressFamily) { return address; } } return addresses[0]; } -- Carlos Guzmán Álvarez Vigo-Spain Blog : http://carlosga.wordpress.com/ FirebirdClient: http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 --- -- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
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 up for that IP, then you won't get any results at all. For example, here is a MySQL bug related to Dns.GetHostEntry: http://bugs.mysql.com/bug.php?id=26593 I'm not saying this is the problem in this particular case, but I have run into trouble just using Dns.GetHostEntry on an IP address... :-) Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
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]; Console.WriteLine(Testing: {0}, address); IPHostEntry hostent = Dns.GetHostEntry(address); Console.WriteLine(Hostname: {0}, hostent.HostName); foreach(string alias in hostent.Aliases) { Console.WriteLine(Alias: {0}, alias); } foreach(IPAddress addr in hostent.AddressList) { Console.WriteLine(Address: {0}, addr); } } Here is the output for two different addresses: D:\Projects\TestProject\bin\Debugtest 10.0.0.33 Testing: 10.0.0.33 Hostname: xx Address: fe80::69eb:837:6a0:5c66%8 Address: fe80::5efe:10.0.0.33%11 Address: 10.0.0.33 D:\Projects\TestProject\bin\Debugtest 123.123.123.123 Testing: 123.123.123.123 Hostname: 123.123.123.123 Address: 123.123.123.123 The first address is my local IP address. Notice how it returned the IPv6 addresses *before* the IPv4 (this is Windows Vista). The second address is one that does not exist on my network. Not visible here, of course, is the fact that this address took about 6 seconds to resolve whereas the first one was practically instant. Your network may be different, but clearly not all networks are the same as yours. Remember, all I'm trying to say here is that you should replace the line: IPAddress addr = Dns.GetHostEntry(hostname).AddressList[0]; With the following: IPAddress addr; if (!IPAddress.Parse(hostname, out addr)) { addr = Dns.GetHostEntry(hostname).AddressList[0]; } It's not a big change and it's only useful in certain circumstances, but it *is* a better solution. Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003 Standard
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 associated with that name. It is quite possible that it can return addresses in a different or unexpected order. Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VISTA Embedded Problem
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 limited :( This is something that you'll have to take up on the firebird developer's list, I believe, since it's not really a problem with the .net provider as such. Note that you don't actually need Administrator rights, the Administrator account has Create Global Objects by default (and since Local Security Policy is not affected by UAC, you don't need to Run as Administrator), but you can assign that right to a limited user and things are still quite effective. As I said, though, this is not just a Vista problem: the privilege was introduced in Windows XP SP2. So it would also affect you running as a limited user account in a fast-user switching environment (you can try it out by logging in to Windows XP, then doing Switch User and logging in as a limited user -- you will get the same error). It's just more prevalent in Vista because nobody runs in session 0 any more. Dean. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB and VS 2008
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. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [PHISH] Re: [PHISH] Re: Visual C# andFirebirdembeddeddatabaseconnection failure
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 Vista has problems with local protocol connection to fb, did you (or smbd. else) tested embeded under Vista ? Yes, it works under Vista (I have tried it). I believe the local protocol used to connect to the server is totally different to how fbembed works. The local protocol uses Named Pipes, I believe and because it doesn't - by default - prefix them with Global\ you cannot connect from your logged-on session to the session which the service runs under. Note that this also means that the local protocol would have never worked on a Terminal Server or Windows XP + fast user switching environment, either... Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Visual C# and Firebird embedded database
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. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Visual C#andFirebird embedded database connection failure
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 error you're getting is 64-bit related, but at least dependency walker should give you some clue... hopefully :-) i would have to uninstall orcas and reinstall 2005 I'm pretty sure they can be installed side-by-side (though maybe you do have to install 2005 *before* Orcas, I don't know...) * http://www.dependencywalker.com/ Dean. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trace Database Log
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 up a trigger to save the data into an audit table. Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] unexpected problem with Euro sign
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 8859-1 has some control codes, WIN-1252 has a few extra letters (like U+2020 †, etc) -- one of those extra letters is the Euro sign. Many applications, however (especially Windows applications) treat ISO 8859-1 as being synonymous with WIN-1252, so that's probably why it worked in those other cases. .NET is not so lenient, however, and something marked as ISO 8859-1 to .NET will not be able to contain a Euro symbol. Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enhacement for FBCommand
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, if you get an exception, recreate it. Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Mapping a database char column to
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 options: 1. Make the column CHAR(5) and store exactly True or False, or 2. Make the column SMALLINT and store 1 or 0, 3. Leave the database as-is, and manually convert the column in the DataTable #1 is a bit silly, given that it needs 5 bytes to store rather than 1. #2 may not be ideal if you don't want to change the database schema. That leaves only #3, I'm afraid. FbDataAdapter is not really suited for what you're trying to do here. It's purpose it basically to create an in-memory copy of the database table that you can modify and then update back in the database. It's not designed to do complex data conversions (that's what an OR mapper is for). Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Can't save UNICODE FSS BLOB TEXT
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. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Can't save UNICODE FSS BLOB TEXT
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 control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Short char field with longer name
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 such a confusing word to begin with. Is é a character? What if I store it as U+0065 U+0301? That's two Unicode codepoints for one logical character. The cause of the problem here is not the length of the data stored but that the client is set to expect single-byte encoding (by using character set NONE) I agree that's a problem, however I disagree that the server should be returning four bytes when the UTF-8 encoded value of e (or whatever ASCII character you like) is only one byte long. What I mean is, even if you changed the connection string character set to UTF8, 0x65 0x00 0x00 0x00 represents four UTF-8 characters (that is, U+0065 U+ U+ U+). Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Short char field with longer name
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 point with this example was to show that one character may require more than one codepoint to represent. You could store é in a CHAR(1) if you used the representation U+00E9, however you could not store it as U+0065 U+0301. The point is that saying n represents a count of characters is misleading, What I mean is, even if you changed the connection string character set to UTF8, 0x65 0x00 0x00 0x00 represents four UTF-8 characters (that is, U+0065 U+ U+ U+). According to what, I wonder? According to the definition UTF-8. See http://en.wikipedia.org/wiki/UTF-8 if you need a primer. Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SQL error - Different windows useraccounts
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* it is executed, and find out the one that causes the error that way. If you create a third account, does it happen with that one? What is different about the two accounts (for example, usernames, group memberships, etc)? Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Big performance gain on Charset.cs
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 actual functionality. The code in Encoding.GetEncoding caches the return value so when you call it again with the same name, it returns the same instance as before. The speed-up you get is from not having to convert from the string name to an integer codepage and doing a hashtable lookup (basically what Encoding.GetEncoding does internall). Depending on the number of times that gets done, the speedup could be significant. Dean. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Commit or Rollback after select ?
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 most database servers, not just firebird), the server has to do more work for a rollback than for a commit. So even if you didn't make any changes still COMMIT your transaction in preference to ROLLBACK. Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Bug in Parameter Substitution?
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 method was added in .NET 2.0 was precisely because of the ambiguity caused between the Add(string, object) and Add(string, *DbType) overloads. If that fixes the problem (I suspect it will), the bug is with NHibernate - it shouldn't be calling the Add(string, object) overload anymore... or, if it needs to work with .NET 1.1 as well, then it should use a different overload of Add(). Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] To Giuliano Asioli
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 SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] BadImageFormatException in vista 64
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 default Any CPU. This means you'll be running in WOW64 on 64-bit Windows, but that's usually OK. I hear 64-bit support for Windows is in the works (it already works in Linux, so shouldn't be too much work) and I, too, am eagerly awaiting it ;) Note: this is a firebird *server* issue; the .net provider works fine in 64-bit. Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string enhancing
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 runtime, with the full path to the fbembed.dll file in the [DllImport] attributes. 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! Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string enhancing
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 2.0 at least) UnmanagedFunctionPointerAttribute, see for example: http://blogs.msdn.com/jonathanswift/archive/2006/10/03/Dynamically-calling-a n-unmanaged-dll-from-.NET-_2800_C_23002900_.aspx Still, using Reflection.Emit will be cross-platform... Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string enhancing
Yeah, but from my POV this is low priority. Well, of course I'm not suggesting that YOU have to do it :-) I was just giving some ideas of how it could be done in a cross-platform manner. I have never working with this generating declarations for extern methods, so I have absolutely no idea, how difficult will it be. :) It's probably not that hard, if I get a free hour or two, I might have a go myself (no promises ;) Dean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Wednesday, 28 February 2007 9:59 am 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 changing things, then why do anything? Reflection.Emit refers to the namespace (its actually System.Reflection.Emit, but most people just abbreviate it to Reflection.Emit). Oh, sorry, you was talking about namespace, my mistake (long day). You don't need to generate any actual IL - the FbClient class is all just type declarations anyway, it would be fairly simple, I believe. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1
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 firebird thing (as in, the database, not the provider). SQL Server doesn't have that feature - in SQL server, identifiers are case-sensitive depending on how you set up the master database. Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string for embedded firebird
What's the complete exception? My guess is that there is some sort of permissions problem. Are you using IIS5 or IIS6 (Windows 2000 or Windows Server 2003)? For IIS5 you need to give the ASPNET account read/write permissions to the database file. For IIS6 you need to give whatever account your Application Pool is running as read/write permissions to the file. Also, re: your last mail. You can run into problems if you have worker process recycling turned on in IIS6, but IIS5 should be OK (though if you ever upgrade to IIS6 in the future...) The problem with worker process recycling is that when IIS6 recycles the worker process, the old one hangs around while it finishes servicing current requests. A new worker process is started to service any new requests. So there is a (admittedly, short) period of time while there will be two processes running. If the new worker process tries to open the database file before the old one goes away, you'll get errors. Dean. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Chalk Sent: Tuesday, 2 January 2007 2:30 pm To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Connection string for embedded firebird Here is the error reported by .Net: I/O error for file CreateFile (open) D:\WORK\Logger\Database\Firebird\MCSCRE.FDB Error while trying to open file However, no other process has the file open. - A _ From: [EMAIL 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 of the FbConnectionStringBuilder class, the following works: FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.ServerType = FbServerType.Embedded; cs.Database = fileName; Calling ToString() on this returns: Initial Catalog={fileName}; Server Type=Embedded Notice that you don't need to specify a user name/password - there is not security in embedded mode. Also, you can use the text of the enumeration for Server Type (Embedded is more readable than 1) What is the error that you get? It could be a file system permissions thing. Also remember that embedded mode acts like super server - meaing you cannot open the same database file from different processes. This is important if you're trying to run in embedded on a web farm or something (you basically can't do it); it also proves problematic in the event of worker process recycling in IIS6 (in fact, I wouldn't recommend embedded mode at all in a website). Dean. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Chalk Sent: Tuesday, 2 January 2007 12:56 pm To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Connection string for embedded firebird Could someone give me or refer me to some example connection strings for the embedded version of Firebird? My string below gets an error opening the file. add key=DBConnectionString value=Data Source=local; Charset=ASCII; Database=D:\\WORK\\Database\\Firebird\\ABC.FDB; User Id=sysdba; Password=masterkey; ServerType=1/ Many thanks. __ Communications Solutions 7000 Independence Pkwy., Ste. 160-227 Plano, TX 75025 USA (972) 377-9074 www.magnacartasoftware.com mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] image001.gif Description: GIF image - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string for embedded firebird
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 process, no matter how many clients connect to it. Embedded is like making every client *process* into a super-server. If there's only one client process, there's no problem. But with web sites, that can be a tough thing to guarantee. Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Does this support the OleDbConnection Class?
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 .NET System.Data architecture, which is better suited to .NET and is a little more flexible as well. You do not NEED to use the Firebird classes (except to create the actual connection) - most actions can be performed via the IDb* interfaces that all System.Data providers implement (so IDbCommand instead of FbCommand, IDataReader instead of FbDataReader, etc). IMHO, though, trying to get database independence using the interfaces is usually not worth it, unless you're writing against multiple database engines right from the start. Dean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Chalk Sent: Friday, 29 December 2006 7:27 am To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Does this support the OleDbConnection Class? I am not clear about the difference between ADO and OLEDb. The Firbird .Net Provider has lots of examples that use its own class to access the provider. What if I want to use the MS recommended OleDbConnection (and associated OleDbXXX class) calls to access a database? Does this provider support this? Thanks - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Unable to get Firebird 2.0 to work on WinXP x64 (w/ AMD64)
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. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Price Sent: Sunday, 17 December 2006 9:21 pm To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Unable to get Firebird 2.0 to work on WinXP x64 (w/ AMD64) Carlos Guzmán Álvarez wrote: Hello: What are those for anyway? Built-in SQL functions? For the unicode support if i'm notworn ( not sure if they are used for other encodings, hope, yes, and if i'm not sure if it's used for the collations support as well ) Sorry Carlos, what type of Unicode support? Reading/storing/other? Kind regards, Scott :) - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Caching is possible?
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 notifications on the server - the client is relatively easy. Dean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of paul.mercea Sent: Tuesday, 12 December 2006 5:20 am To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Caching is possible? Entire system will fire database only when update will apear. That is an Sql Server 2005 specific feature. It could be implemented using events from database. Probably best way is to use web service for that. Thanks, Paul -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbScript delimiter character
Actually, I just downloaded the latest version of the provider, 2.0.1, and it seems to have included special support for the SET TERM statement... that'll do nicely :) It's nice to be able to answer your own question! Dean. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 difficult to add an extra constructor overload which lets you specify a different one? I'm currently using FbScript to execute a bunch of CREATE TABLE, CREATE INDEX, etc statements to create my database structure - now I want to include CREATE PROCEDUREs to create some sprocs, but (unless I'm missing something - which is quite possible :-)) I can't because of the command-terminator problem. Dean. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Batch Select with Firebird provider
|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); If selects returning same type of columns (it should, if you're using one dataset) then you can use union keyword. Else no, it doesn't make any sence. It makes perfect sense, the exact same query would work as expected (i.e. you'd get three DataTables inside your DataSet) on SQL Server. It would only provide (noticeable) benefit if you're running Firebird in server mode, though. Executing your query like that, rather than three separate command would save you the round-trip to the database (which can be in the order of a few milliseconds). Obviously, though, if you're running an embedded database, there'd be little difference. I don't know if Firebird supports it in either server or embedded mode, though. Dean. - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird on Windows Vista?
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 compile your application as explicitly Win32, rather than Any CPU (by passing the /p:Win32 command-line option to msbuild, usually). The other option is that firebird needs to be released as both 32-bit and 64-bit (so that would be two separate DLLs). That's out of scope of the .NET provider mailing list, though... hopefully one day, because I'd like to see that one, too :) Note: This only applies to firebird embedded, where the DLL is loaded in-process. The server version is different. Dean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Monday, 16 October 2006 8:01 am To: Yas Cc: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Firebird on Windows Vista? Yas wrote: Hello Jiri, Did you tested the provider on Vista 64 bit edition? I've tested it on the Vista 32 bit edition and it runs fine. Me too. However in the Vista 64 bit edition it throws an exception BadImageFormat which is shown to came from the 64 bit version of the .NET Framework installed with the Vista 64 bit edition. If you want, I can provided with more detailed info about the exception and screenshots. Yes, of course. I'll check the code for possible problems. Thanks. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Transaction
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 DTC, which would be incur a pretty hefty performance penalty. All in all, the transaction support for TableAdapters are pretty lame. This page contains some basic information on how to get TableAdapters to work with transactions: http://blah.winsmarts.com/2006/06/18/the-definitive-tableadapters--transacti ons-blog-post.aspx Dean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jun S. Pomer Sent: Monday, 18 September 2006 2:15 pm To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Transaction Hi, Anybody can point me where is the right direction? I need the transaction to update multiple tables. Thanks in advance. Jun Jun S. Pomer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Carlos, Thanks for the reply. What is recommended, or alternative to use a transaction? Thanks. Jun Carlos Guzman Alvarez [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello: Hi Carlos, I so sorry, for very late reply. Anyway below is the sample transaction based. Is it safe/compatible using Firebird provider? No, there are no support for TransactionScope for now in the provider. -- = Carlos Guzm=E1n =C1lvarez Vigo-Spain - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easi= er Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as- us.falkag.net/sel?cmd=3Dlnkkid=3D120709bid=3D263057dat=3D1= 21642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- -- - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 -- -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider