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, yo

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,

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. -- _

Re: [Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta

> Conclusion: > * For a server, no change at all. > * For embedded > - if you're using some username, you're good (no matter whether the > username is here for easy switch to normal server, to apply some > specific database objects privileges or by accident) > - if not, you simply add sysdba use

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 d

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 truste

Re: [Firebird-net-provider] Firebird Embedded 64bit and .Net Provider 2.1.0

It depends what you're planning to do with it. Just regular usage is pretty stable, I think most of the new work is in the entity framework support. Certainly, we've been using it for quite a long time here in production (64-bit as well) without issue (though our usage of Firebird is relatively bas

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. Dea

Re: [Firebird-net-provider] FbBatchScript can't CREATE DATABASE in Embedded server

> I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create > database in Embbedded mode. But it can't. Please help me. You haven't described the problem. HOW do you try to create a database using the FbBatchScript (please provide the code you're using). HOW does it fail? Does it

Re: [Firebird-net-provider] Using a Hashtable between reader.Read() kills performance

> object val; > > while( reader.Read() ) > { > for( int j = 0; j < reader.FieldCount; ++j ) > val=reader[j]; > // table.Add(count, val); > ++count; > } It might be that when you don't use val, the optimizer is not executing all of the code, and so

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 yo

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 t

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

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 > . 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 t

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 yo

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 M

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 t

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

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. -

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

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 nev

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 prov

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. --

Re: [Firebird-net-provider] High CPU

Paul wrote: > Any thoughts? > > FB server is using 80% +, often 100% of CPU on out well-specced server > (3.5GHz, 3Gb RAM) > We have 100+ users, connecting via an always-connected (i.e. > non-disconnected architecture) Windows client. > > Version is Firebird 1.5. On Windows 2003 server. > > An

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.

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 machi

Re: [Firebird-net-provider] Question for .NET Provider Author re transaction conflict

Helen Borrie wrote: > Agreed. It's always a source of mystery to me why driver developers, more > often than not, provide the worst possible settings for the default > transaction. The .NET Provider isn't alone in this: most of the Delphi > component sets do the same. I'm not sure about the

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 so

Re: [Firebird-net-provider] I've got decimal issues with other cultures and need help

Rolf Marsh wrote: > CultureInfo ci = CultureInfo.CurrentCulture; > NumberFormatInfo nfi = ci.NumberFormat; > decimal decPrice, decCost; > > decPrice = decimal.Parse(pricePieces[0]); // pricePieces is a string > array where I remove trailing currency sign There are two problems here. This w

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 Mar

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, yo

Re: [Firebird-net-provider] I get Error when I specify ClientLibrary for embeded FB2.1

Mercea Paul wrote: > Eliminating '.dll' extension doesn't make any difference! > Strange is the fact that I can't get in debug mode the error, I get error > message before any code line to be executed! Yeah, sorry, I misread your original post. It looks like it's loading the wrong version of the

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

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

Oleg Deribas wrote: > Is it possible to mark HasRows with "obsolete" attribute? Then people > will get warnings when compiling code with newer versions of the provider... They won't get a warning if they're using it via the base class or the IDataReader interface (as I usually do). Dean.

Re: [Firebird-net-provider] Why FbDataReader.HasRows returns always true?

Jiri Cincura wrote: > On 2/26/08, Aitor Gómez González <[EMAIL PROTECTED]> wrote: >> Is there any reason to return an incorrect result instead of raising a >> NotSupportedException? > > I have not designed this. But according to ADO.NET abstract classes > and "expected" way of using this, I think,

Re: [Firebird-net-provider] Timeout exceeded exception

Vladislav Panteleev wrote: > reader1 = getReader(select .. from mytable left join table1 on .. where .. > group by) > while (reader1.Read()) > { > //do somth > reader2 = getReader(select .. from mytable left join table2 on .. where .. > group by) > while (reader2.Read()) > { > //do somt

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

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 Exp

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 & .

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 wh

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

Re: [Firebird-net-provider] Connection Pooling Options With Firebird

John Martinez wrote: > 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 Si

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

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 ru

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 jus

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/dra

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. -

Re: [Firebird-net-provider] Order of parameters to stored procedure

Jiri Cincura wrote: > On 11/15/07, Shreekar Joshi <[EMAIL PROTECTED]> wrote: >> About getting names and order of parameters from database, is it a good >> idea to cache the SP params and orders at application level (maybe in a >> singleton class hashtable)? This implementation will be in a windows

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.CreateDataba

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

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 sponsor

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 fr

[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-p

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

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

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

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 compila

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 fie

Re: [Firebird-net-provider] Parameter 'in' statement

Tao Lin wrote: Hi, I am using FB.Net 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 DBTy

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-

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.

[Firebird-net-provider] [FB-Tracker] Created: (DNET-112) Should try to explicitly IPAddress.TryParse before calling Dns.GetHostEntry

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

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];

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

Re: [Firebird-net-provider] Connection problem from Win 2003 Standard

> If you provide IP, there's no hostname. Yes, but Dns.GetHostEntry does a reverse lookup on your IP to *get* the hostname. Have a look in Reflector -- it ends up calling gethostbyaddr on your address. Dean. - This SF.net

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

Re: [Firebird-net-provider] Connection problem from Win 2003 Standard

Actually, this is a problem I noticed in some of my own code as well. The solution is to try and parse the string as an IP address before calling Dns.GetHostEntry, like so: IPAddress addr; if (!IPAddress.TryParse(dataSource, out addr)) { addr = Dns.GetHostEntry(dataSource).AddressList[0];

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 mo

Re: [Firebird-net-provider] VISTA Embedded Problem

> FirebirdSql.Data.FirebirdClient.FbException: operating system > directive CreateFileMapping failed ---> Starting from Windows XP SP2, any user who calls CreateFileMapping in a session other than session 0 needs the "Create Global Objects" permission (in Local Security Policy). This may not have

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. ---

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.

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

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 e

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

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-105) FbCommandBuilder does not create Insert/Delete/Update Commands

> FbCommandBuilder does not create Insert/Delete/Update Commands > ... > //The next three lines will throw Exceptions This is the correct behaviour; it's up to you to populate those commands. Use FbCommandBuilder.GetUpdateCommand() and friends. Dean. -

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 88

Re: [Firebird-net-provider] Renaming fields in queries with asterisk

> I think, that using asterisk isn't good idea. :) I agree. Using an asterisk is fine in a gui management type tool, but I don't think it should be a feature of the low-level data provider. Dean. - This SF.net email is sp

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

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

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.

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

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 ACU

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 chara

Re: [Firebird-net-provider] Short char field with longer name

> YES! Changing the column's type to VARCHAR(1) works. > > Now can someone tell me why? Doesn't my experience still indicate that > there is some sort of bug with columns of type CHAR(1)? The language spec is a bit confusing with respect to the what the "n" actually means in CHAR(n). My copy says

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 befo

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 o

Re: [Firebird-net-provider] Big performance gain on Charset.cs

> AFAIK you don't create more objects. Is exactly the same, the difference > is that instead of making thousands of calls to GetEncoding , and going > several times through the switch statement, you just do it once... We > didn't detect a hit on memory consumption (I will double check), but > pefor

Re: [Firebird-net-provider] Issue with Windows 2003 Terminalserverand.Net provider 2.0.1

> I agree with that assessment. I'm just not sure which mailing list will > get the most traction. Also, I'm still not sure that I'm not doing > something wrong with the way I'm using the .Net provider to connect to the > embedded database. I'm not very familiar with the server's sources (not that

Re: [Firebird-net-provider] Issue with Windows 2003 Terminal server and.Net provider 2.0.1

> Which explained that for the file mapping to work when connecting to a > database on the terminal server, I need to give my users "Create global > objects" rights. It's hard to say, actually. Higher up on the page (in the lpName parameter description) it says: Terminal Services: The name

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,

Re: [Firebird-net-provider] Quick question

> I think it's a problem with Visual Studio or the .net framework throwing > that exception but in v2.x the FbTransaction class inherits from > DbTransaction that implements IDisposable. Yeah, I've seen that problem before (indirectly anyway), but usually a re-compile or a reboot (or both) fixes i

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

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 AddWithVa

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 de

Re: [Firebird-net-provider] Connection string enhancing

> > I've tested this and works! > > If it works we can try to add it to the 2.1.0 sources ... > huu i will try to try to take a look at that today or tomorrow No need to rush it in to the 2.1.0 branch if it's going to cause problems. :) One thing that someone probably needs to do is take a l

Re: [Firebird-net-provider] Connection string enhancing

I had a go, and it wasn't all that difficult. I've uploaded the files that I changed from FirebirdClient-2.1.0.0 Beta1 (which was the version I had) here: http://codeka.com/tmp/fb-beta1-updated-files.zip The main interesting thing is IFbClient.cs and FbClientFactory.cs. IFbClient is a new interfa

Re: [Firebird-net-provider] Connection string enhancing

> What do you think? I can try to implement this. > Which way is better, Dean's or myne? Well, I'm going to give my method a go myself (I got myself interested enough to try ;) so I'll let you know the outcome :-) Dean. -

Re: [Firebird-net-provider] Connection string enhancing

day, 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 > &

Re: [Firebird-net-provider] Connection string enhancing

Sent: Wednesday, 28 February 2007 9:40 am > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Connection string enhancing > > Dean Harding wrote: > > You can make it work using Reflection.Emit and dynamically generating > the > &

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

  1   2   >