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

Re: [Firebird-net-provider] DateTime conversion in Firebird.NET

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

Hello:

>I using version 1.5 of Firebird.NET provider and I noticed that DateTime
>does not convert 100% therefore failing if used in CompareTo.  What I
>noticed is that the time portion of the datetime is missing as indicated
>by the ticks count.  For example ....
>
>Write to Firebird 
>EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
>632186542302487500
>
>Read from Firebird
>EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
>632186542300000000
>

That works for me, are you sure the field in the database is
a timestamp field ?? ( i know it's stupid question but i need
to ask it :) ), date only fields doesn't have the time ;).

The only part that isn't handled in 1.5 version for a timestamp
field are the milliseconds (that is being done yet in 1.6)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Guid Support

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

Hello:

>The only issue is reading from Firebird into the .NET provider as it will "think" a GUID is a Firebird TEXT type.  The way for the provider to distinguish that the data coming across is a guid is for the provider to check the size.  If the data is TEXT by and size is 16 then assume a GUID and convert the byte stream to a GUID -- wal-la!
>

That is what i was thinking you are doing for implement it,
but that isn't a real solution as people can have a CHAR(16)
field that isn't used for Guid ;)






--
Best regards

Carlos Guzmán Álavrze
Vigo-Spain

Re: [Firebird-net-provider] DateTime conversion in Firebird.NET

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

Hello:

> 	Since all I need is hh:mm:ss precision then what I have to do to
>work around this issue is to specifically check hours, minute and
>seconds rather than default to the tick counts until you've implemented
>milliseconds support in V1.6
>
This is implemented in 1.6 yet.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Guid Support

[Peter J. <pj...@wa...>]

Hi Chris,

> I've tried storing this with Firebird and it seems to work.  

Did your test include cases where the GUID did contain
bytes of value zero? On average 1/16th of all GUID of
should have this "feature"?

> Firebird seem
> to treat CHAR types as merely as an array of bytes and doesn't seem to
> attempt any other interpretations.  

Only CHARACTER SET OCTETS is designed to be a mere array of bytes,
so that I'm curious whether your test worked without specifying the
character set.

> With that knowledge and if you are
> developing a new database project make it a guideline that only GUID
> entities are defined as CHAR(16).

CHAR(16) CHARACTER SET OCTETS

> The only issue is reading from Firebird into the .NET provider as it will
> "think" a GUID is a Firebird TEXT type.  The way for the provider to
> distinguish that the data coming across is a guid is for the provider to
> check the size.  If the data is TEXT by and size is 16 then assume a GUID
> and convert the byte stream to a GUID -- wal-la!

I don't know whether the provider already includes special casing
for character set octets, perhaps Carlos should comment on this.

Also short of adding a new type, a new (pseudo) character set can
be created, which behaves mostly like OCTETS but uniquely identifies
the field as being an GUID. It's even possible to make the stringification
of the GUID a character set conversion to ASCII, if this buys anything.

Regards,
Peter Jacobi

RE: [Firebird-net-provider] DateTime conversion in Firebird.NET

[Chris W. <ch...@co...>]

Carlos,

	Thanks for your quick response and help.  What is happening is
that=20
Firebird *does* return the correct Date and Time but only up to the
second.  The milliseconds value is missing from the date returned from
the database and thus you cannot assume *absolute* DateTime equality for
use in DateTime.CompareTo.

 	Since all I need is hh:mm:ss precision then what I have to do to
work around this issue is to specifically check hours, minute and
seconds rather than default to the tick counts until you've implemented
milliseconds support in V1.6

Thanks,
Chris.

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
ch...@co...
Sent: Tuesday, April 27, 2004 1:40 PM
To: Carlos Guzm=E1n =C1lvarez
Cc: 'Firebird ADO.NET Data Provider'
Subject: Re: [Firebird-net-provider] DateTime conversion in Firebird.NET

I don't have the code in front of me to refer to right now but I do
believe that I am using timestamp albeit as a domain -- don't know if
that makes a difference.  This allowed be to verify my table layout with
sqlserver since domains can be used like #defines.

I'll take a closer look later this evening but I'm quite certain that
I'm using timestamp.  I can verify whether the timestamp from my
datetime is getting into the data base correctly -- I believe it is but
pulling it out is where I am seeing the discrepancy.

I'll let you know later when I can look at stuff and provide you with
further information.

Thanks for your quick reply and excellent work on the provider and for
open source.

Chris
> Hello:
>=20
> >I using version 1.5 of Firebird.NET provider and I noticed that
DateTime
> >does not convert 100% therefore failing if used in CompareTo.  What I
> >noticed is that the time portion of the datetime is missing as
indicated
> >by the ticks count.  For example ....
> >
> >Write to Firebird=20
> >EntryDate	{4/27/2004}	System.DateTime  =3D=3D> ticks =3D=3D>
> >632186542302487500
> >
> >Read from Firebird
> >EntryDate	{4/27/2004}	System.DateTime  =3D=3D> ticks =3D=3D>
> >632186542300000000
> >
>=20
> That works for me, are you sure the field in the database is
> a timestamp field ?? ( i know it's stupid question but i need
> to ask it :) ), date only fields doesn't have the time ;).
>=20
> The only part that isn't handled in 1.5 version for a timestamp
> field are the milliseconds (that is being done yet in 1.6)
>=20
>=20
>=20
> --
> Best regards
>=20
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain



-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.

Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3D3149&alloc_id=3D8166&op=3Dclick
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] .NET Firebird 1.5

[Claudinei R. <ne...@ac...>]

Hi, peoples.

=20

I can't using the drivers .NET Firebird 1.5 in Visual Studio .NET 2003.

=20

I installed and it is in my ToolBox, but when I drop to WebForm1 I
receive the error:

=20

Unspecified error.

=20

Why happen?

=20

I need help, please.

=20

Thank's

=20

Claudinei

Re: [Firebird-net-provider] Please remove exception in ConnectionTimeout

[<ch...@co...>]

Yep.  I'm taking about FbCommand.CommandTimeout.  Since it is not supported by the Fb provider, I presume that the FbCommand can never timeout and therefore won't upset any positive code path and thus would never engage a negitive code path if it didn't throw an exception.

Because FbCommand.CommandTimeout throws an exception it seems to be to defeat the polymorphic behavior defined by IDbCommand.CommandTimeout as it will not behave consistently across all providers.

If the exception remains how then can you handle this polymorphically?
Is it really an "exception" because the provider doesn't handle timeouts?

In my view essentially CommandTimeout is a stub and Debug.Assert or Trace.Assert can be used to alert the developer.

Chris






> Hello:
> 
> >In the database project that I've previously mention I had to write a 
> persistance layer that wraps the Firebird.NET provider.  The reason is that I 
> can write to my persistance layer for both Firebird and possibly SQLServer and 
> other DB's.  A situation could arise whereby data could be obtained from 
> disparate databases.
> >
> >The problem is that SQLServer provider supports ConnectionTimeout and the 
> Firebird provider throws an exception.  My request is that ConnectionTimeout 
> rather than throw a runtime exeception to return 0 and use an Assert instead.
> >
> >Once again I modified the provider to return 0 causing no behavioral changes to 
> the provider but now my layer can work polymorphically.
> >
> Do you mean FbCommand.CommandTimeout ?? I'm not going to change that,
> at least for now, in my opinion that will give the false impression that
> it's supported and that it works, and it fact if you are going to use
> the CommandTimeout property probably you will be trying to call Cancel
> that will raise an NotSupported exception as well.
> 
> I think the best for you will be to handle the NotSupported exception
> (other providers may throw it too)
> 
> 
> Opinions ??
> 
> 
> 
> --
> Best regards
> 
> Carlos Guzmán Álvarez
> Vigo-Spain

[Firebird-net-provider] Please remove exception in ConnectionTimeout

[<ch...@co...>]

In the database project that I've previously mention I had to write a persistance layer that wraps the Firebird.NET provider.  The reason is that I can write to my persistance layer for both Firebird and possibly SQLServer and other DB's.  A situation could arise whereby data could be obtained from disparate databases.

The problem is that SQLServer provider supports ConnectionTimeout and the Firebird provider throws an exception.  My request is that ConnectionTimeout rather than throw a runtime exeception to return 0 and use an Assert instead.

