firebird-net-provider — All about development of the MS .Net provider

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

[<car...@te...>]

Hello:

> Connection Lifetime is specified in seconds

A lifetime of 0 means that the connection never dies in the pool.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] BeginTransaction problem??

[Thomas <ja...@ma...>]

Now and then we get an exception in "BeginTrancaction".

When I call BeginTransaction(), then I get this error:

at FirebirdSql.Data.Firebird.Gds.GdsTransaction.BeginTransaction()
   at FirebirdSql.Data.Firebird.FbTransaction.BeginTransaction()
   at FirebirdSql.Data.Firebird.FbConnection.BeginTransaction()



(That is all the info that I get)


Some times the exception arise after 5 minutes, and some times the =
exception arise after 30 hours.
Very very random.


It is very hard to re-create the error, but it is 100% sure that the =
error arise at some point.

In my program, I call "myConnection.BeginTransaction()" once every 3 =
second.
(Many hours).


We use:
WinXP SP1
FirebirdSql.Data.Firebird.dll v. 1.5.1437.22333 (.NET 1.1)
Firebird-1.5.0.4027-RC7, running af Super Server.
Microsoft .NET Framework 1.1 v. 1.1.4322


Hope that you can help me with this problem.


Thanks

Regards
Thomas




/// Code snip//////

(It is impossible to send the full code)

My Connection Class that is a singleton:


........................
private FbConnection myConnection;


public static Connection Instance
  {
   get
   {             =20
    if(instance =3D=3D null)
    {
     instance =3D new Connection();    =20
    }//if
    return instance;
   }//get property
  }//property get instance of Connection
 =20

   //constructor
    private Connection()
    {
     try
     {
      myConnectionString =3D getURLToDB();
      myConnection =3D new FbConnection(myConnectionString);      =20
      openConnection();
     }//try
     catch (Exception ex)
     {
      string t =3D ex.Message;
      string t2 =3D ex.StackTrace;
      =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=

     }//try/catch
  }//constructor
 =20
 =20
 =20
 public bool updateTransaction(string myUpdateQuery)
  {
   try
   {
    myConnection =3D MyConnection;
    transaction =3D myConnection.BeginTransaction();

    myCommandOne =3D new FbCommand(myUpdateQuery, myConnection, =
transaction);=20
    myCommandOne.ExecuteNonQuery();

    transaction.Commit();
    myCommandOne.Dispose();
   }
   catch(Exception eb)
   {  =20
  =20
    =
BusinessComponents.LogToFile.Instance.logALineToFile(eb.StackTrace,true);=

    BusinessComponents.LogToFile.Instance.logALineToFile("This =
SQL-statement was not saved in the database: " + myUpdateQuery,false);
    string t =3D eb.StackTrace;
    transaction.Rollback();
    transaction.Dispose();
    closeConnection();
    openConnection();
    throw eb;
   }//try/catch
   return true;
  }//updateTransaction
 =20
 =20
 =20
  public void closeConnection()
    {
     try
     {
      if (myConnection.State !=3D System.Data.ConnectionState.Closed)
      {
       myConnection.Close();  =20
      }//if
     }//try
     catch (Exception ex)
     { =20
      =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=
=20
      Console.WriteLine(ex.Message);
      Console.WriteLine(ex.StackTrace);
     }//try/catch
  }//closeConnection
 =20
 =20

    public void openConnection()
    {
     try
     {
      if (myConnection.State !=3D System.Data.ConnectionState.Open)
      {
       myConnection.Open();
      }//if
     }//try
     catch(Exception ex)
     { =20
      =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=
=20
      Console.WriteLine(ex.Message);
      Console.WriteLine(ex.StackTrace);
     }//try/catch
  }//openConnection
 =20
 =20
   public FbConnection MyConnection
    {
     get
     {  =20
      try
      {
       if (this.connectionCounter > 500)
       {
        if (this.myConnection !=3D null)
        {
         myConnection.Dispose();
         myConnection =3D new FbConnection(myConnectionString);
         openConnection();
         this.connectionCounter =3D 0;
        }//if
       }//if    =20
       else
       {              =20
        if (this.myConnection !=3D null)
        {
         closeConnection();
        }//if
        openConnection();
        this.connectionCounter =3D this.connectionCounter+1;
       }//else    =20
      }//try
      catch (Exception ex)
      {    =20
       =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=
    =20
      }//try/catch
      return this.myConnection;
     }//get =20
  }//property myConnection
 =20
 =20
 =20

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

[<car...@te...>]

Hello:

> I usually use pooled connections in my web applications, but I don't
> understand how and when they are released (looking at my Linux server
> processes, seems never).
> I think the Connection Lifetime parameter can help me in this, but how? In
> the help file is reported to be working when a connection is returned to the
> pool, but is it also working when web applications aren't in use (like a
> separate thread doing the job)?

