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


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

Re: Windows 7 corruption network

Started byJean-Luc Stassen <igsoftsprl.be@gmail.com>
First post2012-10-15 09:53 -0700
Last post2014-09-05 17:51 +0000
Articles 17 — 7 participants

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

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

  Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-10-15 09:53 -0700
    Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-15 17:01 +0000
      Re: Windows 7 corruption network igsofterror@gmail.com - 2012-10-16 23:38 -0700
        Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-17 07:30 +0000
          Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-07 07:20 -0800
            Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-09 15:59 +0000
              Re: Windows 7 corruption network "Ginny Caughey" <gcaughey@online.hotmail.com> - 2012-12-10 07:05 -0500
                Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-10 14:56 +0000
                  Re: Windows 7 corruption network "Ginny Caughey" <gcaughey@online.hotmail.com> - 2012-12-11 07:01 -0500
                    Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-11 15:51 +0000
                      Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-17 06:22 -0800
                        Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-17 14:01 -0800
                        Re: Windows 7 corruption network "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-12-18 07:12 +0000
                    Re: Windows 7 corruption network Jean-Luc Stassen <igsoftsprl.be@gmail.com> - 2012-12-17 06:27 -0800
        Re: Windows 7 corruption network "Rene J. Pajaron" <rjpajaron@gmail.com> - 2012-12-18 03:41 -0800
          Re: Windows 7 corruption network Jean-Luc Stassen <jls@igsoft.be> - 2013-02-02 07:23 -0800
    Win XP Pro vs Win 7 Pro "Jose F Zouain" <jfzouain@zetaconcepts.com> - 2014-09-05 17:51 +0000

#4291 — Re: Windows 7 corruption network

FromJean-Luc Stassen <igsoftsprl.be@gmail.com>
Date2012-10-15 09:53 -0700
SubjectRe: Windows 7 corruption network
Message-ID<cc364fd2-2bfe-4b77-b21c-63597f10b194@googlegroups.com>
Hello Geoff,

I only see this reply two years later... <g>

I agree with you, the code is not really a problem... we can work on it to make it working with SQL.

Altrought, how can I in the same code manage DBF or SQL ?
If it's possible, I will be instersting with this mechanism.

My actual difficulties are:
- convert all the personalised reports (reportpro 2.16) of each customers (+/- 500)
- install and configure Mysql or something else on the server of my customers

These two points cannot automatically done via standard software update. I need to go to the customer or connect his network with teamviwer to configure anything...

If you show me the basics to use the same code for dbf or sql, it will be very kind...

Jean-Luc



Le lundi 3 janvier 2011 00:10:22 UTC+1, Geoff Schaller a écrit :
> J-L,
> 
> Everyone claims their app is big <g>. I genuinely suspect yours is about 
> the same size as most other people's. However the point about class 
> libraries like mine is that you can convert to SQL without rewriting 
> your code base.
> 
> Let me take the average VO application:
> 
> * say around 250,000 lines of generated and written code
> * say around 20 main lookup browsers
> * say around 120 edit windows and dialogs (forget popups)
> * perhaps 80-120 reports
> * around 50-60 business processes (no GUI)
> 
> I can have your first cut in SQL in 2-3 weeks, sometime half that, 
> depends on the quality of your original VO code. Data conversion to SQL 
> included. And the code will run alternately DBF and SQL to prove 
> business logic is the same. Very little code manipulation save for the 
> replacement of SetSelectiveRelation with joins and SetRelation with 
> dynamic scopes.
> 
> The refinements then take a while. Perhaps 2-3 hrs per report (to 
> convert to reporting services) and 1-2 hours per browser/process. But 
> let's make it clear. Your DBF style code remains the same until such 
> time as you want to take advantage of SQL-only functionality and 
> performance benefits. Your app will run faster and be many times more 
> stable.
> 
> Of course there is effort and I would probably allocate a 6 month time 
> frame to do it carefully but at least the process can be undertaken 
> along side your existing maintenance program. The user won't know until 
> the day you cut over.
> 
> Cheers,
> 
> Geoff
> 
> 
> 
> "Jean-Luc Stassen" <jls@igsoft.be> wrote in message 
> news:5831fa1f-bd70-4909-b167-121be4991e00@v12g2000vbx.googlegroups.com:
> 
> > Geoff,
> >
> > The reason is that my app is very very big and it is not possible to
> > change it right now...
> > For sure, I want in the future go to SQL, but I have to rewrite
> > everything and... I don't have time (month !) to do that now...
> >
> > Thank you everyone for your support and help !
> >
> > Jean-Luc

