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

Re: [Firebird-net-provider] FirebirdNetProvider + Mono + Win32

[Carlos G. A. <car...@te...>]

Hello:

> Is Cygwin also needed to use FirebirdNETProvider on Mono/Win32?

No, you can use Nant (nant.sourceforge.net), you only need to modify the 
build file for use mono ( mcs ) instead of csc.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FirebirdNetProvider + Mono + Win32

[Peter J. <pet...@gm...>]

Dear All,

I just started my next try to get the NetProvider running.

I downloaded and installed newest Mono 0.25, works fine.

I downloaded FirebirdNETProvider1.1-Alpha2.exe, which
didn't help as it requires MSFT .NET

I downlaoded FirebirdNETProvider1.1-Alpha2-Src.zip, and 
realized that it needed Cygwin to make.

So my question is:

Is Cygwin also needed to use FirebirdNETProvider on Mono/Win32?

If this is not the case, can somebody volunteer a compiled
FirebirdNETProvider1.1-Alpha2? Also it would be nice, if a 
correct link to the compiled dll be sent to the maintainer of
http://go-mono.com/tutorial/html/en/adonet/dbfirebird.html,
so that the quick start example there can be easily followed.

Best Regards,
Peter Jacobi





-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++

Jetzt ein- oder umsteigen und USB-Speicheruhr als Prämie sichern!

Re: [Firebird-net-provider] variable is neither a DataColumn nor a DataRelation

[Carlos G. A. <car...@te...>]

Hello:

> The complete code is :
>             svrCommonConnection.Open()
>             Dim recCount
>             Dim myTxn As FbTransaction =
> svrCommonConnection.BeginTransaction()
> 
>             Dim objDataAdapter As New
> FbDataAdapter(strCommonQry, svrCommonConnection)
>             objDataAdapter.SelectCommand = New
> FbCommand(strCommonQry, svrCommonConnection, myTxn)
>             Dim objCmdBuilder As New
> FbCommandBuilder(objDataAdapter)
>             Dim objDataSet As New DataSet()
> 
>             objDataAdapter.Fill(objDataSet,
> varTableName)
>             objDataView =
> objDataSet.Tables(0).DefaultView
>             fnSetGridRows(dgObject,
> objSelCombo.SelectedItem.Value)
>             fnTogglePaging(dgObject,
> objDataView.Count)
>             dgObject.DataSource = objDataView
>             dgObject.DataBind()
>             recCount = objDataView.Count
>             svrCommonConnection.Close()
>             objDataView.Dispose()
> 
> Its giving me error at dgObject.DataBind()

I'm making a new test with this code:

	FbConnection connection = new FbConnection(connectionString);
	connection.Open();
	FbTransaction transaction = connection.BeginTransaction();

	FbDataAdapter adapter = new FbDataAdapter("select * from ENGLISH order 
by English.var DESC", connection);
         adapter.SelectCommand.Transaction = transaction;

         FbCommandBuilder builder = new FbCommandBuilder(adapter);

         DataSet ds = new DataSet("ENGLISH");
         adapter.Fill(ds, "ENGLISH");
	adapter.Dispose();

         dataGrid1.SetDataBinding(ds, "ENGLISH");	

	connection.Close();


This binds a DataSet to a DataGrid and all is working as expected.

I think the problem can be in:

fnSetGridRows(dgObject, objSelCombo.SelectedItem.Value)
fnTogglePaging(dgObject, objDataView.Count)

But i don't know what this methods does.


One thing, this code is bad:

 >             Dim objDataAdapter As New
 > FbDataAdapter(strCommonQry, svrCommonConnection)
 >             objDataAdapter.SelectCommand = New
 > FbCommand(strCommonQry, svrCommonConnection, myTxn)


Make it as:

	Dim objDataAdapter As New FbDataAdapter(strCommonQry, svrCommonConnection)
	objDataAdapter.SelectCommand.Transaction = myTxn;

Or as:

Dim objSelectCommand as New FbCommand(strCommonQry, svrCommonConnection, 
myTxn)
Dim objDataAdapter As New FbDataAdapter(objSelectCommand)





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] variable is neither a DataColumn nor a DataRelation

[Carlos G. A. <car...@te...>]

Hello:

