Related topics

User Defined Functions
At a client site I have not been very successful. I am hoping someone out there may have an answer to what may be going wrong. Steps to reproduce problem: 1. Map the NT machine to a remote computer containing FoxPro DBF tables. (I used drive E: ) 2. Create an ODBC DSN called FOXDBF using VFP driver.

Can I get all fields for all tables in a FoxPro DB into excel ...
Mike mcur...@srjgroup.com microsoft public excel programming My question to you is what type of data access have you been reading up on? There are two ways I retrieve data (well StatusBar = "ODBC Connection Established" Else MsgBox ("ADO Connection Failed") Stop End If ' Run the query Set objRS = New ADODB.

RDO, ODBC And FoxPro tables
I have been doing my development work in A97 but the folks have AXP at their site. As near as I can tell, the FoxPro driver has been discarded from A97 and replaced with ODBC in A2K onward I attempted to set up an ODBC connection on my machine. When I go into DataSources, ODBC to create a new data source,

Setting up 16bit ODBC & BDE
ODBC is a method for connecting TO data sources. YES, you can use ODBC to connect to ASE. You can use ODBC drivers to connect to almost any database (Oracle, DB2, Microsoft, FoxPro, Informix, etc.) as long as you have the proper drivers installed on your computer. You should have "ODBC Administrator" installed with

Slow ODBC connection
William Fields Bill_Fie...@azb.uscourts.gov microsoft public fox programmer exchange Sorry, but I don't have much c/s development experience so I cannot comment on performance. But your correct that using ODBC introduces another layer in the mix. We noticed a huge performance drop though using ODBC data access in

Migrating C/embedded SQL to C++ and something
It is my understanding that VFP does not have an OLEDB provider, so that means setting up an ODBC connection to use with ADO.... When you choose the VFP driver, it will ask you whether or not you want to create a DSN with a VFP database or with a free table directory. If you choose free table directory you just

CreateDatabase w/Security in VB
Create a new query, ignoring local tables, set / paste Source connect Str. Go to SQL view and type Select * from tablename; going back to design view you should (For example, I want a query that appends data from the Foxpro table onto the Access table.) I am fairly certain that I have the ODBC drivers set up

OBDC Drivers!!
Dave Tompkins et...@infi.net comp databases xbase fox I'm new to VFP...most of my work has been with FoxPro 2X. I need to SQL data from Access ver 2.0 into VFP 6.0. Although we were able to create and ODBC connection SQL will not run. As a result I now have to open the Project and use the link directly which,

Database connection to MS Access & MS Foxpro
I have been experimenting with this for over a week. Maybe someone can enlighten me. I am working in Access 97 and 2000. I need to create a new version of an My queries that did not work with the ODBC connection now work. Does anyone know if I will have any data integrity problems by calling my visual FoxPro

ODBC connection to mdb for MacIntosh
Customers have reported database bloating issues with the MDAC 2.1 version of the Access ODBC driver. Jet 4.0 now stores all text data as Unicode, driver and opening a Microsoft Access database file on a network share, an excessive amount of network packet activity occurs, even when the ODBC connection is idle.

Linking a table located on a Windows Web server
ProSysPlus.com and download Hank Fay's Video on using xCase2VPM to create applications that can work with several different backends. I want to change the Foxpro database to other databases(egMySQL,SQL server)using ODBC connection. I have already converted the foxpro database to MySQL database.

Need Help converting VBA to VBS
Create an ODBC DSN, use Free Table Directory and point it to the folder with the dbf files. Link tables using the ODBC connection. I am required import the FoxPro data into another Access application. In Access 97 there was a wizard. I have installe Access 97 on the new computer but the wizard is not there.

RDO, ODBC And FoxPro tables
Create an ODBC connection to your Access MDB using the ODBC icon in the Windows Control Panel 2. Create a VFP dbc - say Mydbc 3. OPEN DATA Mydbc 4. Once you have chosen the Table and Fields, go to the Update Criteria tab 9. Designate which field is the primary key and check the Send SQL Updates checkbox Now you

ODBC connection to an Excel spreadsheet ...
You can get your data back from a VFP ODBC connection with the same speed (more or less) as native FoxPro. Its a matter of having indexes on the tables. I am not sure how easy it would be to prove You can test for Rushmore by creating any large table and any index combination you want (that would demonstrate

Which one: MSDE or SQL Server Personal Ed. on a notebook?
The only way to write applications that used a truly secure database was through some type of ODBC connection to a SQL database engine. .... Append groupNew Putting the Pieces Together So far you have seen how to create a logon screen that accepts a user ID and password and to create a secure database.

Linked Server Problem
You have ODBC installed on the machine your developing from or access to a machine with Microsoft ODBC (its in the control panel) Ok here we go: First create a database (Access, FoxPro, Excel (yes you can use an Excel Spreadsheet, its considered a Flat File Database), etc) then go into control panel and start the

Splitting large flat file into relational tables
If you create a share on a windows 9x box and then set the sharing to full access, and point the foxpro ODBC DSN on your IIS to this new machine (ex: I am trying to access a database with and ODBC connection so I can run queries on a VFP 6.0 Database from a Web Browser. I think I have an ODBC Error.

ODBC and ASP Help
A lot of information there, but nothing to do with creating a database, in code, that has security. Does anyone else have information on this? The only way to write applications that used a truly secure database was through some type of ODBC connection to a SQL database engine. The Jet engine at that time had a

Migration from FoxPro
I'am working in MFC app and it must read and write data to/from a Visual FoxPro tables, I have no experience with Visual ForPro tables but I have with MS SQL Server, Access and FireBird, somebody knows where can I found information about Visual C++ and Visual FoxPro tables? If you create an ODBC connection and use

directly access a vfp db vs odbc connection
However, in the latest upgrade, they have instated Visual Fox Pro 6. I changed the application to use the Visual Fox Pro driver (6.01.8629.01) ODBC connection. The table connect, display and update just fine. However, all of the data in every FoxPro table has been padded with spaces to fill the fields.