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


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

VO 2.8 and Sql Server

Started byMark <markjotika@gmail.com>
First post2014-11-24 08:15 -0800
Last post2014-12-10 15:54 -0600
Articles 3 — 3 participants

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


Contents

  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

#7486 — VO 2.8 and Sql Server

FromMark <markjotika@gmail.com>
Date2014-11-24 08:15 -0800
SubjectVO 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]


#7493

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-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]


#7610

From"Willie Moore" <williem@wmconsulting.com>
Date2014-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