>  When I am trying to execute following query, it successfully executes 
> through IBConsole
> 
> "select * from English order by English.var DESC"
> 
> But, when executed through ASP.Net & tried to use a data adapter, 
> dataset, datatable, I get the following error :
> 
> "variable is neither a DataColumn nor a DataRelation for table English."
> 
> Only one row is displayed in the data grid. And above error msg I've 
> trapped.
> 
> Can anybody tell the solution.


Can you send the complete structure of English table ?? Have you tested 
if you can create a datareader an access all field values ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] variable is neither a DataColumn nor a DataRelation

[Ghanshyam P. <gha...@ms...>]

Hello,
  When I am trying to execute following query, it successfully executes 
through IBConsole

"select * from English order by English.var DESC"

But, when executed through ASP.Net & tried to use a data adapter, dataset, 
datatable, I get the following error :

"variable is neither a DataColumn nor a DataRelation for table English."

Only one row is displayed in the data grid. And above error msg I've 
trapped.

Can anybody tell the solution.

Thanx in advance for any help.

Regards,
Ghanshyam

_________________________________________________________________
MSN give you more space! 5 times more storage. 
http://join.msn.com/?page=dept/home&pgmarket=en-xu Do more for less.

Re: [Firebird-net-provider] MS SQL to Firebird?

[Carlos G. A. <car...@te...>]

Hello:

> has anyone experience in porting a .NET application using MSSQL to Firebird?
> Are there any well-known restrictions with
> 
>  - Sub selects or derived tables,
>  - Views,
>  - Stored Procedures or
>  - Batch queries (Commands returning results from multiple SELECT
> statements)
> 
> Is the Guid (uniqueidentifier) supported?
> 
> I would be happy, even with some quick yes/no anwers!

I think you will get better answer to this in the firebird support list 
(ib-support)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] MS SQL to Firebird?

[Mic <mic...@ya...>]

Hi there,

has anyone experience in porting a .NET application using MSSQL to Firebird?
Are there any well-known restrictions with

 - Sub selects or derived tables,
 - Views,
 - Stored Procedures or
 - Batch queries (Commands returning results from multiple SELECT
statements)

Is the Guid (uniqueidentifier) supported?

I would be happy, even with some quick yes/no anwers!

Jens.

[Firebird-net-provider] Implicit transaction control for SELECT statements

[Carlos G. A. <car...@te...>]

Hello:


As a result of a discussion in the firebird-devel list i have finally 
decided to add implicit transaction control for SELECT commands, 
preliminary version is committed into CVS, for brach of 1.1 version 
sources only, i'm going to try to make some testing and add NUnit tests 
today.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Error in the help file

[Carlos G. A. <car...@te...>]

Hello:

> Hi,
> I am playing around with the .Net driver which works just fine. But I would
> like to mention that I have found an error in the example showing how to use
> the FbDataReader. The connection must be active before you can start a
> transaction.

Fixed and commited in both CVS branches, Thanks very much :D





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Error in the help file

[Jan J. <ja...@uv...>]

Hi,
I am playing around with the .Net driver which works just fine. But I would
like to mention that I have found an error in the example showing how to use
the FbDataReader. The connection must be active before you can start a
transaction.

Regards
Jan Jensen

 string mySelectQuery = "SELECT dept_no, departament FROM departament";

    FbConnection	myConnection = new FblConnection(myConnString);

    FbTransaction	myTxn		 = myConnection.BeginTransaction();
    FbCommand		myCommand    = new FbCommand(mySelectQuery, myConnection,
myTxn);
    myConnection.Open(); //Error   - move up!

    FbDataReader myReader;
    myReader = myCommand.ExecuteReader();

    // Always call Read before accessing data.
    while (myReader.Read())
    {
       Console.WriteLine(myReader.GetInt32(0) + ", " +
myReader.GetString(1));
    }

    // always call Close when done reading.
    myReader.Close();

    // Close the connection when done with it.
    myConnection.Close();
 }

Re: [Firebird-net-provider] DDL

[Carlos G. A. <car...@te...>]

Hello:

> Im new to Firebird. I am trying to use net provider to toy with the 
> server. I managed to create new database but I don't know how to create 
> its structure (tables, realtions, indices). How do you execute CREATE 
> TABLE or similar through the .NET provider Or is there some other API to 
> achieve this goal?

You can try using FbCommand.ExecuteNonQuery method, using as CommandText 
a CREATE TABLE statement, you can downalod this file for more info abot 
ddl syntax in firebird (10 MB):


ftp://ftpc.inprise.com/pub/interbase/techpubs/ib_b60_doc.zip




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] DDL

