Re: [Firebird-net-provider] FirebirdClient.FbRestore (.Net) restores always only 1064KB

2011-01-09 Thread Jiri Cincura
On Sun, Jan 9, 2011 at 01:17, Takeshi Kabuto wrote: >  FbRestore restore = new FbRestore(); >    restore.ConnectionString = conStr; >    restore.BackupFiles.Add(new FbBackupFile(backupPath, 2048)); >    restore.PageSize = 4096; >     restore.Options = FbRestoreFlags.Create | FbRestoreFlags.Replace

[Firebird-net-provider] FBSecurity UserPassword

2011-01-09 Thread Rick Roen
FBClient 2.5.2 Firebird 2.5.0.26074 When I access FBSecurity.DisplayUsers, the UserPassword is always blank. I guess this is not filled in when the structure is initialized. Is there a way to get this using the FBSecurity class or other? Rick -

Re: [Firebird-net-provider] FirebirdClient.FbRestore (.Net) restores always only 1064KB

2011-01-09 Thread Takeshi Kabuto
Sorry, I am not sure what you mean with output. conStr string contains the typical con string: "Server=localhost;Port=3051;User=SYSDBA;Password=masterkey;Database=d:\databases\mydb.fdb" The thing is that it works fine in my develop computer, but not in the production computer. restore.Execute(

[Firebird-net-provider] Dispose and FbRestore

2011-01-09 Thread Takeshi Kabuto
Is there a way to close or call the the Dispose function when the FbRestore class is used? Now, FbRestore does not release the fbk file when the FbRestore object is deleted. I need to force a call to the garbage collector. You can test if you call restore.Execute(), then delete restore and fin

Re: [Firebird-net-provider] Dispose and FbRestore

2011-01-09 Thread Jiri Cincura
On Sun, Jan 9, 2011 at 14:40, Takeshi Kabuto wrote: > Is there a way to close or call the the Dispose function when the > FbRestore class is used? > > Now, FbRestore does not release the fbk file when the FbRestore object > is deleted. I need to force a call to the garbage collector. > > You can t

Re: [Firebird-net-provider] FirebirdClient.FbRestore (.Net) restores always only 1064KB

2011-01-09 Thread Jiri Cincura
On Sun, Jan 9, 2011 at 14:16, Takeshi Kabuto wrote: > Sorry, I am not sure what you mean with output. conStr string contains > the typical con string: Output from server. > restore.Execute() does not throw any exception Sure. It will not throw any, at least not one related to operation on serve

Re: [Firebird-net-provider] FBSecurity UserPassword

2011-01-09 Thread Jiri Cincura
On Sun, Jan 9, 2011 at 12:54, Rick Roen wrote: > Is there a way to get this using the FBSecurity class or other? No. It will be a security hole. And passwords are encrypted using one way algorithm. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] FBSecurity UserPassword

2011-01-09 Thread Rick Roen
So if I try FBSecurity.ModifyUser(user) there is no way for it to work unless I know the password? I am trying to write a utility program to add/update/delete users from the database, but I don't always know their password so it seems like Update would be impossible. I know it is possible to g

Re: [Firebird-net-provider] FBSecurity UserPassword

2011-01-09 Thread Jiri Cincura
On Sun, Jan 9, 2011 at 18:57, Rick Roen wrote: > I am trying to write a utility program to add/update/delete users from the > database, but I don't always know their password so it seems like Update > would be impossible. You don't need it. If you're SYSDBA. > I know it is possible to get the

Re: [Firebird-net-provider] FirebirdClient.FbRestore (.Net) restores always only 1064KB

2011-01-09 Thread Takeshi Kabuto
Ok, I have found the problem. It is related with the Verbose property. When it is false, FbRestore works in development computer but not in production. In production the database size is 640 or 1064 KB. The real size should be 14000KB. The production computer is a dynamic cloud server. Maybe it