Go Premium for a chance to win a PS4. Enter to Win

x

FoxPro

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello,

For testing the performance of a legacy database application (.DBF files) I need to temporarily disabe SMB2 and 3 on WS 2008 R2 and WS 2016 (standard editions) and turn off opportunistic locking (Oplocks.)

I have researched it a but can’t seem to get it to work – links to some related articles below.

On the servers I think I just need to disable SMB2 since MS states SMB3 is automatically disabled when SMB2 is because they share the same stack.

What I’ve found is that the following procedure done on the server should work but it does not seem to.

1.      Reboot

2.      Show SMB1 running:
C:\ >sc query mrxsmb10
SERVICE_NAME: mrxsmb10
TYPE               : 2  FILE_SYSTEM_DRIVER
STATE              : 4  RUNNING
                        (STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE    : 0  (0x0)
SERVICE_EXIT_CODE  : 0  (0x0)
CHECKPOINT         : 0x0
WAIT_HINT          : 0x0

3.      Show SMB2 running
C:\ >sc query mrxsmb20
SERVICE_NAME: mrxsmb20
TYPE               : 2  FILE_SYSTEM_DRIVER
STATE              : 4  RUNNING
                         (STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE    : 0  (0x0)
SERVICE_EXIT_CODE  : 0  (0x0)
CHECKPOINT         : 0x0
WAIT_HINT          : 0x0

4.      Update the registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
Registry entry: SMB2
REG_DWORD: 0 = Disabled

5.      Reboot

6.      Show that SMB2 is still running
C:\ >sc query mrxsmb20
SERVICE_NAME: …
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Hello Experts,
Our customer has several applications, a few of them developed more than 20 years ago in visual basic and visual fox
they work just fine so the customer is not interested in migrating although we are pushing him to do so... and probably soon
he will in invest in these...
for the time being we are still using a four applications developed 3 in vb6 and 1 in vfp
everything has been working ok until last weekend taht we upgraded to win 10
the older app seem not to be updating when working in the network as usually
and we are experiencing some corruption in the fox indexes...

Is there any parameter in win 10 that we can use to help this...
the customer may take this a a way to push him to invest right now
and that is not the idea.... the customer has to do it in his own time and understanding..

So i would really love to find a solution for this.

Best regards,
0
I have an issue with something that has worked many times before, but not so much now.  I have a large database of uses of plants by native peoples of north america, 44,691 uses.  (Database is online at naeb.brit.org if you'd like to see what it's like}  It's native form is FoxPro.  I got a request from some college kids in Oregon who want to do a virtual tour of useful trees on their college campus. I said I'd help.  I got a list of all the tree species in the county in Oregon where the college is.  113 species.  I put their names (latin binomials) in a small database, named MarionORTrees.dbf.  The main listing of all the plants is titled bothitem.dbf Here's the list of commands I used. Sciname is the names of the species in Marion County.  Synthname is the latin names of all the species in the database.

CLEAR
SELECT a
USE "d:\data files\databases\synth99\MarionORTrees.DBF"
SELECT b
USE "d:\data files\databases\food\bothitem.DBF"
SET ORDER TO SYNTHNAME   && SYNTHNAME
SELECT a
SET RELATION TO sciname INTO b
SET SKIP TO b
BROWSE FIELDS a.sciname,b.synthname,b.comname,b.tribe,b.use,b.descrip
BROWSE LAST FOR b.synthname#"  "

The last command should show all the relevant info for the items in the main database for trees in Marion County.  But it doesn't. I have various outcomes, some really loony, none really right.

I'm using what I believe to be the latest version of Windows 10 Pro: Build 15063

Any suggestions?
0
Hi Experts

Could you point how to have a gateway to credit cards/ paypal/ ... - any library for that use when using a VPF's PDV app?

Thanks in advance!
0
I have a DOCX with mail merge fields set up and a CSV file for the data source. If I complete the merge and save the main document, when I re-open the main document I get an error message saying that (an unknown docx filename) is a mailmerge main document. Word cannot find it's data source (correct CSV filename).
The CSV file stated in the error message exists in the path stated in the error message. I know that if running manually, I can disconnect then reconnect the data source and go on, however, this document needs to be processed from within a Visual Foxpro program using OLE automation. Unfortunately, if I attempt to process the document from within the program I get the same message about Word cannot find the data source.
I need to get this working as soon as possible using Word 2010 and Office 365. Worthy of mention is that I have many Visual Foxpro programs that successfully automated Word mail merge when we were using Word 2003.
Thanks in advance.
Cathie
NYC
0
Is there a way to make a VFP application executable that runs fine in Windows 7 with Visual Studio 6 installed to work in Windows 10? Windows 10 does not allow to install VS 6. Windows 7 complained somewhat during the VS 6 installation, but still installed it, and the VFP executable runs fine.

Thank you.
0
Hello Experts!

So I'm working on converting some programs over from Inserting data into FoxPro to now inserting that same data into MS Access 2013...because lets face it FoxPro is gone.

Now comes my issue, in FoxPro I had a field set to character length of 4...in MS Access same field text set to length of 4.
However there are times I get data in the file that is longer than 4 and when importing that data into FoxPro it would just truncate the data from say 6 to 4 and insert it...however in MS Access it doesn't strip it from 6 to 4 it throws an error.

"The field is too small to accept the amount of data you attempted to add."

Is there a way to set MS Access (property of some kind) that will just truncate (ignore the length) the data if it is longer than 4?
Or do I need to change my program to pull all fields from left to right and truncate all the fields in my program?

Thanks,
Mark
0
I have Foxpro 2.6 dos run under Novell 3.12 server. I want to move it to windows server 2012r2. What I have to do to make it work multiple users?
0
Hi Experts,

i need suggestion to convert .xlsx or .csv file in to .dbf format , in my machine i had installed Visual FoxPro - Access - Excel. please help me out .

Thanks
0
Hi Guys,

Here's a beginner style question. I have never done anything in Databases nor have I worked on GUIs. We are running FoxPro 2.6 for Payroll since the boonies and want to convert to Access with a GUI .. Eventually we will get an ERP

I know how to convert dbf files to access, that is not the issue. The problem is, I do not know the process of how to start building the GUI. User accounts, Data, Printing, employee info, we have a lot of databases. I know it will be a timely process .. any ideas where I can start?

Would love some help here.. if you guys know any company that does this conversion and building of GUI in access, let me know as well.

Thanks

Al
0
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I've got a third-party DLL file that I want to access from within VFP. The DLL file is called GIQ.DLL; the function within that is called ConvertCoordinates().

I've got a DECLARE statement that seems to work : after I've run this, when I do DISPLAY STATUS, the function andd the DLL are both reported.

But when I try to run the function, I get the error message

    Cannot load 32-bit DLL ...\giq.dll

I've tried moving the DLL into the same folder as the rest of my program.

I've tried unzipping the file afresh.

Any suggestions?
0
In VFP6 report I want to make same printer margins  to all printer drivers like Microsoft word & excel does.
How?

Please make it fast, its essential.

Thanks in advance
Balaji Infocom
0
I want to command in dos foxpro 2.6 to remove eof mark in my csv generated thru program
0
I suspect the answer to this question is "Windows 10 update" like so many others I've had to deal with.

I'll describe how the problem manifests. What I'm after is a way of zeroing in on the culprit.

Took me several days to realise I had the problem. I had wrongly assumed that I was requiring VFP to perform a more arduous task than I'd anticipated.  It almost doesn't matter what the task was but I'll describe it anyway.

I was running a report involving 32k records but requiring a summed calculation based on a quantity held in the current table and a cost held in a related table.  The kind of thing we've all done a zillion times.

Some of mine can take a few minutes to run, especially if they're sucking out 2 years worth of data and performing a detailed year on year comparison, so I wasn't too perturbed when this particular report was taking longer than I expected.

But then it got ridiculous. Last night I had to leave it running while it churned through just 32k records (and only 8k in the related table) and check in from home to find it had finished about 20 minutes after I'd left. WTF?

So today I've been troubleshooting. Frequent culprit has been Zonealarm. If you don't specify certain programs as being safe, it performs a paranoid check every time you run them. But the program had been correctly tagged. Didn't fully trust that, so I uninstalled zone alarm. Rinse and repeat. Problem behaviour still there.  I should specify that it's actually Zone Alarm …
0
Hi Experts,

Need a help to edit .dbf file or say create .dbf file, i have Excel 2016 but i can't find any option to save file as .dbf format. actully i have one .dbf file and opened in excel change whole data and try to save but excel error...... it missing some data while open again. is there any way out to open .dbf file and edit data and save as .dbf file ?  or is there any way if i create one .csv file and convert to .dbf file.?

Thanks
0
Using SQL Server 2008 R2 and Using the SQL 32 Bit Import and Export Data to connect to a Visual FoxPro Database (this used to work Just Fine)

However when selecting Data Source and Choosing OLE DB Provider for Visual Fox Pro I get the following  error

Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)

------------------------------
Program Location:

   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory,…
0
We are looking at the future of a VFP9 ERP app. In testing one path, a C++ programmer is finding it more of a challenge than he expected to convert the database to SQL Server 2014. So far there seems to be no way around retyping all the field names after exporting. I know nothing about SQL Server--but figure I'd better start to learn! Is this the case? No straighforward migration of a VFP9 database to SQL Server 2014? (No fancy triggers or rules)
0
Hello Experts some antivirus and other applications report our app as unsafe or propose delete...
what is the procedure to register it properly so no other software will see it as a threat?
We use visual studio (basic and c#) but we also still have some legacy visual fox pro apps working just fine.
Regards
0
In VB.net it appears it rounds my number when I don't want it to...
Example:

Amount = $110.00
Percent = 0.1791

In FoxPro when you multiply Amount * Percent you get = 19.695543
In VB.net when you multiply Amount * Percent you get = 19.701

I want the same result as I get in FoxPro...how can I get the decimal places out farther in VB.net.

Thanks,
Mark
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi All,

Greetings....

According to my work, pdf files will be get merged in a specific path. I need to give dynamic file names to the mergedOutPut File.
1. Is there any way to pass parameters to the file name?
2.Or I can give fixed file name to the mergedOutput file through my code.After that Can I  rename it into dynamic naming conversion?

I saw RENAME command in Foxpro. But I am not sure whether I can pass parameters to it

Any help regarding this would be highly appreciated.

Thanks in Advance.
0
I have found a strange performance issue with xBase++.
Essentially, client performance is very good until database files in the same database are opened locally on the server (see graph.)
Details are below.
Thanks,
Tim

Test Setup
----------------
•      Three client platforms and two server platforms, all under controlled conditions.
•      Clients: Win7 10/100, Win7 gb, Win Server 2008 R2 via XenApp
•      Servers: Win Server 2012 R2, Win Server 2008 R2 (VMware virtual machine)
•      xBase++: 2.00.785
•      Dbe: FOXCDX (see dbesys.prg example)
•      Client test function: representative function that creates a DBF/CDX file on the client C: drive from data assembled from multiple open data files residing on the server.

Test Procedure
----------------------
1.      Reboot the server
2.      On a client map a drive to the server database share
3.      Run the app from the client c: drive, starting it in the mapped server folder – performance is good for multiple simultaneous clients
4.      Run an app locally on the server and open files in the same database folder as the client
5.      As the number of files opened locally on the server increases the client performance degrades significantly for all clients, even new instances on different machines (see graph)
6.      Close the locally opened files on the server
7.      Client performance remains degraded

Notes
---------
•      The performance is poor for all subsequent clients once a database folder has files opened locally on the server
•      The performance …
0
I have a foxpro data table having files name and fname. Now i want to create a foxpro form having text box on it  and i press a alpha bates key from keyboard like A all the name starting with a will listed for making selection and when i press second key b all the name stared with ab will be listed and so on.   Is it possible please help
0
I had to reinstall Windows 7 and Access 2013 and now I cant find my ODBC drivers to Link with Foxpro from Access?
0
FoxPro  FoxPro 2.6
I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code. If there is any program in foxpro 2.6 kindly mail me at rajesh.ranjan@modernajyoti
.com.
0
Examples
0

FoxPro

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Top Experts In
FoxPro
<
Monthly
>