Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1721
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | E®!k \\/!$$E® <nospam@nospam.url> |
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Opening data on websites ADS/MySQL; SQL vs Vo2Ado |
| Date | Thu, 21 Jul 2011 10:44:24 +0200 |
| Lines | 80 |
| Message-ID | <98q779Fp8U1@mid.individual.net> (permalink) |
| References | <b1je27hol46petc0k61c5938h1ferfveq3@4ax.com> <92e7b8fb-fc99-4cff-b064-3a1b440c231e@10g2000yqn.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; format=flowed; charset="iso-8859-1"; reply-type=original |
| Content-Transfer-Encoding | 7bit |
| X-Trace | individual.net eCzcqGt+IYhCOrmGrchk6wzhP542fgZvOxWZX5mYluId6C/7Gy |
| Cancel-Lock | sha1:Sviz51l66Lao2UrbgzzFc7daFiA= |
| In-Reply-To | <92e7b8fb-fc99-4cff-b064-3a1b440c231e@10g2000yqn.googlegroups.com> |
| X-Priority | 3 |
| X-MSMail-Priority | Normal |
| Importance | Normal |
| X-Newsreader | Microsoft Windows Live Mail 15.4.3508.1109 |
| X-MimeOLE | Produced By Microsoft MimeOLE V15.4.3508.1109 |
| Xref | x330-a1.tempe.blueboxinc.net comp.lang.clipper.visual-objects:1721 |
Show key headers only | View raw
For MsSql access it is very simple. There is no OleDb driver (at least not a free one) available so you need to use ODBC. In the situation where you can choose between OleDB (old) ODBC (from the stoneage) I would prefer to use the youngest and fastest of the both. In that case VO2ADO is an good option, but you can also generate your own OLE classes of OleDB, like you can do with Word and Excel. If there is no choice (ODBC only), using OleDB would implicate an extra layer: the ODBC-OleDB driver over ODBC. This will give some performance loss. It this case the VO Sql classes would be an option. There is some sentiment about the poor quality of the VO-Sqlclasses, but this is based upon pre VO2.8SP1 versions. Erik "Johan Nel" schreef in bericht news:92e7b8fb-fc99-4cff-b064-3a1b440c231e@10g2000yqn.googlegroups.com... Dick, Same conclusion here. Yes I also got the get yourself VO2ADO message, however I have also found that the Sql* classes of VO was more than what was needed for standard CRUD functionality, alas via ODBC and not through OLEDB. Some of the issues that I did encounter, but there were workarounds: 1. DateTime columns - Rather wrote a wrapper inside my Apps to save as string column and parse inside the application. 2. Single precision float columns in Access - There was an issue and I had to change column format to Double for floating values. 3. Memo style columns - Think this was fixed in one of the later releases, but I again wrote a wrapper that will rather use a string field that I would parse myself to concat and split when writing back inside a TRIGGER on the database. So in conclusion: I do believe that VO2ADO give a lot more functionality and is a great product, but with careful planning the Sql classes of VO can do the job. As my motto is, if Vx.a is doing the job why need Vx+y.a+b, except if the new version have major impact on enhancing my productivity. My 2c worth of use[less|full] info. Johan Nel Pretoria, South Africa. On Jul 20, 11:55 pm, D.J.W. van Kooten <pub...@ic2remove.this.com> wrote: > After a few earlier postings I've succeeded in 2 things, so a quick > report for anyone who's interested followed by a more general > question: > > First, I managed to use Advantage databases stored on a Linux > webserver (adt or dbf via a .add file on the remote server with ADS > installed there too). Anyone who is about to start this can contact me > ass I have code and descriptions of the whole process, which will save > you a lot of time I think. > > However, the client's programmer did find ADS lots faster in several > respects but some actions (maybe due to the combination of MySQL and > ADS on the same Linux server?) considerably slower; like making the > connection. I am not sure where the problem was but he wanted me to > connect to MySQL which worked surprisingly well. I installed a MySQL > driver from Oracle, set up ODBC to the database using the IP address > of the server and found the basic code I need to read data in one of > the databases and write back some results in another in the VO SQL > classes. It all basically seems to work with a few lines of VO code. > > What I wondered was: any question about the VO SQL classes is replied > with "Get yourself Vo2Ado instead". No doubt Robert has done good work > and it's not costing a fortune either, but what exactly is the > advantage of Vo2Ado? If I can connect to the SQL database, retrieve > and write back data by issuing SQL strings or even plain VO code like > fieldput and gotop, where would I need Vo2Ado for? > > Dick
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread
Opening data on websites ADS/MySQL; SQL vs Vo2Ado D.J.W. van Kooten <public@ic2remove.this.com> - 2011-07-20 23:55 +0200
Re: Opening data on websites ADS/MySQL; SQL vs Vo2Ado Johan Nel <johan.nel@xsinet.co.za> - 2011-07-20 23:49 -0700
Re: Opening data on websites ADS/MySQL; SQL vs Vo2Ado E®!k \\/!$$E® <nospam@nospam.url> - 2011-07-21 10:44 +0200
csiph-web