Subject | Problem connecting my VB6 App to Firebird. |
---|---|
Author | Paddy Flanagan |
Post date | 2010-06-29T19:42:47Z |
I am trying to connect an existing VB application that connected to an
Oracle 10G database to a Firebird database.
I have created an ODBC connection on my PC and can successfully connect to
the database tables from Microsoft Excel, so I am reasonably happy that the
odbc connection is working.
In my VB6 app, I am using the following connection string
GConnection.ConnectionString = _
"DRIVER=Firebird/InterBase(r)
driver;UID=SYSDBA;PWD=masterkey;DBNAME=localhost:c:\IFOLDER\FIREBIRD\TIME.FDB"
GConnection.Open
I get an error message telling me "Error 3706 Provider cannot be found, it
may not be properly installed"
Can some one please help me here.
Paddy Flanagan
[Non-text portions of this message have been removed]
Oracle 10G database to a Firebird database.
I have created an ODBC connection on my PC and can successfully connect to
the database tables from Microsoft Excel, so I am reasonably happy that the
odbc connection is working.
In my VB6 app, I am using the following connection string
GConnection.ConnectionString = _
"DRIVER=Firebird/InterBase(r)
driver;UID=SYSDBA;PWD=masterkey;DBNAME=localhost:c:\IFOLDER\FIREBIRD\TIME.FDB"
GConnection.Open
I get an error message telling me "Error 3706 Provider cannot be found, it
may not be properly installed"
Can some one please help me here.
Paddy Flanagan
[Non-text portions of this message have been removed]