[toc] | [next] | [standalone]


#4293

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-10-15 17:01 +0000
Message-ID<ae2tqkFj7fuU1@mid.individual.net>
In reply to#4291
Hi Jean-Luc, 

PMFJI,

I had a similar problem and I solved it by using ADS. ADS can be used
like a DBF, for SQL do work properly you need a complete redesign of
the application.

Wolfgang

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


#4299

Fromigsofterror@gmail.com
Date2012-10-16 23:38 -0700
Message-ID<31b0f031-3ba3-4911-a73a-c33dffa88717@googlegroups.com>
In reply to#4293
Hello Wolfgang,

By "ADS" do you mean Advantage Database Server ? Ok, I tried that some years ago (with the driver AXDBFCDX that I was loading in the start function) but I never really make it working... on the server, ADS didn't use my dbf...

I think, make the code good for the 2 database is maybe the best solution...

Jean-Luc



Le lundi 15 octobre 2012 19:01:10 UTC+2, Wolfgang Riedmann a écrit :
> Hi Jean-Luc, 
> 
> 
> 
> PMFJI,
> 
> 
> 
> I had a similar problem and I solved it by using ADS. ADS can be used
> 
> like a DBF, for SQL do work properly you need a complete redesign of
> 
> the application.
> 
> 
> 
> Wolfgang

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


#4301

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-10-17 07:30 +0000
Message-ID<ae754cFiiojU1@mid.individual.net>
In reply to#4299
Hi Jean-Luc,

> By "ADS" do you mean Advantage Database Server ? Ok, I tried that
> some years ago (with the driver AXDBFCDX that I was loading in the
> start function) but I never really make it working... on the server,
> ADS didn't use my dbf...


yes, I mean Advantage Database Server.

It is not 100% compatible to DBFs (you cannot use own function in index
expressions, filter expressions cannot used functions from your
program, ANSI needs to be set to false), but it took a day or so to
adapt my software to ADS.
It is very fast and absolutely stable, and does not takes too much
resources on the server.

Wolfgang

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


#4439

FromJean-Luc Stassen <igsoftsprl.be@gmail.com>
Date2012-12-07 07:20 -0800
Message-ID<cc25d292-5bfd-45d0-9085-a8bc4e0a4924@googlegroups.com>
In reply to#4301
Hi Wolfgang,

IS ADS free ? 
I think it's exmpansive for the customer, isn't it ?

Jean-Luc


Le mercredi 17 octobre 2012 09:30:22 UTC+2, Wolfgang Riedmann a écrit :
> Hi Jean-Luc,
> 
> 
> 
> > By "ADS" do you mean Advantage Database Server ? Ok, I tried that
> 
> > some years ago (with the driver AXDBFCDX that I was loading in the
> 
> > start function) but I never really make it working... on the server,
> 
> > ADS didn't use my dbf...
> 
> 
> 
> 
> 
> yes, I mean Advantage Database Server.
> 
> 
> 
> It is not 100% compatible to DBFs (you cannot use own function in index
> 
> expressions, filter expressions cannot used functions from your
> 
> program, ANSI needs to be set to false), but it took a day or so to
> 
> adapt my software to ADS.
> 
> It is very fast and absolutely stable, and does not takes too much
> 
> resources on the server.
> 
> 
> 
> Wolfgang

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


#4442

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-12-09 15:59 +0000
Message-ID<aijqrfFmohlU1@mid.individual.net>
In reply to#4439
Hi Jean-Luc,

> IS ADS free ? 

until 5 users You can use the local server

> I think it's exmpansive for the customer, isn't it ?