Once again I modified the provider to return 0 causing no behavioral changes to the provider but now my layer can work polymorphically.

Thanks,
Chris
> > The question is how to use a 16-byte GUID in Firebird when the system
> > itself doesn't.  In the database that I'm designing with Firebird I
> > decided to reserve CHAR(16) for GUID only.  If I have a need for a
> > 16-byte character representation then I'll use either VARCHAR(16) or
> > CHAR(17).  In the CHAR(17) case I'm anticipating the front end to limit user
> > input.
> 
> A column of "char(16) character set octets" should in theory hold
> a binary GUID. 
> 
> But it is a field of research, whether all layers involved will gladly 
> handle bytes of zero in this. It's worth a try.
> 
> A middle ground between binary and textual GUIDs would be to use base64 
> encoded binary GUIDs, requiring 22 bytes.
> 
> Regards,
> Peter Jacobi
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek
> For a limited time only, get FREE Ground shipping on all orders of $35
> or more. Hurry up and shop folks, this offer expires April 30th!

> http://www.thinkgeek.com/freeshipping/?cpg=12297
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Guid Support

[<ch...@co...>]

I've tried storing this with Firebird and it seems to work.  Firebird seem to treat CHAR types as merely as an array of bytes and doesn't seem to attempt any other interpretations.  With that knowledge and if you are developing a new database project make it a guideline that only GUID entities are defined as CHAR(16).

With that, and using some helper UDFs -- GuidCreate, GuidIsEmpty, GuidString --
Guids can be "simulated" on Firebird.

The only issue is reading from Firebird into the .NET provider as it will "think" a GUID is a Firebird TEXT type.  The way for the provider to distinguish that the data coming across is a guid is for the provider to check the size.  If the data is TEXT by and size is 16 then assume a GUID and convert the byte stream to a GUID -- wal-la!

Writing is easier as the provider can do a GetType() on the object.

Right now I've modified the provider to support this (only for sprocs) but what I'm really asking is if this make sense for community wide support.

I think having some sort of GUID support would be extremely useful especially to assist and encourage SqlServer migration to Firebird.

Thanks,
Chris



> > The question is how to use a 16-byte GUID in Firebird when the system
> > itself doesn't.  In the database that I'm designing with Firebird I
> > decided to reserve CHAR(16) for GUID only.  If I have a need for a
> > 16-byte character representation then I'll use either VARCHAR(16) or
> > CHAR(17).  In the CHAR(17) case I'm anticipating the front end to limit user
> > input.
> 
> A column of "char(16) character set octets" should in theory hold
> a binary GUID. 
> 
> But it is a field of research, whether all layers involved will gladly 
> handle bytes of zero in this. It's worth a try.
> 
> A middle ground between binary and textual GUIDs would be to use base64 
> encoded binary GUIDs, requiring 22 bytes.
> 
> Regards,
> Peter Jacobi
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek
> For a limited time only, get FREE Ground shipping on all orders of $35
> or more. Hurry up and shop folks, this offer expires April 30th!

> http://www.thinkgeek.com/freeshipping/?cpg=12297
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] DateTime conversion in Firebird.NET

[<ch...@co...>]

I don't have the code in front of me to refer to right now but I do believe that I am using timestamp albeit as a domain -- don't know if that makes a difference.  This allowed be to verify my table layout with sqlserver since domains can be used like #defines.

I'll take a closer look later this evening but I'm quite certain that I'm using timestamp.  I can verify whether the timestamp from my datetime is getting into the data base correctly -- I believe it is but pulling it out is where I am seeing the discrepancy.

I'll let you know later when I can look at stuff and provide you with further information.

Thanks for your quick reply and excellent work on the provider and for open source.

Chris
> Hello:
> 
> >I using version 1.5 of Firebird.NET provider and I noticed that DateTime
> >does not convert 100% therefore failing if used in CompareTo.  What I
> >noticed is that the time portion of the datetime is missing as indicated
> >by the ticks count.  For example ....
> >
> >Write to Firebird 
> >EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
> >632186542302487500
> >
> >Read from Firebird
> >EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
> >632186542300000000
> >
> 
> That works for me, are you sure the field in the database is
> a timestamp field ?? ( i know it's stupid question but i need
> to ask it :) ), date only fields doesn't have the time ;).
> 
> The only part that isn't handled in 1.5 version for a timestamp
> field are the milliseconds (that is being done yet in 1.6)
> 
> 
> 
> --
> Best regards
> 
> Carlos Guzmán Álvarez
> Vigo-Spain