Connection Lifetime is specified in seconds, there are a cleanup thread 
that is running at every 10 seconds.

I'm thinking on rework the connection pool in 1.6 for allow max and min 
pool sizes, ...

Can you retry with latest CVS sources i think it will work correctly now 
:) if not let me know, please.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

I usually use pooled connections in my web applications, but I don't
understand how and when they are released (looking at my Linux server
processes, seems never).
I think the Connection Lifetime parameter can help me in this, but how? In
the help file is reported to be working when a connection is returned to the
pool, but is it also working when web applications aren't in use (like a
separate thread doing the job)?
For example imagine the following scenario:
10 users are using my web application. At 6 pm they stop working and go
having fun :-).
Setting the Connection Lifetime to 20, I imagine all the connections being
closed at 6.20 pm... am I right?

TIA.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] SetPageBuffers + SetReserveSpace ?

[<car...@te...>]

Hello:

> What will I achieve be settings the SetPageBuffers(), SetReservsSpace() 
> and the QueryBufferSize ?

* QueryBufferSize

	Is the length of the buffer that is going to be used 		when queriying 
Firebird Services (isc_service_query).

 From the Interbase 6.0 API documentation:

* SetPageBuffers

	Set the default number of cache buffers to the
	specified number; corresponds to gfix -buffers

* SetReserveSpace

	Configure the database to fill data pages when
	inserting new records, or reserve 20% of each
	page for later record deltas; the next byte must
	be one of:
		• isc_spb_prp_res_use_full
		• isc_spb_prp_res
	Corresponds to gfix -use





--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

[Firebird-net-provider] TECH SECTOR - Technology Breakthrough - Patents Filed...carlen

[Catalina G. <xo...@ya...>]

TECHNOLOGY SECTOR - TECHNOLOGY BREAKTHROUGH - PATENTS FILED

Symbol: NMMG
Market: OTC.BB
Sector: L.E.D. TECHNOLOGY


Barcharts Rate NMMG an 80% BUY - http://quotes.barchart.com/texpert.asp?sy=
m=3DNMMG


BREAKING NEWS in technology - New Millennium Media International (OTCBB: N=
MMG) announces that it has officially filed its patents---with over 50 cla=
ims---protecting its revolutionary technology, a breakthrough in (LED) arc=
hitecture.  The OnScreen=99 LED Display Architecture is a radical new type=
 of Bright LED video display architecture that is expected to revolutioniz=
e the 1.5 billion dollar LED display market.  This breakthrough technology=
 will give NMMG great potential to capture significant market share in the=
 the 19 billion dollar outdoor advertising market.

With all the new initiatives in Homeland Security and the Amber Alert, Int=
elligent Message Signs (IMS) are the future, and with the recent signing o=
f new laws and federally mandated funds in the billions of dollars, NMMG a=
nd its patent-pending OnScreen technology is poised to lead the way.  NMMG=
 currently has the only technology that allows it to build onto exisiting =
