Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7486 > unrolled thread
| Started by | Mark <markjotika@gmail.com> |
|---|---|
| First post | 2014-11-24 08:15 -0800 |
| Last post | 2014-12-10 15:54 -0600 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
VO 2.8 and Sql Server Mark <markjotika@gmail.com> - 2014-11-24 08:15 -0800
Re: VO 2.8 and Sql Server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-11-24 23:34 +0100
Re: VO 2.8 and Sql Server "Willie Moore" <williem@wmconsulting.com> - 2014-12-10 15:54 -0600
| From | Mark <markjotika@gmail.com> |
|---|---|
| Date | 2014-11-24 08:15 -0800 |
| Subject | VO 2.8 and Sql Server |
| Message-ID | <c0588f9b-038a-4a1d-bdd5-eb846918e0f3@googlegroups.com> |
I am about to write an application in VO 2.8 which will access an advantage database server and also a SQL server. Does anyone have any ideas as to the best practice for accessing both these different server. We currently use RDD to access the advantage server, can we access SQL in the same way or would ODBC be better as this keeps the 2 server seperate.
[toc] | [next] | [standalone]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-11-24 23:34 +0100 |
| Message-ID | <6ec77a5ndo6fflt48nsit3ksg20rg51pec@4ax.com> |
| In reply to | #7486 |
On Mon, 24 Nov 2014 08:15:12 -0800 (PST), Mark <markjotika@gmail.com> wrote: Hello Mark, >I am about to write an application in VO 2.8 which will access an advantage database server and also a SQL server. >Does anyone have any ideas as to the best practice for accessing both these different server. > We currently use RDD to access the advantage server, can we access SQL in the same way or would ODBC be better as this keeps the 2 server seperate. It's probably a good idea to use SQL for both in your case; also ADS with DBF files can be operated via SQL statements, although you must be aware of syntax differences here and there. You should probably use Vo2Ado for approaching your SQL server; we have some occasional MySQL servers and these work fine with the VO 2.8 standard SQL classes. Dick
[toc] | [prev] | [next] | [standalone]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2014-12-10 15:54 -0600 |
| Message-ID | <m6affe$5o5$2@speranza.aioe.org> |
| In reply to | #7486 |
Mark, I use VO2ADO for my SQL server access. They have a ADOServer that has the same syntax as the DBServer. Robert has excellent support. Regards, Willie Vulcan VIP "Mark" wrote in message news:c0588f9b-038a-4a1d-bdd5-eb846918e0f3@googlegroups.com... I am about to write an application in VO 2.8 which will access an advantage database server and also a SQL server. Does anyone have any ideas as to the best practice for accessing both these different server. We currently use RDD to access the advantage server, can we access SQL in the same way or would ODBC be better as this keeps the 2 server seperate.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web