yes, it costs some money, but it costs far less than any other SQL
database (except MySQL or other open source SQL servers like Postgres
or Firebird).
And if you compare the expenses to a complete rewrite on a complex app
for a SQL interface, they are very low.

With ADS you can use both approaches, positional access with
incremental search and the other goodies from DBF, and relational
access with SQL.

I have moved one customer to Advantage and I'm very happy with it.

Wolfgang


-- 

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


#4448

From"Ginny Caughey" <gcaughey@online.hotmail.com>
Date2012-12-10 07:05 -0500
Message-ID<50c5d012$0$47703$c3e8da3$5e5e430d@news.astraweb.com>
In reply to#4442
You may be unaware that SQL Server Express is also free.

Ginny

"Wolfgang Riedmann"  wrote in message 
news:aijqrfFmohlU1@mid.individual.net...

Hi Jean-Luc,

> IS ADS free ?

until 5 users You can use the local server

> I think it's exmpansive for the customer, isn't it ?

yes, it costs some money, but it costs far less than any other SQL
database (except MySQL or other open source SQL servers like Postgres
or Firebird).
And if you compare the expenses to a complete rewrite on a complex app
for a SQL interface, they are very low.

With ADS you can use both approaches, positional access with
incremental search and the other goodies from DBF, and relational
access with SQL.

I have moved one customer to Advantage and I'm very happy with it.

Wolfgang


--  

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


#4453

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-12-10 14:56 +0000
Message-ID<aimbh9F9mc5U1@mid.individual.net>
In reply to#4448
Hi Ginny,

> You may be unaware that SQL Server Express is also free.

I know that, but moving a DBF based application to SQL is more work
than buying ADS.
And SQL is a major impact on the user interface - most of my customers
are using incremental searches on bBrowser controls.

Wolfgang


-- 

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


#4461

From"Ginny Caughey" <gcaughey@online.hotmail.com>
Date2012-12-11 07:01 -0500
Message-ID<50c72080$0$34943$c3e8da3$460562f1@news.astraweb.com>
In reply to#4453
Yes I agree it's a lot more work. For my company it was clearly worth it - 
we'd probably be out of business by now if I hadn't done that - but each 
situation is different.

You do have to perform searches somewhat differently with SQL, but it is 
certainly possible to give users the ability to quickly find the data they 
want with a SQL database.

Ginny

"Wolfgang Riedmann"  wrote in message 
news:aimbh9F9mc5U1@mid.individual.net...

Hi Ginny,

> You may be unaware that SQL Server Express is also free.

I know that, but moving a DBF based application to SQL is more work
than buying ADS.
And SQL is a major impact on the user interface - most of my customers
are using incremental searches on bBrowser controls.

Wolfgang


--  

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


#4462

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-12-11 15:51 +0000
Message-ID<aip343Fsnq2U1@mid.individual.net>
In reply to#4461
Hi Ginny,

> Yes I agree it's a lot more work. For my company it was clearly worth
> it - we'd probably be out of business by now if I hadn't done that -
> but each situation is different.

yes, that's true. I work regularly also with Oracle, MySQL and MS Sql,
but IMHO positional databases like DBF permit more userfriendly software

> You do have to perform searches somewhat differently with SQL, but it
> is certainly possible to give users the ability to quickly find the
> data they want with a SQL database.

yes, with SQL the user need to think first what he needs. With DBF the
user can open a databrowser, and if he not sees what he needs, he can
begin to search.

Obviously with very large databases SQL is the only choice....

Wolfgang

-- 

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


#4476

FromJean-Luc Stassen <igsoftsprl.be@gmail.com>
Date2012-12-17 06:22 -0800
Message-ID<16c096b9-056c-4e90-b056-c963b32acd63@googlegroups.com>
In reply to#4462
Hi Wolfgang,

Ok, I just want to try with the 5 users local server.
What do I have to do ?
I have a server 2008 and 3 stations with windows 7
I guess I must install something on the server ? Do you have a link where I can download an ASD for free ?

And, in my App do I only have to set 
 		SetAnsi(FALSE)
 		RDDSETDEFAULT("AXDBFCDX")
 		AX_AXSLocking(FALSE)
 		AX_RightsCheck(FALSE)