infrastructure, i.e. road signs, billboards, etc.  Imagine one day you are=
 driving home on the freeway past a road sign you have seen a thousand tim=
es before--but this time you notice something different.  This time you se=
e a WARNING lit up--truck overturned 1 mile ahead--hazardous chemicals spi=
lled.  The sign advises you to exit immediately and to safety.  Such a war=
ning was broadcast instantly and using NMMG's OnScreen technology.  You ne=
ver noticed, as you drove by the roadside every day, that OnScreen was dra=
ped over the sign all this time.  Now it has sprung into action by the pun=
ch of a button on a PC from a central station--instantly and just in the n=
ick of time.  You have just experienced OnScreen technology.  And that is =
just one example.  The possibilities are limitless.  And because OnScreen =
can be applied to existing structures like road signs or billboards, its c=
ost-effectiveness makes it far and away the technology choice.

NMMG will unveil its breakthrough technology at the STRATEGIES IN LIGHT co=
nference on February 2-4, 2004 at the San Mateo Marriott Hotel in San Mate=
o, California. This unique event is considered to be the premier annual fo=
rum for addressing commercial developments in high-brightness LEDs, as wel=
l as an unparalleled networking opportunity for suppliers and users of the=
se devices. The growing interest in, and expanding attendance at, this eve=
nt, reflects the excitement associated with a market that has grown by 50=
% since 2000, while other semiconductor and optical component industries h=
ave stagnated or experienced large declines.



ON-SCREEN=99 TECHNOLOGY

OnScreen=99 is expected to create a broad-range of products with much bett=
er resolution and brighter pictures than the current generation of display=
s. OnScreen=99 will be visible in direct sunlight yet avoid many of the is=
sues associated with current displays including sun-loading, wind-loading =
and excessive weight.  In addition, the new LED architecture produces an a=
dvantage that is not available in today's marketplace: a more lightweight,=
 pliable display that can fit any application.  These are important advant=
ages as the High Brightness LED market is expected to grow from 1.2 billio=
n dollars in 2000 to 4 billion in 2006.  In addition, according to Stanfor=
d Resources, the LED sign market value alone is expected to exceed 1 billi=
on by 2006. These projections are made based on existing technology and do=
 not take into account emerging technologies, such as OnScreen=99, that ca=
n rapidly alter the size and shape of this market.



COMMERCIAL MARKET & STRATEGY

NMMG's initial marketing strategy revolves around licensing intellectual p=
roperty (IP) to worldwide manufacturers of LED display products and compon=
ents. The LED sign market is projected to reach over 1 billion dollars by =
2006. Lumiled's projects that high brightness LED's, used in LED signs alo=
ne, will exceed 1.2 billion by 2007. If these projections hold, the fully =
manufactured signs would represent a $5 billion market. Whichever number i=
s accurate, they both point towards a robust market for these new LED disp=
lays. Many projections don't take into account emerging high growth applic=
ations such as the Amber Alert project, Homeland Security and roadway =93i=
ntelligent message transfer=94.



THE MARKET

An article in Media Post's Media Daily News in March of 2003 noted that th=
e outdoor industry has successfully weathered the recession and that =93ou=
r large members say they're having a great first quarter=94 in 2003. They =
go on to note that technology is expected to transform both the display an=
d measurement of outdoor advertising. According to Media Daily the most ex=
citing news is coming on the display side, where =93Lamar Advertising is c=
onverting their key boards to LED units whose messages can be changed at w=
ill and sold in day-parts by the hour or even the minute.=94 They added th=
at =93Clear Channel's backlit subway panels in stairwells are being conver=
ted to LED as well=94. Together these companies represent two of the three=
 largest outdoor US advertisers.  

