×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Anyone using VFP against a native database on server 2019

Anyone using VFP against a native database on server 2019

Anyone using VFP against a native database on server 2019

(OP)
I have a client planning to 'upgrade' his server to 2019 and he has asked if there will
be any problems...

Anyone done that? Do Op' locks cause any problem?


(I am aware I answered a question on this a year ago, but it doesn't hurt to ask for actual experience)

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Anyone using VFP against a native database on server 2019

I have some users that have upgraded their servers to 2019, and I haven't heard of any problems. I might add that I always install EVERYTHING in a catalogue on the server, and the clients only have a shortcut to the main EXE on the server.
BTW, this approach has worked for me back from W95 until now :)

RE: Anyone using VFP against a native database on server 2019

(OP)
Thank you Dan

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Anyone using VFP against a native database on server 2019

Hi Dan,
Would you care to elaborate with some more detail?
Using native VFP tables? SQL ?
Using Remote Desktop RDS ?
How do you "catalogue" on the server ?

Regards,

Edgar
Integrated Bar Code Systems, Inc.

RE: Anyone using VFP against a native database on server 2019

While it works to have the exe shared on the server, it does mean you have to kick everyone out to install a new version. The best performance is gained by having the exe on the local pc.

Mike Yearwood - Former FoxPro MVP

RE: Anyone using VFP against a native database on server 2019

No issues, neither any settings needed if native dbfs reside on shared server and exe's on local PC's.

RE: Anyone using VFP against a native database on server 2019

(OP)
Thank you LJ

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Anyone using VFP against a native database on server 2019

@fitedgar
Sorry for late answer and my somewhat bad English :)
Only free VFP tables.
I meant DIRECTORY, catalogue was "swenglish", it's called "katalog" in Swedish.
Some users use RDP, but not many.
Most use "Connect network device" to get a device letter.

@myearwood
You have to kick everyone out anyway if you're upgrading, right? You are of course right that performance can be a LITTLE better with local EXEs, but it increases the complexity of everything.
Just today, I moved my app (actually it's one EXE and about 10 APPs for better performance, the EXE is only about 750kb) for two of the companies that use it. No need to access the clients, I just moved the app-directories to another server.

RE: Anyone using VFP against a native database on server 2019

You don't have to kick everyone out if the change applies to only a few. They can get the new version when the need to.

I had a co-worker put Excel on the server. Cost the entire accounting department a day's work when a switch failed. No one could save, because that dll was lost to the users. It's our job to simplify things to get performance and easy maintenance. So people also create a database with view which are also copied to the workstation. Since every time a query is loaded, it locks a record in the dbc, and then releases it.

Mike Yearwood - Former FoxPro MVP

RE: Anyone using VFP against a native database on server 2019

(OP)
I think that if a client upgrades a server, as a vendor you end up living with the consequences...

In this case they DID ask if there might be in advance, normally it's in arrears, and it always reflects
on the vendor.

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close