Re: [Firebird-net-provider] named parameters
Hello: > I am using Firebird Client 2.0.1 and need do some dynamic SQL using > named parameters: > > UPDATE order SET qty = ? WHERE order_id = ? > > The catch is that I want the parameters to be named. What is the > correct syntax for Firebird Client? You can use sql server like named params: UPDATE order SET qty = @content WHERE order_id = @id -- Download Intel® 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] Does provider fit to work with EF 4.0
Hello: > I've installed VS 2010 Beta 2 and Firebird .NET Provider 2.5.1 + DDEX > 2.0.4, but i can't create connection to FB server: > > 1) From server explorer. I chooose Add connection ... -> Data source: > other -> Data provider - .NET Framework Data Provider for Firebird. > After this "Add connection" window appears with firebird settings, but > when i'm trying to type something (data source, or database? or user, > ets.), "Add Connection" window disappears without any messages. > If i remember well that happens when the provider is not properly registered in the machine.config file. -- 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] Dialect 1 issues?
Hello: > Are you saying that the Firebird provider won't work for Interbase or > that it is bad form for me to use the open source software with the > closed source database? The only version of Interbase that *could* work with the provider is the 6.0, 7.5 may have changes in the network protocol that are incompatible with the provider protocol implementation. -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-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] Can someone please email me FIREBIRDSQL.DATA.FIREBIRDCLIENT.DLL from .NET data provider version 2.0.1?
Hello: > Jim - Yes, I have the .exe from the official web site. by the ".exe" did you mean the installer package ?? if yes, have you installed it ?? - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [Patch] 1.7 changes to connect against Firebird 2.1
Hello: > If there will be a problem, let me know. I'll apply the patch and > commit changes. The we can do official release. > the changes should be commited now :) - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [Patch] 1.7 changes to connect against Firebird 2.1
Hello: Attached is a patch file ( a ZIP file with extension changed ) with changes to allow v1.7 of the provider to connect against Firebird 2.1, changes has been done by backporting 2.5 svn sources to the v1.7 sources. The nunit test suite looks as being running fine ( except one of them ) agins Firebird 2.1.1 SuperServer, i haven't tested the embedded server support XDD -- Best regards Carlos Guzmán Álvarez NetProvider_FW11_Firebird_Server_2_1_X.piz Description: Binary data - 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=100&url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [Patch] 1.7 changes to connect against Firebird 2.1
Hello: > Hi, > > will you commit these changes to NETProvider_FW11 branch in SVN? > hummm haven't checked if i continue to have commit rights XDD, will try to do so as soon as possible :) - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [Patch] 1.7 changes to connect against Firebird 2.1
Hello: Attached is a patch file ( a ZIP file with extension changed ) with changes to allow v1.7 of the provider to connect against Firebird 2.1, changes has been done by backporting 2.5 svn sources to the v1.7 sources. The nunit test suite looks as being running fine ( except one of them ) agins Firebird 2.1.1 SuperServer, i haven't tested the embedded server support XDD -- Best regards Carlos Guzmán Álvarez NetProvider_FW11_Firebird_Server_2_1_X.piz Description: Binary data - 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=100&url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Server Engine`?
Hello: > Timestamp - when one of my application crashes I have a dead entry in my > database... > > I want to have a "server engine" which knows each application and can react > if an application crashes because of a timeout when the application isn't > responding. > Well, i think you will need to do it yourself ;), there are no way right now to know wheter the record is locked or not, and to lock the record you will need to do a select ... for update, that if i remember well will lock the data in the server. Anyway, i didn't see the problem on allowing two people edit the same record, as far as only one of them will save his changes xD - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Trailing spaces trimmed
Hello: > Hardly. I can send you private build with this removed. You can test > it and see, whether it works. > > PS: Carlos, if you're reading, can you see why is this there? > I didn't remember the exact reason for this ( i think it can be related to some change done time ago on a user request bu didn't remember exact details ) - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
Hello: > ExecuteReader() takes 0.029 seconds. > Read() takes 0.026 seconds. What is the amount of data being fetched ?? remember that Read will fetch rows in packs of 200, by default, when working against the classic/superserver firebird server ( subsequents reads will work agsint the fetched rows until they are all readed, then it will try to fetch another pack of 200 rows ) - 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=100&url=/ ___ 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 provider and DataGridView and Visual Studio 2008
Hello: > >> I get to that point. Then, unless I am completely out to lunch, I need >> to right click the designer surface to add items. I right click and >> select Add | Query. (My only choices are Query, Data Table and Table >> Adapter). Which gets me to the TableAdapter Query Configuration >> Wizard. Where I need to select a connection. So I click New >> Connection because the one that appears by default is not the one that >> I want. Which eventually gets me to the point where I have to select a >> provider and Firebird is not listed. >> And you have the DDEX provider for firebird installed ?? - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [firebird-support] Not converttoUNICODE in Embedded
Hello: > Problem is, that for i.e. win1250 it works fine, so some quick'n'dirty > conversion isn't good. Do you have any idea how to solve this? Do > there conditional conversion? ... > And for UTF-8 works or not ?? if not, maybe there is a way to read the string byt to byte into a buffer and encoding it, huu - 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=100&url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] First asp.net/firebird application
Hello: > I got this error: > > Compiler Error Message: BC30002: Type 'Firebird.fbConnection' is not > defined. Have you added a reference to the FirebirdSql.Data.FirebirdClient.dll assembly in the web.config file ?? - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error: Object reference not set to an instance of an object
Hello: > In fact design-time support for these, has been dropped somewhere > between 2.0 and 2.5 :) (sorry I don't remember exactly the version). > It was removed in 2.1 if i remember well xD - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Regarding connection speed with .Net
Hello: > > Hello All, > > > > I have installed Firebird 2.0 (server) in one of the system. Now, I am > trying to connect from another system via .Net Provider using > FBConnection.Open(). > > > > 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. > > > > I want to know the reason, why it is taking so much of time? > This maybe caused by a network configfuration problem ( spending time resolving the server name ), are you sure your network is well configured ?? - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Compact Framework error using .NET Provider
Hello: > I don't know what could be causing this. It is my first experience with > Compact Framework, Can anyone help me please ? > Have you done a rebuild of the provider sources using the Compact Framework ?? - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] How to verify if SP exist in DB?
Hello: > > Hi all > > Using VS2005 , FB1.5.4 and FB.Net 2.1! > > I have a procedure to verify if a SP exist in database, code looks like: > Have you given a try using FbConnection.GetSchema ?? - 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] Timeout exceeded exception
Hello: > Ok, I just making a simpliest queries like "select somth from left > join where order by group by". If I'm rising different menu items with there > own functionality there are no exceptions at all. Haven't understood well but are you using connection pooling ?? -- 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
Re: [Firebird-net-provider] System.Argumen,
Hello: > System.Argumen > tException: Encoding name 'ks_c_5601-1987' not supported That encoding is used only on MS.NET builds of the provider, have you done a rebuild of the provider using mono ?? -- 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
Re: [Firebird-net-provider] setup problem
Hello: > thanks for reply, > i don't understand well. i must install fb server in every machine that > i want run my project?!!?! Could you post the connection string you are using ?? if you are using Localhost as the server name you will need to have installed firebird in the machine you are trying to run the application, if you want to connection to another server simply give the server name in the connection string -- 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
Re: [Firebird-net-provider] Timeout exceeded exception
Hello: > Hi! I'm permanently getting "Timeout exceeded" exception during my program > work. I use: > VS2008 > FB Client 2.5 > FB Server 2.1. > > So why this could be happens? > It will be great if you provide some more details on what you are doing. -- 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
Re: [Firebird-net-provider] Missing files on SVN
Hello: Hi Carlos, in project file for FirebirdClint (latest version) are two files that are not in SVN: StoreSchemaDefinition.ssdl StoreSchemaMapping.msl Could you please commit them? Attached to this email, sorry. OT: Seems that you'll have no free time. ;) :) -- Carlos Guzmán Álvarez Vigo-Spain http://schemas.microsoft.com/ado/2006/04/edm/ssdl";> SELECT TABLE_SCHEMA + TABLE_NAME [Id] , TABLE_CATALOG [Catalog] , TABLE_SCHEMA [Schema] , TABLE_NAME[Name] FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' SELECT c.TABLE_SCHEMA + c.TABLE_NAME + c.COLUMN_NAME [Id] , c.TABLE_SCHEMA + c.TABLE_NAME [TableId] , c.COLUMN_NAME [Name] , c.ORDINAL_POSITION [Ordinal] , CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [Nullable] , CASE WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and c.CHARACTER_MAXIMUM_LENGTH = -1 THEN c.DATA_TYPE + '(max)' ELSE c.DATA_TYPE END as [Type] , c.CHARACTER_MAXIMUM_LENGTH [MaxLength] , c.NUMERIC_PRECISION [Precision] , c.NUMERIC_SCALE [Scale] , columnproperty( object_id( c.TABLE_SCHEMA + '.' + c.TABLE_NAME ), c.COLUMN_NAME, 'IsIdentity' )/* | columnproperty( object_id( c.TABLE_SCHEMA + '.' + c.TABLE_NAME ), c.COLUMN_NAME, 'IsRowGuidCol' )*/ as [StoreGenerated] FROM INFORMATION_SCHEMA.COLUMNS c SELECT kc.TABLE_SCHEMA + kc.TABLE_NAME + kc.COLUMN_NAME [Id] , kc.TABLE_SCHEMA + kc.TABLE_NAME + kc.COLUMN_NAME [ColumnId] , kc.CONSTRAINT_NAME [Name] , kc.ORDINAL_POSITION [Ordinal] FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kc on kc.CONSTRAINT_SCHEMA = pk.CONSTRAINT_SCHEMA AND kc.CONSTRAINT_NAME = pk.CONSTRAINT_NAME WHERE pk.CONSTRAINT_TYPE = 'PRIMARY KEY' SELECT CONSTRAINT_SCHEMA + CONSTRAINT_NAME [Id] , CONSTRAINT_NAME[Name] FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS SELECT FC.CONSTRAINT_SCHEMA + FC.CONSTRAINT_NAME + cast(FC.ORDINAL_POSITION as nvarchar(30)) [Id] , PC.TABLE_SCHEMA + PC.TABLE_NAME + PC.COLUMN_NAME [FromColumnId] , FC.TABLE_SCHEMA + FC.TABLE_NAME + FC.COLUMN_NAME [ToColumnId] , FC.CONSTRAINT_SCHEMA + FC.CONSTRAINT_NAME [RelationshipId] , FC.ORDINAL_POSITION [MapOrdinal] FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/ ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA AND RC.UNIQUE_CONSTRAINT_NAME= PC.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/ ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA AND RC.CONSTRAINT_NAME= FC.CONSTRAINT_NAME AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION - 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] DDEX provider - support files and installation
Hello: > Sorry for late reply, mail stucked on the bottom. > Don't worry :) > Well I think we can use: > * separate place (branch or tag or folder) in SVN > * create conditional builds > > I don't know, what changed in SDK. If it's some extension, I propose > to use conditional builds. But if there're some working changes, the > separation would be IMO better. > The actual trunk sources have the changes take a look at it ( there are changes in base classes and interfaces ) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] question
Hello: > hi; > > i download firebirdSqlclient (.net provider) and after 3 week i > successful to access to database but connection to database wisard (in > tools) don't work, and don't open the tree structure of table,why? Could you please, explain in detail what you are trying to do ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Restore problem
Hello: > I am getting following Exception "FirebirdSql.Data.Common.IscException". > What is the problem with the Code. > > I am using Firebrid 2.0.3 and .NET Provider Version 2.1.0 > Please could yoy send the exception details ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Unsupported On-Disk Structure
Hello: > Has anyone figured this one out? > Could you try to do a backup using IB 6 and the restore it using Firebird ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Command line switches for Firebird Client?
Hello: > I need to include installer for firebird client net provider in my setup > without the UI. Are there any command line switches I can use to achieve > this? If there are none, how can I install all the necessary files > without using the "normal" setup? > All you will need is the provider assembly, FirebirdSql.Data.FirebirdClient.dll -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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
Hello: > I've tested it under VS2008 Final and works fine. :D IMO we don't need > branching. > I know it will work with VS 2008 :) but there are too many changes in DDEX implementation in the VS 2008 SDK so i think we can do an specific version for that, what do you think ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] [ANN] FirebirdClient 2.1.0 released
Hello: > I downloaded FirebirdClient-2.1.0.msi. > The file size is 331KB instead of 358KB as marked in the webpage. > It should appear correct no, i think i will remove that for future releases as it's not really important hehe > When running it, the installer shows 2.1.0 RC 2. > > Did I download the right file? > http://downloads.sourceforge.net/firebird/FirebirdClient-2.1.0.msi?use_mirror=osdn > Huu it's the correct version i will see to update the installer today setting the correct version in the installer. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Windows CE 4.2
Hello: > I don't know if the following is possible : We have a Windows CE 4.2 > wireless device. We would like to connect to a Firebird database on a > remote server (not embedded). We are using Visual Studio 2003, the version > that targets CE 4.2 You will be not able to do so unless you get to use Visual Studio 2005/.NET Compact Framework 2.0 -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] [ANN] FirebirdClient 2.1.0 released
Hello: FirebirdClient 2.1.0 for .NET 2.0 is available for download. Download information can be found here: http://www.firebirdsql.org/index.php?op=files&id=netprovider -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Ayuda con los Charsets
Hola: Perdon por el retraso. > Gracias Carlos, > > Esto esta asi, > > Mi database es WIN1251, y mi Campo tambien es WIN1251, > y esta es mi forma de accederla Sino me equiovoco el character set deberia ser WIN1252 o ISO8859_1 > -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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
Hello: Sorry for the delay. > You have done some modification in sources? > Not yet, i'm going to move current DDEX provider to branches today so we can modify the devel one to match VS 2008 > If you install FirebirdClient it's by default in > %ProgramFiles%\FirebirdClient. The if you wan to install DDEX, the > default parth is also %ProgramFiles%\FirebirdClient. But in DDEX > installation are some files with same name as in FirebirdClient > installation. So installer asks you, whether to rewrite i.e. > readme.txt or let there the old. Which can be little bit confusing. > We can modify both instalers to install in they own folder inside %ProgramFiles%\FirebirdClient ADO.NET Provider will get installed on : %ProgramFiles%\FirebirdClient\ADONETProvider DDEX Provider will get installed on %ProgramFiles%\FirebirdClient\DDEXProvider -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Ayuda con los Charsets
Hola: > Gracias Carlos, > > Esto esta asi, > > Mi database es WIN1251, y mi Campo tambien es WIN1251, > y esta es mi forma de accederla El charset no deberia ser Win1252 o ISO8859_1 ?? > -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Ayuda con los Charsets
Hello: > Mi database es WIN1251, y mi Campo tambien es WIN1251, > y esta es mi forma de accederla Shouldn't the charset be Win1252 or ISO8859_1 ?? > -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] OT: (un)released version in Jira
Hello: > Hi Carlos, > > I've found, that in tracker we have 2.1.0 RC2 marked as unreleased. > This can be a little bit confusing for reporters. Can you, please, > mark it as released? > It should be correct now, thanks -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enlisting transaction - final and clear
Hello: > So, I'm testing 5 cases per second and seems to be, that I'm little > bit confused with TransactionScope and no result. :) > I'm reading this today, sorry for the delay ... i'm a bit busy this times :) > To clarify things I'll do some summary. Focused on some basic ADO.NET > classes. If you're writing some objects, that will later bind to so > visual components you'll probably use FbXxx objects directly. > Ok. First thing we may solve is what to do when closing enlisted connections > The third and fourth case is IMO problem. Why??? IMO we have two > choices. When enlist is true and no TS block, throw exception (not my > favourite) OR just ignore the enlisting and do it without "thinking" > (my favourite). > There maybe a way to start an implicit transaction scope bu i don't know how ( it maybe too that SqlClient does different things when working against the DTV :P ) > I think there's a room for improvements. We should talk about this and > see what behaviour will fit most needs (something isn't possible > 'cause we don't have DTC). > Sure, and sorry for the delay again. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] (no subject)
Hello: > Hi Carlos, > Could you reproduce it? Haven't the time to check it. > Do you need a sample project? > Yes please. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [Fwd: problem in .NET provider]
Mensaje original Asunto: problem in .NET provider Fecha: Sat, 20 Oct 2007 15:34:00 +0200 De: Peter Turcan <[EMAIL PROTECTED]> Para: [EMAIL PROTECTED] Hello Carlos! For first, thank you for your great work on .NET Firebird provider! I have found problem in it, when there is Turkish regional settings. Problem is in program FbConnectionString.cs, where you are initializing HashTable this way: Hashtable synonyms = new Hashtable(StringComparer.CurrentCultureIgnoreCase); but I don't know why, this hash table, especially GetKey procedure in FbConnectionStringBuilder.cs doesn't work. So in FbConnectionString.cs I have changed StringComparer property to: Hashtable synonyms = new Hashtable(StringComparer.OrdinalIgnoreCase); and everything works ok. (see source from version 2.0.1, but in the latest 2.1.0RC2 it is still the same code) I think, it will be fine to incude this patch into full version all the best, Peter -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 /* * Firebird ADO.NET Data provider for .NET and Mono * * The contents of this file are subject to the Initial * Developer's Public License Version 1.0 (the "License"); * you may not use this file except in compliance with the * License. You may obtain a copy of the License at * http://www.firebirdsql.org/index.php?op=doc&id=idpl * * Software distributed under the License is distributed on * an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either * express or implied. See the License for the specific * language governing rights and limitations under the License. * * Copyright (c) 2004-2005 Carlos Guzman Alvarez * All Rights Reserved. */ using System; using System.Collections; using System.Data; using System.Globalization; using System.Text.RegularExpressions; using FirebirdSql.Data.Common; namespace FirebirdSql.Data.FirebirdClient { internal sealed class FbConnectionString { #region · Static Fields · public static readonly Hashtable Synonyms = GetSynonyms(); #endregion #region · Static Methods · // This is somethig that should be needed in .NET 2.0 // for use with the DbConnectionOptions or DbConnectionString classes. private static Hashtable GetSynonyms() { // Hashtable synonyms = new Hashtable(StringComparer.CurrentCultureIgnoreCase); Hashtable synonyms = new Hashtable(StringComparer.OrdinalIgnoreCase); synonyms.Add("data source", "data source"); synonyms.Add("datasource", "data source"); synonyms.Add("server", "data source"); synonyms.Add("host", "data source"); synonyms.Add("port", "port number"); synonyms.Add("port number", "port number"); synonyms.Add("database", "initial catalog"); synonyms.Add("initial catalog", "initial catalog"); synonyms.Add("user id", "user id"); synonyms.Add("userid", "user id"); synonyms.Add("uid", "user id"); synonyms.Add("user", "user id"); synonyms.Add("user name", "user id"); synonyms.Add("username", "user id"); synonyms.Add("password", "password"); synonyms.Add("user password", "password"); synonyms.Add("userpassword", "password"); synonyms.Add("dialect", "dialect"); synonyms.Add("pooling", "pooling"); synonyms.Add("max pool size", "max pool size"); synonyms.Add("maxpoolsize", "max pool size"); synonyms.Add("min pool size", "min pool size"); synonyms.Add("minpoolsize", "min pool size"); synonyms.Add("character set", "character set"); synonyms.Add("charset", "character set"); synonyms.Add("connection lifetime", "connection lifetime");
Re: [Firebird-net-provider] (no subject)
Hello: > You're right, LIKE 'xxx%' OR Starting with 'xxx' both generate the same > execution plan. > Unfortunately, there are situations where starting with doesn't fit my needs. the query runs fine under isql ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enlisting transaction
Hello: Is this something like what you are doing ?? using (TransactionScope scope = new TransactionScope()) { using (FbConnection connection = new FbConnection(@"DataSource=localhost;Database=C:\Program Files (x86)\Firebird\Firebird_2_1\examples\empbuild\employee.fdb;UserID=SYSDBA;Password=masterkey;Enlist=true")) { DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); using (FbDataAdapter adapter1 = new FbDataAdapter("SELECT * FROM Customer", connection)) { adapter1.Fill(ds1); } using (FbDataAdapter adapter2 = new FbDataAdapter("SELECT * FROM Employee", connection)) { adapter2.Fill(ds1); } } } -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with connection strig using Report Manager
Hello: > I have I silly question : do I have to make this configuration on > every computer that I install my application ? DDES is for devel only but anyway you can put it on your App.config file -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with connection strig using Report Manager
Hello: > Hi ! I've discovered Report Manager (http://reportman.sourceforge.net/ > ),free reporting solution and I've tried to connect using firebird > and VB .Net 2005 Express.Connection manually works,but not using > code.Has anyone used it?Thanks. > > I've got this error,on last line : > "An OLE DB Provider was not specified in the ConnectionString. An > example would be, 'Provider=SQLOLEDB;'" FirebirdClient is an ADO.NET Data Provider not and OleDb driver -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Embedded and .NET Provider used in o2 Connection Manager
Hello: > Some time ago I have upgraded my phone contract to include also mobile > internet (5GB/month) and as a normal user read the instructions on the > o2 website, which suggested to install the "o2 Connection Manager" > software. I installed it, but then got some device driver problems with > another similar software (Vodafone Mobile Connect - I have two mobiles, > one private and one from my company) and had to go deeper... > That looks really nice :) > I have to confess that I did not notice the Firebird on the first check > (hmmm... how could it be? should smell it from 1 km distance!), but the > folder structure appeared somewhat familiar... But then I noticed the > intl/ directory, then the .NET Provider DLL and finally fbembed.dll. :) > hehehehe :) > Congratulations! Keep up with good job! > thanks very much ! -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Enlisting transaction
Hello: > Both inside same not working. Only first .Fill fills datatable. Second > is empty. It's probably not expected. :) > I will check it on Friday > BTW when I not use TransactionScope block but in connection string is > enlist=true should this work? > No -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Enlisting transaction
Hello: > With this, everything works fine. Now change the enlist=false to > enlist=true.The filling stopped working. OK, I added TransactionScope > around all two .Fill commands. But only first was sucesfull and > DataSet has been filled, the second not. When you add TransactionScope > block around every .Fill command everything works fine. :o Both inside the same TransactionScope -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] IsolationLevel
Hello: > It's not supported. Only valid values are: > IsolationLevel.ReadCommitted; > IsolationLevel.ReadUncommitted; > IsolationLevel.RepeatableRead; > IsolationLevel.Serializable; > IsolationLevel.Chaos; > IsolationLevel.Unspecified; I have committed a change to add the Snapshot il as well. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Returning clause
Hello: > I'm pretty sure, that it has been working, isn't it? Am I try to debug > and locate the problem or it's just as is? Huumm if i remember well that was implemented using ExecuteNonQuery calls with output parameters but i will try to check it tomorrow :) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: 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] Problem : Firebird integration with
Hello: > I checked all of my tables and i'm sure that they all have primary keys. > I think ddex cannot understand the user tables to show me . > Any other ideas will be great. I haven't visual studio 2005 installed right now bu i will try to give a try to this on vs 2008 beta 2 this weekend -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Building WebProviders
Hello: > Weird... > > Never mind, I think, we can put on website new build, isn't it? Sure. - 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] Membership Provider 2.1.0.0 -
Hello: > Looks like Carlos didn't build WebProviders. Let's wait, what he will said. > > If you want I can send you build from current sources. In first place they should be built, as i have done the build using VS Could you open a new thread for this problem please. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [ANN] FirebirdClient v2.1.0 RC2 released.
Hello: FirebirdClient v2.1.0 Release Candidate 2, ADO.NET Data Provider for Microsoft .NET 2.0, and mono is available for download. Download information can be found here: http://www.firebirdsql.org/index.php?op=files&id=netprovider If all goes well in the next few weeks this well be the last release candidate. ( The installer of this version has been built using Wix ) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
Hello: > I need to have the C# .NET 2.0 application that could use both firebird > and/or oracle as a database engine. What is the best way to hide the > difference in parameter prefix? In firebird it is '@' in oracle it is > ':' May be it is possible to explicitly set in firebird provider a > prefix to ':'? Can you give more information about how you are using the command classes in both providers ?? Maybe an option to get the parameter prefix from the schema support that is built-in the provider and accesible using FbConnection.GetSchema ?? ( I think the oracle provider should have that as well using the DataSourceInformation metadata collection ) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
Hello: > The ':' is used in procedures, triggers, etc. Ok, anyway i didn't want to change that right now :) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
Hello: > Ah, sorry. I was thinking that '@' is some recomendation for implementors. = > :) Don't worry :) that was decided in the early stages of the provider development ( the place holder is supported as well ) Maybe we should be supporting : as well as it's supported by firebird if i'm not wrong ( or maybe it's ISQL only i'm not sure ) > But no matter, from my POV changing it makes no sense. :) - 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] how to change parameter prefix
Hello: > For this time, it's hardcoded in provider code. The '@' character is > default fo ADO.NET classes, so if oracle is using another, it's weird. That isn't 100% true :) Really the parameter prefix is provider dependedant ( depends on the RDBMS ), in the Firebird .NET Provider the @ was used for compatibility resons with Sql Server :) as it's not really supported by Firebird. -- Best regards Carlos Guzmán Álvarez - 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] GetSchema and numeric precision
Hello: > I could not send to <*/[EMAIL PROTECTED]/*>,I've downloaded > FirebirdClient-2.5.0-Alpha1.msi and it works fine(my old > version was FirebirdClient-2.1.0-RC1). If you have a test case, please send it to my private email -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with FbScript and execute
Hello: > i found the solution , i remove the suspend and the output parameter into my > procedure and after that all is commited. Nice :) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
Hello: > Should be: > > if (IPAddress.TryParse(dataSource, out ipaddress)) > { > return ipaddress; > } Thanks for the hint, the change should be now in SVN :) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
Hello: >> Sorry this way ;) > > Looks good. Thanks !!! i will do the commit a little later today !! XD -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
Hello: Sorry this way ;) private IPAddress GetIPAddress(string dataSource, AddressFamily addressFamily) { IPAddress ipaddress = null; if (!IPAddress.TryParse(dataSource, out ipaddress)) { return ipaddress; } IPAddress[] addresses = Dns.GetHostEntry(dataSource).AddressList; // Try to avoid problems with IPV6 addresses foreach (IPAddress address in addresses) { if (address.AddressFamily == addressFamily) { return address; } } return addresses[0]; } -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
Hello: > OK, I'll commit this to SVN during evening. hehe i have readed this now after i have the change in my local tree hahahaha, this way: private IPAddress GetIPAddress(string dataSource, AddressFamily addressFamily) { if (!IPAddress.Parse(hostname, out addr)) { return Dns.GetHostEntry(hostname).AddressList[0]; } IPAddress[] addresses = Dns.GetHostEntry(dataSource).AddressList; // Try to avoid problems with IPV6 addresses foreach (IPAddress address in addresses) { if (address.AddressFamily == addressFamily) { return address; } } return addresses[0]; } Will it be correct or not ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
Hello: > I don't know, where Carlos is right now. But when he doesn't drop the > ticket till evening, I'll create changes and do tests. I'm at job and can't do the change, but we can add it to 2.5 sources and see what happens ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win
Hello: > It's not a big change and it's only useful in certain circumstances, but it > *is* a better solution. this is what the provider is doing right now ( i have checked it from v2.5, but i think v2.0+ should be doing the same thing ): private IPAddress GetIPAddress(string dataSource, AddressFamily addressFamily) { try { IPAddress[] addresses = Dns.GetHostEntry(dataSource).AddressList; // Try to avoid problems with IPV6 addresses foreach (IPAddress address in addresses) { if (address.AddressFamily == addressFamily) { return address; } } return addresses[0]; } catch (Exception ex) { // If it's not possible to get the list of IP adress associated to // the Data Source we try to check if Data Source is already an IP Address // and return it try { return IPAddress.Parse(dataSource); } catch { // In this case we want to rethrow the first exception throw ex; } } } And the method is being called as: IPAddress hostadd = this.GetIPAddress(this.dataSource, AddressFamily.InterNetwork); -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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] Problem with dataadapter under VS2005 US
Hello: > The strange thing is that this error occures only in the US version of > VS but not in the german one > > Could somebody help please ? Why you don't try with TableAdapters and the DDEX provider ?? The old design time support is deprecated now, and is removed in newer releases. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003
Hello: > The database server is a Linux machine. I wouldn't know how to develop a > server (using sockets) that runs on Linux so I could test the connection > using sockets, but I don't think that the problem comes from here, since > there are some *Delphi* - Interbase apps on the same Windows 2003 > machine that run and properly *connect *to the Interbase Server on > Linux. The problem appears only with the 2 apps developed in C# that use > the ..NET Firebird provider class. Pleazse, make that simple check, there is no the first time a user report that problem, it could be some problem with the dns resolution of .net -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win 2003
Hello: > I forgot to mentioned another particular thing about the Windows 2003 > machine. It has 2 network adapters (one connects to the LAN the other to a > NAS storage). > I've tried even to set to disable the network adapter to the NAS. No change. > No connection... It maybe a network problem ,have you tried to connection using a simple C# console program usina socket to connect to that server ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Character sets of web providers
Hello: > What do you think? Looks fine :) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] 2.1.0 Installer moved to Wix
Hello: The 2.1.0 sources installer has been moved to Wix, hope i will be releasing the next RC in the next few days. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ - 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] Possible bug in Solaris
Hola: > When you read a char field of lenght 1, Windows and Linux return a char of 1 > but in Solaris you get a string with the value and 2 blanks. Huu it could be a problem with the Encoding implementation of mono, but, can you give us a little more of information, like the character set of the database, and the character set of the connection string ?? Where is the firebird server located ?? in solaris as well ?? -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ - 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] Examples of database restore and table
Hello: > I'm looking for some links that explain how to restore databases, and > create tables on new databases, using the Firebird .NET data provider. > Can anyone please point me in the right direction? I'm using version > 2.0.1 BTW. While they are for v1.7 you can find 2 examples here: http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=examples#4 -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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] What transaction handle is needed for SET
Hello: > Does this statement need to be handled differently? Really i don't know if that statement can be executed that way, could you ask it in the firebird support list, plase ?? ( possible it shoule be set in the the same way of the FbTransactionOptions, but i'm not sure :), and there is nothing right now, in the provider, to give options that need extra values ) - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird.Net and SQL Reporting Services
Hello: > Firebird.Net Data Provider 2.0 Can you give a try using 2.0.1 ?? or it's that what you are using already ?? - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird.Net and SQL Reporting Services
Hello: > The query it is executing is simplistic: "select * from [action_names]" brackets aren't correct quoting characters in Firebird. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird.Net and SQL Reporting Services
Hello: > SQL 2005 Reporting Services Isn't this an SQL Server only product ?? > Dynamic SQL Error > > SQL error code = -104 > > Token unknown - line 3, char 8 > > [ (Microsoft Visual Studio) More than probabbly the query is trying to run isn't valid for Firebird, but we should see it to be sure. - 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] OT: Firebird built-in function list
Hello: > http://www.firebirdsql.org/devel/doc/rlsnotes/html/rlsnotes21.html#rnfb21-a= > ppx-builtins Nice list :) Thanks very much ! :) - 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] OT: Firebird built-in function list
Hello: > What FB Server version? For the 2.1 ^^ -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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] Update of Visual Studio
Hello: > Can't be made a 'copy' of sln file? Like > FirebirdSql.Data.FirebirdClient2008.sln! > Like that it can be open with both VS !!! Web can but with that we will need to mantain two sets of solution/project files. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] OT: Firebird built-in function list
Hello: Is there any place where i can find a list of firebird built-in functions with the description of the input parameters and return values ?? Thanks in advance !! -- Best regards Carlos Guzmán Álvarez Vigo-Spain - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
Hello: I'm going to convert the solution/project files to Visual Studio 2008 Beta 2( with compilation against the .NET Framework 3.5 ), does somebody have any problem with that change ?? ( the sources should be buildable with .net 2.0 using the nant scripts or changing the build options of the new solution files ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB and VS 2008
Hello: > Somebody knows if the System.Data.Entity.dll assembly should come with > the Orcas beta 2 installation ?? Looks like all entity framework stuff got out of the beta 2 ( sic ) - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB and VS 2008
Hello: > Ya, that's the easy part ... Implementing and adapting the SQL generator was > a pain in the butt, as will be adjusting the XML files that provide LINQ > with information on builtin functions, datatypes, conversions, etc. Somebody knows if the System.Data.Entity.dll assembly should come with the Orcas beta 2 installation ?? - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB and VS 2008
Hello: > Carlos, you'll be wanting the Resources.zip file from here: > > http://blogs.msdn.com/adonet/archive/2007/03/16/ado-net-orcas-sample-provide > r.aspx Thanks very much for the information :D > Inside is an OrcasProvider.exe which is a self-extracting executable > containing a simple LINQ provider over Sql Server. You can use it and adapt > it to Firebird. The blog post explains too how to extend an existing ado.net data provider to support the Entity Framework wqhat is nice as well :) Thanks ! - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB and VS 2008
Hello: > This seems like a good start: > http://blogs.msdn.com/kevin_halverson/archive/2007/07/10/how-to-implement-iq > ueryable.aspx Looks great, thanks very much !! > > It's VB but shouldn't be hard to translate :-) Agreed. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FB and VS 2008
Hello: > This is about the DDEX stuff. Not closely related to FB provider, it > works (should) without any changes. Confirmed that it works on Visual Studio 2008 Beta 2. Anybody knows a good reference to implement Linq providers ?? - 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] .net provider version
Hello: > Can I use the .net provider 1.5 and 1.7 with Firebird Version 2.x Yes. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] OT: Which databases should Visual Studio Team Edition for Database Professionals support?
Hello: Microsoft has a survey for that you can get more info here: http://blogs.msdn.com/buckh/archive/2007/07/19/survey-which-databases-should-visual-studio-team-edition-for-database-professionals-support.aspx - 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] Bulk copy
Hello: > Carlos, > Wrapping the process in a single transaction reduced the time to only 4mins. > Are you using the embedded server or the standalone one ?? - 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] Bulk copy
Hello: > The problem with this approach is that FbDataAdapter.Update() is too slow. > It takes almost 1 hour to copy aprox 500.000 rows. > > Is there a faster way to do this? or am I missing something? Can you try to wrap the inserts inside a single ( or several ones ) transaction ?? - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Visual C# and Firebird embedded database
Hello: > 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 ?? Could you try to build the provider using Orcas ?? and retry ?? > string connStr; > connStr = "User=SYSDBA;" + > "Password=masterkey;" + > "Database=C:/Photography/Software/rak-photography/rak-photography/rak-photograph\y.fdb;"+ > "ServerType=1"; > FbConnection conn = new FbConnection(connStr); > conn.Open(); Looks fine. > the error: > == > System.DllNotFoundException was unhandled > Message="Unable to load DLL 'fbembed': The specified module could > not be found. (Exception from HRESULT: 0x8007007E)" > Source="FirebirdSql.Data.FirebirdClient" The fbembed.dll should be in the .net search path if not it will be not found ( the exception you are getting ) You ca try using v2.1 that has a new connection string parameter ClientLibrary to give the client library ( dll ) you want to use. - 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] GAC problems
Hello: > Just to provide some service to community :), here's short simple KB > article, how to view in dialog specified assemblies. > http://support.microsoft.com/kb/306149 that is what is being done in the old Ghost installer, huummm, i will check if i need to add it to the new Wix installer. - 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] I'm back
Hello: > And did relaxed on vacation? :) a lot ! It was great !! ;) - 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
[Firebird-net-provider] I'm back
Hello: I'm back from my París travel. - 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] Enlisting transaction
Hello: > it's liitle bit old problem, but ... > > It's now working. Did you commit any changes? If so, I must miss it. :) If i remember well yes, and i have some more pending that i should do in 2.5.0 first. - 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
Hello: > 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. I'm going to reproduce here an answer of Peter Jacobi on this topic some time ago: "Whatever you are trying to achieve here, note that there is no euro- character in ISO-8859-1. You can use ISO-8859-15, WIN1252, UTF8 or even more strange options, but not ISO-8859-1." -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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] Cannot get DDEX Provider to work
Hello: > > > type="System.Data.Common.DbProviderConfigurationHandler, System.Data, > Version=2.1.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> This is wrong version should be 2.0.0.0 - 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] MONO Build
Hello: > I am trying to build the provider in Linux/MONO using: > > make –f makefile > > Inside the build\linux directory, but I am getting the error > makefile:36: *** multiple target patterns. Stop. > > Can anyone give a hand with this? It could be broken as there are too much time that i haven't linux installed and i can't test it. ( the last time i built the provider with mono was on windows using nant ) - 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] URGENT: NAnt build scripts - review
Hello: > Neat! Works great. > > Where was the problem? I have done the build using Visual Studio. Hope this week i will check the nant build scripts, while in a first review they looks as being correct. -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ - 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] URGENT: NAnt build scripts - review
Hello: > Yes. > > I will try to update the installation package tomorrow with an new > assembly. I have updated the installer file at sourceforge, can somebody give a try to itr and check if now the assembly works correctly, please. - 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