Recent Federal Government legislation has also placed a spotlight on expan=
ding the =93Amber Alert=94 network nationwide. The highly publicized succe=
ss in locating a number of kidnapped children shortly after their abductio=
n in California has now triggered federal funding for U.S.-wide expansion =
of these variable-message signs.  Homeland Security issues have also incre=
ased the number of early warning signs being planned and funded as part of=
 an overall information sharing network. Traffic safety is also becoming a=
 much higher priority in the U.S.. It is estimated that just over 60,000 r=
oadway dynamic message signs are in operation in the United States. In Jap=
an alone there are over 1.5 million of these signs. The United States repr=
esents a huge growth market for LED displays.



GROWTH OPPORTUNITES

In addition to the outdoor television market, another interesting and exci=
ting application for OnScreen=99 arrays is artistic lighting in dramatic c=
urved and shaped displays in places like Las Vegas, New York City or reall=
y virtually any venue. The tensile, flexible structure of OnScreen=99 prov=
ides unlimited opportunity for creativity. 

The anticipated cost reductions of OnScreen=99 will also provide ample opp=
ortunity for growth of the large-scale LED display market itself. OnScreen=
=99's unique architecture opens the door for new applications such as curv=
ed implementations, billboards on the sides of buildings where tenants can=
 still see out, and lower cost mobile applications on the sides of existin=
g vehicles. 

Homeland Security, Amber Alert variable message signage and instant messag=
e transfer applications can also benefit significantly from the advantages=
 of OnScreen=99. Reduced wind-loading and weight can significantly lower t=
he cost of the superstructures required to support these signs and also re=
duce the cost to install and maintain them.




JUST LOOK WHO IS ALREADY ON BOARD

New Millennium has established a Technology Breakthroughsentific Advisory =
Board comprised of leading experts in key categories in the research and m=
arketing of LED technology.

David Pelka, Ph.D.- Chairman =96 Well known expert in physics, founded TIR=
 Technologies Inc. to pursue patents for his LED lighting systems and LCD =
backlits.  Dr. Pelka secured more than $2 million in venture capital and l=
icensing for TIR before it was acquired by Teledyne Electronic Technologie=
s (NYSE:TDY).  Since the buyout, Dr. Pelka has served as Director of Produ=
ct Development for Teledyne Lighting and Display Products.  Dr. Pelka's ac=
colades include fellowships and awards from the Smithsonian, National Defe=
nse, Northrop University and Ebell Fellowship, as well as countless articl=
es published in both classified (the U.S. Air Force and Army) publications=
 and various non-classified publications.  He has founded several technolo=
gy companies, which he successfully expanded by building strong revenue st=
reams and securing venture capital investments and government contracts. 
 
 
Robert V. Steele, Ph.D. =96 Director of Optoelectronics Programs and Chair=
man of the annual conference =93Strategies in Light=94 for Strategies Unli=
mited.  Steele is responsible for all of Strategies Unlimited's activities=
 in the area of optoelectronic components, for which the 23-year-old marke=
t research firm has specialized in providing market research reports and c=
onsulting services.  Co-author of =93Solid-State Lighting: New Growth Oppo=
rtunities for High-Brightness LED's=94, Dr. Steele writes regularly for in=
dustry publications on high-brightness LED markets and applications such a=
s Forbes, The Wall Street Journal, The Economist and more. 
 
 
John Biondo =96 Owner and President of Silicon Robotics Corporation, which=
 provides various product development services including electronic and el=
ectromechanical design, software development, optics, and project manageme=
nt.  Biondo also has extensive patent-process experience.  In 1980, Biondo=
 launched Electric Filmworks, which produced computer-generated visual eff=
ects for the television and motion picture industry.  He also designed an =
apparatus using newly available and inexpensive microcomputers, which allo=
wed the company to compete successful against older, more established firm=
s.  To transfer from the service-sector into manufacturing, Biondo sold El=
ectric Filmworks in 1989 and co-founded Amazing Photos.  Amazing Photos de=
signed, manufactured and sold a variety of innovative coin-operated photo =
booths.  Polaroid Corporation licensed and marketed the two most popular a=
nd cost effective booths under their own name. 
 
 
Richard Reis, Ph.D. =96 Executive Director of the Alliance for Innovative =
Manufacturing at Stanford and Director for Academic Partnerships in the St=
anford Learning Laboratory.  Dr. Reis' impressive career includes serving =
as; the Executive director of the Stanford Center for integrated Systems, =
a major research partnership between Stanford and 15 industrial companies;=
 a Consulting Professor in both the Stanford University Electrical and Mec=
