Re: [Firebird-net-provider] help

2011-04-05 Thread Eduardo Cimas
rnal-dependencies\\FirebirdDDEXProvider\\FirebirdSql.VisualStudio.DataTools.dll" > > 2011/4/5 Eduardo Cimas : > > Spanish: > > > > Hola! > > > > Estoy intentando configurar VS2008 y VS2010 para trabajar con Firebird y > > siguiendo todos los pasos y al añadir una conex

[Firebird-net-provider] help

2011-04-04 Thread Eduardo Cimas
s: He copiado *FirebirdSql.VisualStudio.DataTools.dll y FirebirdSql.VisualStudio.DataToolsUI.dll *en la misma ruta y sigue sin funcionar. Confio en que esto se pueda solucionar. Muchas gracias por adelantado. Eduardo Cimas. -- English: Hi! Im trying to config

Re: [Firebird-net-provider] Working without DDEX

2008-12-01 Thread Eduardo Lima
Title: ICEFLOR S.L. Try This FbConnection m_obConexionDB = null; sConexion = @"ServerType=0;DataSource=xxx.xzz.xxx.xxx;Port=;user=SYSDBA;Password=masterkey;" +    "Charset=NONE;Packet Size=32767;Fetch Size=100; Database=DBName"; m_obConexionDB = new FbConnection(sConexi

Re: [Firebird-net-provider] Linux

2007-08-29 Thread Eduardo
nts. /opt/firebird/bin/gsec ->GSEC> add username -pw password To traslatate DB betew Windows and Linux ... You can use .. gbak -t -user sysdba -password masterkey DataBase.FDB DataBase.FDK That's all for now folks. "juliosm" <[EMAIL PROTECTED]> escribió en el men

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

2007-08-16 Thread Eduardo
Hi Just one idea. I think it is a good idea to use "aliases". to resolve the path, when you are working between diferent S.O. Edit -> aliases.conf Add entry -> MyDataBase = /opt/interbase/test.gdb sConnectionString = @"ServerType=0;DataSource=192.168.100.55;Port=3050;DataBase=MyDataBase .

Re: [Firebird-net-provider] Linux

2007-08-15 Thread Eduardo
Hello all! Server Linux: Debian 4.0 Firebird 2.0.1 CS Client WXP: FirebirdClient ADO.NET 2.0 Work perfect! Knowing that you are there has made it possible. When I finish testing I will prepar a little HowDo. Thanks - Thi

[Firebird-net-provider] Linux

2007-08-14 Thread Eduardo
Hello all! I have a program run under Windows, and it works fine. I use VS2005 and Firebird .NET Data Provider. The Server is Windows Server 2003 and the clients are WXP. I am using .net Compact Framework 2 sp 2 with FirebirdClient-1.5.2 to access FireBird 1.5 SS. I would like to change the Serv

Re: [Firebird-net-provider] Bulk copy

2007-07-24 Thread Eduardo Gamboa
Standalone. ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > >> Carlos, >> Wrapping the process in a single transaction reduced the time to only >> 4mins. >> > > Are you using the embedded server or the standalone one ?? > > --

[Firebird-net-provider] [FB-Tracker] Created: (DNET-107) FbCommand Exception

2007-07-24 Thread Eduardo Gamboa (JIRA)
: FB SS 2.0.1 Windows 2003 Server 32-bit VStudio 2005 Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez Having two tables with identical structure and executing the following statement: INSERT INTO TABLE1 SELECT * FROM TABLE2 everything works fine, but executing

Re: [Firebird-net-provider] Bulk copy

2007-07-20 Thread Eduardo Gamboa
Is there a way to use a single transaction with multiple database connection? ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > >> The problem with this approach is that FbDataAdapter.Update() is too >> slow. >> It takes almost 1 hour to copy apro

Re: [Firebird-net-provider] Bulk copy

2007-07-20 Thread Eduardo Gamboa
Carlos, Wrapping the process in a single transaction reduced the time to only 4mins. Thanks, Eduardo ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > >> The problem with this approach is that FbDataAdapter

[Firebird-net-provider] Bulk copy

2007-07-20 Thread Eduardo Gamboa
"].Rows) { /// Change the state of the row dr.SetAdded(); } targetDA.Update(ds, "TEST_TABLE"); The problem with this approach is that FbDataAdapter.Update() is too slow. It takes almost 1 hour to copy aprox 500.000 rows. Is there a faster way to do this? or

[Firebird-net-provider] [FB-Tracker] Created: (DNET-106) FbCommandBuilder GetInsertCommand(True) throws an Implicit Cast Exception

2007-07-13 Thread Eduardo Gamboa (JIRA)
Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.5.0 Environment: .Net Windows 32-bit Fb SS 2.0.1 Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez When you use GetInsertCommand(True) an Explicit Cast is required. It seems

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

2007-07-12 Thread Eduardo Gamboa (JIRA)
Components: ADO.NET Provider Affects Versions: 2.5.0 Environment: Windows 32-bit & 64-bit Firebird SS 2.0.1 Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez static void Main(string[] args) { FbConnectionStringBuilder fbCsb =

[Firebird-net-provider] [FB-Tracker] Created: (DNET-104) Error building Provider for Mono

2007-07-11 Thread Eduardo Gamboa (JIRA)
: 2.5.0 Environment: Windows XP SP2 32Bit Mono 1.2.4 Firebird SS 2.0.1 Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez When I try to build the Provider with NANT, it finishes with errors. /***/ NAnt 0.85 (Build

Re: [Firebird-net-provider] MONO Build

2007-07-11 Thread Eduardo Gamboa
Ok, I configures a Windows sandox with Mono 1.2.4 and Nant. But the provider is not created!! - Log file is attached. Thanks in advance Eduardo ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hello: I am trying to build the pr

[Firebird-net-provider] MONO Build

2007-07-10 Thread Eduardo Gamboa
I am trying to build the provider in Linux/MONO using: make -f makefile Inside the build\linux directory, but I am getting the error makefile:36: *** multiple target patterns. Stop. Can anyone give a hand with this? Thanks in advance, Eduardo

[Firebird-net-provider] [FB-Tracker] Created: (DNET-102) FbConnection.GetSchema() throws reference exception

2007-07-02 Thread Eduardo Gamboa (JIRA)
: ADO.NET Provider Affects Versions: 2.5.0 Environment: FB SS 2.1.0 Beta 1 Windows Server 2003 Net Provider 2.5 (rev 306 trunk) Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez The following code worked fine with NETProvider 2.1.0 rev 306. But with

[Firebird-net-provider] [FB-Tracker] Created: (DNET-100) FbCommandBuilder has problems with Calculated fields

2007-06-27 Thread Eduardo Gamboa (JIRA)
: ADO.NET Provider Affects Versions: 2.1.0 RC 1 Environment: .Net Framework 2.0 Windows Sever 2003 FB 2.0.1 SS Visual Studio 2005 C# Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez When I try to insert new rows using FbDataAdapter and FbCommandBuilder an

[Firebird-net-provider] [FB-Tracker] Created: (DNET-96) FbConnection.CreateDatabase creates database with wrong PageSize

2007-06-19 Thread Eduardo Gamboa (JIRA)
Affects Versions: 2.1.0 RC 1 Environment: Windows 2003 Server .Net 2.0 VS2005 FB SS 2.0.1 Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez When I try to create a database using FbConnection.CreateDatabase(connectionString, 16384, true, false); the

[Firebird-net-provider] [FB-Tracker] Created: (DNET-95) Connecion to a database throws an exception

2007-06-12 Thread Eduardo Gamboa (JIRA)
Affects Versions: 2.1.0 RC 1 Environment: Ubuntu 7.04 Mono 1.2.4 C# Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez Priority: Critical When I try to connect to a database using .Net provider 2.1.0 RC1 the following exception is thrown: &qu

[Firebird-net-provider] [FB-Tracker] Created: (DNET-90) FbConnection.GetSchema returns incorrect data

2007-05-30 Thread Eduardo Gamboa (JIRA)
Affects Versions: 2.1.0 RC 1 Reporter: Eduardo Gamboa Assignee: Carlos Guzman Alvarez If you have a domain defined as: CREATE DOMAIN D_CURRENCY AS NUMERIC(15,4); or CREATE DOMAIN D_CURRENCY AS DECIMAL(15,4); when you use the method FbConnection.GetSchema("DOMAINS

[Firebird-net-provider] GetSchema() does not get column names for Procedures

2006-08-03 Thread Eduardo Alvarez
Hi there, DataTable dtColumns = conn.GetSchema("Columns", new string[] { null, null, TableName }); If the 'TableName' variable contains the name of a table or a view, this works. However, if I try with the name of a Stored procedure, the returned DataTable is empty. What is happening? Regards,

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

2006-05-03 Thread Eduardo Alvarez
Hi there, I'm getting the following exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." But the above error message does not apply to my case, so I think this is a bug. To reproduce, follow this simple steps: 1) Cr

[Firebird-net-provider] .Net provider can't connect to WIndows 2003?

2006-04-25 Thread Eduardo Alvarez
Hi there, I sent a .NET Windows application to a customer, which runs Firebird 1.5 Server on a Windows 2003 Small Business box. My application is built with VS 2005 and FB .Net Provider RC3. When trying to connect to the database from a Windows XP terminal, the following exception is thrown: Una

Re: [Firebird-net-provider] Stored Procedure select ...

2006-04-22 Thread Eduardo Beninca
yes, it works.. thxOn 4/22/06, Jiri Cincura <[EMAIL PROTECTED]> wrote: On 21.4.2006 22:27 Eduardo Beninca wrote:> I have a stored procedure that returns to me an entire table..> Anyone can help ??And select * from procedure works?--Jiri Cincura http://www

[Firebird-net-provider] Stored Procedure select ...

2006-04-22 Thread Eduardo Beninca
I have a stored procedure that returns to me an entire table.. I tried 2 ways to execute this procedure im my c# code... fbDA fbDataAdapter = new FbDataAdapter(); fbDA.SelectCommand = new FbCommand("EXECUTE PROCEDURE CONSULTA_SEMEN", fbConnection); FbTransaction ft = fbConnection.BeginTransactio

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

2006-04-18 Thread Eduardo Beninca
You can do in this way too... FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE INSERT_RESERVATION(?,?)", myConnection, myTransaction); On 4/18/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: > Hello: > > FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE > > INSERT_RESERVATION", m

[Firebird-net-provider] Views

2006-04-14 Thread Eduardo Beninca
Hi, i need a help with views.. I want to call a view inside my c# code ... how can i do this ??? -- "I throw myself into the sea Release the wave, let it wash over me To face the fear I once believed The tears of the dragon, for you and for