Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1721

Re: Opening data on websites ADS/MySQL; SQL vs Vo2Ado

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


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