hanical Engineering departments; professor of a year-round seminar that is=
 part of the Stanford University Future Professors of Manufacturing progra=
m; a professor of astronomy at the College of San Mateo, Calif.; and a cur=
riculum consultant at Menlo College, Calif. 
 
 
Ben Jacobson, Ph.D. =96 Dr. Jacobson has worked on numerous impressive LED=
 projects that have exponentially increased beam density and brightness an=
d reduced system costs. Additionally, these projects have improved power r=
equirements, heat load and LED count, while improving compactness, efficie=
ncy and performance over competitors' products.  Dr. Jacobson was instrume=
ntal in positioning Illumitech as a new company developing high-performanc=
e LED lighting systems with thermal packaging.  Dr. Jacobson has over a de=
cade of experience developing and marketing new technology for the display=
 industry, both in his previous positions and currently at Illumitech.  Pr=
ior to Illumitech, Dr. Jacobson held various executive and research direct=
orial positions at EG Controls Inc., ARCH Venture Partners, NiOptics Corpo=
ration and the University of Chicago.  He has seven U.S. patents, and has =
published 13 research articles and seven conference presentations. 
 
 
Joseph D. Tajnai, Ph.D. =96 Dr. Tajnai is a consultant in Optical Radiatio=
n Safety, LED's & Applications and Optics & Optical Measurement Training. =
He was an engineer, Technology Breakthroughsentist and technical manager f=
or 23 years at Hewlett-Packard and Agilent Technologies. He has focused on=
 fiber optic development, LED development and measurements, new product pr=
ocesses, mathematical modeling and international and US standards and regu=
lations. He also worked with GE Sylvania for nine years and contributed he=
avily to their YAG laser development. Dr. Tajnai received his BS, MS and P=
h.D. from California Institute of Technology in Electrical Engineering and=
 Applied Physics. 











Please note that NMMG had absolutley nothing to do with this report and is=
 not a participant in any way.









No more advertisements: www.inet-notification.com/away.html









Technology Breakthroughs is an independent research firm. This report is b=
ased on Technology Breakthroughs's independent analysis but also relies on=
 information supplied by sources believed to be reliable. This report may =
not be the opinion of NMMG management. Technology Breakthroughs has also b=
een retained to research and issue reports on NMMG. Technology Breakthroug=
hs may from time to time purchase or sell NMMG common shares in the open m=
arket without notice. The information contained in this report shall not c=
onstitute, an offer to sell or solicitation of any offer to purchase any s=
ecurity. It is intended for information only. Some statements may contain =
so-called "forward-looking statements". Many factors could cause actual re=
sults to differ. Investors should consult with their Investment Advisor co=
ncerning NMMG. Copyright 2003 =A9 Technology Breakthroughs. All Rights Res=
erved. Technology Breakthroughs was paid eight thousand dollars to distrib=
ute this report. Technology Breakthroughs is not affiiated with Technology=
 Breakthroughs and is not responsible for newsletter content.  All informa=
tion in this report can be obtained on the world wide web at www.nmmimedia=
com.  New Millenimum Media was not a participant in this newsletter in an=
y way.



























oxchmvubfk  bzanj xg


l dviozj  z   fxuohkr mcawzqmoaejhisfbs
pp y 

[Firebird-net-provider] SetPageBuffers + SetReserveSpace ?

[Thomas <ja...@ma...>]

Hi

What will I achieve be settings the SetPageBuffers(), SetReservsSpace() =
and the QueryBufferSize ?