[<ro...@ro...>]

Hi!

Im new to Firebird. I am trying to use net provider to toy with the 
server. I managed to create new database but I don't know how to create 
its structure (tables, realtions, indices). How do you execute CREATE 
TABLE or similar through the .NET provider Or is there some other API to 
achieve this goal?

Michal Ziemski

Re: [Firebird-net-provider] How can i set transaction?

[Carlos G. A. <car...@te...>]

Hello:

> Where i can set transaction property RecVersion and NoWait? I can set
> only Read commited.

You can't set these values manually, instead you can use 
FbConnection.BeginTransaction(IsolationLevel) or 
FbConnection.BeginTransaction(IsolationLevel, string transactionName), 
the last only if you are working with Firebird 1.5, where each supported 
Isolation level is configured as:


* isc_tpb_version3
* isc_tpb_write
* isc_tpb_wait

- IsolationLevel.Serializable:
	
	* isc_tpb_consistency

- IsolationLevel.RepeatableRead:				

	* isc_tpb_concurrency

- IsolationLevel.ReadUncommitted:
	
	* isc_tpb_read_committed
	
	* isc_tpb_rec_version

- IsolationLevel.ReadCommitted:
	
	* isc_tpb_read_committed

	* isc_tpb_no_rec_version





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] =?iso-8859-2?Q?How=20can=20i=20set=20transaction=3F?=

[<de...@se...>]

Hello 

Where i can set transaction property RecVersion and NoWait? I can set
only Read commited.

Thanks

______________________________________________________________________
Reklama:
Za surfov=E1n=ED po internetu dost=E1vat odm=ECny - to je nov=FD http:/=
/ad2.seznam.cz/redir.cgi?instance=3D55053%26url=3Dhttp://club.razdva.cz=
/

RE: [Firebird-net-provider] Overwrite database in use

[<ait...@gm...>]

Thank you, I'll try it.

-----Mensaje original-----
De: fir...@li...
[mailto:fir...@li...] En nombre de
Carlos Guzman Alvarez Enviado el: lunes, 30 de junio de 2003 10:11
Para: Aitor G=F3mez Gonz=E1lez
CC: Fir...@li...
Asunto: Re: [Firebird-net-provider] Overwrite database in use


Hello:

> Thanks, I know that.  May be I didn't explain well enough my question.
>=20
> I have one and only one live connection.  If I close this unique
> connection (myConnection.Close()) I should be able to delete the=20
> database file in use (myDatabase.fdb), but this works only when=20
> connection pooling is disabled.  Should I understand connection (my=20
> unique connection) is not really closed when I call=20
> "myConnection.Close()" and connection pooling is enabled?

Using Connection Pooling the onnection is not closed until the pool=20
performs a cleanup yo can try to add a Thread.Sleep to=20
DoRestoreDatabaseBackup(); or try to change the "Connection lifetime"=20
value in Connection String






--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain



-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Interbase 4.0 Compatiblity

[Carlos G. A. <car...@te...>]

Hello:

> Thanks for the feedback.  Asp.net is enough new technology for me right
> now.  After much thought, I decided to upgrade production box to
> Firebird anyway, and now my site is up and running.


Great !! I think it's the best option because Interbase 4.0 is an old 
product :)





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Overwrite database in use

[Carlos G. A. <car...@te...>]

Hello:

> Thanks, I know that.  May be I didn't explain well enough my question.
> 
> I have one and only one live connection.  If I close this unique
> connection (myConnection.Close()) I should be able to delete the
> database file in use (myDatabase.fdb), but this works only when
> connection pooling is disabled.  Should I understand connection (my
> unique connection) is not really closed when I call
> "myConnection.Close()" and connection pooling is enabled?

Using Connection Pooling the onnection is not closed until the pool 
performs a cleanup yo can try to add a Thread.Sleep to 
DoRestoreDatabaseBackup(); or try to change the "Connection lifetime" 
value in Connection String






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Overwrite database in use

[Alan M. <al...@me...>]

It may not be in conformance but maybe there should be a parameter in=
 the
connection string to force a single connection even when the pooling =
on the
driver is set to ON.
I would never have thought to or wanted to do a restore via the old O=
DBC
connection setup and I suppose the .NET driver has some left over log=
ic
assocated with this kind of connection
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Alan McDonald
> Sent: Monday, 30 June 2003 11:23 AM
> To: Aitor G=F3mez Gonz=E1lez; Fir...@li...urcefor=
ge.net
> Subject: RE: [Firebird-net-provider] Overwrite database in use
>
>
> Sorry if I misunderstood..
> I imagine that with connection pooling turned on, then there are ot=
her
> connections made by the driver at the time you make your single
> connection.
> With connection pooling turned on, there is also the timeout to
> consider on
> connection made, not used and expired...
>
> Alan
>
> > -----Original Message-----
> > From: Aitor G=F3mez Gonz=E1lez [mailto:ait...@gm...]
> > Sent: Monday, 30 June 2003 9:13 AM
> > To: 'Alan McDonald'
> > Subject: RE: [Firebird-net-provider] Overwrite database in use
> >
> >
> > Hi Alan,
> >
> > Thanks, I know that.  May be I didn't explain well enough my ques=
tion.
> >
> > I have one and only one live connection.  If I close this unique
> > connection (myConnection.Close()) I should be able to delete the
> > database file in use (myDatabase.fdb), but this works only when
> > connection pooling is disabled.  Should I understand connection (=
my
> > unique connection) is not really closed when I call
> > "myConnection.Close()" and connection pooling is enabled?
> >
> >
> > Regards,
> > Aitor.
> >
> >
> > -----Mensaje original-----
> > De: Alan McDonald [mailto:al...@me...]
> > Enviado el: lunes, 30 de junio de 2003 0:30
> > Para: Aitor G=F3mez Gonz=E1lez
> > Asunto: RE: [Firebird-net-provider] Overwrite database in use
> >
> >
> > you can't do a restore with more than one live connection. It's t=
here to
> > protect the database since a second connection means someone else=
 is
> > currently using the DB. You can backup with many connections but
> > restoring is an amdin function carried out with only one connecti=
on.
> > Alan
> >
> > > -----Original Message-----
> > > From: fir...@li...
> > > [mailto:fir...@li...]On Be=
half Of
> >
> > > Aitor G=F3mez Gonz=E1lez
> > > Sent: Monday, 30 June 2003 7:29 AM
> > > To: Fir...@li...
> > > Subject: [Firebird-net-provider] Overwrite database in use
> > >
> > >
> > > Hi,
> > >
> > > I'm trying to overwrite database in use for a "Restore database
> > > backup" feature in a program, using "gbak -RESTORE_DATABASE" co=
mmand.
> >
> > > My code is something like this:
> > >
> > >
> > > myConnection.Close();
> > > DoRestoreDatabaseBackup();
> > > myConnection.Open();
> > >
> > >
> > > It works perfect with ConnectionPooling =3D false, but almost n=
ever when
> >
> > > ConnectionPooling =3D true, even if "myConnection" is the only
> > > connection opened across the application.  It's not a problem f=
or me
> > > by now, I only need a connection, I'll work without ConnectionP=
ooling,
> >
> > > but I'd like to know how could I do it in case of working with =
more
> > > than one connection.
> > >
> > >
> > > Thanks in advance,
> > > Aitor.
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email sponsored by: Free pre-built ASP.NET sites in=
cluding
> >
> > > Data Reports, E-commerce, Portals, and Forums are available now=
.
> > > Download today and enter to win an XBOX or Visual Studio .NET.
> > > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061=
203_01/
> > > 01
> > > _______________________________________________
> > > Firebird-net-provider mailing list
> > > Fir...@li...
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provi=
der
> >
> >
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites includ=
ing
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_=
01/01
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

RE: [Firebird-net-provider] Overwrite database in use

[Alan M. <al...@me...>]

Sorry if I misunderstood..
I imagine that with connection pooling turned on, then there are other
connections made by the driver at the time you make your single connection.
With connection pooling turned on, there is also the timeout to consider on
connection made, not used and expired...

Alan

