[Firebird-net-provider] Feedback from FBBackup/Restore
Hi Gang! Using Provider 2.6.0, I played around with FBBackup/FBRestore and it all works very good. Thanks for all the good work Jiri, Carlos and others!! I did not understand, though, how I can get some output or feedback from the backup/restore processes. On calling execute() the process starts and eventually ends, but I would like to have - at least - a notification when the method has finished it's job. I know how to do that when binding gbak.exe to a process object in .net 4, but I really would LOVE to do as much as possible using FBProvider. I do have links to weppages explaining fbbackup class, but the links are broken for at least a week now and I would like to advance on this. Can someone point me to the appropriate documentation? thanks! --- -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Time is recognized as Timespan
If this is something known, can somebody please point me to relevant discussions, or if this is unknown, can you tell me what info you would need from me to analyse this? JC It's expected. Look at this list archives to find some related threads. OK, found some time to search the archives; found DNet 333, based upon which you changed the behaviour. I will have to think about an efficient way to change my code in different places. Problem so far only manifests in datagridview columns. But I am usually doing the formatting of datagridview columns in the designer for each separate datagridview, _NOT_ in some template or base class. May I ask why this suddenly has been changed? Are ADO.net whitebooks demanding to do so or was it a change to match requirements for certain software? Can I get an installer package for 2.5.2 provider somewhere? This would be my preferred solution so far, until I can come up with a solution for my datagridsviews. thanks! --- -- Achieve Improved Network Security with IP and DNS Reputation. Defend against bad network traffic, including botnets, malware, phishing sites, and compromised hosts - saving your company time, money, and embarrassment. Learn More! http://p.sf.net/sfu/hpdev2dev-nov ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Time is recognized as Timespan
Hello, now I successfully ported our project from .net 2.0 to .net 4.0. I am using provider 2.5.2. I have something strange, though. When I'm reading data from a firebird database (Server 1.5) and the field type is Time, I get an error when using a data adapter to fill a table with a datacolumn of datatype DateTime. The exception suggests that the value is interpreted as Timespan and can therefore not be written into a datacolumn of datatype DateTime. If I comment-out the definition of the datatype for the respective DataColumn, everything works, but the seconds are displayed in the corresponding DataGridView because if nothing is defined, the column will interpret the data as string and I can't use the time format hh:mm to suppress the seconds. If this is something known, can somebody please point me to relevant discussions, or if this is unknown, can you tell me what info you would need from me to analyse this? Thank you very much! ciao, André --- -- Nokia and ATT present the 2010 Calling All Innovators-North America contest Create new apps games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] fbcommand.Parameters.Add /.AddRange (.net 4)
JC On Mon, Sep 13, 2010 at 16:09, André Knappstein, Controlling JC knappst...@beta-eigenheim.de wrote: System.StackOverflowException JC Do you have a stack trace for it? Sorry for coming back to this so late. No, unfortunately right now I can't seem to get one. I have deleted the first converted solutions and wanted to start over again, because I had some more problems with outdated references. Now, when converting the same project over to VS2010, the specific lines do _NOT_ get converted from using ..Params.Add() to ...Params.AddRange(). I don't have an idea. And I can't reproduce this now. I guess something's wrong with VS2010 converter, because now I do have problems in other places, which I did not have before. I had to delete and re-add one (the same!) reference to a TAPI DLL for example. In addition it seems like Properties.Settings.Default cannot be used in VS2010. Compiler does not complain, but runtime just closes when I try to access some values from there... Anyway, does not seem to be FBProvider specific so far, more like something in general not working good in VS2010. Thanks for your time. --- -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] fbcommand.Parameters.Add /.AddRange (.net 4)
Hi Gang, I don't remember anyone posting this before, so I thought I'd inform you. I am updating my application to use .net 4 with VS 2010. Using the conversion wizard (opening a 3.5 or 2.0 project in VS2010), the wizard is doing changes to code using FB provider, which then leads to stack overflow exceptions. Here is the problematic structure _BEFORE_ conversion (watch line wrap!)... FBCommand1.Parameters.Add(new FbParameter(@PM_IDREP, FbDbType.Char, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), , System.Data.DataRowVersion.Current, \1002\)); And here is the same line _AFTER_ conversion (again watch wrap!)... FBCommand1.Parameters.AddRange(new FbParameter[] {new FbParameter(@PM_IDREP, FbDbType.Char, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), , System.Data.DataRowVersion.Current, \1002\)}); which basically means that the converter is making a collection of parameters out of each parameter. It does not do so in ALL places of the project - so far I did not find out what makes these 2 places so special... well... this is the oldest code snippet I do use which involves fb provider functionality and I wouldn't do it like this anyway today... strange enough though, isn't it? Manually editing the line to the version BEFORE conversion will make it run fine. But the converted version using AddRange(...) instead of Add(...) will cause System.StackOverflowException. I am still using fb provider 2.0.1.0 please excuse the signature following below... mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: i...@beta-eigenheim.de Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 --- -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing http://p.sf.net/sfu/novell-sfdev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] problem with a query (maybe a bug)
k select userinfo0_.id as x0_0_ k from user_infos userinfo0_ k where (@p0 in(select views1_.View_Id from User_Views_Map views1_ k where userinfo0_.id=views1_.User_Id)) I have such an idea, that you cannot use a dynamic parameter at this place. But I can be wrong. k note 2: if i do the query directly to firebird all is ok so the k problem is with the .net data provider How do you do the query directly to firebird ? --- -- ___ 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 error using Virtual PC Windows XP Mode
MS has put a nasty Easter-Egg into XP/SP3 installations of the latest generation. If - during installation of XP-VM - you chose to have the firewall turned off, the GUI displays the firewall indeed as being off, but that is _not_ the case. Turn it on, reboot, turn it off again, and see if you can connect. We had this issue on several machines in the last weeks. mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: i...@beta-eigenheim.de Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 ~~~Ihre Nachricht~~~ k I am using the connection builder as follows: k FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); k csb.Charset = UTF8; k csb.DataSource = localhost; k csb.Database = myTestDb;//Defined in aliases.conf k csb.UserID = x; k csb.Password = x; k FbConnection db = new FbConnection(csb.ToString()); k db.Open(); k //Exception happens here. --- -- Download Intelreg; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbDbType.Decimal param fails
For what it's worth, I am making excessive use of parameters with type Decimal, and I am experiencing _no_ problem at all. I am in the process of eliminating the last non-Firebird portions of databases our softare is based upon and only then will I be able to migrate from 1.5.x to the current 2.x branch. So, I am still using the 2.01 provider and FB 1.5 (all Dialect 3), if that's of any importance for determining why Decimal parameters are working fine for me. I am, though, declaring the parameters another way than you do. Specifically I do not declare precision and scale on the client side. All my Decimals do have at least a precision of 12 while yours obviously only has 8. According to Helen's Book, Decimals with precision 10 are stored differently. I am not in the position to guess if that can somehow be connected to your problem. But it's worth trying, so you could leave out the declaration of the precision and scale and also try with a target field of higher precision and scale. ciao, André -- ~~~Ihre Nachricht~~~ KG Hi Daniel, KG I'm not at my workstation today, so I can't cut and paste anything. I will KG try tomorrow. KG However, I can mention that I am using the provider in probably two dozen KG projects, and in each project I have at least 50 parameterized inserts. In KG no case am I able to use the decimal type. KG If I insert to a decimal field using a FbDbType.Integer, the insert works, KG though the decimal portion is truncated, KG If I insert to the decimal field using an FbDbType.Float, the insert works. KG I'll try to send more code for context tomorrow. KG Thanks, KG Kyle KG - Original Message - KG From: Daniel Rail dan...@accra.ca KG Sent: Mon, January 25, 2010 14:41 KG Subject:Re: [Firebird-net-provider] FbDbType.Decimal param fails KG Hi, KG At January-25-10, 5:19 PM, Richard Green wrote: Using this, the insert fails with this message: The string was not recognized as a valid DateTime. There is a unknown word starting at index 0 KG Can you show us all of the insert statement and then the code that KG creates the FbParameter[] and assigning of the values? -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-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] Character set problem between with Firebird .NET provider
I would second what Jiri wrote. We have been using 8859_1 widely. This works okay with ODBC. Using .net, some things did not work correctly. Or rather they worked correctly but not as we expected :) ISO8859_1 does - for example - not really specify a solution for displaying the Euro symbol (€). We changed everything to Win1252 instead, which supports spanish and french characters as well as German Umlauts and ß ciao, André -- ~~~Ihre Nachricht~~~ LvA Hi, I would appreciate it if someone could help. LvA LvA I am I South Africa and is developing an application for use in South LvA Africa, France and Italy. Therefore the application and database has to LvA support the French and Italian special characters. LvA LvA I created the database using IBExpert with a default character set as shown LvA below LvA LvA SET NAMES ISO8859_1; LvA CREATE DATABASE LvA 'D:\Projects\Intertrade\Tech\Database\FRANCECROCO V26.FDB' LvA USER 'SYSDBA' PASSWORD 'masterkey' LvA PAGE_SIZE 8192 LvA DEFAULT CHARACTER SET ISO8859_1; LvA LvA So I am assuming that all text type fields will default to this character LvA set. LvA LvA My application is developed in .NET 2 VS2005 and am using .NET client 2.0.1 LvA LvA My application sets the character set to ISO8859_1 when connecting to the LvA database. When I connect to the database and want to access some data that LvA the customer has updated, I get the transliteration error. Data that the LvA customer has not touched i.e. does not contain special characters shows ok. LvA LvA What else do I need to do? LvA LvA Thanks LvA Louis -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Character set problem between with Firebird .NET provider
I don't know. If I remember correctly I have read that unicode takes an extra byte per character and I did not want to hit any technical limit (max. lenghth of index key and such...) And I dimly remember that there were such limits for FB 1.5, which have been extended along with 2.x. Our databases are still on FB 1.5 due to technical limitations of the old programming tools. Only recently I converted another big part over to C#/.net and will hopefully be done completely this summer. ciao, André -- ~~~Ihre Nachricht~~~ JC On Thu, Jan 7, 2010 at 16:54, André Knappstein, Controlling JC knappst...@beta-eigenheim.de wrote: We changed everything to Win1252 instead, which supports spanish and french characters as well as German Umlauts and ß JC Why not unicode? -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ 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-Tracker] Created: (DNET-287) Memory Problem when not dispose the DbCommand
I don't know if the following method really is better, but it's worth a try, because from old school I would rather not create and destroy too many objects unnecessarily. Dbcmd = Dbconn.CreateCommand(); Dbcmd.Transaction = Dbtrans; Dbcmd.Connection = Dbconn; Dbcmd.CommandType = CommandType.Text; Dbcmd.CommandText = INSERT INTO TEST(IDCODIGO,TESTE) VALUES (@IDCodigo, @Teste); Dbcmd.Parameters.Add(@IDCodigo, FbDbType.VarChar, 6); Dbcmd.Parameters.Add(@Teste, FbDbType.VarChar, 6); for (int i = 0; i 50; i++) { Dbcmd.Parameters[0].Value = i.ToString(); Dbcmd.Parameters[1].Value = i.ToString(); Dbcmd.ExecuteNonQuery(); } ciao, André -- Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] arithmetic overflow mystery
Hello together, this is the first real problem I have with .net provider for more than 2 years; great work! Thanx! But this one is really scaring me. I get an FBException arithmetic exception, numeric overflow or string truncation, suddenly. And I only get it in .net using provider 2.0.1, the same query runs fine in IBExpert, for example, on the very same server and the same database. As far as I can tell, that routine is still running fine in the deployed version of my application... Here is what is causing the exception: Cmd_PosMax = new FbCommand(); Cmd_PosMax.Connection = Program.DBConn101; Cmd_PosMax.CommandText = Select + max(D3017003.P3017_017Z) + from + D3017003 + where + D3017003.P3017_001Z = @IDEBA ; Cmd_PosMax.Parameters.Add(@IDEBA, FbDbType.Char, 5); Cmd_PosMax.Parameters[@IDEBA].Value = IDEBA; sPoxMax = Cmd_PosMax.ExecuteScalar(); I don't have the slightest clue what is going on or wrong. And my experience is not good enough to know where to start looking. The parameter IDEBA at the time has a valid content (for example 27315, but the exception gets thrown on _all_ possible content, so it's not just the matter of one ID. Thanks in advance, André ~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 0 Telefax: +49 2389 9240 150 e-mail: i...@beta-eigenheim.de Amtsgericht Hamm Nr. B 420 || USt-IDNr.: DE 125215402 Geschäftsführer: Achim Krähling, Dirk Salewski, Matthias Steinhaus -- Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-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] Help with BLOB type
Hello, also check out this link: http://www.firebirdsql.org/dotnetfirebird/blob-reading-example-csharp.html It is for C#, but the principle is the same and you should be able to transfer it with very small changes to VB.net ciao, André ~~~Ihre Nachricht~~~ tgc dear All, tgc i want to insert image to table. how should i do? tgc would you meint to give one example code with vb .net? tgc many thanks tgc tahan tobing ~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 0 Telefax: +49 2389 9240 150 e-mail: [EMAIL PROTECTED] Amtsgericht Hamm Nr. B 420 || USt-IDNr.: DE 125215402 Geschäftsführer: Achim Krähling, Dirk Salewski, Matthias Steinhaus - 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] Help with SQL
Hello Steve, join InvoiceDetail d ON (d.InvoiceID = :InvoiceID) join InvoicePayment p ON (p.InvoiceID = :InvoiceID) where (i.InvoiceID = :InvoiceID) Are parameters supposed to work that way in ADO.net?? I always use @ for a parameter identifier instead of : regards, André - 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] all news are duplicated
Hello Helen, HB FYI, we have very few people (all volunteers) trying to HB manage a large number of lists and it is a time-consuming and HB THANKLESS task. this cannot go uncommented, I think. I do know about what you're talking there, because I made the same experience in other fields, where I am counted on as expert, contributing for free. Just to let you know that I VERY much appreciate all the work that you AND the other volunteers are doing. Without that contribution, given in many places, I would have ended up using another DBMS long ago. And I am quite sure that this would be far less than perfect for me. I am sure that this attitude is true for most others which are on the taking side in these mailing lists as well. HB This particular list has by far the worst HB subscriber behaviour of all lists so it's more of a headache HB than most. Please don't swallow such things just so, but drop a comment about that. I for one wouldn't even know if I would be doing something that's considered to be bad subscriber behaviour, unless someone would point me to it. Hell... maybe you are talking about just me here :) I know you got a humorous but at the same time forcing style to do so :) André - 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] Asynchronous query execution available?
Matthias, please be kind with me if the following advice is boring for you, but you mentioned that you are migrating from Access. I am active in teaching developers how to migrate from dBase DBFs, which in general have a lot of similarities with Access MDBs. The biggest mistake I have to correct out of the minds of people is the problem of overindexing and the missing sense for housekeeping. But a query like the one you posted should - under normal circumstances - deliver records in FAR less than 5-10 seconds, even on a slow machine and with 10.000s of records in the tables. - Are you familiar with the concept of Backup/Restore in Firebird - Did you read Helen's book especially on the keep the Gap going (between OIT and the actual transaction) - Have you checked that you do not have too many indexes, maybe with a lot of duplicate entries. In comparison to MDBs/DBFs where a lot of indexing was sometimes necessary to make acceptable orders, Firebird is sometimes indeed performing better withOUT an index. - Did you probably put different indexes on the same field? Such could make the plan-optimizer in Firebird just go crazy. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ MW Hi, MW Madhu Sasidhar, MD schrieb: Mathias, Please check your query syntax and Db (indexes and keys). Even the most complex JOINS with 1 records returned in my VB.NET does not take more than a few milliseconds. You may have to optimize your Db/SP or query. MS MW well, unfortunately I can't seem to find a problem with my query or MW indexes/keys. MW Maybe you can see any sense in this and help: MW Query: MW -- MW SELECT visits.VISITED, visits.BROWSER, SiteUrls.URL, titles.TITLE MW FROM SiteUrls INNER JOIN (titles INNER JOIN visits ON titles.IDTITLE = MW visits.TITLEID) ON SiteUrls.idSiteUrl = visits.URLID MW ORDER BY visits.VISITED DESC; MW (Using RIGHT JOIN does not make a difference.) MW On those tables, the timestamp column visits.VISITED has a descending MW index, while titles.IDTITLE and SiteUrls.idSiteUrl are (bigint) primary MW keys and visits.TitleID and visits.URLID are bigint columns with MW ascending index sort order. MW visits.BROWSER, SiteUrls.URL and titles.TITLE are not indexed because no MW grouping or sorting takes place on this columns. MW I also rebuild the indexes (deactivate/activate) and updated database MW statistics at no avail. MW Did I overlook something? MW Regards, MW Mathias Wuehrmann MW Mit freundlichen Grüßen, MW Mathias Wührmann MW FLEXact Informationssysteme - 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] selecting accented vowels from RDB$RELATIONS
Hello, you are already CREATING the database using CS NONE. IBExpert is sometimes using nasty tricks :) I am not too much expert in that but I made the following experience: If there is no pressing need to define CS NONE as default for the database, then it would be good to define one Charset and to specify the same CS in your connection. Try that and see if it helps. I do have a lot of special characters and have no problems using Win1252 on both sides. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ AGG my tests: AGG NONE, incorrect results AGG UTF8, I/O error for file CreateFile (open) H:\Firebird AGG Databases\Facturación.fdb AGG Error while trying to open file AGG UNICODE_FSS, I/O error for file CreateFile (open) H:\Firebird AGG Databases\Facturación.fdb AGG Error while trying to open file AGG ISO8859_1, arithmetic exception, numeric overflow, or string truncation AGG Cannot transliterate character between character sets AGG Looking at RDB$RELATIONS structure from IBExpert: AGG RDB$RELATION_NAME CHAR(31) CHARACTER SET UNICODE_FSS, AGG 2008/2/19, Carlos [EMAIL PROTECTED]: Hello: I'll start with UTF8. If it wouldn't work. I'll select it as raw bytes and 'll look what the database is sending. Try using ISO8859-1, i think utf8 will not work as the system tables are not unicode compliant ( unless this has changed recently ) -- Carlos Guzmán Álvarez Vigo-Spain - 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 AGG - AGG This SF.net email is sponsored by: Microsoft AGG Defy all challenges. Microsoft(R) Visual Studio 2008. AGG http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ AGG ___ AGG Firebird-net-provider mailing list AGG Firebird-net-provider@lists.sourceforge.net AGG https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - 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] FBException using VPN
On my LAN the same code is OK. This issue just happens on my VPN clients and just with Date/DateTime fields. Alex, I must admit that I do not know if the normal client.dll (fbclient.dll or gds32.dll) still is involved when using the .net provider. But I had exactly the same issue as you described when for compatibility reasons I was still using a gds32.dll and another software package installed an older version over the existing one. That was far back when using Delphi7, but maybe your problem has the same root? It would not hurt to check the version(s) of the client dlls on the VPN clients, I guess. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 - 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] FBException using VPN
Alex, I am also using OpenVPN to connect some remote clients including my home with the main building. I remember clearly that a local application could run easily using OpenVPN. I could dock the laptop into the LAN and did not have to change anything. So I would doubt that the problems are caused by OpenVPN. But at those times the application was written in Delphi and dBase. For 1 year already, we are using Remote Desktop/Terminal Server instead of locally installed applications. So I did not do any test using the .net-provider. I am sure I could make a test when I am at home, and report results to you tomorrow. I will be setting up something using the good old employee.fdb. If it works, I will send the project to you by e-mail. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ AC Hello André, AC My Fb server is 2.0.1 and I'm using the same client AC version in every computer on VPN. AC I've opened the port 3050 on my firewall and I can run AC the application without any problem (connecting to AC myserver:3050 instead of 10.7.0.X from my VPN), so AC definitely is the OpenVPN server, but for some unknown AC reason Firebird has issues with it. AC Regards, AC --- André Knappstein, Controlling AC [EMAIL PROTECTED] escribió: On my LAN the same code is OK. This issue just happens on my VPN clients and just with Date/DateTime fields. Alex, I must admit that I do not know if the normal client.dll (fbclient.dll or gds32.dll) still is involved when using the .net provider. But I had exactly the same issue as you described when for compatibility reasons I was still using a gds32.dll and another software package installed an older version over the existing one. That was far back when using Delphi7, but maybe your problem has the same root? It would not hurt to check the version(s) of the client dlls on the VPN clients, I guess. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 AC - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. AC http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net AC https://lists.sourceforge.net/lists/listinfo/firebird-net-provider AC ___ AC I'm free, I use GNU/Linux. AC Close your Windows, Open your mind. AC AC AC ¡Capacidad ilimitada de almacenamiento en tu correo! AC No te preocupes más por el espacio de tu cuenta con Correo Yahoo!: AC http://correo.yahoo.com.mx/ AC - AC This SF.net email is sponsored by: Microsoft AC Defy all challenges. Microsoft(R) Visual Studio 2008. AC http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ AC ___ AC Firebird-net-provider mailing list AC Firebird-net-provider@lists.sourceforge.net AC https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - 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] FBException using VPN
Home early this evening, and tried at once. Well, seemed to have forgotten that the employee.fdb does not contain any date fields, only timestamps. But maybe this is already enough for testing? I set up a vqd (very quick and dirty) example connecting to the employee database on a server. To be quick I was using visual designer and so you will find the data components in the form1.designer.cs (*shiver*). I just sent the project 44KByte to your mail-adress. Open the project, select the fbconnection and change the servername, password and username to your needs. employee.fdb is aliased - like all databases - even on this testing server. If you don't have an alias for that you will also need to enter the server path. the test application runs fine through our openVPN tunnel. OpenVPN 2.0.2 FBClient 2.0.0.0 (don't know why not .0.1 is on my home machine) FBServer 1.5.2 as remote test server. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ AC Hello André, AC My Fb server is 2.0.1 and I'm using the same client AC version in every computer on VPN. AC I've opened the port 3050 on my firewall and I can run AC the application without any problem (connecting to AC myserver:3050 instead of 10.7.0.X from my VPN), so AC definitely is the OpenVPN server, but for some unknown AC reason Firebird has issues with it. AC Regards, AC --- André Knappstein, Controlling AC [EMAIL PROTECTED] escribió: On my LAN the same code is OK. This issue just happens on my VPN clients and just with Date/DateTime fields. Alex, I must admit that I do not know if the normal client.dll (fbclient.dll or gds32.dll) still is involved when using the .net provider. But I had exactly the same issue as you described when for compatibility reasons I was still using a gds32.dll and another software package installed an older version over the existing one. That was far back when using Delphi7, but maybe your problem has the same root? It would not hurt to check the version(s) of the client dlls on the VPN clients, I guess. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 AC - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. AC http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net AC https://lists.sourceforge.net/lists/listinfo/firebird-net-provider AC ___ AC I'm free, I use GNU/Linux. AC Close your Windows, Open your mind. AC AC AC ¡Capacidad ilimitada de almacenamiento en tu correo! AC No te preocupes más por el espacio de tu cuenta con Correo Yahoo!: AC http://correo.yahoo.com.mx/ AC - AC This SF.net email is sponsored by: Microsoft AC Defy all challenges. Microsoft(R) Visual Studio 2008. AC http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ AC ___ AC Firebird-net-provider mailing list AC Firebird-net-provider@lists.sourceforge.net AC https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - 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)
Jürgen, reading this I am quite glad that I have not needed this property in .net provider so far, because I admit it would exceed my comprehension of FB internals. Just in case I need it in future, I would like to get an additional clarification: Looking at a column which is not nullable because you set NOT NULL to the column, you would EXPECT the property is_nullable to be true, where true is represented by the numeric value 1. I would NOT, because literally the column is not nullable, and so I would not want to have this situation concluded as column is nullable. Instead I would either expect that the result is 0 where 0 means false or 1 where 1 means false (because the NOT-NULL flag in the system table is set to 1 as Helen described...) Looking at a column which is not nullable because you (only) set it's domain to a domain for which you set NOT NULL, not touching the NOT NULL constraint of the column itself, you would EXPECT the property is_nullable false. I also would, because the column is indeed not nullable. 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. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 - 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)
Hello Jiri, 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. JC Isn't this just negation of is_nullable? BTW in schema table are some JC well-known columns so you cannot adding/removing some in a free way. No, not necessarily. You can set the column's NOT NULL in addition to it's Domain's NOT NULL. That would be double for now. Once you remove the NOT NULL from the domain, this column would still remain not nullable. Jürgen might have exactly a situation where he needs this information. - 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
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. Even several 100 users should not crash a Firebird server. Is the application installed on every client machine, or are you running remote sessions? In spite of the fact that there is data worth only 300 MB but the file size does not seem to shrink down. Excuse me if this is a stupid question, but are you familiar with the concept of backup/restore? - 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] DDEX provider - support files and installation
2.1. BTW no matter wheter you have VS SDK you can use ...Less.reg, isn't it? 3. What about installation. Maybe should provide some no so common path like %ProgramFiles%\FirebirdClient, 'cause there're *.txt files with same name from FirebirdClient installation, so during install some can be confused. I know, it's not a big deal, bug it's also small change. Jiri, all of that sounds VERY good to me. If the time for implementing these changes can be spared this will be a big help for a lot of people. About developers and their abilities: the world is not just black and white but has a lot of shades between. I would not call myself a real developer and especially I do not have time to learn about all new things at once. But I wrote quite a big application, now half based on Firebird and already 5% written in C#. And the income of about 50 employees depends on that. So I am also a bit more than a hobbyist. I always demonstrate in my workshops how to use ODBC in the beginning, and once the attendees understood ADO.net principles, they do not need DDEX anyway. But those who do not listen to me are already re-converting their just converted-to-Firebird applications over to MSSQL just because it's too complicated to install the designtime support for the FB provider. Thanks, André - 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] Help: Unable to execute theGRANTstatement
My somewhat restricted knowledge of Firebird internals might lead me wrong here, but wouldn't you have to run GRANT statements against the target database, instead of against the security.fdb ??? -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 - 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] unexpected problem with Euro sign
coming back to that topic, if anybody reading this will try the same. found out that all stored procedures have to be recompiled, otherwise there will be transliteration errors. After recompiling offending stored procs, everything is fine. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ JC On 7/20/07, André Knappstein, Controlling JC [EMAIL PROTECTED] wrote: 1.) update rdb$database set rdb$character_set_name = WIN1252; JC This isn't required. This is default charset for new columns if it's JC not specified. 2.) update rdb$Fields set rdb$character_set_ID = 53 where rdb$character_set_ID = 21; 3.) update rdb$function_arguments set rdb$character_set_ID = 53 where rdb$character_set_ID = 21; JC This the quickdirty version. But if no error is reported during JC backuprestore, it's fine. Then backing up, and restoring into a new database. Quite brutal, I know, but that worked perfectly. But - before I try that with the production databases - did I miss something important which might beat me only much later?? Is there maybe a much more simple way to switch character set for a database? JC Changing domain. Thanks, André ~~~Ihre Nachricht~~~ 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? DH ISO 8859-1 and WIN-1252 are almost exactly the same, except that where ISO DH 8859-1 has some control codes, WIN-1252 has a few extra letters (like U+2020 DH , etc) -- one of those extra letters is the Euro sign. DH Many applications, however (especially Windows applications) treat ISO DH 8859-1 as being synonymous with WIN-1252, so that's probably why it worked DH in those other cases. .NET is not so lenient, however, and something marked DH as ISO 8859-1 to .NET will not be able to contain a Euro symbol. DH 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 - 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] unexpected problem with Euro sign
Just for confirmation: I was testing with a backup of several production databases. All results were the same: changing charset from ISO8859_1 to WIN1252 for all objects in the database does the trick. I can then read and write the Euro-sign not only via ODBC and .net for ODBC and via other drivers, but ALSO via FB.net provider. I have one request for advice from the experts here, please: Not needing the database 24/7, luckily, I was taking it offline and doing the following 3 steps: 1.) update rdb$database set rdb$character_set_name = WIN1252; 2.) update rdb$Fields set rdb$character_set_ID = 53 where rdb$character_set_ID = 21; 3.) update rdb$function_arguments set rdb$character_set_ID = 53 where rdb$character_set_ID = 21; Then backing up, and restoring into a new database. Quite brutal, I know, but that worked perfectly. But - before I try that with the production databases - did I miss something important which might beat me only much later?? Is there maybe a much more simple way to switch character set for a database? Thanks, André ~~~Ihre Nachricht~~~ 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? DH ISO 8859-1 and WIN-1252 are almost exactly the same, except that where ISO DH 8859-1 has some control codes, WIN-1252 has a few extra letters (like U+2020 DH †, etc) -- one of those extra letters is the Euro sign. DH Many applications, however (especially Windows applications) treat ISO DH 8859-1 as being synonymous with WIN-1252, so that's probably why it worked DH in those other cases. .NET is not so lenient, however, and something marked DH as ISO 8859-1 to .NET will not be able to contain a Euro symbol. DH 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] unexpected problem with Euro sign
Hello Gang, I am a bit puzzled about a problem which came quite unexpected to me. It seems that I cannot get our Euro-sign (ALT+0128) through to the client GUI via the .net Provider. Database standard for character type fields is ISO8859_1, Database-fields are ISO8859_1, Charset of Connection is ISO8859_1 All is well when querying the database with Delphi-components, or via ODBC to old dBase applications, or via ODBC to C#-programs. Isn't ISO8859_1 the correct charset for also transmitting Euro-signs? And if it is not, why does it nevertheless work with other components? Anf if it is not, which _IS_ a good charset for this? Thanks in advance -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 - 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] [2] unexpected problem with Euro sign
You should use unicode (UTF8) in connection string, on 99% you're putting data from .NET in Unicode. Thanks, Jiri. I will give that a try this afternoon. But the data was mostly not entered via my .net-application. - 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
Damn, I missed, that you're not inserting (but the connection string should be changed at all). What exception you get? No problem, because for the nearest future I definitely do plan to insert data via the (new) .net application. I am doing the latest tests and now stumbled over that curiosity. I do NOT get any exception. Just the character which is shown as Euro symbol in other applications is shown as a placeholder symbol when using the .net Provider. Other applications also includes IBExpert which - as I understand - is written in Delphi. Other applications also includes my own old dBase and Delphi applications, either with native drivers or via BDE/ODBC. Also everything works fine when I am using the Microsoft net provider for ODBC. I tried changing the charset of the connection to UNICODE_FSS but to no avail. Instead of showing rectangle placeholder now I just get an empty space. When I ENTER data with .net provider and charset UNICODE_FSS the result will be stored in the database as question mark (?); querying the database again will also deliver a question mark. What could I probably be overlooking? Thanks for your time - 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
Now you got me, Jiri :) I have once and never again used ISQL when I started converting DBF to Firebird 4 years ago. If I need to use it to make further tests, I will get the documents and use it. Carlos' Answer might be helping out as well, thanks. ~~~Ihre Nachricht~~~ JC It's definetely encoding problem. It looks like, that the sign isn't JC added into DB right. JC When you connect using isql with proper encoding (probably DOS852) did JC you get the sign right? - 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
Thanks for the answer, Carlos. So, I should use Win1252 and be well? That's not too big a problem. I have about 300 tables, but most of the objects do not override the database's charset. Can I change the database's charset by restoring a backed up db into an (empty) database with another charset? 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? Having the Euro sign (for notes/memo-fields) is essential for my application so I will try to convert charset as early as possible and give a report back. I will try Win1252 because I don't want the 2 bytes extra for Unicode. Thanks, André CGÁ Whatever you are trying to achieve here, note that there is no euro- CGÁ character in ISO-8859-1. You can use ISO-8859-15, WIN1252, UTF8 CGÁ or even more strange options, but not ISO-8859-1. - 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
Paul, I still did not find a way to reply to this mail-list thingy from behind our proxy, so I hope this message will get through to you. The function you wish for does not belong into a command-feature or new method, but you can easily implement it yourself. To do that, connect with sufficient privileges and query the system tables via that connection. select SP.RDB$Procedure_ID from RDB$Procedures SP where SP.RDB$Procedure_Name = :PM_TheProcedureName You can hand the procedure name in question to that query and if you receive a result, then a procedure with the same name exists in the database. I would be aware of the danger that the procedure could probably have the same name, but maybe it has a different content/effect from the one you wish to implement/recreate. In addition I think I remember that only with classic server engine a listed stored proc is active already for the next connection to the database. Hi I face with this situation: Some customers want to have reports or export 'patterns' from fb database. For that I have some possibilities as sql query or stored procedures. For query I make all by code. For stored procedures I have 2 situation, first, SP exist in database, second SP not exist. If SP exist , just run, etc. For this case it would be useful to have a method to check if SP exist in database, if not, recreate procedure. (this works only for FB2 I think, for FB 1.x just create). Sample code: FBCommand fbCommand1 = new FBCommand(); fbCommand1.CommandType = CommandType.StoredProcedure; if (!fbCommand1.Exists) {fbCommand.Recreate()}; What do you think about ??? TIA, Paul -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 - 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
In addition I think I remember that only with classic server engine a listed stored proc is active already for the next connection to the database. JC What do you mean with listed? If I create a new SP, I will find it then listed in RDB$Procedures. On ClassicEngine, next user will be able to execute it. On SuperEngine, very often the next user can NOT run it until a restart of the server is made or the last client disconnected. I think this is normal, but I don't know. I am only using Classic, and I see such problems only where users have Super engine. This is in any case something that Paul also has to keep in mind. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 - 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] Parameterized Query
Peter, not an expert myself, but in your code I am missing a statement like: daDuePacks.SelectCommand = FbCmdDuePacks; so far you are setting the parameter to the command-object, and to the adapter-object you are just copying the select command text. Don't know if that is the culprit in your case, but does it get better, if you add the above command line?? ciao, André Hi, I am trying to use a parameter in one of my queries but consistently get the following error: 'Prepare adapter to retrieve information from db. Dim daDuePacks As New FbDataAdapter(sDuePackSelect, conn) 'Add table to the Module based dataset. daDuePacks.Fill(m_dsDocoInfo, DuePacks) Can someone please tell me what I'm doing wrong? - 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] Parameterized Query
Hello Peter, I'm afraid I can't, because I'm an awfully bad teacher. I can try just this: without that association the adapter does not know of your defined parameter. The need to supply the selectcommand-object to the adapter, I think, is basic knowledge for dealing with ADO.net objects. While I still have some problems with basics in C#/ADO.net myself, this one I think is quite clear. Check the OLH maybe on Fill method. There you will find: The Fill method retrieves rows from the data source using the SELECT statement specified by an associated SelectCommand property. -- Mit freundlichen Grüssen, André Knappstein, EDV und Controlling Verwaltungs- und Erlebniszentrum Marina Rünthe beta Eigenheim GmbH Hafenweg 4 59192 Bergkamen-Rünthe Durchwahl: +49 2389 9240 140 ~~~Ihre Nachricht~~~ PD Thank you André PD Works perfectly! PD I don't really understand your explanation. PD I suppose I really don't understand why it is possible to retrieve data from PD the database when the query has no parameters without the addition of your PD below suggestion. PD And why I need the extra line when the query uses parameters. PD If possible could you give me some more information to improve my PD understanding of this? PD Thanks for your time, PD Peter. PD -Original Message- PD From: [EMAIL PROTECTED] PD [mailto:[EMAIL PROTECTED] On Behalf Of PD André Knappstein, Controlling PD Sent: Thursday, 19 April 2007 6:15 PM PD To: firebird-net-provider@lists.sourceforge.net PD Subject: Re: [Firebird-net-provider] Parameterized Query PD Peter, PD not an expert myself, but in your code I am missing a statement like: PD daDuePacks.SelectCommand = FbCmdDuePacks; PD so far you are setting the parameter to the command-object, and to the PD adapter-object you are just copying the select command text. PD Don't know if that is the culprit in your case, but does it get PD better, if you add the above command line?? PD ciao, PD André Hi, I am trying to use a parameter in one of my queries but consistently get PD the following error: 'Prepare adapter to retrieve information from db. Dim daDuePacks As New FbDataAdapter(sDuePackSelect, conn) 'Add table to the Module based dataset. daDuePacks.Fill(m_dsDocoInfo, DuePacks) Can someone please tell me what I'm doing wrong? PD - PD This SF.net email is sponsored by DB2 Express PD Download DB2 Express C - the FREE version of DB2 express and take PD control of your XML. No limits. Just data. Click to get it now. PD http://sourceforge.net/powerbar/db2/ PD ___ PD Firebird-net-provider mailing list PD Firebird-net-provider@lists.sourceforge.net PD https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - 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