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


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

Reading Access files

Started byMartin <spam@spam.spam>
First post2011-06-06 09:34 +0100
Last post2011-06-08 15:02 +0100
Articles 15 — 6 participants

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


Contents

  Reading Access files Martin <spam@spam.spam> - 2011-06-06 09:34 +0100
    Re: Reading Access files E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-06 10:48 +0200
    Re: Reading Access files Johan Nel <johan.nel@xsinet.co.za> - 2011-06-06 02:51 -0700
      Re: Reading Access files E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-06 17:24 +0200
        Re: Reading Access files Johan Nel <johan.nel@xsinet.co.za> - 2011-06-07 02:07 -0700
          Re: Reading Access files "Willie Moore" <williem@wmconsulting.com> - 2011-06-07 07:29 -0500
            Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:29 +0000
              Re: Reading Access files "Willie Moore" <williem@wmconsulting.com> - 2011-06-08 08:42 -0500
          Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:31 +0000
    Re: Reading Access files "Willie Moore" <williem@wmconsulting.com> - 2011-06-06 06:56 -0500
    Re: Reading Access files D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-07 22:56 +0200
      Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:21 +0000
        Re: Reading Access files D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-10 11:50 +0200
          Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-10 21:27 +0000
    Re: Reading Access files Martin <spam@spam.spam> - 2011-06-08 15:02 +0100

#1254 — Reading Access files

FromMartin <spam@spam.spam>
Date2011-06-06 09:34 +0100
SubjectReading Access files
Message-ID<qi0Hp.5466$r52.1063@newsfe02.ams2>
Hello

I need to read abd write to an access file, how do I do use them please?

Is there a RDD?

Thanks

Martin

[toc] | [next] | [standalone]


#1255

FromE®!k \\/!$$E® <nospam@nospam.url>
Date2011-06-06 10:48 +0200
Message-ID<953ij1F9glU1@mid.individual.net>
In reply to#1254
MArtin,

You can use ADO or VO2ADO or VO2Jet or the VO2ADO RDD

I would not recommend the last one, but I do use it for reports with RPRO.

Erik



"Martin"  schreef in bericht news:qi0Hp.5466$r52.1063@newsfe02.ams2... 

Hello

I need to read abd write to an access file, how do I do use them please?

Is there a RDD?

Thanks

Martin

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


#1256

FromJohan Nel <johan.nel@xsinet.co.za>
Date2011-06-06 02:51 -0700
Message-ID<f2d7f9b9-8213-4896-a09e-52518d3deeb5@n10g2000vby.googlegroups.com>
In reply to#1254
Martin,

Depending on the complexity of what is required, VO2ADO is the best,
however even the build in SQL classes of VO should suffice (ODBC
connection required though).

Regards,

Johan Nel
Pretoria, South Africa.

On Jun 6, 10:34 am, Martin <s...@spam.spam> wrote:
> Hello
>
> I need to read abd write to an access file, how do I do use them please?
>
> Is there a RDD?
>
> Thanks
>
> Martin

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


#1260

FromE®!k \\/!$$E® <nospam@nospam.url>
Date2011-06-06 17:24 +0200
Message-ID<9549qaFudvU1@mid.individual.net>
In reply to#1256
Johan,

> Depending on the complexity of what is required, VO2ADO is the best,

Better than VO2JET ???

I do agree however  if you say VO2ADO gives more flexibility, as you can use 
the same code for MS SQLServer and others.
(You will need to change the queries however, as the Jet engine has other 
function names for common tasks and the Sql slightly differs.)

Erik



"Johan Nel"  schreef in bericht 
news:f2d7f9b9-8213-4896-a09e-52518d3deeb5@n10g2000vby.googlegroups.com...

Martin,

Depending on the complexity of what is required, VO2ADO is the best,
however even the build in SQL classes of VO should suffice (ODBC
connection required though).

Regards,

Johan Nel
Pretoria, South Africa.

On Jun 6, 10:34 am, Martin <s...@spam.spam> wrote:
> Hello
>
> I need to read abd write to an access file, how do I do use them please?
>
> Is there a RDD?
>
> Thanks
>
> Martin 

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


#1276

FromJohan Nel <johan.nel@xsinet.co.za>
Date2011-06-07 02:07 -0700
Message-ID<7df86595-00d9-4eef-8019-f95796ed8805@g28g2000yqa.googlegroups.com>
In reply to#1260
Erik,

> > Depending on the complexity of what is required, VO2ADO is the best,
>
> Better than VO2JET ???

Sorry if I was not clear.  Depending the complexity of what Martin
wants to do, even a SQLTable, SQLSelect, SQLStatement, SQLConnection
might be enough.  Had a couple of systems that were build around the
VO native SQL* classes that ran quite successfully.

As you stated, VO2ADO has a lot of flexibility.  My response was more
in line of what does Martin believe is the future of the Access
interface?  If long-term, I would rather consider going the .NET route
(if he does not have VO2ADO).  If it is a short-term solution, just go
with the SQL* classes in VO until a permanent long-term solution is
decided upon.

Hope this clear any confusion.

Johan.

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


#1281

From"Willie Moore" <williem@wmconsulting.com>
Date2011-06-07 07:29 -0500
Message-ID<isl5j1$l8l$1@speranza.aioe.org>
In reply to#1276
Johan,

Reading access from dotNet is very easy. If you define your data access in 
dotNet, you can expose that to VO. Once you are fully in dotNet, you just 
reference the class directly instead of using COM. It set mine up as a WCF 
component. That way I can use the same business logic on the PC as well as 
the web.

Regards,
Willie

"Johan Nel"  wrote in message 
news:7df86595-00d9-4eef-8019-f95796ed8805@g28g2000yqa.googlegroups.com...

Erik,

> > Depending on the complexity of what is required, VO2ADO is the best,
>
> Better than VO2JET ???

Sorry if I was not clear.  Depending the complexity of what Martin
wants to do, even a SQLTable, SQLSelect, SQLStatement, SQLConnection
might be enough.  Had a couple of systems that were build around the
VO native SQL* classes that ran quite successfully.

As you stated, VO2ADO has a lot of flexibility.  My response was more
in line of what does Martin believe is the future of the Access
interface?  If long-term, I would rather consider going the .NET route
(if he does not have VO2ADO).  If it is a short-term solution, just go
with the SQL* classes in VO until a permanent long-term solution is
decided upon.

Hope this clear any confusion.

Johan. 

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


#1291

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-06-07 22:29 +0000
Message-ID<4deea631$0$12375$c30e37c6@exi-reader.telstra.net>
In reply to#1281
Willie,

When you say you reference the class "directly", do you mean that you 
build a large library of prototypes to go in the VO app to call into the 
DLL? Seems a little bit of overkill for something very easy natively out 
of VO? There is also a lot of work to get data types across the boundary 
properly, especially if you need arrays from memos etc. But COM also 
solves a lot of access issues and means the target app doesn't need to 
manually generate a prototype library.

> Reading access from dotNet is very easy.

And statements like this will get you into trouble <g>. Yes it is easy 
once you know how, but it is a paradigm shift to get there. There are 
also around 4 key ways to manage data access (table/adapters, entity 
framework, direct sql, webservice...) so which one do you pick and why.

Geoff

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


#1305

From"Willie Moore" <williem@wmconsulting.com>
Date2011-06-08 08:42 -0500
Message-ID<isnu7p$ea9$1@speranza.aioe.org>
In reply to#1291
Geoff,

In VO I have my business classes separate from the GUI. The business classes 
have a VOCOM layer so I can serve them up from a web server. When the VO 
client (not the web client) uses the library, I include it as a library 
instead of a COM and I just call the classes I need. The web pages 
instantiate the COM object and use the exported methods to get to the 
classes. In dotNet I do things in a similar fashion. But instead of using 
VOCOM I create a WCF service that exposes the classes and the methods I 
need. My web site uses the web reference to get to the exposed methods but 
my Vulcan client just uses a reference to that class #USING wmConsulting.SFM 
and access the class / methods directly. I could use WCF on my Vulcan client 
too but I don’t want to add the extra layer in if I don’t have to.

Regards,
Willie

"Geoff Schaller"  wrote in message 
news:4deea631$0$12375$c30e37c6@exi-reader.telstra.net...

Willie,

When you say you reference the class "directly", do you mean that you
build a large library of prototypes to go in the VO app to call into the
DLL? Seems a little bit of overkill for something very easy natively out
of VO? There is also a lot of work to get data types across the boundary
properly, especially if you need arrays from memos etc. But COM also
solves a lot of access issues and means the target app doesn't need to
manually generate a prototype library.

> Reading access from dotNet is very easy.

And statements like this will get you into trouble <g>. Yes it is easy
once you know how, but it is a paradigm shift to get there. There are
also around 4 key ways to manage data access (table/adapters, entity
framework, direct sql, webservice...) so which one do you pick and why.

Geoff

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


#1292

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-06-07 22:31 +0000
Message-ID<4deea6ac$0$12375$c30e37c6@exi-reader.telstra.net>
In reply to#1276
Johan,

You are right on two fronts. Whilst I guess VO2Jet is somehow optimised 
for MS Access, we just use VO2Ado for the limited needs we have. Our SQL 
syntax just needs to obey the rules for access. And in C# we just use 
our regular data adapters and tables to get to MS Access.

Geoff




"Johan Nel" <johan.nel@xsinet.co.za> wrote in message 
news:7df86595-00d9-4eef-8019-f95796ed8805@g28g2000yqa.googlegroups.com:

> Erik,
>
>
> > > Depending on the complexity of what is required, VO2ADO is the best,
> >
>
> > Better than VO2JET ???
>
>
> Sorry if I was not clear.  Depending the complexity of what Martin
> wants to do, even a SQLTable, SQLSelect, SQLStatement, SQLConnection
> might be enough.  Had a couple of systems that were build around the
> VO native SQL* classes that ran quite successfully.
>
> As you stated, VO2ADO has a lot of flexibility.  My response was more
> in line of what does Martin believe is the future of the Access
> interface?  If long-term, I would rather consider going the .NET route
> (if he does not have VO2ADO).  If it is a short-term solution, just go
> with the SQL* classes in VO until a permanent long-term solution is
> decided upon.
>
> Hope this clear any confusion.
>
> Johan.

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


#1257

From"Willie Moore" <williem@wmconsulting.com>
Date2011-06-06 06:56 -0500
Message-ID<isif9s$vjd$1@speranza.aioe.org>
In reply to#1254
Martin,

I use VO2ADO.

Regards,
Willie

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


#1285

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-06-07 22:56 +0200
Message-ID<lf3tu69abisgai3b17nua7e1ocruv4b6m6@4ax.com>
In reply to#1254
On Mon, 06 Jun 2011 09:34:27 +0100, Martin <spam@spam.spam> wrote:

Hello Martin.
>
>I need to read abd write to an access file, how do I do use them please?
>
The simplest way in VO (without the need to buy Vo2ADo) is to create
an ODBC connection with this database using Windows. Then go to the
DBServer editor and select New entity, SQL Editor. 

Unfortunately it's been a few years ago so I am not sure anymore about
the exact order/steps but in the end you will have a database which
you can instantiate an approach exactly like you do with a DBF file.

Dick

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


#1290

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-06-07 22:21 +0000
Message-ID<4deea46a$0$12376$c30e37c6@exi-reader.telstra.net>
In reply to#1285
Dick,

