Please..help, error in open connection

hi all,

i've just installed firebird 1.53 and was trying to use it in my vb.net application. i've downloaded and installed FirebirdNetProvider 1.71

however i cannot connect to the database, when i try to open the connection, an exception was thrown:

No message for error code 335544344 found.
No message for error code 335544734 found.

it failed with or without connectionstringbuilder.

Dim fcb As New FbConnectionStringBuilder
fcb.DataSource = "localhost"
fcb.Database = "sample.fdb"
fcb.UserID = "SYSDBA"
fcb.Password = "masterkey"
'fcb.Pooling = False
cn.ConnectionString = fcb.ToString

Try
cn.Open()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

how to fix this problem?

Thanks.

Wei Fuk

Mhhh, sorry, the only help I can give you is the list of firebird error codes (pdf).

And this result from Google (same problem as you)

i found the solution: finally..

Dim fcb As New FbConnectionStringBuilder
fcb.DataSource = "localhost"
fcb.Database = "localhost:sample.fdb"
fcb.UserID = "SYSDBA"
fcb.Password = "masterkey"
'fcb.Pooling = False
cn.ConnectionString = fcb.ToString

and note that if the connectionstring is written in one line, the text "User ID" must be type with space, a "UserID" won't work.

dim str as string = "DataSource=localhost;Database = localhost:\sample.gdb;User ID=SYSDBA;Password=masterkey;Dialect=3"

cn.connectionstring = str