Re: [Firebird-net-provider] Data Migrate
Hello: Hi all, I'm a beginner, so I neddo to migrate Data from DB Firebird 1.5 to another DB Firebird 1.5, I want to ralize a simple console application with Visual studio 2005 and Firebird Provider 2.0 an my question is how I can do that? For example: Connect to DB 1 Make a FbDataAdapter DB1 whit query Fill DataSet 1 Connect to DB 2 ?? Create a new adapter against DB2. Create a CommandBuilder with the new DataAdapter Try to update the DataSet filled with the DB1 using the Adapter created against DB2 ( It may work while i'm not fully sure ;) ) -- 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-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] UNICODE .NET provider and c#
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, ni un esclavo que no haya tenido reyes en su familia. ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem
Hello: I try the new dispose implemmentation but it doesn't work the properties have not changed and the connection still open :( I search also but for the moment i don't find witch method is called by the data binding method to close the datareader and the connection :( 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-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] UNICODE .NET provider and c#
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 esclavo que no haya tenido reyes en su familia. ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem !
Hello: OK i found the solution in fact when a control do a databind with a datareader the overiden GetEnumerator is called and now it returns New Dbenumerator(this) or it sould return New DbEnumerator(this,(CommandBehavior.Default != (CommandBehavior.CloseConnection this._behavior))); 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 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://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem !
Hello: In fact when the second parameter of the dbenumerator constructor is true the datareader is automatically close at the end of the iteration; MSDN said : [DbEnumerator (IDataReader, Boolean) Initializes a new instance of the DbEnumerator class using the specified DataReader, 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 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://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] UNICODE .NET provider and c#
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. ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FirebirdClient ADO.NET 2.0 Enhancement code
HEllo: I am using firebird and the .Net client and found I can not connect to a server if the server name/address does not get resolved by the GetIPAddress function in \source\FirebirdSql\Data\Client\Gds\GdsConnection.cs. The change should be in CVS now. Thanks very much !! -- 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-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem
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 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 and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem
Hello: i do some search and the isclosed property of sqldatareader is set to true after a databind only if the commandbehavior is set to closeconnection ! So i put a breakpoint in the fbdatareader close method and she is never called. More over the last fbdatareader method called by the databind is Read so i think the sql server or oracle provider close the datareader in this method ? It maybe ... i will try to confirm it .. if possible :P Can you check in the case of sql server what is the state of the data reader immediatly after the instruction where you do the data binding ?? -- 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 and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem
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 reyes en su familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] v 2.0 rc 4.0 CommandBehavior problem !
Hello: The problem is that the connection is not closed after the gridview databind and the property fbdatareader.isclosed is false or with other provider as oracle or sql server the connection is closed If that happens is because the Close Method is not being called, can you try to build 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. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problem with special german characters
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 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 and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] BINARY BLOBS (images) works well
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 familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RV: Returned mail: see transcript for details
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 no haya tenido reyes en su familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] BINARY BLOBS (images) works well
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 esclavo que no haya tenido reyes en su familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?
Hello: I'm trying to update a BLOB SUB_TYPE TEXT column but I get always the following error: arithmetic exception, numeric overflow, or string truncation I'm using .net 2.0 RC4 provider and FB 2.0 RC2. The value can be retrieved from table. The problem relies on how the parameter is defined, your parameter is defined only as DbType.String what isn't valid for Text Blob parameters as DbType.String is mapped by default to FbDbType.VarChar. In a case like this the FbPArameter.FbDbType should be set to FbDbType.Text to get it to work. ( Anyway i'm thinking on modify the Size 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 su familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?
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 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 and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?
Hello: I'm behind Websense and the only way I can surf is via http proxy (such kproxy), I can browse CVS, I see your comment but I found no change con FbParameter.cs. Modify the FbParameter.Size property as: public override int Size { get { return this.size; } set { this.size = value; // Hack for Clob parameters if (value == 2147483647 (this.FbDbType == FbDbType.VarChar || this.FbDbType == FbDbType.Char)) { this.FbDbType = FbDbType.Text; } } } 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 no haya tenido reyes en su familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RE: Cant use BLOB: Provider limitation or what?
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. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RE: Cant use BLOB: Provider limitation or what?
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 su familia. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RE: Cant use BLOB: Provider limitation or what?
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. --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Cant use BLOB: Provider limitation or what?
Hello: I'm trying to update a BLOB SUB_TYPE TEXT column but I get always the following error: arithmetic exception, numeric overflow, or string truncation I'm using .net 2.0 RC4 provider and FB 2.0 RC2. The value can be retrieved from table. Send a test case, database included please. -- 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 and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnkkid=107521bid=248729dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Can connect using the server name, but cant with the ip, why?
Hello: I tried some time ago to use the 2.0 version of the .net provider but i couldnt connect to my database (linux server), then i tried it at home and connect perfectly using localhost, today i decided to try it here at work, and it didnt work using the ip, then i just changed the ip to the server name and it worked... So: DataSource = 192.168.0.1 http://192.168.0.1 didnt work, but: DataSource = MyServer works. Is it supposed to be this way? That maybe indicate a problem with your network configuration, i think that should be failing on Dns.GetHostEntry(dataSource) call done 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 Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problems with VS DDEX
Hello: Hi. I'm a little frustrated with VS2005 and Firebird. I already install what is needed: - VS 2005 PRO - VS SDK (I'm using march 2006) - FB .net provider RC4 And: - Modify machine.config - Modify and import to registry FirebirdDDEXProvider.reg. - Firebird client is in GAC. 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, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS 2005 Prof. integration and Firebird .NET provider 2 RC4
Hello: - Visual Studio 2005 Professional installed - Visual Studio 2005 SDK from October 2005 installed Install the April one that is the latest stable one if i'm not worng :P I've changed the two path occurences in FirebirdDDEXProvider.reg to: C:\\Program Files\\FirebirdClient Add \\ at the end of the path and retry, please. Whenever I click on the Connect to Database button in the Server Explorer in VS2005, I get the following error message: An unexpected error occured in the .NET framework data provider for Firebird. Please contact the provider vendor to resolve this problem. 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 ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Feedback Request (III)
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 architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Feedback Request (III)
Hello: Well, for this time, I've no in my head. But if I encounter some, I'll post it here. ;) Ok. Why? To separate it in a different package ?? Because it has no dependendices on the provider itself and can have hi own development cycle without the need to wait for releases of the provider 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 ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Small date problem when binding to a textbox
Hello: it shows like this: 24/7/1984 00:00:00 Withou the 0 (zero) too, the same as it shows on the maskedtext box. Is there any way to fix it? You can review what is the format of the Date in the Culture info of the main thread and look if that can be the problem, but anyway it's 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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [ANN] FirebirdClient v2.0 Release Candidate 4 released.
Hello: FirebirdClient v2.0 Release Candidate 4 is available for download. Download information can be found here: http://www.firebirdsql.org/index.php?op=filesid=netprovider · Release Candidate 4 ( 2006-05-15 ) · ( Please review the changelog for details ) Bug Fixes: - Fixed bug 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 code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Small date problem when binding to a textbox
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 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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Feedback Request (III)
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 --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Feedback request ( II )
Hello: dont know if it's a perfirmance problem or not but it seems it slightly different in getting rows when i call stored procedure using Command Parameter over direct new fb command. Please email me ([EMAIL PROTECTED]) please, please. I'll send the sample VB.Net code you can test. Send it to my private email, please Another questions I'm using Embedded Firebird, but i could find anything in the FB provider to do vacuum or compact database. The database keep big in size after i delete lot's of records. Services API is not available on the embedded server if i remember well. Yes. i 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, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Feedback Request (III)
Hello: I have some questions for people using/testing v2.0 to answer, if possible, when having a little amount of free time :) 1. Do you know of any ADO.NET 2.0 feature that is missing in the provider= ?? 2. Are you having any error that is not fixed yet ?? 3. Are you having performance problems ?? 4. Are you using the DDEX provider to integrate it into Visual Studio 2005 ?? 5. If you are using provider integration into Visual Studio 2005, are you having problems with it ?? 6. If you are using provider integration into Visual Studio 2005, Are you using it with the new .NET Data Components ( BindingSource, BindingNavigator, ... ) ?? 7. Are you using the old Design-Time features ( for FbConnection, FbCommand and FbDataAdaptercomponents ) ?? ( i 'm thinking on remove that design time support in future releases of the v2.X) Thanks very much for your help !!! --=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 ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [ANN] FirebirdClient v2.0 Release Candidate 4 released.
Hello: FirebirdClient v2.0 Release Candidate 4 is available for download. Download information can be found here: http://www.firebirdsql.org/index.php?op=filesid=netprovider · Release Candidate 4 ( 2006-05-15 ) · ( Please review the changelog for details ) Bug Fixes: - Fixed bug 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 code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) -- 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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] How to create a Membership provider with
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://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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Viejo Modelo de Acceso a Datos VS Nuevo Modelo de Firebird.NET en VS2005
Hola: Estamos estudiando la posibilidad de usar Visual Studio 2005 y Firebird.Net para desarrollar una aplicacion web. Fenomenal !! Una de mis necesidades es, poder trabajar con transacciones explicitas (BEGIN_TRANSACTION, COMMIT, ROLLBACK) en los procesos que desarrollaré para consultar y modificar los datos en mi base de datos FB (SELECT, INSERT, UPDATE Y DELETE). Existe alguna forma de controlar explicitamente las transacciones en VS2005? Yo no lo he revisado pero supongo que se tiene q poder, has visto en la ayuda de Visual Studio 2005/.NET Framework SDK ?? Que modelo de datos es el mas recomendado para trabajar con la base de datos de mi nueva aplicacion web? El de VS2002/2003 (FBConnection, FBCommand, FBDataAdapter) o el de VS2005? En Visual Studio 2005 parece que los componentes FbCommand, FbConnection, ... aparecen deshabilitados para proyectos web ( ocurre 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-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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Charset
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/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Setting sweep interval to 0 stop fb server
Hello: Sorry for to late response.. I have try with CVS sources and I don't gat error message or stop the server, but...sweep interval is not changed. I use this: FbConfiguration cfgSvc = new FbConfiguration(); cfgSvc.ConnectionString = cs.ToString(); 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/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Setting sweep interval to 0 stop fb server
Hi: I use IBExpert to check if sweep interval it's set ok.From IBExpert I changed sweep interval succesfuly. I have done a test agains Firebird 2.0 RC 1 and looks as working ( check the sweep interval value using statistics service from IBExpert ) My test case, tell to me if it's correct or not: FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); csb.Database= @localhost:d:\employee.fdb; csb.UserID = sysdba; csb.Password= masterkey; csb.Charset = NONE; csb.Port= 3050; csb.ServerType = FbServerType.Default; FbConfiguration cfgSvc = new FbConfiguration(); cfgSvc.ConnectionString = csb.ToString(); cfgSvc.ServiceOutput += new ServiceOutputEventHandler(cfgSvc_ServiceOutput); cfgSvc.SetSweepInterval(1000); 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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Setting sweep interval to 0 stop fb server
I use IBExpert to check if sweep interval it's set ok.From IBExpert I changed sweep interval succesfuly. I have done a test against Firebird 2.0 RC 1 ( in localhost ) and looks as working for me ( reviewed the Sweep Interval value using the Statis Servbice from IBExpert ): Here is my test case, it's correct ?? FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); csb.Database= @localhost:d:\employee.fdb; csb.UserID = sysdba; csb.Password= masterkey; csb.Charset = NONE; csb.Port= 3050; csb.ServerType = FbServerType.Default; FbConfiguration cfgSvc = new FbConfiguration(); cfgSvc.ConnectionString = csb.ToString(); cfgSvc.ServiceOutput += new ServiceOutputEventHandler(cfgSvc_ServiceOutput); cfgSvc.SetSweepInterval(1000); 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 to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] How to create a Membership provider with
Hello: But there's a lot of problems in sample implementation (it's really sample). I've fixed a lot of bugs (but because Carlos is out-of-network I can't merge it into sources). And because, there's no RoleProvider, it's better (for this time) to use default provider with asp.net. I'm 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 quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Charset
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? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error Stored Procedure
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()) command.CommandType = CommandType.StoredProcedure --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Transactions with datasets
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 ?? --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] RC3 Bug Report, Example Included
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 --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FireBird, VS2005 and Data connection.
Hello: I had lot's off error trying to use FB.Net provider in Visual Studio 2005. I had try to reinstall VS, FB...etc,etc. Today I resolved all problems after cleaning registry. Uninstalling VS or FB provider is not enough. First, uninstall FB . Net provider. My problems to connect was solved after I deleted from registry these: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion\References\FireBird. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion\GACChangeNotification\Default\F irebird... and from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Management\ARPCache .Firebird related records. I reinstalled FB .Net provider and works from first try. So you get it working now ?? Little error found trying to expand Domains: Column 'CHARACTER_LENGHT' does not belong on table Domains. This error message show on FB1.5.3 and FB 2.0 RC1 (Windows and Linux). Fixed 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 ) --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid0709bid3057dat1642 ___ 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 to datasource using VS 2005
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 architects who thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Executing Procedure Error Help Please!
Hello: FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION, myConnection, myTransaction); 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; As people has told you yet or you put the parameters in tthe command text, or, you can do this: FbCommand myCommand = new FbCommand(INSERT_RESERVATION, myConnection, myTransaction); myCommand.CommandType = CommandType.StoredProcedure; 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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbMembershipProvider problem
Hello: type=FirebirdSql.Web.Providers.FbMembershipProvider Huu should't this have the assembly name as well ?? Here is an article with things on Membership Providers configuration, it may help: http://www.odetocode.com/Articles/427.aspx http://odetocode.com/Articles/428.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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbMembershipProvider problem
Hello: Eureka! Carlos, I've found the problem. You have typo there: // // Initialize FbConnection. // ConnectionStringSettings ConnectionStringSettings = ConfigurationManager.ConnectionStrings[config[connectionectionStringName]]; *^^^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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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.0 Release Candidate 3 released
Hello: FirebirdClient v2.0 Release Candidate 3is available for download. Download information can be found here: http://www.firebirdsql.org/index.php?op=filesid=netprovider · Release Candidate 3 ( 2006-04-19 ) · ( Please review the changelog for details ) Bug Fixes: - Fixes in Connection Pooling implementation. - Fixed bug on named parameters parsing ( when the @ was used in quoted identifier names ) - Fixed bug in the implicit transaction support of FbCommand class. - Fixed bug when running scripts with dashes in it (e.g. As minus signs of calculations). - Fixed the buffer size used in the emebdded support to request the server version. - Fixed Stored Procedure support in the DDEX provider. Changes: - Changed service name used in Services API to allow it to work 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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,CHARACTER_LENGTH
Hello: Visual Studio 2005, .NET Framework 2.0 RC1, Firebird 1.0.3 SQL dialect 1, Employee.gdb. I was able to create a conection and I can see the tables in Server Expolorer. But when I click on tables I get : Dynamic DQL Error SQL Error Code =-104 Token unknown - line 1, char 411 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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbMembershipProvider problem
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 thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [OT] Microsoft has released Source Code for the Built-in ASP.NET 2.0 Providers
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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Running the NHibernate test suite against Firebird
Hello: I'm doing some tests with the v2.0 of the provider using Firbeird 2.0 RC 1 and the NHibernate test suite :) The results were really nice IMHO. The failed tests where: 1. NHibernate.Test.Legacy.MultiTableTest.MultiTable : Failed because the generated query has joins and the WITH LOCK statements what is not allowed by firebird 2. NHibernate.Test.Legacy.MultiTableTest.MultiTableGeneratedId : Same as the previous one. 3. NHibernate.Test.NHSpecificTest.NH386.Fixture.Query : The generated query uses _ at the first chacater of the table aliases and firebird doesn't allow that. 4. There are too a good number of tests that aren't running for problems on creating the tables ( for example for problems with primary key sizes ), i haven't finished the review of all the this type of tests. When running the nhibernate test suite i found a bug in the provider when 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 code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Connection Pooling Problem
Hello: There were a few bugs in Provider in connection pooling. We fixed them and sent bugreports to Carlos. But i don't know if he commit fixes in 1.7.1 or not. You can rebuild provider yourself with our fixes. Replace original FBConnectionPool.cs file from attachment. Added to 1.7 in CVS, 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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 FbDataAdapter and Update
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 is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbMembershipProvider problem
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 everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 code -303, Operation Not Supported...
Hello: What's interesting, though, is that I still got the error with FbDbType set to Text as well. Shouldn't that have worked, even with the size specified? Huumm yes !! ... can you do a try with latest v2.0 CVS sources ?? There are a change from some days ago that changes the way 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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 use sql to insert record with guid?
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 code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 use sql to insert record with guid?
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 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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Connection Strings changes in CVS
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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 use sql to insert record with guid?
Hello: Select * From Table where GuidField = +Guidvalue,How can I convert Guidvalue to a string format that It can works? You can try by using the BinaryEncoding class that comes with the provider ( it was contributed by Jim Beveridge for the Guid support ) if it doesn't work ... hehe .. 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 ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Feedback request ( II )
Hello: I have some questions for people using/testing v2.0 to answer, if possible, when having a little amount of free time :) 1. Do you know of any ADO.NET 2.0 feature that is missing in the provider?? 2. Are you having any error that is not fixed yet ?? 3. Are you having performance problems ?? 4. Are you using the DDEX provider to integrate it into Visual Studio 2005 ?? 5. If you are using provider integration into Visual Studio 2005, are you having problems with it ?? 6. If you are using provider integration into Visual Studio 2005, Are you using it with the new .NET Data Components ( BindingSource, BindingNavigator, ... ) ?? 7. Are you using the old Design-Time features ( for FbConnection, FbCommand and FbDataAdaptercomponents ) ?? ( i 'm thinking on remove that design time support in future releases of the v2.X) Thanks very much for your 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 the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate 1?
Hello: I'm having problem using the Firebird ADO.NET Data Provider 2.0 Release Candidate 1 with the Firebird 2 Release Candidate 1 embedded version. I'm getting a System.IndexOutOfRangeExection when doing a connection.Open(). Is the Firebird 2 Release Candidate 1 supported by the Firebird 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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?
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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?
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 tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.
Hello: int codigo=int.Parse(this.txtCli_cod.Text); if (dr ==DialogResult.Yes){ try { da_cli.DeleteCommand = con.CreateCommand(); da_cli.DeleteCommand.CommandText = DELETE FROM CLIENTES WHERE CLI_COD = @cli_cod; da_cli.DeleteCommand.Parameters.Add(@cli_cod, codigo).SourceColumn = CLI_COD; da_cli.Update(ds_cli, CLIENTES); ds_cli.AcceptChanges(); MessageBox.Show(Record deleted...); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { MessageBox.Show(Record NOT deleted...); } 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 everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.
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, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 code -303, Operation Not Supported...
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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.
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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SqlDataSource problem
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 is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] bug of Guid When use dbcommandbuilder
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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FBConnection.CreateDatabase
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 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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 code -303, Operation Not Supported...
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 ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Connection string change
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/ 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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string change
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 Á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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection string change
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 Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 use sql to insert record with guid?
Hello: sorry,as you know,many Guid's char is not visable in ascii. for eample,if /0 in it,the sql statement will failed to exceute. my question is how to write the sql statement when it contained char such as 0x10,0x14? You need to use parametrized queries and the filed in the table should 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 is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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.0 Release Candidate 1 released
Hello: FirebirdClient 2.0 Release Candidate 2 for Microsoft.NET 2.0 is available for download. · Download information can be found here · http://www.firebirdsql.org/index.php?op=filesid=netprovider · Release Candidate 2 ( 2006-04-08 ) · Bug Fixes: - Changed the Service maneger name sent to the server in the Services API implementation to get it working with Firebird 2.0 - Added a new StoredProcedureColumn concept to the DDEX provider, to try to fix a problem when dragging selectable stored procedures from the Server Explorer onto a DataSet. Changes: - Changed 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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Re: Firebird .NET Provider DDEX Issue
Hello: I have found an issue and I'm wondering if you are aware of it and how I can work around it. If I create a data source in VS2005 that uses a stored procedure VS does not show any fields available for dataset. The stored procedure is a select-able stored procedure that returns a record 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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Re: Firebird .NET Provider DDEX Issue
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://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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Helping inserting data on a firebird database using C#.
Hello: The error occur on the bold part, if i use: INSERT...VALUES(' + txtCli_nome.Text.ToString() + ') it works, but if i use Add(@cli_nome, txtCli_nome.Text.ToString()), it gives me that error, anyone knows why am i getting that? Try to add the parameters using the ctor that takes 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 ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Helping inserting data on a firebird database using C#.
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 code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: Connection Pooling Problem
Hello: I've tried the rebuild with the modified file, using NANT, but the problem is still there. The connections just keep growing until I get the timeout error. I've also noticed that when I disable Pooling, after 10 minutes of heavy use, the Web app will slow down to about 50 seconds 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 thinks everything is possible ( Anders Hejlsberg ) --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Re: Firebird-net-provider digest, Vol 1 #1186 - 10 msgs
Hello: my answers are written within the original text.. Thanks. :) When I change FbDataAdapter - e.g. I change select query - I can only generate NEW Dataset. There is no way of updating my existing Dataset.. This behaviour is unpleasant because in the time of updating DataAdapter I usually have some other properties of Dataset already set.. Generating of new Dataset means that I'am losing these changes made on the Dataset and I have to make them manually again. In fact it means that I do not use the auto generate dataset feature in this case... I have no idea how difficult is developing the design-time ability of DataAdapter to keep its Dataset up-to-date but I am sure that many people would appreciate such behaviour.. The best will be to use the DDEX provider to get the Visual Studio Integration of the provider. First - property FbDataReader.HasRows returns always true. Oops - I have searched it up in the documentation just now and it says that this property simply is always true.. Ehm - why should we have such property then? According to my knowledge, there is no way how to determine whether executed query has returned some rows and (if yes) how many rows it has returned.. ..Am i wrong? No, and this is as designed. Second - we are using firebird databases with Unicode charset - i.e. rdb$bytes_per_character is set to value 3. We have following problem with the provider - sometimes it raises an IscException(335544321), even though there is (in my opinion) no need for throwing any exception. The same SQL statement that raises this exception via FbProvider is succesfully executed via IB Expert. IBExpert doesn't have proper UTF-8 support so it's not a valid test ;) I wanted to make a test case for you, but did not have time, sorry.. Please do it when you have the time and send it to me. Well - I'm the one who had problem with this too and spammed this conference a lot about solving it ;-) the result is that I'm able to use FbConnection, Command etc. in the design-time - I can set properties and let VS to manage creating of these components etc. But full integration does not work at my PC :-( - in VS dialogues there is no FbProvider in the list and if yes, choosing FbProvider leads to errors.. But I am not sure if the your intension was to achieve full integration of FbProvider into VS -- maybe I simply do not know what is a bug and what is unsupported feature.. Some questions here: 1. The Computer where you are trying to install the DDEX provider where having Visual Studio 2005 betas ?? 2 . Have you installed the Visual Studio SDK ( it's not th e:NET Framework SDK ), more info about it here: http://affiliate.vsipmembers.com/affiliate/downloadFiles.aspx 3 . Have you modifed the machine.config file of .NET 2.0 according to the changes proposed in the ReadmeDDEX.txt 4. Have you combined the .reg file that comes with the provider into the Windows Registry with the %path% modified according to the changes proposed 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 webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SQLMonitor
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 applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Re: SQLMonitor
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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection Pooling Problem
Hello: add key=ConnectionString value=User=SYSDBA;Password=masterkey;Database=C:\ChARMTeamData\ChARM.fdb;DataSource=localhost;Charset=NONE;Pooling=false;MinPoolSize=10;MaxPoolSize=200;Connection Lifetime=5;ServerType=0 / This connection string has pooling disabled ... I will try to make a test 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 and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,CHARACTER_LENGTH
Hello: But support for Firebird dialect 1 is very neccesary! Without support for dialect 1 the provider is useless for many developers. I don't agree here, while for sure there are people using dialect 1 databases. Please put into plans and schedules to add a feature for the provider 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 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 and firebird on windows.
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/ --- 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 and firebird on windows.
Hello: I was able to compile the 1.7 data provider. But how do i install it now so i can use it on mono and sharpdevelop? It created a net 1.1 folder with a release folder inside of it and some files... where should i put those files? Use gacutil to install the assembly in the GAC ... but i 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 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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Feedback request
Hello: I have some questions for people using/testing v2.0 to answer, if possible, when having a little amount of free time :) 1. Do you know of any ADO.NET 2.0 feature that is missing in the provider ?? 2. Are you having any error that is not fixed yet ?? 3. Are you having performance problems ?? 4. Are you using the DDEX provider to integrate it into Visual Studio 2005 ?? 5. If you are using provider integration into Visual Studio 2005, are you having problems with it ?? 6. If you are using provider integration into Visual Studio 2005, Are you using it with the new .NET Data Components ( BindingSource, BindingNavigator, ... ) ?? 7. Are you using the old Design-Time features ( for FbConnection, FbCommand and FbDataAdaptercomponents ) ?? ( i 'm thinking on remove that design time support in future releases of the v2.X) Thanks very much for your 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 the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Feedback request
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 by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions about NetProvider and
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, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ObjectDataSource and Firebird.Provider
Hello: I'm trying to use an ObjectDataSource and a TableAdapter where I have builded some queries and I'm not able to see the querie on the ObjectDataSource. How do I use the ObjectDataSource with the FirebirdClientProvider? I'm using VS2005 Pro + RC1 Have you done a test using Sql 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 the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions about NetProvider and
Hello: I closed my program, returned to VisualStudio and in the Server Explorer tab I chose Data Connection localhost(MYDB) by clicking on a + and expanding that nod. Next, i debugged my program and i received that error - I/O error for file C:\MYDB.FDB. Error while trying to open file Are you using embedded server right ?? With connection pooling enabled rigth ?? ( it's enabled by default ) Do the same test, but before going to the Server Explorer close the IDE, restart it and retry and let me know if it works. I've found 2 more (possibly) bugs... 1) When I placed FbDataAdapter and it generated DataSet - in Generate DataSet window i couldn't choose existing Dataset ( that option is always gray and inactive, even i've got another DataSet on my form) and, in bottom section of thet window, there are 3 CheckBoxes - the first one says - Add this DataSet to the To the... what? The sentence is cut in a half... 2) If in my table a column has a name like PEOPLE_I_LIKE, in DataSet the name will be changed to PEOPLEILIKE. So that column won't be displayed in DataGrid... I must change that name in DataSet manually... I will try to check this , but anyway if i were you 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 that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EXECUTE PROCEDURE in a script
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-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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ 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 Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,CHARACTER_LENGTH
Hello: Dynamic DQL Error SQL Error Code =-104 Token unknown - line 1, char 411 CHARACTER_LENGTH also I get the same error when I drag GridView, DataList or any other component of ASP.NET WebForm and try to configure data source. any ideas? The problem is with this line on the sql 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-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 developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnkkid0944bid$1720dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider