Re: [Firebird-net-provider] Data Migrate

2006-06-01 Thread Carlos Guzmán Álvarez
Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https

Re: [Firebird-net-provider] UNICODE .NET provider and c#

2006-06-01 Thread Carlos Guzmán Álvarez
Hello: while(myReader.Read()) { cmbtst1.Items.Add(myReader.GetString(0)); } And how are you doing the inserts ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem

2006-05-30 Thread Carlos Guzmán Álvarez
:( And is the Dispose being called ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. ___ Firebird-net-provider mailing list Firebird-net

Re: [Firebird-net-provider] UNICODE .NET provider and c#

2006-05-30 Thread Carlos Guzmán Álvarez
Hello: What character set are you using in the connetion string ?? And send a test case if possible to see what you are doing, of both c# and the ddl, please -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem !

2006-05-30 Thread Carlos Guzmán Álvarez
))); Thanks a lot Carlos for you help and please tell me if this solution is good for you ? What about this one: return new DbEnumerator(this, this.IsCommandBehavior(CommandBehavior.CloseConnection)); -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem !

2006-05-30 Thread Carlos Guzmán Álvarez
, and indicates whether to automatically close the DataReader after iterating through its data.] So when the commandbehavior is set to closeconnection the second parameter is set to true else is set to false ! Ok the change should be in CVS now, thanks very much !!! -- Carlos Guzmán Álvarez

Re: [Firebird-net-provider] UNICODE .NET provider and c#

2006-05-30 Thread Carlos Guzmán Álvarez
Hello: I've already requested test case. Don't be so eager. ;) hehe -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia

Re: [Firebird-net-provider] FirebirdClient ADO.NET 2.0 Enhancement code

2006-05-30 Thread Carlos Guzmán Álvarez
Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem

2006-05-29 Thread Carlos Guzmán Álvarez
Hello: No pooling is on why ? Pooling is on by default. I think the difference agaisnt sqlclient maybe in the dispose implementation, i have it modified in my local tree but i want to wait first to see if you can answer my last question, before commit something -- Carlos Guzmán Álvarez

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem

2006-05-29 Thread Carlos Guzmán Álvarez
?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. --- All the advantages of Linux Managed Hosting--Without the Cost

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem

2006-05-29 Thread Carlos Guzmán Álvarez
Hello: After a databind of course :) Ok change committed into the CVS could you give a try to it when it's ready for pserver connections ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido

Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem !

2006-05-28 Thread Carlos Guzmán Álvarez
the provider sources and put a breakpoint in the FbDataReader.Close method to see if it's getting called ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia

Re: [Firebird-net-provider] Problem with special german characters

2006-05-28 Thread Carlos Guzmán Álvarez
Hello: how can I send an message to the support list? You will need to subscribe to the list: [EMAIL PROTECTED] Or you will need to create a yahoo groups user account and subscribe to the list there: http://www.yahoogroups.com/messages/firebird-support -- Carlos Guzmán Álvarez Vigo-Spain

Re: [Firebird-net-provider] BINARY BLOBS (images) works well

2006-05-26 Thread Carlos Guzmán Álvarez
Hello: FWIW: BINARY BLOB (images) works well, is only TEXT which doesn't. Did you have the field defined as sub_type text ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su

Re: [Firebird-net-provider] RV: Returned mail: see transcript for details

2006-05-26 Thread Carlos Guzmán Álvarez
Hello: Some idea? (reason: 552 5.7.0 Illegal Attachment 45si6976262wri) Looks like it doesn't accept the attachment. that comes with the email. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que

Re: [Firebird-net-provider] BINARY BLOBS (images) works well

2006-05-26 Thread Carlos Guzmán Álvarez
Hello: Yep. I'm sorry but i need the test case, try to send it in a different format. or if you were sending it with zip extension send it with a different one. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un

Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?

2006-05-26 Thread Carlos Guzmán Álvarez
property of the FbParameter class to switch to FbDbType.Text when the size is greater than the max size of a char/varchar field in firebird ) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en

Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?

