Subject | Re: [firebird-support] FireBird with VB |
---|---|
Author | Jason Dodson |
Post date | 2005-12-09T20:15:25Z |
Bullocks.
ODBC is too generic an interface. Use an OLEDB provider:
http://www.zstyle.dp.ua/files/ibfree5.zip
Using that in VB/ADO is just as fast as using Delphi components.
Jason
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
ODBC is too generic an interface. Use an OLEDB provider:
http://www.zstyle.dp.ua/files/ibfree5.zip
Using that in VB/ADO is just as fast as using Delphi components.
Jason
> ODBC is rather slow - some years ago i did compare for an--
> Delphi-Application accessing MDB files by ODBY and by DAO, using DAO
> was significantly faster.
>
> ADO/OLEDB seems to have poor performance too. But there are
> significant differences in the OLEDB drivers available.
>
> The best performance in combination VB/FB is to write an DLL driver to
> interface the FB-API efficiently. This is much more performant than
> using OLEDB.
>
> Elmar
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.