Re: [Firebird-net-provider] Guid Support

[Peter J. <pj...@wa...>]

> The question is how to use a 16-byte GUID in Firebird when the system
> itself doesn't.  In the database that I'm designing with Firebird I
> decided to reserve CHAR(16) for GUID only.  If I have a need for a
> 16-byte character representation then I'll use either VARCHAR(16) or
> CHAR(17).  In the CHAR(17) case I'm anticipating the front end to limit user
> input.

A column of "char(16) character set octets" should in theory hold
a binary GUID. 

But it is a field of research, whether all layers involved will gladly 
handle bytes of zero in this. It's worth a try.

A middle ground between binary and textual GUIDs would be to use base64 
encoded binary GUIDs, requiring 22 bytes.

Regards,
Peter Jacobi

[Firebird-net-provider] Guid Support

[Chris W. <ch...@co...>]

I know that the Firebird database doesn't support GUIDs however I have
an extremely helpful document that I found on the net that discusses
transitioning from SqlServer to Firebird.  The doc suggests using a
string representation of a Guid instead.

But I think that is an unacceptable suggestion.  Using that technique
Guids are defined as CHAR(36) or CHAR(38) (if you surround the string
rep with curly braces).  This is unacceptable as GUID are 16-byte
(128-bit) values and in may databases used as OID thus quite pervasive.

The question is how to use a 16-byte GUID in Firebird when the system
itself doesn't.  In the database that I'm designing with Firebird I
decided to reserve CHAR(16) for GUID only.  If I have a need for a
16-byte character representation then I'll use either VARCHAR(16) or
CHAR(17).  In the CHAR(17) case I'm anticipating the front end to limit
user input.

Using this definition then the Firebird.NET provider can then determine
and support 16-byte guids.  I made some modifications in FbCommand.cs,
GDS\GdsInetReader.cs and GDS\GdsInetWriter.cs (I'm got to get to work
now so I'll publish the mods in a subsequent email).

But my point is that the provider (perhaps using a compiler switch)
should provide "guid" support into Firebird.  On the Firebird side using
a very simple UDF you can also generate GUIDs this I use an empty guid
to indicate insert and a non-empty guid to indicate update.

My changes however only work if you are using stored procedures as that
is the only code path I really interested in.  But if this sound
plausible and reasonable I think that since .NET makes GUIDs easy to use
and is fully supported in SQLServer it will assist many SQLServer
programmer to migrate the data base over to Firebird.

Thanks,
Chris

[Firebird-net-provider] DateTime conversion in Firebird.NET

[Chris W. <ch...@co...>]

I using version 1.5 of Firebird.NET provider and I noticed that DateTime
does not convert 100% therefore failing if used in CompareTo.  What I
noticed is that the time portion of the datetime is missing as indicated
by the ticks count.  For example ....

Write to Firebird 
EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
632186542302487500

Read from Firebird
EntryDate	{4/27/2004}	System.DateTime  ==> ticks ==>
632186542300000000


I don't know if this is an issue with the provider or with the native
Firebird layer used by the provider.  If this a problem of DateTime to
TimeStamp translation at the native level then I can work around this
issue by defining time in my data base as ticks using a bigint.

Thanks,
Chris

Re: [Firebird-net-provider] Bug in FbConnectionString parsing

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

Hello:

> There is a bug in the FbConnectionString in the parsing of connection 
> strings.  The code in the ConnectionStringToFields() method will loose 
> the last parameter in a connection string because there is no ending 
> semicolon.


Thanks very much.

If you mean the FbConnectionString class that is in the Isql Directory,
that will be, more than probably, removed and the 
FirebirdSql.Data.Common.AttachmentParams class will be used instead 
(Abel Eduardo Pereria has a pending commit on that
classes)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Bug in FbConnectionString parsing

[Todd P. <pal...@ya...>]

There is a bug in the FbConnectionString in the parsing of connection strings.  The code in the ConnectionStringToFields() method will loose the last parameter in a connection string because there is no ending semicolon.
 
Proposed change:
 
Replace all the lines in the FbConnectionString() function with the following:
 
string[] fields = connectionString.Split(";".ToCharArray());
 
foreach (string field in fields)
  ParseConnectionField(field);
 
I'd also like to suggest changing the code in the ParseConnectionField() function to be a case-insentitive match.  I'd be happy to provide a cvs diff.
 
Todd

		
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢

Re: [Firebird-net-provider] Re: FbCommand.ExecuteReader always failed on FirebirdNETProvider1.6 Beta2

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

Hello:

>    I just solved my problem by changing the line from
> parameterPassword := FbParameter.Create('@PASSWORD' 
> <mailto:%27@PASSWORD%27>, FirebirdSql.Data.Firebird.FbDbType.Text); to
> parameterPassword := FbParameter.Create('@PASSWORD' 
> <mailto:%27@PASSWORD%27>, FirebirdSql.Data.Firebird.FbDbType.Varchar);
> after this changes everything looks fine.


Ok :) , You can read the message:

[Firebird-net-provider] Parameter handling (27/3/2004)

For now the reasons of the problem ;)







--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: FbCommand.ExecuteReader always failed on FirebirdNETProvider1.6 Beta2

[benny <be...@ch...>]

Hi,
 =20
   I just solved my problem by changing the line from
parameterPassword :=3D FbParameter.Create('@PASSWORD', =
FirebirdSql.Data.Firebird.FbDbType.Text); to=20
parameterPassword :=3D FbParameter.Create('@PASSWORD', =
FirebirdSql.Data.Firebird.FbDbType.Varchar);
after this changes everything looks fine.

TIA

regards,

benny ;)

Re: [Firebird-net-provider] FbCommand.ExecuteReader always failed on FirebirdNETProvider1.6 Beta2

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

Hello:

>   parameterPassword := FbParameter.Create('@PASSWORD' 
> <mailto:%27@PASSWORD%27>, FirebirdSql.Data.Firebird.FbDbType.Text);


Password is a text blob ?? if not you should use FbDbType.Char or
FbDbType.VarChar (depends on the parameter type)






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbCommand.ExecuteReader always failed on FirebirdNETProvider1.6 Beta2

[benny <be...@ch...>]

Hi,

   After uninstalling the FirebirdNetProvider1.6 Beta1, and replaced it =
FirebirdNetProvider1.6 Beta2 I always have following error while running =
asp.net web application on my delphi8 updated pack 2 compiler using =
cassini....
Error I had:-
Dynamic SQL Error SQL error code =3D -303 internal error=20
[FbException: Dynamic SQL Error
SQL error code =3D -303
internal error
]
   FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior =
behavior)
   FirebirdSql.Data.Firebird.FbCommand.ExecuteReader()


my code:- =20

  parameterPassword :=3D FbParameter.Create('@PASSWORD', =
FirebirdSql.Data.Firebird.FbDbType.Text);
  parameterPassword.Value :=3D strHash;
  FbCommBizCust.Parameters.Add(parameterPassword);

  Reader :=3D FbCommBizCust.ExecuteReader; //failed here ....

why ?

I didnt faced this problem on FirebirdNetProvider1.6 Beta1.

TIA
=20
regards,

benny ;) 

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

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

Hello:

I'm doing an internal rework of data types and field/parameter values,
it's unfinished, until i finsh them CVS maybe unstable :) (the first block
of changes i have committed builds but i haven't tested them yet ;)).


I have added a CVS TAG to the sources befor teh commit:

    NP_1_6_BETA3



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Backup error if spaces in database path....

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

Hello:

> Backup works fine if I use this path: c:\121212\myDB.gdb
> But if I use this path: C:\C:\12 12 12 - 12\myDB.gdb

Do you mean:

C:\12 12 12 - 12\myDB.gdb

Can you do the backup using gbak.exe ??



I will try to do a test later today




--
best regards

Carlos Guzm=C3=A1n =C3=81lvarez
Vigo-Spain

[Firebird-net-provider] Developement status report

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

Hello:

* I have committed yesterday some changes (important in my opinion)
to the FbCommand.Connection and FbCommand.Transaction properties,
the SqlCommand.Connection .NET documentation says:

"If you set *Connection* while a transaction is in progress and the 
Transaction <frlrfsystemdatasqlclientsqlcommandclasstransactiontopic.htm>
property is not null, an InvalidOperationException 
<frlrfsysteminvalidoperationexceptionclasstopic.htm> is generated."

This is in both .NET Framework 1.0 and 1.1. documentation, but after 
some tests
with SqlClient against MSDE 2000 Release A that seems to be untrue, i 
have removed
that check and the exception than was raised.

* Today i have committed some changes for try to improve the DataReader 
implementation:

    - Make it more readable and easy to maintain.

    - Changed open field by isClosed.
   
    - Changed constructor parameters.

    - Improved exception handling, now it's more close to SqlClient,
    the sample used for test it, in SqlClient, was:


            string sql = "SELECT * FROM Customers";

            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();

            SqlCommand command = new SqlCommand(sql, connection);

            SqlDataReader reader = command.ExecuteReader();
            while(reader.Read())
            {
            }

            // Add calls to reader methods ere
                       
            reader.Close();

            // Add calls to reader methods ere

            connection.Close();

* I have started to work in the Borland Data Provider too, now than i have
installed the Delphi .NET trial and i can do some tests with it, but there
are no so much code done yet.

This was going to be implemented in a first time by Abel Eduardo Pereira 
but
he seems to be busy (Abel Eduardo if you read this, please, contact me,
i have sent to you an email to your sourceforge account, because i have lost
my Address book and doesn't have your real email now :P)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] RE: Backup error if spaces in database path....

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

Hello:

>Have you tried a path with spaces?
>  
>

Yes and it works for me, ghere is the sample code:

            FbBackup backupSvc = new FbBackup();
           
            backupSvc.Parameters.UserName         = "SYSDBA";
            backupSvc.Parameters.UserPassword  = "masterkey";
            backupSvc.Parameters.ServerType        = 0;
           
            backupSvc.Parameters.Database = @"C:\Archivos de 
programa\Firebird\Firebird_1_5\examples\employee.fdb";
            backupSvc.BackupFiles.Add(new FbBackupFile(@"c:\testdb.gbk", 
2048));
            backupSvc.Verbose = true;
                     
            backupSvc.Start();

            string lineOutput;
            while((lineOutput = backupSvc.GetNextLine()) != null)
            {
                Console.WriteLine(lineOutput);
            }

            backupSvc.Close();



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbServerProperties.DatabasesInfo Property /list database names

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

Hello:

Sorry for the delay.

>Does anyone know if (and how) it is possible to list all database names on a
>server with the FBServerProperties.DatabasesInfo property?
>

But you want to know the databases that are in use in the server ??
(that if i remember well is what FBServerProperties.DatabasesInfo does) or
the databases existent in the server computer ?? (that can't be know, or 
i don't know how)






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] RE: Backup error if spaces in database path....

[Majken L. <maj...@ma...>]

Hi Carlos.

=20

Yes I mean:

C:\12 12 12 - 12\myDB.gdb <-- This will fail

=20

C:\121212\myDB.gdb <-- This will work

=20

I am using the Backup class in Firebird .NET provider.

=20

Is this using the gbak.exe?

=20

=20

Have you tried a path with spaces?

=20

=20

Regards

Thomas

=20

=20

=20

=20

=20

=20

=20

=20

=20

=20

Hello:

=20

> Backup works fine if I use this path: c:\121212\myDB.gdb

> =20

> But if I use this path: C:\C:\12 12 12 - 12\myDB.gdb

=20

Do you mean:

=20

C:\12 12 12 - 12\myDB.gdb

=20

??

=20

The backup works using gbak.exe ??

=20

=20

=20

=20

=20

=20

--

Best regards

=20

Carlos Guzm=E1n =C1lvarez

Vigo-Spain

=20

=20

--__--__--

=20


  _____ =20

Min mail er beskyttet af SPAMfighter=20
1518 spam mails er blokeret indtil videre.
Hent gratis SPAMfighter <http://www.spamfighter.com/>  i dag!=20