Hi thanks for the assistance. Herewith as much details as possible:

Laptop

Running Visual Studio 2008 where app is being developed
Running FB client 2.5.0 Alpha 2
OS: Win XP Prof.
Firewall: ZoneAlarm

Desktop

IP address: 10.0.0.51
Running FB server 2.0.4
Security2.fdb located in c:\Program Files\Firebird\Firebird_2_0
Application database “MyDatabase” located at e:\
OS: Win XP Prof.
Firewall: ZoneAlarm


Connection string being used (Being run from Laptop):

Friend myCellCollection As New Collection
Friend myConnection As New FbConnection
Friend myDataAdapter() As FbDataAdapter
Friend myDataSet As New DataSet
Friend myWorkRow As DataRow

Friend ServerType As FbServerType = FbServerType.Default
Friend UserID As String = "sysdba"
Friend Password As String = "masterkey"

Friend DataSource As String = "10.0.0.51"
Friend Database As String = "10.0.0.51:e:\\MyDatabase.fdb"

Public Function OpenSQLConnection() As Boolean

Try
If myConnection.State = ConnectionState.Closed Then
Dim cs As New FbConnectionStringBuilder()

If Not ServerType = FbServerType.Embedded Then
cs.Password = Password
cs.UserID = UserID
cs.Port = 3050
End If

cs.Pooling = False
cs.DataSource = DataSource
cs.Database = Database
cs.Charset = "UNICODE_FSS"
cs.ConnectionLifeTime = 30
cs.ServerType = ServerType

myDataSet.Locale = CultureInfo.InvariantCulture
myConnection.ConnectionString = cs.ToString

If cs IsNot Nothing Then cs = Nothing
myConnection.Open()
myDataSet.Reset()
End If
Return True
Catch ex As Exception
MessageBox.Show("An error has occured!" & vbCrLf & vbCrLf & _
ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
End
Return False
End Try

End Function

When using the code as above the connection is made and I’m able to extract data from the database as required. As mentioned, I make use of SQL Manager Lite 2008 to work with the database. I have used this to add more users to the database. The new users were given the same grants etc.. as that displayed in SQL manager for sysdba.

When I change the variables for the user and password in the code above I get the error 335544528 (I only got the 335544721 error once and never again).

This afternoon I went into SQL Manager and made a backup of the database. Afterwards I tried the different connections again (different user names) and both worked without any errors. Yesterdays problems seems to be something of the past now. I am however worried as | do not know what caused it in the first place.

I have tried the command line you have given me gsec –display…etc to display the users but I get the following error: “no parameters allowed for this operation”.

I hope that the above can shed some more light on the problem I’ve had. As said it is now sorted but I would like to know why this happened. Also, if possible could you tell me whether there is a document with all the commands to use on the command line ?

Thanks for your help.

Cheers