kornel | 3 Jan 11:54 2008
Picon

VS Express Edition connection

So, there is no solution to connect Express edition with firebird?

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
Carlos | 3 Jan 12:32 2008
Picon

Re: VS Express Edition connection

Hello:

So, there is no solution to connect Express edition with firebird?


There are no DDEX support for third party providers in the Express Editions of VS, the only way to achieve this is to modify the registry entries of the Access or SQL DDEX provider to match the Firebird DDEX provider. ( what is not exactly an easy task )
 


--
Carlos Guzmán Álvarez
Vigo-Spain
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Chris Wilson (JIRA | 3 Jan 18:47 2008

[FB-Tracker] Created: (DNET-149) Interpretation of CommandBehavior.CloseConnection

Interpretation of CommandBehavior.CloseConnection
-------------------------------------------------

                 Key: DNET-149
                 URL: http://tracker.firebirdsql.org/browse/DNET-149
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.1.0, 2.0.1
         Environment: winxp
            Reporter: Chris Wilson
            Assignee: Carlos Guzman Alvarez
            Priority: Minor

When opening a datareader with CloseConnection setting, get an error message (something about the
cursor) when try to read first record.

Workaround: don't use that setting and make sure the dr is manually closed.

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
Chris Wilson (JIRA | 4 Jan 17:37 2008

[FB-Tracker] Created: (DNET-150) Implementation of DataAdapter.SelectCommand.Cancel

Implementation of DataAdapter.SelectCommand.Cancel
--------------------------------------------------

                 Key: DNET-150
                 URL: http://tracker.firebirdsql.org/browse/DNET-150
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 2.1.0
         Environment: WinXP
            Reporter: Chris Wilson
            Assignee: Carlos Guzman Alvarez

When I try to invoke this command, I get an error message that it is not supported. I trap that of course, and
just ignore the cancel, so that's the workaround. However, I've learned that this command can be very useful.

Consider the problem of a long da.fill operation. Normally you start it and just have to wait. Even if you run
it in a background thread, it has to play out. With the SelectCommand.Cancel (which works for other
providers), I can handle the datatable rowchanged event and look for a global "cancelled" variable I set
elsewhere; if set I issue the SelectCommand.Cancel method and I'm good to go.

Strongly recommended.

P.S., the command works for OleDB and SQLServer, but it ignored by SQLite.

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
Vladislav Panteleev | 6 Jan 03:00 2008
Picon

(no subject)


  Hi!

I have to return FbDataReader object from function. So I 
write this:

public static FbDataReader getReader(string sql)

  FbConnection conn = new FbConnection(MF.constr);
  FbCommand command = new FbCommand(sql, conn);
  conn.Open();
  FbDataReader reader = command.ExecuteReader();            
  return reader;
}

But when I run the application and rise the function many 
times per minute I've grtting "Timeout exceed" exception write on 
conn.Open() method rising. I think this because of I havn't 
close the connection and garbage collector do not clean the 
memory quickly enought, but I can't to rise conn.Close() 
before I return reader. So what should I do to solve this 
problem?

Vlad Panteleev,
http://panvladislav.1gb.ru
http://mobile.1gb.ru

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
Dean Harding | 6 Jan 04:39 2008
Picon

Re: (no subject)

Vladislav Panteleev wrote:
> But when I run the application and rise the function many 
> times per minute I've grtting "Timeout exceed" exception write on 
> conn.Open() method rising. I think this because of I havn't 
> close the connection and garbage collector do not clean the 
> memory quickly enought, but I can't to rise conn.Close()

You should never rely on the garbage collection to close database 
connections!

> before I return reader. So what should I do to solve this 
> problem?

If you pass CommandBehavior.CloseConnection to the ExecuteReader() 
method, then the FbDataReader will automatically close the connection 
when you call it's IDispose.Dispose method. So you can do something like 
this:

using(FbDataReader reader = getReader("blah"))
{
   // Use FbDataReader here
} // On this line, FbDataReader will automatically close the connection

Dean.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
Carlos | 7 Jan 14:50 2008
Picon

Leaving the project

Hello:

I have decided to leave the project, the reason is mainly that i have left to do development in my spare time and really i'm going to continue in that situation for a long time, really, right now the last thing i want when i reach home is get coding again

I want to give great thanks to all of you for your help and support in all the time i was active in the development of the .NET provider :)




--
Carlos Guzmán Álvarez
Vigo-Spain

P.D: Happy new year !!!!

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Ernesto Cullen | 7 Jan 19:16 2008
Picon

Re: Leaving the project

Carlos, WE have to thank you for your good work! I hope you enjoy your 
time at home now :-D

Ernesto Cullen

Carlos escribió:
> Hello:
>
> I have decided to leave the project, the reason is mainly that i have 
> left to do development in my spare time and really i'm going to 
> continue in that situation for a long time, really, right now the last 
> thing i want when i reach home is get coding again
>
> I want to give great thanks to all of you for your help and support in 
> all the time i was active in the development of the .NET provider :)

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kai Bøhli | 7 Jan 20:11 2008
Picon

Re: Leaving the project

Hi Carlos !

 

It’s sad that you’re quitting. As I understand it, you’ve been one of the key persons on the firebird .net provider.

I wish you luck on whatever the future will bring to your screen. May the source be with you.

 

Best wishes

Kai Bohli

Norway

 

 

 

From: firebird-net-provider-bounces <at> lists.sourceforge.net [mailto:firebird-net-provider-bounces <at> lists.sourceforge.net] On Behalf Of Carlos
Sent: 7. januar 2008 14:51
To: For users and developers of the Firebird .NET providers
Subject: [Firebird-net-provider] Leaving the project

 

Hello:

I have decided to leave the project, the reason is mainly that i have left to do development in my spare time and really i'm going to continue in that situation for a long time, really, right now the last thing i want when i reach home is get coding again

I want to give great thanks to all of you for your help and support in all the time i was active in the development of the .NET provider :)




--
Carlos Guzmán Álvarez
Vigo-Spain

P.D: Happy new year !!!!

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Kevin Stanton | 7 Jan 20:24 2008

Re: Leaving the project

Best of luck to you Carlos – I’m just getting into .Net, but I know you’re a key player.

 

How big of a hit is this on the FB .Net project?

 

Cheers,

Kevin

 

 

From: firebird-net-provider-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org [mailto:firebird-net-provider-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] On Behalf Of Carlos
Sent: Monday, January 07, 2008 5:51 AM
To: For users and developers of the Firebird .NET providers
Subject: [Firebird-net-provider] Leaving the project

 

Hello:

I have decided to leave the project, the reason is mainly that i have left to do development in my spare time and really i'm going to continue in that situation for a long time, really, right now the last thing i want when i reach home is get coding again

I want to give great thanks to all of you for your help and support in all the time i was active in the development of the .NET provider :)




--
Carlos Guzmán Álvarez
Vigo-Spain

P.D: Happy new year !!!!

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Gmane