Discussion:
OLE DB driver with Interbase
(too old to reply)
RB Smissaert
2007-09-24 16:53:43 UTC
Permalink
Trying to connect to Interbase (5.6) in VB with the free OLE DB driver
IbOleDb.dll, which
can be downloaded from:
http://iboledb.sourceforge.net/
I have put the dll in Windows\System32\
Tried to do a regsrvr32 but it doesn't do that.

Tried to connect with this connection string (and lot of
variations, such as local IP address and computer name for the location),
but sofar no success:

ADOConn.Open "Provider=IbOleDb;Location=localhost;" & _
"Data Source=C:\Torex\Synergy\Meddata\S6000\db\S6.gdb", _
"xxx", _
"zzz"

Keep getting error 3706, Provider cannot be found. It may not be installed
properly.

Any suggestions how to connect with this?


RBS
Stephen Howe
2007-09-24 17:49:11 UTC
Permalink
Post by RB Smissaert
Any suggestions how to connect with this?
The web page has a "Contact Us" so i suggest emailing them.
And until you can regsvr32 the DLL (and it may be more than that is
necessary for a OLEDB provider) then I dont think you will get anywhere.

Checking the DLL reveals that
(i) the necessary DllRegisterServer(), DllUnregisterServer() are
present.
(ii) It relies on FBCLIENT.DLL, which is not on my system. That is
FireBird.
So you might have to install FireBird ODBC first. Go to
http://www.firebirdsql.org/

Cheers

Stephen Howe
RB Smissaert
2007-09-24 17:52:45 UTC
Permalink
Post by Stephen Howe
It relies on FBCLIENT.DLL, which is not on my system.
That is FireBird.
Thanks, that might be it then.

RBS
Post by Stephen Howe
Post by RB Smissaert
Any suggestions how to connect with this?
The web page has a "Contact Us" so i suggest emailing them.
And until you can regsvr32 the DLL (and it may be more than that is
necessary for a OLEDB provider) then I dont think you will get anywhere.
Checking the DLL reveals that
(i) the necessary DllRegisterServer(), DllUnregisterServer() are
present.
(ii) It relies on FBCLIENT.DLL, which is not on my system. That is
FireBird.
So you might have to install FireBird ODBC first. Go to
http://www.firebirdsql.org/
Cheers
Stephen Howe
RB Smissaert
2007-09-24 18:01:01 UTC
Permalink
Have installed the FB ODBC driver without any problem and did a regsvr32 on
that,
but still I can't do a regsvr32 with the file IbOleDb.dll
Maybe this is not for IB 5.6.
Will e-mail them.

RBS
Post by Stephen Howe
Post by RB Smissaert
Any suggestions how to connect with this?
The web page has a "Contact Us" so i suggest emailing them.
And until you can regsvr32 the DLL (and it may be more than that is
necessary for a OLEDB provider) then I dont think you will get anywhere.
Checking the DLL reveals that
(i) the necessary DllRegisterServer(), DllUnregisterServer() are
present.
(ii) It relies on FBCLIENT.DLL, which is not on my system. That is
FireBird.
So you might have to install FireBird ODBC first. Go to
http://www.firebirdsql.org/
Cheers
Stephen Howe
Stephen Howe
2007-09-24 18:09:33 UTC
Permalink
Post by RB Smissaert
Will e-mail them.
Point out their documentation is way insufficient.
At the very least, it should outline what is necessary to install and get
this working.

Cheers

Stephen Howe
Stephen Howe
2007-09-24 18:18:07 UTC
Permalink
Post by RB Smissaert
Have installed the FB ODBC driver without any problem and did a regsvr32
on that...
Did it install FBClient.DLL ? Where did it put it?
Post by RB Smissaert
but still I can't do a regsvr32 with the file IbOleDb.dll
It may be that FBClient.DLL is crucial to register it

Stephen Howe
RB Smissaert
2007-09-24 18:43:15 UTC
Permalink
The trouble is that all these additional files will then have to go into my
installer
and not sure now that will be worth it.
Did you find any improved performance (mainly SELECTS) with OLE DB drivers
as compared to ODBC?
I am currently connecting with the ODBC driver from Intersolve and that
seems
quite good, but can't compare to anything.
Had a little explore into accessing the Interbase API directly from VB, but
that is
probably (most likely) unrealistic.

RBS
Post by Stephen Howe
Post by RB Smissaert
Have installed the FB ODBC driver without any problem and did a regsvr32
on that...
Did it install FBClient.DLL ? Where did it put it?
Post by RB Smissaert
but still I can't do a regsvr32 with the file IbOleDb.dll
It may be that FBClient.DLL is crucial to register it
Stephen Howe
Stephen Howe
2007-09-24 18:58:27 UTC
Permalink
Post by RB Smissaert
Did you find any improved performance (mainly SELECTS) with OLE DB drivers
as compared to ODBC?
No, I have never made that comparison.
I suspect to be fair, I would have write in pure OLE DB as ADO comes with
its own baggage which I dont believe is huge but nevertheless does
contribute.
I have seen an OLE DB template library and that seem attractive to program
in.
I would also have to make sure that OLE DB was native anmd not piggybacking
on top of ODBC drivers.

Stephen Howe
RB Smissaert
2007-09-24 19:34:46 UTC
Permalink
OK, thanks.
As there are so few clear statements on the net about this whole issue
(ODBC versus OLE DB) there probably isn't much in it and I think I will give
this a rest.

RBS
Post by Stephen Howe
Post by RB Smissaert
Did you find any improved performance (mainly SELECTS) with OLE DB drivers
as compared to ODBC?
No, I have never made that comparison.
I suspect to be fair, I would have write in pure OLE DB as ADO comes with
its own baggage which I dont believe is huge but nevertheless does
contribute.
I have seen an OLE DB template library and that seem attractive to program
in.
I would also have to make sure that OLE DB was native anmd not
piggybacking on top of ODBC drivers.
Stephen Howe
Loading...