Thread: [Firebird-net-provider] FB Connection

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi
As earlier told I am a NEWBIE.

I'm still trying to connect to Firebird 1.5 from Visual Studio .Net
(VB.Net).
1) I have manually inserted a reference (in the Solution Explorer) to
Firebird.Data.Firebird
2) Just to test if all is allright I'm using a bit of a code send from
Carlos:

Public myConnectionString As String

Public myConnection As FbConnection

Public myTxn As FbTransaction

Public selectCmd As String

Public mycommand As FbCommand

Public myReader As FbDataReader

Public myXMLfile As String = "data.xml"

Sub Connect()

' Use Pooling=False so that connections are physically dropped immediately
when connection is closed

myConnectionString =
"Database=C:\Data\NY.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=ser
ver;Pooling=False"

myConnection = New FbConnection(myConnectionString)

myConnection.Open()

myTxn = myConnection.BeginTransaction()

End Sub

When compiling I get severel errors starting with:

1) Type 'FbConnection' is not defined

2) Type FbTransaction' is not defined

3) Type 'FbCommand' is not defined

4) Type 'FbDataReader' is not defined

...an so on.

What is the problem? It doesn't seem like I'm using the Firebird Provider at
all?

HELP!!!

Best Regard

Steen

Thread: [Firebird-net-provider] FB Connection

A powerful, cross platform, SQL database system

firebird-net-provider