Re: [Firebird-net-provider] Feedback request

2006-04-03 Thread Jiri Cincura 

On 3.4.2006 23:52 Carlos Guzmán Álvarez wrote:

Hello:

What are the old design-time features?


FbDataAdapter configuration wizard, Dataset Generator, ConnectionString 
dialog ...





OK. So the answer for question 7 is yes (sometimes, I guess 80%).

--
Jiri Cincura
http://www.cincura.net/


---
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=lnk&kid0944&bid$1720&dat1642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Connection Pooling Problem

2006-04-03 Thread Eric Walmsley 

Hi,

I'm using version 1.7.1 and trying to use connection pooling, but the 
connections just grow and grow until I get a timeout. I've looked on the 
web and know about using the same connection string, but it doesn't seem 
to work.


in Web.Config, I have:

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" />


and a sample Delphi function is (The call 'GetConnectionString' returns 
the above entry):


function TActivityDB.AddActivityIssue(MyGroup, MyProject, MyActivity,
  MyIssue: Integer): Boolean;
var
 cmd  : FBCommand;
 conn : FBConnection;
 parameterGroupID : FBParameter;
 parameterProjectID : FBParameter;
 parameterActivityID : FBParameter;
 parameterRiskID : FBParameter;
begin
  conn := FBConnection.Create;
  cmd := FbCommand.Create('PADDACTIVITYISSUE', conn);

  conn.ConnectionString := GetConnectionString;
  cmd.CommandType := CommandType.StoredProcedure;

  parameterGroupID := FBParameter.Create('@fGroupID', FBDbType.BigInt);
  parameterProjectID := FBParameter.Create('@fProjectID', FBDbType.BigInt);
  parameterActivityID := FBParameter.Create('@fActivityID', 
FBDbType.BigInt);

  parameterRiskID := FBParameter.Create('@fIssueID', FBDbType.BigInt);

  cmd.Parameters.Add(parameterGroupID);
  cmd.Parameters.Add(parameterProjectID);
  cmd.Parameters.Add(parameterActivityID);
  cmd.Parameters.Add(parameterRiskID);

  parameterGroupID.Value := TObject(MyGroup);
  parameterProjectID.Value := TObject(MyProject);
  parameterActivityID.Value := TObject(MyActivity);
  parameterRiskID.Value := TObject(MyIssue);

  cmd.Connection.Open;
  try
cmd.ExecuteNonQuery;
  except
  end;
  cmd.Free;
  Conn.Close;
  Conn.Dispose;
end;

If I run just this function 10 times, there are 10 connections in 
Firebird  I don't see what I'm doing wrong, but I'm sure someone 
will  the connection string is the same always and I do call Close 
and Dispose.


Any ideas 

Thanks

Eric


---
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=lnk&kid=110944&bid=241720&dat=121642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] SQLMonitor

2006-04-03 Thread Dimyan 

Does SQLMonitor for Firebird ADO.NET Data Provider 2.0 exist?



---
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=lnk&kid=110944&bid=241720&dat=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

2006-04-03 Thread Carlos Guzmán Álvarez 

Hello:

What are the old design-time features?


FbDataAdapter configuration wizard, Dataset Generator, ConnectionString 
dialog ...



--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/



---
This SF.Net email is sponsored 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=lnk&kid0944&bid$1720&dat1642
___
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

2006-04-03 Thread Jiri Cincura 

On 3.4.2006 18:05 Carlos Guzmán Álvarez wrote:
1. Do you know of any ADO.NET 2.0 feature that is missing in the 
provider ??


For this time no.


2. Are you having any error that is not fixed yet ??


No.


3. Are you having performance problems ??


No.

4. Are you using the DDEX provider to integrate it into Visual Studio 
2005 ??


Yes.


5. If you are using provider integration into Visual Studio 2005,
  are you having problems with it ??


No.


6. If you are using provider integration into Visual Studio 2005,
  Are you using it with the new .NET Data Components
  ( BindingSource,  BindingNavigator, ... ) ??


Sometimes yes.

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)


What are the old design-time features?

--
Jiri Cincura
http://www.cincura.net/


---
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=lnk&kid0944&bid$1720&dat1642
___
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"

2006-04-03 Thread Carlos Guzmán Álvarez 

Hello:
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.


To clarify this a little, this didn't meant i'm not going to di it, it 
looks as the only viable solution so more than problably i will need to 
do that.




--
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=lnk&kid0944&bid$1720&dat1642
___
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

2006-04-03 Thread Carlos Guzmán Álvarez 

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=lnk&kid0944&bid$1720&dat1642
___
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.

2006-04-03 Thread Fabio Gomes 
I found the option to browse the assembly and the code i posted earlier now compiled with mono!Thanx a lot!Now i just need to test it all on linux :)On 4/3/06, 
Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
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 willneed 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 ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/---
This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat extends applications into web and mobile media. Attend the live webcastand join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642___
Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2006-04-03 Thread Carlos Guzmán Álvarez 

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=lnk&kid0944&bid$1720&dat1642
___
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.

2006-04-03 Thread Fabio Gomes 
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?
On 4/3/06, Fabio Gomes <[EMAIL PROTECTED]> wrote:
Thanx.So i need to compile the version 1.7 of the provider?"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?Sorry if its a stupid question, but i m really new to this .NET stuff :(
On 4/3/06, 
Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:

Hello:> Hum.. where can i find info about how to build it? i just downloaded> the installer and installed it.

http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=development--Carlos Guzmán ÁlvarezVigo-Spain
http://carlosga.blogspot.com/
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat 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?cmdlnk&kid0944&bid$1720&dat1642
___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.