Sorry, wrong advice. The VO SQL classes will generate more in lost time 
and hair pulling than the purchase price of VO2Ado (which is actually 
very low). I'm not here to drum up business for Robert but this really 
is the best way to go.The VO SQL classes will just give you endless 
grief.

Geoff



"D.J.W. van Kooten" <public@ic2remove.this.com> wrote in message 
news:lf3tu69abisgai3b17nua7e1ocruv4b6m6@4ax.com:

> On Mon, 06 Jun 2011 09:34:27 +0100, Martin <spam@spam.spam> wrote:
>
> Hello Martin.
>
> >
> >I need to read abd write to an access file, how do I do use them please?
> >
>
> The simplest way in VO (without the need to buy Vo2ADo) is to create
> an ODBC connection with this database using Windows. Then go to the
> DBServer editor and select New entity, SQL Editor.
>
> Unfortunately it's been a few years ago so I am not sure anymore about
> the exact order/steps but in the end you will have a database which
> you can instantiate an approach exactly like you do with a DBF file.
>
> Dick

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


#1346

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2011-06-10 11:50 +0200
Message-ID<tvp3v61qm4c09ttlq4gv4okhiiaab69hf4@4ax.com>
In reply to#1290
On Tue, 7 Jun 2011 22:21:29 +0000, "Geoff Schaller"
<geoffx@softwarexobjectives.com.au> wrote:

Hello Geoff,
>
>Sorry, wrong advice. The VO SQL classes will generate more in lost time 
>and hair pulling than the purchase price of VO2Ado (which is actually 
>very low). I'm not here to drum up business for Robert but this really 
>is the best way to go.The VO SQL classes will just give you endless 
>grief.
>
I agree with you (surprise, surprise...<g>) but having said that, once
an ODBC connection was set up to the Access database (in Windows,
which was the hardest part) I found (years ago) that having access to
Access (I used it read only) was working without problems.

Depending on the goal (full blown data processing or just able to read
some data besides your own dbf data) it could be a quick solution
without the need to install anything.

Dick

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


#1350

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-06-10 21:27 +0000
Message-ID<4df28c50$0$12373$c30e37c6@exi-reader.telstra.net>
In reply to#1346
..and that is the secret.

If you have a quick solution to a simple need than I would always 
advocate using it. The problem with the VO sql classes and odbc is that 
if you start to need more, you will get into trouble <g>.

Guaranteed.

Geoff



"D.J.W. van Kooten" <public@ic2remove.this.com> wrote in message 
news:tvp3v61qm4c09ttlq4gv4okhiiaab69hf4@4ax.com:

> On Tue, 7 Jun 2011 22:21:29 +0000, "Geoff Schaller"
> <geoffx@softwarexobjectives.com.au> wrote:
>
> Hello Geoff,
>
> >
> >Sorry, wrong advice. The VO SQL classes will generate more in lost time
> >and hair pulling than the purchase price of VO2Ado (which is actually
> >very low). I'm not here to drum up business for Robert but this really
> >is the best way to go.The VO SQL classes will just give you endless
> >grief.
> >
>
> I agree with you (surprise, surprise...<g>) but having said that, once
> an ODBC connection was set up to the Access database (in Windows,
> which was the hardest part) I found (years ago) that having access to
> Access (I used it read only) was working without problems.
>
> Depending on the goal (full blown data processing or just able to read
> some data besides your own dbf data) it could be a quick solution
> without the need to install anything.
>
> Dick

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


#1307

FromMartin <spam@spam.spam>
Date2011-06-08 15:02 +0100
Message-ID<zhLHp.9373$w86.5757@newsfe22.ams2>
In reply to#1254
Thanks for all the replies

The Access files will be accessed by our current software as we will 
need to update values of things used.

Not a lot of access, just very occasionally.

ODBC access if easy enough should be fine.

Any simple worked examples?

Thanks

Martin

[toc] | [prev] | [standalone]


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


csiph-web