and remove all kind of self:server:filter := "...." ?
What can replace filter with ADS ?

Sorry if all these questions seems to be evident, but I don't know nothing about ADS...


Jean-Luc

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


#4479

FromJean-Luc Stassen <igsoftsprl.be@gmail.com>
Date2012-12-17 14:01 -0800
Message-ID<b661f2eb-a134-4f91-a271-4bdd724af0df@googlegroups.com>
In reply to#4476
Wolfgang,

I have installed ADS on my server. Do I have to specify the path of my databases dbf ?

On the workstation, I made a little app that use ads, like this:

SetAnsi(FALSE)
RddSetDefault("AXDBFCDX")

AX_AXSLocking(FALSE)
AX_RightsCheck(FALSE)

oserver := clients{,,,"AXDBFCDX")

...

on the open line I get an error saying that a call to _except_handler_4 in msvcrt.dll is not avaiable, and the app crashes...

Can you light me ?

Thank you
Jean-Luc

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


#4482

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-12-18 07:12 +0000
Message-ID<ajajbcFsaakU1@mid.individual.net>
In reply to#4476
Hi Jean-Luc,

> Ok, I just want to try with the 5 users local server.
> What do I have to do ?
> I have a server 2008 and 3 stations with windows 7
> I guess I must install something on the server ? Do you have a link
> where I can download an ASD for free ?

the local server is only a DLL, so nothing to install on the server -
only to adjust ADS.INI in your app directory to permit local server:

[SETTINGS]

;ADS_SERVER_TYPE = 7
ADS_SERVER_TYPE = 3


> And, in my App do I only have to set 
>  		SetAnsi(FALSE)
>  		RDDSETDEFAULT("AXDBFCDX")
>  		AX_AXSLocking(FALSE)
>  		AX_RightsCheck(FALSE)
> and remove all kind of self:server:filter := "...." ?
> What can replace filter with ADS ?

filters are working, but only when ADS-provided functions are used. The
same is true for orders: orders can include only ADS-provided functions
(since they are executed on the server), but most standard functions
are provided.

I have spent about half a day to make work an application with ADS (and
would never miss it).

But the true saving is coming when you are using the commercial server
on the server itself: it runs very stable and it does consume very few
ressources on CPU and memory.

Wolfgang

-- 

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


#4477

FromJean-Luc Stassen <igsoftsprl.be@gmail.com>
Date2012-12-17 06:27 -0800
Message-ID<4596ec68-54ff-4f3a-9b47-89889d03e75f@googlegroups.com>
In reply to#4461
Hello Ginny,

I agree with you but now I think it's too late for me to change all my app to SQL.
I have around 200 tables to manage ! this is a very big application. And we still work everyday on it, so it's impossible to stay 2 or 3 months without any new version (with bug correction)

So if ADS can fix my problem, I'm going to try...

Jean-Luc

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


#4483

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2012-12-18 03:41 -0800
Message-ID<76d9745d-1b8b-492a-8c89-aae6939a1e1a@googlegroups.com>
In reply to#4299
Jean-Luc,

My apps run seamlessly on both driver: DBFCDX and AXDBFCDX.  I also have working apps converted from Geoff SOVO SQL classes that work like a treat.  Now we have two modes: ADS/ALS/DBFCDX and SQL Server.

My only problem with SQL is that we have a delay in converting hundred RP3 to SSRS. But with ADS, RP3 works fine, it evens used native ADT using ADSADT.RDD.



--

Rene

On Wednesday, October 17, 2012 2:38:15 PM UTC+8, igsof...@gmail.com wrote:
> Hello Wolfgang,
> 
> 
> 
> By "ADS" do you mean Advantage Database Server ? Ok, I tried that some years ago (with the driver AXDBFCDX that I was loading in the start function) but I never really make it working... on the server, ADS didn't use my dbf...
> 
> 
> 
> I think, make the code good for the 2 database is maybe the best solution...
> 
> 
> 
> Jean-Luc
> 
> 
> 
> 
> 
> 
> 
> Le lundi 15 octobre 2012 19:01:10 UTC+2, Wolfgang Riedmann a écrit :
> 
> > Hi Jean-Luc, 
> 
> > 
> 
> > 
> 
> > 
> 
> > PMFJI,
> 
> > 
> 
> > 
> 
> > 
> 
> > I had a similar problem and I solved it by using ADS. ADS can be used
> 
> > 
> 
> > like a DBF, for SQL do work properly you need a complete redesign of
> 
> > 
> 
> > the application.
> 
> > 
> 
> > 
> 
> > 
> 
> > Wolfgang

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