Thanks

Regards
Thomas

Re: [Firebird-net-provider] (no subject)

[<car...@te...>]

Hello:

> I'm using the Firebird .NET provider components in the Visual Studio .NET
> 2003 IDE.
> 
> I was wondering whether it is possible to set any of the attributes that
> need to parse SQL. For example, when I click on the '...' button next to the
> CommandText attribute of an FbCommand component, I receive a 'Specified cast
> is not valid.' error. This also happens with the Parameters attribute and in
> other components (e.g. Mappings attribute in FbDataAdapter)
> 
> Is there some way to enable this?

The only one that isn't working for me is the Connection String editor, 
it's fixed yet in CVS.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] (no subject)

[<fir...@th...>]

Hi,

I'm using the Firebird .NET provider components in the Visual Studio .NET
2003 IDE.

I was wondering whether it is possible to set any of the attributes that
need to parse SQL. For example, when I click on the '...' button next to the
CommandText attribute of an FbCommand component, I receive a 'Specified cast
is not valid.' error. This also happens with the Parameters attribute and in
other components (e.g. Mappings attribute in FbDataAdapter)

Is there some way to enable this?

Thanks.

Ben.


Using FirebirdSql.Data.Firebird version 1.5.1437.22333

Re: [Firebird-net-provider] Does firebird.net provider work with Interbase?

[<car...@te...>]

Hello:

> Additional information: Invalid PInvoke metadata format."

This usually gives trying to use an assembly built using .net 1.1 with 
.net 1.0.

> Is this because the provider does not work with Interbase or is there
> another cause?

It needs to work with Interbase 6.0, i am not sure if it will work with 
6.5 and 7.x

Which version of the .NET Data Provider, .NET Framework and Interbase 
are you using ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Does firebird.net provider work with Interbase?

[David R. <dav...@nt...>]

Sorry if this is a daft question but I have to develop an app to talk =
with
an existing Interbase DB using C#. The firebird.net provider seemed =
perfect
but when I try to connect I get the following error=20

"An unhandled exception of type 'System.TypeLoadException' occurred in
firebirdsql.data.firebird.dll

Additional information: Invalid PInvoke metadata format."

Is this because the provider does not work with Interbase or is there
another cause?

Best Wishes
=A0
David Royal

Re: [Firebird-net-provider] Developement status report.

[<car...@te...>]

Hello:

> It is possible to expect  (in version 1.6) support of parameters of
> transactions "read" and "nowait" (letter Riaan Nagel from October, 8 and my
> letter from December, 3)

I have committed to the CVS (1.6 sources) a first implementation for 
allow this, using two new overloads of FbConnection.BeginTransaction 
method and a new FbTransactionOptions flags enumeration.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Developement status report.

[<car...@te...>]

Hello:

> It is possible to expect  (in version 1.6) support of parameters of
> transactions "read" and "nowait" (letter Riaan Nagel from October, 8 and my
> letter from December, 3)

Yes.




--
Bets regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] BLOB?

[<car...@te...>]

Hello:

> how do I update a blob field (text) ?
>  
> UPDATE myTABLE SET text = "TEST"
>  
> result in error:
> BLOB and array data types are not supported for move operation

Using parametrized querys:

...

string sql = "UPDATE myTABLE SET text = @text";
FbCommand update = new FbCommand(sql, connection, transaction);

update.Parameters.Add("@text", FbDbType.Text).Value = "TEST";

int rowsAffected = update.ExecuteNonQuery();

...



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Developement status report.

[Alexander H. <ale...@sa...>]

Hello, Carlos

It is possible to expect  (in version 1.6) support of parameters of
transactions "read" and "nowait" (letter Riaan Nagel from October, 8 and my
letter from December, 3)

Best regards
Alexander

[Firebird-net-provider] BLOB?

[Thomas <ja...@ma...>]

how do I update a blob field (text) ?

UPDATE myTABLE SET text =3D "TEST"