2006-05-26 Thread Carlos Guzmán Álvarez
Hello: This means that there only way to do this now is modifying the data source's generated source code, isn't? The little hack in the size property is on CVS now, could you give a try to it ( for v2.0 only ) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un

Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?

2006-05-26 Thread Carlos Guzmán Álvarez
; } } } By the way, how can I build the provider in VS? There are a VS solution or you can use nant ( nant.sourceforge.net ) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que

Re: [Firebird-net-provider] RE: Cant use BLOB: Provider limitation or what?

2006-05-25 Thread Carlos Guzmán Álvarez
Hello: To Carlos: How can I help you? Sending a test case showing the problem. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia

Re: [Firebird-net-provider] RE: Cant use BLOB: Provider limitation or what?

2006-05-25 Thread Carlos Guzmán Álvarez
Hello: I already did. Didn't get my message? I sent to your gmail account. I will send again right now. Haven't received it. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en

Re: [Firebird-net-provider] RE: Cant use BLOB: Provider limitation or what?

2006-05-25 Thread Carlos Guzmán Álvarez
Hello: I sent it a few hours ago. Still don’t get it? Yeah, haven't received it yet. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia

Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?

2006-05-23 Thread Carlos Guzmán Álvarez
. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. --- All the advantages of Linux Managed Hosting--Without the Cost

Re: [Firebird-net-provider] Can connect using the server name, but cant with the ip, why?

2006-05-22 Thread Carlos Guzmán Álvarez
in GdsConnection.GetIPAddress method -- Bets regards Carlos Guzmán Álvarez Vigo-Spain --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier

Re: [Firebird-net-provider] Problems with VS DDEX

2006-05-18 Thread Carlos Guzmán Álvarez
. The information of the provider ( version, culture and PublicToken ) in the machine config matches the one the provider assembly has in the GAC ?? What happens if you try to add a connection in the server explorer ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code

Re: [Firebird-net-provider] VS 2005 Prof. integration and Firebird .NET provider 2 RC4

2006-05-18 Thread Carlos Guzmán Álvarez
. What is the message that gets shown in the Windows Event Log ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] Feedback Request (III)

2006-05-18 Thread Carlos Guzmán Álvarez
Hello: Yes. But is there any plan to improve its installation with C# and Web Developer Express editions as RSimpson suggested he did for SQLite provider? Not for now. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those

Re: [Firebird-net-provider] Feedback Request (III)

2006-05-17 Thread Carlos Guzmán Álvarez
to see a bug fixed in the DDEX provider -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] Small date problem when binding to a textbox

2006-05-17 Thread Carlos Guzmán Álvarez
not a problem on the provider. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need

[Firebird-net-provider] [ANN] FirebirdClient v2.0 Release Candidate 4 released.

2006-05-16 Thread Carlos Guzmán Álvarez
in Domains schema. Changes: - Changed info calls reponse length handling to handle responses with a small size than the requested one. - Changed validations on FbCommand.CommandText property. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't

Re: [Firebird-net-provider] Small date problem when binding to a textbox

2006-05-16 Thread Carlos Guzmán Álvarez
Hello: But when i need to show the data on the maskedtextbox, the data appears like this: 24/71/984 It is removing the 0 (zero) from the month, is there a way to fix this? What happens if you do the DataBinding against a Textbox instead of a MaskedTextbox ?? -- Carlos Guzmán Álvarez

Re: [Firebird-net-provider] Re: Feedback Request (III)

2006-05-16 Thread Carlos Guzmán Álvarez
Hello: Are you still using fbembed.dll instead of fbclient.dll for ServerType=1 ? Yes, and that is not going to change for now, while you can rebuild the provider to point to fbclient.dll if you need that. -- Best regards Carlos Guzmán Álvarez Vigo-Spain

Re: [Firebird-net-provider] Re: Feedback request ( II )

2006-05-16 Thread Carlos Guzmán Álvarez
followed all the step to configure FB Provider to integrate using DDEX, but i found .NET display errors when i try to create connection in SQL Server Explorer. Did you have the Visual Studio SDK installed ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code

[Firebird-net-provider] Feedback Request (III)

