Conexion Visual Basic a Firebird

01 CREATE TABLE persona(
02 	id varchar(4) primary key,
03 	nombre varchar(60)
04 );

01 Imports FirebirdSql.Data.FirebirdClient
02 
03 Public Class dbconexion
04 
05     Dim Conexion As New FbConnection
06     Dim fb_string As FbConnectionStringBuilder = New FbConnectionStringBuilder
07 
08     Public Sub conectar()
09         ' Se forma la cadena de conexion
10         fb_string.ServerType = FbServerType.Default
11         fb_string.UserID = "sysdba"
12         fb_string.Password = "masterkey"
13         fb_string.Dialect = 3
14         fb_string.Database = "e:\firebird_db\test.fdb"
15         fb_string.Pooling = False
16         ' se realiza la conexion
17         Try
18             Conexion.ConnectionString = fb_string.ToString
19             Conexion.Open()
20 
21             If Conexion.State = ConnectionState.Open Then
22                 Console.WriteLine("Conexión a [" & fb_string.Database & "] establecida")
23             End If
24 
25         Catch err As FbException
26             Console.WriteLine("Error: No se pudo realizar la conexión a [" & fb_string.Database & "]")
27             Console.WriteLine(err.Message)
28         End Try
29 
30     End Sub
31 
32     Public Sub Desconectar()
33         If (ConnectionState.Open) Then
34             Conexion.Close()
35             Console.WriteLine("Conexión a [" & fb_string.Database & "] cerrada")
36         End If
37     End Sub
38 
39     Public Sub Consulta()
40         Dim sql As String = "SELECT * FROM persona"
41         Dim cmd As New FbCommand(sql, Conexion)
42         Dim fbdatareader As FbDataReader = cmd.ExecuteReader
43 
44         While (fbdatareader.Read)
45             Dim id As String = fbdatareader.GetString(0)
46             Dim nombre As String = fbdatareader.GetString(1)
47             Console.WriteLine("" & id & " | " & nombre)
48         End While
49 
50     End Sub
51 End Class

01 Module Module1
02 
03     Sub Main()
04 
05         Dim dbc As New dbconexion
06         dbc.conectar()
07         dbc.Consulta()
08         Console.WriteLine("Presione una tecla para terminar")
09         Console.ReadKey()
10         dbc.Desconectar()
11 
12     End Sub
13 
14 End Module

Conexión a [e:\firebird_db\test.fdb] establecida
6655  |  Charly Manson
9876  |  Marilin Garcia
7621  |  Enanitos Rojos
Presione una tecla para terminar