result in error:
BLOB and array data types are not supported for move operation

[Firebird-net-provider] Developement status report.

[<car...@te...>]

Hello:

* Firebird .NET Data Provider 1.5:

	- A bugfix for date/time/timestamp parameters conversions. (Thanks to 
Dmitry Azaraev for his feedback)

	- Two little bugfixes in the Firebird Services Implementation.

	- Added serializable attribute to GdsException, GdsError and 
GdsErrorCollection (Thanks to Dmitry Yemanov for his feedback)


* Firebird .NET Data Provider 1.6:

I have added this week the initial implementation of the 1.6 sources, 
with the new assembly distribution and the embedded server support.

I am going to start the testing using the NUnit test suite next week.

The know problems at this moment, with the embedded GDS implementation, are:

* Array data type support:

	- Limited to C# primitive types on insert/update.

	- The array bounds are limited to 1..32767, i have send an email to the 
firebird-devel list around this issue and i am waiting for an answer 
(the pure C# GDS implementation doesn't have this limitation)

* Firebird Events support:

	- It's implemented but, it's not working yet, i am having problems, i 
think that the problem is in the marshaling of a callback function, 
needed for receive events notification, i can receive them one time but 
after this the test program crashes, i will try to review this next week 
too, for see if it's possible or not to implement it in the embedded GDS.



For use the embedded GDS implementation, there are a new parameter in 
the connection string:

	ServerType = 0 # Pure C# GDS implementation.
	ServerType = 1 # Embedded C# GDS implementation.

The FirebirdSql.Data.Embedded by default will use the Firebird Embedded 
server dll, but it can work too with fbclient.dll if  the build has a 
FBCLIENT define, in both cases the dll needs to be in the path.

Other changes in 1.6 sources:

	- Changes for try to make the code more readable.

	- The implicit transaction support will be handled now in FbCommand 
class, this will allow handle it in one place only, and to use the 
FbCommand transaction for the commands used in 
FbDataReader.GestSchemaTable method.

	- Changes for simplify the Firebird Events API implementation.

	- Changes in the Firebird Services API implementation, FbService class 
was modified for use an instance of AttachmentParams instead of use 
individual properties.

	- GdsException is renamed as IscException.

	- GdsError is renamed as IscError.

	- GdsErrorCollection is renamed as IscErrorCollection.

	- There a more changes but they are mainly internal changes :)



As always all comments are very welcome!





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: AW: [Firebird-net-provider] MSVCR70.dll II

[<car...@te...>]

Hello:

> I had already read that. Nevertheless thanks.
> My problem however is, that I have at all no msvcr70.dll on my PC.
> I have a msvcr71.dll. So how can I do all registrations with this file?

I don't know what can be the problem, probably that i have generated the 
installation packages with both frameworks installed, try to download 
the sources and build them using nant (nant.sourceforge.net)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

AW: [Firebird-net-provider] MSVCR70.dll II

[Generalissimo <gen...@gm...>]

I had already read that. Nevertheless thanks.
My problem however is, that I have at all no msvcr70.dll on my PC.
I have a msvcr71.dll. So how can I do all registrations with this file?

-----Ursprüngliche Nachricht-----
Von: Carlos Guzmán Álvarez [mailto:car...@te...]
Gesendet: Freitag, 12. Dezember 2003 17:32
An: Generalissimo
Cc: fir...@li...
Betreff: Re: [Firebird-net-provider] MSVCR70.dll II


Hello:

> Hello, I have a problem with the installation of the
> FirebirdNETProvider1.5-RC1-NET1.1.
> At the end of the installation it wants to make registrations with a
> msvcr70.dll.
> I have however a higher version of this file by the installation of the
NET
> Frameworks 1.1 (inclusive SDK).
> How can I accomplish now the registrations manually and which files would
> have I to register?

Form the KNOWN.TXT file:

Problem with MSVCR70.dll
------------------------