2006-05-16 Thread Carlos Guzmán Álvarez
!!! --=20 Carlos Guzm=E1n =C1lvarez Vigo-Spain http://carlosga.blogspot.com/ -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

[Firebird-net-provider] [ANN] FirebirdClient v2.0 Release Candidate 4 released.

2006-05-16 Thread Carlos Guzmán Álvarez
in Domains schema. Changes: - Changed info calls reponse length handling to handle responses with a small size than the requested one. - Changed validations on FbCommand.CommandText property. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't

Re: [Firebird-net-provider] How to create a Membership provider with

2006-05-13 Thread Carlos Guzmán Álvarez
Hi: There's also updated sql file for table users. For this time I'm using it on my real ASP.NET app (now it's in beta, so ...). I hoep this will help others. Committed to CVS let me know if there is something i have merged in bad way :) -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] Viejo Modelo de Acceso a Datos VS Nuevo Modelo de Firebird.NET en VS2005

2006-05-10 Thread Carlos Guzmán Álvarez
lo mismo con los de SqlClient por ejemplo. ) El modelo que implementa VS2002/2003 va a desaparecer? En el caso del provider de firebird de momento no, aunq es posible q se acabe eliminando el soporte de tiempo de diseño antigüo en futuras versiones. -- Carlos Guzmán Álvarez Vigo

Re: [Firebird-net-provider] Charset

2006-05-10 Thread Carlos Guzmán Álvarez
Hello: 1) with FbParameter it works 2) it works also with simple SQL-Query if table has an index on the field in where clause in other cases it doesn't seem to work for me Huummm i will see if i can do a test using Fb 1.5 -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com

Re: [Firebird-net-provider] Setting sweep interval to 0 stop fb server

2006-05-10 Thread Carlos Guzmán Álvarez
(); cfgSvc.SetSweepInterval(0); cfgSvc.SetForcedWrites(true); where cs is connection string used to create database. I'm doing something wrong? No in first place, huummm could you do a test against Firebird 1.5 ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com

Re: [Firebird-net-provider] Setting sweep interval to 0 stop fb server

2006-05-10 Thread Carlos Guzmán Álvarez
); cfgSvc.SetForcedWrites(true); -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need

Re: [Firebird-net-provider] Setting sweep interval to 0 stop fb server

2006-05-10 Thread Carlos Guzmán Álvarez
); cfgSvc.SetForcedWrites(true); -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat

Re: [Firebird-net-provider] How to create a Membership provider with

2006-05-05 Thread Carlos Guzmán Álvarez
back again so if you don't mind send to me the fixed version and i will do the commit to the CVS :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done

Re: [Firebird-net-provider] Charset

2006-05-05 Thread Carlos Guzmán Álvarez
Hello: I have next function to execute SQL command Please can you send a test case to my private email ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain --- Using Tomcat but need to do more? Need to support web services, security

Re: [Firebird-net-provider] Error Stored Procedure

2006-05-05 Thread Carlos Guzmán Álvarez
Hello: command =3D New FbCommand(EXECUTE PROCEDURE SP_APONT_VLD_FUNCIONARIO(@CODFUNCIONARIO,@CODSETOR,@ERRO,@DSCFUNCIONARIO)= , FireBirdConnection()) command.CommandType =3D CommandType.Text Try using: command = New FbCommand(SP_APONT_VLD_FUNCIONARIO, FireBirdConnection())

Re: [Firebird-net-provider] Transactions with datasets

2006-05-05 Thread Carlos Guzmán Álvarez
Hello: Here is some code that results in the error message when using transactions with datasets. It's more informative than my last message. The code works with SQL Server 2005 and with SQLite. Please can you send a test database to my private email ??

Re: [Firebird-net-provider] RC3 Bug Report, Example Included

2006-05-05 Thread Carlos Guzmán Álvarez
Hello: this isn't the problem of provider, I think so. You have to add 'tabla.CaseSensitive = true;' because you have in table some same values differs only in case. Doing this works or not ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain

Re: [Firebird-net-provider] FireBird, VS2005 and Data connection.

