Apologies, In generating the sample script, I noticed a reference to an
Oracle driver and when I removed that, it connected.

Thanks you

On Tue, Jun 29, 2010 at 12:49 PM, Paddy Flanagan <pjmflan@...> wrote:

>
> 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
>



--
Paddy Flanagan
"Ashfield", Newtown,
Kildare Town.
T: 045 530355 (evenings)
M: 086 2237045
F: 045 439113
email: pjmflan@...


[Non-text portions of this message have been removed]