> -----Original Message-----
> From: Aitor Gómez González [mailto:ait...@gm...]
> Sent: Monday, 30 June 2003 9:13 AM
> To: 'Alan McDonald'
> Subject: RE: [Firebird-net-provider] Overwrite database in use
>
>
> Hi Alan,
>
> Thanks, I know that.  May be I didn't explain well enough my question.
>
> I have one and only one live connection.  If I close this unique
> connection (myConnection.Close()) I should be able to delete the
> database file in use (myDatabase.fdb), but this works only when
> connection pooling is disabled.  Should I understand connection (my
> unique connection) is not really closed when I call
> "myConnection.Close()" and connection pooling is enabled?
>
>
> Regards,
> Aitor.
>
>
> -----Mensaje original-----
> De: Alan McDonald [mailto:al...@me...]
> Enviado el: lunes, 30 de junio de 2003 0:30
> Para: Aitor Gómez González
> Asunto: RE: [Firebird-net-provider] Overwrite database in use
>
>
> you can't do a restore with more than one live connection. It's there to
> protect the database since a second connection means someone else is
> currently using the DB. You can backup with many connections but
> restoring is an amdin function carried out with only one connection.
> Alan
>
> > -----Original Message-----
> > From: fir...@li...
> > [mailto:fir...@li...]On Behalf Of
>
> > Aitor Gómez González
> > Sent: Monday, 30 June 2003 7:29 AM
> > To: Fir...@li...
> > Subject: [Firebird-net-provider] Overwrite database in use
> >
> >
> > Hi,
> >
> > I'm trying to overwrite database in use for a "Restore database
> > backup" feature in a program, using "gbak -RESTORE_DATABASE" command.
>
> > My code is something like this:
> >
> >
> > myConnection.Close();
> > DoRestoreDatabaseBackup();
> > myConnection.Open();
> >
> >
> > It works perfect with ConnectionPooling = false, but almost never when
>
> > ConnectionPooling = true, even if "myConnection" is the only
> > connection opened across the application.  It's not a problem for me
> > by now, I only need a connection, I'll work without ConnectionPooling,
>
> > but I'd like to know how could I do it in case of working with more
> > than one connection.
> >
> >
> > Thanks in advance,
> > Aitor.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>
> > Data Reports, E-commerce, Portals, and Forums are available now.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/
> > 01
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

RE: [Firebird-net-provider] Overwrite database in use

[Alan M. <al...@me...>]

you can't do a restore with more than one live connection. It's
there to protect the database since a second connection means
someone else is currently using the DB. You can backup with many
connections but restoring is an amdin function carried out with
only one connection.
Alan
>
> > -----Original Message-----
> > From: fir...@li...
> > [mailto:fir...@li...]On Beha=
lf Of
> > Aitor G=F3mez Gonz=E1lez
> > Sent: Monday, 30 June 2003 7:29 AM
> > To: Fir...@li...
> > Subject: [Firebird-net-provider] Overwrite database in use
> >
> >
> > Hi,
> >
> > I'm trying to overwrite database in use for a "Restore database b=
ackup"
> > feature in a program, using "gbak -RESTORE_DATABASE" command.  My=
 code
> > is something like this:
> >
> >
> > myConnection.Close();
> > DoRestoreDatabaseBackup();
> > myConnection.Open();
> >
> >
> > It works perfect with ConnectionPooling =3D false, but almost nev=
er when
> > ConnectionPooling =3D true, even if "myConnection" is the only co=
nnection
> > opened across the application.  It's not a problem for me by now,=
 I only
> > need a connection, I'll work without ConnectionPooling, but I'd l=
ike to
> > know how could I do it in case of working with more than one conn=
ection.
> >
> >
> > Thanks in advance,
> > Aitor.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites incl=
uding
> > Data Reports, E-commerce, Portals, and Forums are available now.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_06120=
3_01/01
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provide=
r

RE: [Firebird-net-provider] Overwrite database in use

[<ait...@gm...>]

Hi Alan,

Thanks, I know that.  May be I didn't explain well enough my question.

I have one and only one live connection.  If I close this unique
connection (myConnection.Close()) I should be able to delete the
database file in use (myDatabase.fdb), but this works only when
connection pooling is disabled.  Should I understand connection (my
unique connection) is not really closed when I call
"myConnection.Close()" and connection pooling is enabled?


Regards,
Aitor.


-----Mensaje original-----
De: Alan McDonald [mailto:al...@me...]=20
Enviado el: lunes, 30 de junio de 2003 0:30
Para: Aitor G=F3mez Gonz=E1lez
Asunto: RE: [Firebird-net-provider] Overwrite database in use


you can't do a restore with more than one live connection. It's there to
protect the database since a second connection means someone else is
currently using the DB. You can backup with many connections but
restoring is an amdin function carried out with only one connection.
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Aitor G=F3mez Gonz=E1lez
> Sent: Monday, 30 June 2003 7:29 AM
> To: Fir...@li...
> Subject: [Firebird-net-provider] Overwrite database in use
>
>
> Hi,
>
> I'm trying to overwrite database in use for a "Restore database
> backup" feature in a program, using "gbak -RESTORE_DATABASE" command.