2006-04-19 Thread Carlos Guzmán Álvarez
in CVS now, thanks and soory for the inconvenience. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Carlos Guzmán Álvarez
Hello: No beta release has been installed. I just install the release provided by msdn, disc 3070 december 2005. Ok :) And did you have Visual Studio SDK installed ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Carlos Guzmán Álvarez
; myCommand.Parameters.Add(@COMPANY_NAME, FbDbType.VarChar, 100, COMPANY_NAME).Direction = ParameterDirection.Input; myCommand.Parameters.Add(@PASSENGER_NAME, FbDbType.VarChar, 100, PASSENGER_NAME).Direction = ParameterDirection.Input; -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-18 Thread Carlos Guzmán Álvarez
-- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- This SF.Net email is sponsored by xPML

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-18 Thread Carlos Guzmán Álvarez
]]; *^^^connectionStringName* Great !!! The change is in CVS yet -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

[Firebird-net-provider] [ANN] FirebirdClient v2.0 Release Candidate 3 released

2006-04-18 Thread Carlos Guzmán Álvarez
against Firebird 2.0 - Changed column name CHARACTER_LENGTH to CHARACTER_MAX_LENGTH to allow the Domains, Columns, Stored Procedure Parameters, View Columns schemas to work using Dialect 1 databases. -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] Visual Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,CHARACTER_LENGTH

2006-04-15 Thread Carlos Guzmán Álvarez
CHARACTER_LENGTH This should be fixed now in CVS. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-14 Thread Carlos Guzmán Álvarez
Hello: Here's. Sorry for HTML mail, but it's more clearly. The Web.Config is also there. I will try to check it but looks like a configuration problem ... -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who

[Firebird-net-provider] [OT] Microsoft has released Source Code for the Built-in ASP.NET 2.0 Providers

2006-04-14 Thread Carlos Guzmán Álvarez
Hello: More information here: http://weblogs.asp.net/scottgu/archive/2006/04/13/442772.aspx -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

[Firebird-net-provider] Running the NHibernate test suite against Firebird

2006-04-14 Thread Carlos Guzmán Álvarez
parsing named parameters, that should be fixed now in CVS, it was taken @ inside quoted identifier names as parameter names. And another bug on implicit transaction support. Initial fixes for both bugs are in CVS now. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't

Re: [Firebird-net-provider] Re: Connection Pooling Problem

2006-04-14 Thread Carlos Guzmán Álvarez
, working on get the same results in 2.0 Thanks very much !!! -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] Problem with FbDataAdapter and Update

2006-04-13 Thread Carlos Guzmán Álvarez
Hello: What can I do, so that this function works correctly? Please send a test case to my private email including a test database. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-13 Thread Carlos Guzmán Álvarez
Hello: whatever I try I get error: Connection string cannot be blank., but I have also in web.config: Post the Stack trace of the exception please. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-12 Thread Carlos Guzmán Álvarez
the FbParameter class infers the DataType of the parameter and that may have solved that problem. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-12 Thread Carlos Guzmán Álvarez
Hello: sure I use a field by char[16],and the charset is octecs. Have you tested it using parametrized queries ?? and setting the param value a the Guid ( the System.Guid not the string representation ) ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't

Re: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-12 Thread Carlos Guzmán Álvarez
Hello: I've Test it use FbCommand,It Works Fine. but It Can't Work use Dbcommand,only can work with fbcommand.as you know,dbParameter Haven't charset property. You don't need to set the Charset when using a Guid parameter the provider will do so. -- Carlos Guzmán Álvarez Vigo-Spain

[Firebird-net-provider] Connection Strings changes in CVS

2006-04-12 Thread Carlos Guzmán Álvarez
Hello: I have committed some changes in CVS to fix some problems with the synonyms handling in the FbConnectionStringBuilder class. Along with that fixes there are a new Catalog synonym for the Database connection string parameter. -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-12 Thread Carlos Guzmán Álvarez
.. well try asking in the fb-support list, as you will need the opinion of somebody with good knowledge of the octets charset -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible

[Firebird-net-provider] Feedback request ( II )

2006-04-11 Thread Carlos Guzmán Álvarez
!!! -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate 1?