#4712

FromJean-Luc Stassen <jls@igsoft.be>
Date2013-02-02 07:23 -0800
Message-ID<ea1c15fa-3694-4cf0-bc28-04528fef443d@googlegroups.com>
In reply to#4483
Hi René,

Can you tell me where I can find the SOVO classes ?

Thank you
Jean-Luc

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


#7178 — Win XP Pro vs Win 7 Pro

From"Jose F Zouain" <jfzouain@zetaconcepts.com>
Date2014-09-05 17:51 +0000
SubjectWin XP Pro vs Win 7 Pro
Message-ID<c6ubgvFtknnU3@mid.individual.net>
In reply to#4291
Jean-Luc Stassen wrote:

> Hello Geoff,
> 
> I only see this reply two years later... <g>
> 
> I agree with you, the code is not really a problem... we can work on
> it to make it working with SQL.
> 
> Altrought, how can I in the same code manage DBF or SQL ?
> If it's possible, I will be instersting with this mechanism.
> 
> My actual difficulties are:
> - convert all the personalised reports (reportpro 2.16) of each
> customers (+/- 500) - install and configure Mysql or something else
> on the server of my customers
> 
> These two points cannot automatically done via standard software
> update. I need to go to the customer or connect his network with
> teamviwer to configure anything...
> 
> If you show me the basics to use the same code for dbf or sql, it
> will be very kind...
> 
> Jean-Luc
> 
> 
> 
> Le lundi 3 janvier 2011 00:10:22 UTC+1, Geoff Schaller a écrit :
> > J-L,
> > 
> > Everyone claims their app is big <g>. I genuinely suspect yours is
> > about the same size as most other people's. However the point about
> > class libraries like mine is that you can convert to SQL without
> > rewriting your code base.
> > 
> > Let me take the average VO application:
> > 
> > * say around 250,000 lines of generated and written code
> > * say around 20 main lookup browsers
> > * say around 120 edit windows and dialogs (forget popups)
> > * perhaps 80-120 reports
> > * around 50-60 business processes (no GUI)
> > 
> > I can have your first cut in SQL in 2-3 weeks, sometime half that, 
> > depends on the quality of your original VO code. Data conversion to
> > SQL included. And the code will run alternately DBF and SQL to
> > prove business logic is the same. Very little code manipulation
> > save for the replacement of SetSelectiveRelation with joins and
> > SetRelation with dynamic scopes.
> > 
> > The refinements then take a while. Perhaps 2-3 hrs per report (to 
> > convert to reporting services) and 1-2 hours per browser/process.
> > But let's make it clear. Your DBF style code remains the same until
> > such time as you want to take advantage of SQL-only functionality
> > and performance benefits. Your app will run faster and be many
> > times more stable.
> > 
> > Of course there is effort and I would probably allocate a 6 month
> > time frame to do it carefully but at least the process can be
> > undertaken along side your existing maintenance program. The user
> > won't know until the day you cut over.
> > 
> > Cheers,
> > 
> > Geoff
> > 
> > 
> > 
> > "Jean-Luc Stassen" <jls@igsoft.be> wrote in message 
> > news:5831fa1f-bd70-4909-b167-121be4991e00@v12g2000vbx.googlegroups.c

Hi all

I have been getting this weird behavior in my Win 7 machine,
IN XP looks beatiful, no problem.
Bu in Win 7 I get problem of resizing and double controls.
Running VO 2.8 SP3.

I did not know that going from XP Pro to Win 7 Pro, will have
this problem.

Have anyone had this problem.
Don't know where to start.
Di MS again changed all the settings.

Thansks

Jose

-- 

[toc] | [prev] | [standalone]


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


csiph-web