ADO-VO
in [Visual Objects]
|
Prev: VOCOM for VO 2.8
Next: RP214 not working
From: James Martin on 21 May 2007 15:59 I just started using the ADO-VO2 that came with Visual Objects. Now I will have to decide what to do. I will be connecting to MySQL or PostgreSQL. 1.- What's wrong with the classes that come with VO8 (I've ordered it now) 2.- Will the ADO-VO2 of version 2.7 not work with VO8? 3.- The ADO section of the CAVO site is not too clear. What do I have to pay to get a working copy of ADO-VO2 for VO8? Which of the sections do i come under. I have only what came with VO.
From: E�!k Visser on 21 May 2007 16:29 James, >I just started using the ADO-VO2 that came with Visual Objects. Now I will >have to decide what to do. I will be connecting to MySQL or PostgreSQL. I do not know about PostgrreSQL, but for MySQL is no decent ADO/OLEDB provider available. There was a expensive commercial product that I diud not evaluate, but most people use MySQL with VO using ODBC or use wrappers around the client DLL'. If you google this newsgroup for MySQL I am sure you'll find it. > > 1.- What's wrong with the classes that come with VO8 (I've ordered it now) Not sure what you mean. I am using VO2.8 for several months without major problems. > > 2.- Will the ADO-VO2 of version 2.7 not work with VO8? Nope, you 'll need a 2.8 version of VO2ADO . > 3.- The ADO section of the CAVO site is not too clear. What do I have to > pay to get a working copy of ADO-VO2 for VO8? Which of the sections do i > come under. I have only what came with VO. VO2ADO is a third party product of www.heliks.nl You can order it there. You could also generate your own ActiveX baseclasses. It won't be as efficient as VO2ADO and without the Ado(data)Server class, but it can be done. hth Erik
From: Geoff Schaller on 21 May 2007 18:24 James, > I just started using the ADO-VO2 that came with Visual Objects. Now I will > have to decide what to do. I will be connecting to MySQL or PostgreSQL. If you have a choice, abandon MySQL for PostGre. ....or try the free MS SQL Express (it is superior to them all) In any of these cases, you will need an OLEDB provider. > 1.- What's wrong with the classes that come with VO8 (I've ordered it now) They have been improved but aspects are still flaky and its implementation is limited to ODBC, an old technology. ADO is feature rich and enables you better to write dbms independent code. It will also help you get to ado.net more easily when the need eventually arises. > 2.- Will the ADO-VO2 of version 2.7 not work with VO8? No, because it is compiled for 2.7 - unless you purchase the source code. I advise you to purchase the 2.8 version but get Pro. You should carry the source for ultimate flexibility and code security. > 3.- The ADO section of the CAVO site is not too clear. What do I have to pay > to get a working copy of ADO-VO2 for VO8? Which of the sections do i come > under. I have only what came with VO. Why not contact Robert at www.heliks.nl Geoff
From: Sherlock on 22 May 2007 07:58 James, snip[ If you have a choice, abandon MySQL for PostGre.] You do not NEED an OLEDB providor because with mySQL and PostGRES you can do it natively with a DLL both of these SQL engines provide. One VO 3rd party providor is releasing a mySQL + PostGres or either engine written round the dataserver class.. so the syntax can be as close to DBserver or SQL I believe they are writing the documentation for it and I tested it a few months ago. I understand the source will be made available as well. We have been using VO with the native DLL for years and have been experimenting for Desktop development with PostGres and we have one of Delphi systems running with it now. Phil Mc Guinness
From: James Martin on 22 May 2007 09:06
Thanks to all. Where can I get these SLLs? James "Sherlock" <sherlock(a)sherlock.com.au> wrote in message news:1179835122.079497.114300(a)u36g2000prd.googlegroups.com... > James, > > snip[ If you have a choice, abandon MySQL for PostGre.] > > You do not NEED an OLEDB providor because with mySQL and PostGRES you > can do it natively with a DLL both of these SQL engines provide. One > VO 3rd party providor is releasing a mySQL + PostGres or either engine > written round the dataserver class.. so the syntax can be as close to > DBserver or SQL > I believe they are writing the documentation for it and I tested it a > few months ago. > I understand the source will be made available as well. > > We have been using VO with the native DLL for years and have been > experimenting for Desktop development with PostGres and we have one of > Delphi systems running with it now. > > Phil Mc Guinness > > |