> My code is something like this:
>
>
> myConnection.Close();
> DoRestoreDatabaseBackup();
> myConnection.Open();
>
>
> It works perfect with ConnectionPooling =3D false, but almost never =
when
> ConnectionPooling =3D true, even if "myConnection" is the only=20
> connection opened across the application.  It's not a problem for me=20
> by now, I only need a connection, I'll work without ConnectionPooling,

> but I'd like to know how could I do it in case of working with more=20
> than one connection.
>
>
> Thanks in advance,
> Aitor.
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.=20
> Download today and enter to win an XBOX or Visual Studio .NET.=20
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/
> 01
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

RE: [Firebird-net-provider] Interbase 4.0 Compatiblity

[Andrew G. <And...@Bu...>]

Carlos Guzm=E1n =C1lvarez wrote on Fri 6/27/2003 10:11 AM
> Hello:

>> Does firebird-net-provider work with IB 4.0?  If not, any suggestions
>> what I might try to connect to the db via asp.net?  Unfortunately,
>> upgrading from IB 4.0 is not an option.

> Huumm at this moment no for connection to the firebird server the=20
> provider is sending PROTOCOL_VERSION10 as protocol version i can
suggest=20
> you to modify this by the protocol version used by Interbase 4, in=20
> GDS.CS line 2150, recompile the provider sources ( using NAnt=20
> nant.sourceforge.net) and try it, with your app or using the NUnit
test=20
> suite, and if you can please comment here the results of your test :).

Thanks for the feedback.  Asp.net is enough new technology for me right
now.  After much thought, I decided to upgrade production box to
Firebird anyway, and now my site is up and running.
=20
Andy

[Firebird-net-provider] Overwrite database in use

[<ait...@gm...>]

Hi,

I'm trying to overwrite database in use for a "Restore database backup"
feature in a program, using "gbak -RESTORE_DATABASE" command.  My code
is something like this:


myConnection.Close();
DoRestoreDatabaseBackup();
myConnection.Open();


It works perfect with ConnectionPooling = false, but almost never when
ConnectionPooling = true, even if "myConnection" is the only connection
opened across the application.  It's not a problem for me by now, I only
need a connection, I'll work without ConnectionPooling, but I'd like to
know how could I do it in case of working with more than one connection.


Thanks in advance,
Aitor.

Re: [Firebird-net-provider] Interbase 4.0 Compatiblity

[Carlos G. A. <car...@te...>]

Hello:

> Does firebird-net-provider work with IB 4.0?  If not, any suggestions
> what I might try to connect to the db via asp.net?  Unfortunately,
> upgrading from IB 4.0 is not an option.

Huumm at this moment no for connection to the firebird server the 
provider is sending PROTOCOL_VERSION10 as protocol version i can suggest 
you to modify this by the protocol version used by Interbase 4, in 
GDS.CS line 2150, recompile the provider sources ( using NAnt 
nant.sourceforge.net) and try it, with your app or using the NUnit test 
suite, and if you can please comment here the results of your test :).






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Interbase 4.0 Compatiblity

[Andrew G. <And...@Bu...>]

Hi,

My development machine is Win XP, Firebird 1.03, .net 1.1, FBNetProv
1.1.  The production box is Win 2k Server, Interbase 4.0 (sic), .net
1.1, FBNetProv 1.1.  The ASP.NET project works great on the development
box.

But when I try to run it on production (IB 4.0), I get

GDSException: Exception of type FirebirdSql.Data.INGDS.GDSException was
thrown
...
FbException: connection rejected by remote interface

trying to open an FbConnection.  The connect string is

    public connStr As String = "User=xxx; Password=xxx;" & _
      "Database=C:\\db\\xxx.gdb;" & _
 
"Server=localhost;Port=3050;Dialect=1;Charset=NONE;Role=;Connection" & _
      "lifetime=15;Pooling=true;Packet Size=8192"

I can connect to IB 4.0 db's via ISAPI DLL's using http on the same web
site.

Does firebird-net-provider work with IB 4.0?  If not, any suggestions
what I might try to connect to the db via asp.net?  Unfortunately,
upgrading from IB 4.0 is not an option.

Thanks,

Andy