2006-04-03 Thread Carlos Guzmán Álvarez 

Hello:
"*Version 2.0 of the provider targets only the .NET Framework 2.0 and 
the .NET Compact Framework 2.0"


*Or is it going to compile on mono too?

Mono doesn't have right now a complete ADO.NET 2.0 implementation.

--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/



---
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=lnk&kid0944&bid$1720&dat1642
___
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.

2006-04-03 Thread Fabio Gomes 
Thanx.So i need to compile the version 1.7 of the provider?"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?Sorry if its a stupid question, but i m really new to this .NET stuff :(On 4/3/06, 
Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
Hello:> Hum.. where can i find info about how to build it? i just downloaded> the installer and installed it.
http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=development--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat 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?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2006-04-03 Thread Carlos Guzmán Álvarez 

Hello:
Hum.. where can i find info about how to build it? i just downloaded 
the installer and installed it.

http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=development


--
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=lnk&kid0944&bid$1720&dat1642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] 2.0 Provider and 2.0 RC1 Database

2006-04-03 Thread Warren Anderson 

Good Morning;

I have been using the Firebird-net-provider 1.7 and the 1.5 embedded 
database inside Visual Studio 2005 with a Forms Application, it work fine. I 
switched to the 2.0 .NET Provider using the 1.5 embedded database and it 
works as well. But when I switched to 2.0 .NET Provider and 2.0 RC1 embedded 
database I get an error from conn.Open() the very first time the datbase is 
accessed.


conn.Open();

Unable to load DLL 'fbembed': The specified module could not be found. 
(Exception from HRESULT: 0x8007007E)


I know the fbembed.dll is present in both the project root and the bin/debug 
directory and since the 2.0 provider works with the 1.5 database in the same 
project (same configuration) my guess is that there may be a 2.0 issue I am 
not aware of.


Any help would be greatly appreciated.

Thanks
Warren Anderson 




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.4/299 - Release Date: 3/31/2006



---
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=lnk&kid=110944&bid=241720&dat=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] Mono and firebird on windows.

2006-04-03 Thread Fabio Gomes 
Hum.. where can i find info about how to build it? i just downloaded the installer and installed it.On 4/3/06, Carlos Guzmán Álvarez <
[EMAIL PROTECTED]> wrote:Hello:> The same code compiles and run fine if i just switch the compiler from
> mono to .NET.>> Am i m making something wrong? could you guys help me out with some> information about using mono with firebird?In first place, nothing, it looks like a mono problem when doing the
strong name validation of the provider.Try to build the provider sources using mono and retry.--Carlos Guzmán ÁlvarezVigo-Spainhttp://carlosga.blogspot.com/
---This SF.Net email is sponsored by xPML, a groundbreaking scripting languagethat 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?cmdlnk&kid0944&bid$1720&dat1642
___Firebird-net-provider mailing listFirebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2006-04-03 Thread Carlos Guzmán Álvarez 

Hello:
The same code compiles and run fine if i just switch the compiler from 
mono to .NET.


Am i m making something wrong? could you guys help me out with some 
information about using mono with firebird?
In first place, nothing, it looks like a mono problem when doing the 
strong name validation of the provider.

Try to build the provider sources using mono and retry.

--
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=lnk&kid0944&bid$1720&dat1642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

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

2006-04-03 Thread Fabio Gomes 
Hi all.I m new to C# and all this .NET stuff. But i m trying to at least learn and start developing with C# and firebird, firebird 1.7 is working fine on Visual Studio, but i tried to use mono and got not luck.
I tried mono with sharpdevelop, it installs and try to compile.. a simple "hello world" compiles fine, but when i try to import a visual studio project or just connect with the firebird database it doesnt compile.
When i try to connect i get this error with mono:Exception System.IO.FileLoadException was thrown in debugee:
Strong name validation failed for assembly 'FirebirdSql.Data.Firebird'.This is my code:using System; using System.Data; using FirebirdSql.Data.Firebird; public class Test {    public static void Main(string[] args) {
        FbConnection myConnection1 = new FbConnection("User=SYSDBA;" +    "Password=masterkey;" +    "Database=/home/trab/SiadPHP/testes/siad.gdb;" +
    "DataSource=192.168.15.101 ;" +    "Port=3050;" +    "Dialect=3;" +    "Charset=ISO8859_1;");
          myConnection1.Open();          Console.WriteLine("Hello World");          Console.ReadLine();    }}The same code compiles and run fine if i just switch the compiler from mono to .NET.
Am i m making something wrong? could you guys help me out with some information about using mono with firebird?Any help is welcome,Thanx in advance.

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

2006-04-03 Thread Carlos Guzmán Álvarez 

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=lnk&kid0944&bid$1720&dat1642
___
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"

2006-04-03 Thread Raigo 

Carlos, thanks for reply.
Support for Firebird dialect 1 is very neccesary! Without support for 
dialect 1 the provider is useless for many developers.


For example we have a big ERP software which development started on 
Interbase about 10 years ago, now has been moved on Firebird dialect 1 
and has very many Delphi client applications and running on many 
customer sites.We are planning new client applications development on 
ASP.NET 2.0 when stable .NET 2 provider for Firebird comes out. But 
moving the full database from dialect 1 to dialect 3 right now, 
overnight, is imossible! I believe many developers are in similar 
situation.


Please put into plans and schedules to add a feature for the provider to 
support dialect 1. 
thank you.



Carlos Guzmán Álvarez wrote:


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 






---
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=lnk&kid0944&bid$1720&dat1642
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider