Writing my own OLEDB provider in Delphi

I'm in charge of maintaining an OLEDB provider written in Delphi 5, that uses the OPTK 101 development kit, which dates circa 2002.

The current code has give us headaches for years. Either it was purely implemented, or the development kit does not provide so much base to grow. I can't tell since this is a project among many others I have with this contractor.

Now, the boss want me to move all that development to Delphi XE.

I'm sort of want to start from scratch, i.e. not use that OPTK library, unless I can find an update, or replace with a very good one.

I'm asking for places to start reading, and learning about OLEDB providers.

I'd really appreciate any guidelines.

LVL 1
fischermxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
devart has really good components

you can purchase them with source code ... saves a lot of work in typing everything yourself :)

www.devart.com
0
jimyXCommented:
If you want something a little bit more updated than OPTK, then you might consider OLEDB Direct, which is as old as 2006:
http://www.oledbdirect.com/download.php
http://www.oledbdirect.com/tutorial/index.php

New stuff, you may have a look at:
http://www.ibprovider.com/eng/
http://www.da-soft.com/
0
Ephraim WangoyaCommented:

If you are using a well known database then there is really no need for you to write your own providers.
Just purchase a commercial one for your particular database, they don cost much

If you are using a propriety format, then Definitely you have to write your own provider but the question I would have is, if its already your format and so you know how to access the data, why would you need to write a provider?

Here are some resources
http://msdn.microsoft.com/en-us/library/ms715920(v=vs.85).aspx
http://msdn.microsoft.com/en-us/library/ms718014(v=vs.85).aspx
http://www.codeproject.com/KB/database/oledb_example.aspx

Another option is to contact Binh Ly and see if there is a possibility of updating the Development Toolkit.
binh.ly@hibalo.com
I'm not sure if that works any more
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Ephraim WangoyaCommented:
0
fischermxAuthor Commented:
Geert Gruez: Devart sells products like the one I'm maintaining.

Jimyx: That's another commercial product.

Ewangoya: Yes, this is a commercial proprietary format that we sell.
I already had the microsoft documentation.
The 3rd link is very good, I'm reading it.
The 4th link is a good kick off point.
Thanks!




0
fischermxAuthor Commented:
Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.