Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1718 > unrolled thread
| Started by | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| First post | 2011-07-20 23:55 +0200 |
| Last post | 2011-07-21 10:44 +0200 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-07-20 23:55 +0200 |
| Subject | Opening 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]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2011-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]
| From | E®!k \\/!$$E® <nospam@nospam.url> |
|---|---|
| Date | 2011-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