I have some SQL Server DTS packages that import data from a FoxPro database. This was working fine until recently. Now the script that imports data from one of the FoxPro tables bombs out about 470,000 records into the import. I'm just pulling the data into a table with nullable varchar fields so I'm thinking it must be a weird/corrup...
Is anyone programming in Visual Foxpro out there? I'm stuck supporting a legacy foxpro system. Wanted to know who else is out there is using Foxpro. Added 9/11/2008: Thanks to all of you who responded! ...
I've got a bunch of FoxPro (VFP9) DBF files on my Ubuntu system, is there a library to open these in Python? I only need to read them, and would preferably have access to the memo fields too. Update: Thanks @cnu, I used Yusdi Santoso's dbf.py and it works nicely. One gotcha: The memo file name extension must be lower case, i.e. .fpt, ...
I want to set all the fields and labels on a VFP7 report to "Float" and "Stretch with overflow". I tried USEing the .frx file and doing the following REPLACE but it didn't work. Is there some other field I need to change too? REPLACE float WITH .T. FOR objtype = 8 ...
How can you import a foxpro DBF file in SQL Server? ...
I have a foxpro app, that contains hard coded path for icons and bitmaps. That's how foxpro does it and there is no way around it. And this works fine, except that when a removable drive has been used but is not connected, and when is connected windows assigns the same letter as hard coded path, when opening any form that contains such p...
I know that there are issues with the VFP OLEDB provider on 64 bit machines. ... but what issues do you encounter while actually running a VFP application - on a 64 bit machine? Has anyone had any experience in this area? My first thought was that it would just run as a 32bit app, without making use of the 64 bit power. However, I ran i...
Anyone could point me to some code/give me ideas on how to create a smooth scrolling vertical marquee for VFP 8,9 Any help is appreciated. Nelson Marmol ...
I have a little utility that converts .dbc files to .csv files, trouble is, somewhere in the conversion some data is lost/destroyed/whatever. I input a.dbc into converter, it produces a.csv. I delete a.dbc,and then run a.csv back through the converter, and I come back with a "slightly" different .dbc file then I had started with. Does a...
We recently installed Team Foundation Server 2008 and we are using it for both Visual Studio 2008 code and Visual FoxPro 9 code that we are still migrating to .Net. I had to install the TFS MSSCCI provider to get connectivity from the VFP9 IDE. That works fine, but Visual Studio now seems to get confused about which source control plug i...
What compatibility issues have you found when developing with Visual FoxPro 9 on Windows Vista? ...
Are there any successor products on DOS, Windows or Linux? ...
Is there a reasonable way to access FoxPro databases using LINQ? ...
I am trying to understand the file format of a Visual FoxPro compact index (*.IDX). I am currently referring to Microsoft's documentation for guidance. The index is a B-tree of 512-byte nodes. Each leaf ("exterior") node contains multiple entries. Each entry consists of four pieces of data: Row number [FIXED LENGTH] Duplicate byte cou...
Our VFP 8 application is returning error 1958, which is "Error loading printer driver" when executing the following line of code SET PRINTER TO HP1200 on a customers Vista Business 64bit laptop. The HP1200 is a HP business ink jet model 1200. The customer removed and reinstalled the printer using the latest 64bit driver from HP. We...
I need to open foxpro free tables in vb.net using the oledb connection. But... i only need to get the column names. I don't really need to 'select' anything. I am trying to dynamically browse through all our free tables and set up a listing of every column from every file and xref that to another free table that contains a description o...
One of our clients has an application (FoxPro 9) running on top of a SQL Server 2005 backend. Intermittently, they are losing their ODBC connection with the SQL Server database. Below is the intial error information: Err Msg: Connectivity error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). ODBC Err Msg: [Micros...
I'm writing a C# program to convert a FoxPro database to XML, and everything works except the memo field is blank. Is there something I'm missing to convert that bit? I'm using C# .Net 3.5 SP1, Visual FoxPro 9 SP 1 OLE DB Driver. Connection string is okay, as all other data is being pulled properly. When I converted the FoxPro database...
Hi I'm converting a foxpro database to SQL Server and some of the keys are VFP-generated unique identifiers - GUIDs I assume. Are these valid uniqueidentifiers? Can I just use the bytes and convert them easily into a uniqueidentifier in SQL Server? Thanks, Craig ...
I'm porting a VFP 9 application to SQL Server. The VFP app has some tables with "general" fields in them. I get a byte array when query the field, and when I save it to disk, I can look inside and see it's a word document, or a Paint BMP, etc. From reading around, I've found that the general field is a proprietary format and contains a...