2006-04-11 Thread Carlos Guzmán Álvarez
ADO.NET Data Provider 2.0 Release Candidate 1? Using embedded server right ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Yes, I'm using the embedded server. Is it possible, that it will work in the near future? Well, another user was having the same problem with RC 1 but looks like it was working with Beta 2 What is your connection string ?? -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Well, another user was having the same problem with RC 1 but looks like it was working with Beta 2 Fixed in CVS the problem was on the buffer size used when requesting the server version. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
...); } da_cli is my data Adapter and ds_cli is my DataSource, is something wrong with this? The database has changes before the update ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Sorry.. what do mean changes before the update? Check if ds_cli.HasChanges is true if not the dataadapter will have nothing to update, did you have deleted the Row from the datatable right ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: I tried that as a hard-coded hack (and confirmed that the hack was setting the FbDbType by watching in the debugger), but it did not make a difference. Please, send a test case to my private email including a test database. -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: delete.Delete(); For this line try instead: dtTable.Rows.Remove(delete); -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] SqlDataSource problem

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: but everything is working next. I can use the SqlDataSource, etc. Can you send to my private email a test database, please ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything

Re: [Firebird-net-provider] bug of Guid When use dbcommandbuilder

2006-04-10 Thread Carlos Guzmán Álvarez
Hello: Can you send a test database to my private email please ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] FBConnection.CreateDatabase

2006-04-10 Thread Carlos Guzmán Álvarez
Hello: Use fb client 2.0, Firebird 2.0 and VS 2005. Can I specify Page Size when I creata database? Yes, use: FbConnection.CreateDatabase(string connectionString, int pageSize, bool forcedWrites, bool overwrite) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-10 Thread Carlos Guzmán Álvarez
Hello: COMMENTBODY = BLOB -- LONGVARCHAR -- subtype: text Have you set the FbDbType of this parameter to FbDbType.Text ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible

[Firebird-net-provider] Connection string change

2006-04-10 Thread Carlos Guzmán Álvarez
Hello: I'm thinking if i should do or not ( if not it will be done post v2.0 release ) a minor change in connection strings, just add a new 'Catalog' synonym for Database connection string parameter. Opinions welcome !!! -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com

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

2006-04-10 Thread Carlos Guzmán Álvarez
Hello: I think, if it will be synonym, why not. For me, this is not important. I'll use the good old syntax. ;) Yes, it's more a matter of compatibility with other provider when using the Connection String Builders in a generic way using DbConnectionStringBuilder. -- Carlos Guzmán

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

2006-04-10 Thread Carlos Guzmán Álvarez
Hello: OK. I think this wouldn't be a problem. Of course it's not a great deal, but i think it can be useful. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders

Re: [Firebird-net-provider] How to use sql to insert record with guid?

2006-04-10 Thread Carlos Guzmán Álvarez
be a char(16) character set octets -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- This SF.Net email

[Firebird-net-provider] [ANN] FirebirdClient 2.0 Release Candidate 1 released

2006-04-08 Thread Carlos Guzmán Álvarez
the way the FbParameter class infers Value data type. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

[Firebird-net-provider] Re: Firebird .NET Provider DDEX Issue

2006-04-07 Thread Carlos Guzmán Álvarez
set so this should work. Below is my stored procedure. This prevents me from using the data from the SP. It should be fixed now in CVS, i have added a new StoredProcedureColumns comcept to the FbDataObjectSupport.xml file, that should do the trick. -- Carlos Guzmán Álvarez Vigo-Spain http

[Firebird-net-provider] Re: Firebird .NET Provider DDEX Issue

2006-04-07 Thread Carlos Guzmán Álvarez
Hello: Thanks a lot. Do you know when you'll be releasing a new set of binaries? Hope this weekend if i have the time. I not in a position to enlist in the CVS project and rebuild it. Maybe you could send me some privates? Sure. -- Carlos Guzmán Álvarez Vigo-Spain http

Re: [Firebird-net-provider] Helping inserting data on a firebird database using C#.

2006-04-07 Thread Carlos Guzmán Álvarez
a FbDbtype parameter, if it didn't work send a test case ( database included ) to my private email for review. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg

Re: [Firebird-net-provider] Helping inserting data on a firebird database using C#.

2006-04-07 Thread Carlos Guzmán Álvarez
Hello: Am i making it the right way? or is there another way to do this insert on my database? cause google isnt helping much in this case :( Send a test case to my private email, please, database included. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't

Re: [Firebird-net-provider] Re: Connection Pooling Problem

2006-04-05 Thread Carlos Guzmán Álvarez
to refresh a page then stop with error Cannot complete connection to 'localhost'. It must be something I'm not setting properly? Can you send a test case, please ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who

[Firebird-net-provider] Re: Firebird-net-provider digest, Vol 1 #1186 - 10 msgs

2006-04-04 Thread Carlos Guzmán Álvarez
in ReadmeDDEX.txt ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live

Re: [Firebird-net-provider] SQLMonitor

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: Does SQLMonitor for Firebird ADO.NET Data Provider 2.0 exist? No. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends

Re: [Firebird-net-provider] Re: SQLMonitor

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: And how can I view to the sending sql-queries? The provider has nothing to do that so you will need to do it manually. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML

Re: [Firebird-net-provider] Connection Pooling Problem

2006-04-04 Thread Carlos Guzmán Álvarez
to see if there any problem with the connection pooling. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web

Re: [Firebird-net-provider] Visual Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,CHARACTER_LENGTH

2006-04-03 Thread Carlos Guzmán Álvarez
to support dialect 1. The provider supports dialect 1 databases, what looks as being not supporting them is the Columns schema. As i have told the column anme is not going to change, and i didn't like the idea of having different results for dialect 1 and dialect 3 databases. -- Carlos Guzmán Álvarez

Re: [Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Carlos Guzmán Álvarez
Hello: *Version 2.0 of the provider targets only the .NET Framework 2.0 and the .NET Compact Framework 2.0 *Or is it going to compile on mono too? Mono doesn't have right now a complete ADO.NET 2.0 implementation. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com

Re: [Firebird-net-provider] Mono and firebird on windows.

2006-04-03 Thread Carlos Guzmán Álvarez
think you will need to use the mono one. Or maybe SharpDevelop show have an option to browse for the assemblies when adding a new reference to a project -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net

[Firebird-net-provider] Feedback request

2006-04-03 Thread Carlos Guzmán Álvarez
help !!! -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join

Re: [Firebird-net-provider] Feedback request

2006-04-03 Thread Carlos Guzmán Álvarez
Hello: What are the old design-time features? FbDataAdapter configuration wizard, Dataset Generator, ConnectionString dialog ... -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored

Re: [Firebird-net-provider] Some questions about NetProvider and

2006-04-02 Thread Carlos Guzmán Álvarez
Hello: No, It's Windows Application. Huu and the the database file exists in that path in the firebird server machine ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML

Re: [Firebird-net-provider] ObjectDataSource and Firebird.Provider

2006-04-02 Thread Carlos Guzmán Álvarez
Server and the queries get shown ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend

Re: [Firebird-net-provider] Some questions about NetProvider and

2006-04-02 Thread Carlos Guzmán Álvarez
i will be looking to the new .NET 2.0 data components ( BindingSource, TableApdater, ... ) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language

Re: [Firebird-net-provider] EXECUTE PROCEDURE in a script

2006-04-01 Thread Carlos Guzmán Álvarez
Hello: I downloaded v1.7.1 of the provider with the ability to execute a procedure from a script. The procedure is executed properly but the following statements in the script raise an error. Can you send a sample test case to my private email please. ?? -- Carlos Guzmán Álvarez Vigo

Re: [Firebird-net-provider] Visual Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,CHARACTER_LENGTH

2006-04-01 Thread Carlos Guzmán Álvarez
statement of the columns schema: cast(fld.rdb$character_length AS integer) AS CHARACTER_LENGTH, looks like dialect 1 database didn't support quoted identifiers ... We can't left it without quotes, and i don't like the idea of chaning the column name at this stage -- Carlos Guzmán Álvarez Vigo

<    1   2   3   4   5   6   7   8   >