Re: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers

[Michael M. <m.m...@mb...>]

Hi Alfredo,

 

this way:

Dim conFirebird as string

 

conFirebird = "DRIVER={Firebird/InterBase(r) driver};" & _

                                   "Uid=SYSDBA; " & _

    "Pwd=YOURPASSWORD; " & _

    "DIALECT=3;" & _

 
"DbName=IPorHOSTNAMEofYOURserver:C:\pathToYourDB\DBNAME.fdb"

 

Dim conDB as new ADODB.Connection

 

conDB.CursorLocation = adUseClient

conDB.Open conFirebird

DIALECT depends on your Database, newer ones should have DIALECT=3 older
ones coming from Interbase maybe have DIALECT=1

 

Br

Michael

 

From: Ing. Alfredo Jimenez [mailto:sa...@gm...] 
Sent: Friday, October 01, 2010 5:09 PM
To: fir...@li...
Subject: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers

 

Hi I need help
Use Visual Basic and I need to create a connection via ODBC to a firebird
database 2.1,
as I can do it?