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


Groups > comp.lang.clipper.visual-objects > #1718 > unrolled thread

Opening data on websites ADS/MySQL; SQL vs Vo2Ado

Started byD.J.W. van Kooten <public@ic2remove.this.com>
First post2011-07-20 23:55 +0200
Last post2011-07-21 10:44 +0200
Articles 3 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#1718 — Opening data on websites ADS/MySQL; SQL vs Vo2Ado

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-07-20 23:55 +0200
SubjectOpening data on websites ADS/MySQL; SQL vs Vo2Ado
Message-ID<b1je27hol46petc0k61c5938h1ferfveq3@4ax.com>
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

[toc] | [next] | [standalone]


#1719

FromJohan Nel <johan.nel@xsinet.co.za>
Date2011-07-20 23:49 -0700
Message-ID<92e7b8fb-fc99-4cff-b064-3a1b440c231e@10g2000yqn.googlegroups.com>
In reply to#1718
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

[toc] | [prev] | [next] | [standalone]


#1721

FromE®!k \\/!$$E® <nospam@nospam.url>
Date2011-07-21 10:44 +0200
Message-ID<98q779Fp8U1@mid.individual.net>
In reply to#1719
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 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web