Solution from an answer of Andrew C. Goodall in the developement lis:

Do a file search on the pc/server where you installed .net framework
The dll is there but it's in a temp folder and needs to be copied to the
main .net folder.

my msvcr70.dll was in C:\WINNT\SYSTEM32\URTTemp
I copied it to C:\WINNT\Microsoft.NET\Framework\v1.0.3705

Then I re-installed Firebird .NET provider and all was well in the world.




--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] MSVCR70.dll II

[<car...@te...>]

Hello:

> Hello, I have a problem with the installation of the
> FirebirdNETProvider1.5-RC1-NET1.1.
> At the end of the installation it wants to make registrations with a
> msvcr70.dll.
> I have however a higher version of this file by the installation of the NET
> Frameworks 1.1 (inclusive SDK).
> How can I accomplish now the registrations manually and which files would
> have I to register?

Form the KNOWN.TXT file:

Problem with MSVCR70.dll
------------------------

Solution from an answer of Andrew C. Goodall in the developement lis:

Do a file search on the pc/server where you installed .net framework
The dll is there but it's in a temp folder and needs to be copied to the 
main .net folder.

my msvcr70.dll was in C:\WINNT\SYSTEM32\URTTemp
I copied it to C:\WINNT\Microsoft.NET\Framework\v1.0.3705

Then I re-installed Firebird .NET provider and all was well in the world.




--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

[Firebird-net-provider] MSVCR70.dll II

[Generalissimo <gen...@gm...>]

Hello, I have a problem with the installation of the
FirebirdNETProvider1.5-RC1-NET1.1.
At the end of the installation it wants to make registrations with a
msvcr70.dll.
I have however a higher version of this file by the installation of the NET
Frameworks 1.1 (inclusive SDK).
How can I accomplish now the registrations manually and which files would
have I to register?

Thanks already times.

Re: [Firebird-net-provider] Remote connection using .net provider

[<car...@te...>]

Hello:

>       I would like to make a connection to a remote to a firebird database
> server. I have been happily using the existing .net provider for local
> access or access on the same LAN.
> 
>       Not I wish to make a remote connection to a server that exists on the
> internet.
> 
>      Does anybody have an example of a connection string I can use. 

You need to give the server name in the DataSource element of the 
connection string and the port number that is being used by the Firebird 
Server.

User=SYSDBA;Password=masterkey;Database=C:\SampleDatabase.fdb;DataSource=Firebird_Server; 
Port=3050;Dialect=3;Charset=ISO8859_1;Role=; Connection 
lifetime=15;Pooling=true;Packet Size=8192



--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

[Firebird-net-provider] Remote connection using .net provider

[martin <mc...@we...>]

Hi,

      I would like to make a connection to a remote to a firebird database
server. I have been happily using the existing .net provider for local
access or access on the same LAN.

      Not I wish to make a remote connection to a server that exists on the
internet.

     Does anybody have an example of a connection string I can use. I am
assuming that I will have to idenify the server by IP address. Also are
there any additional steps that I need to take in order to ensure that when
a  connection is made to the remote box that houses the firebird server that
the traffic is forawrded on to the acual instance of the firebird server
that is running on the box.

If anybody knows of any information on this subject that I could reference,
then I would appreciate being pointed to the article.

any help is appreciated.

cheers

martin.

Re: [Firebird-net-provider] Firebird performance?

[<car...@te...>]

Hello:

> I use the FbCommand.CommandText  very very extensive.
>  
> Are there any way that I can optimize the performance on my sql?
>  
> Maybe the Prepare() or the CreateParameter() ?

Can you provide more details on what you need to optimize ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Firebird performance?

[Thomas <ja...@ma...>]

I use the FbCommand.CommandText  very very extensive.

Are there any way that I can optimize the performance on my sql?

Maybe the Prepare() or the CreateParameter() ?


(Nb. I cannot use stored procedure)


Thanks

Regards
Thomas