Related topics

FoxPro 2.6 ODBC Connectivity
I have no need to authenticate via the NTFS filesystem. I don't create a files on the system except when generating faxes. .... The ODBC connection from the NT box to the mainframe is set to "read only". (not that that would stop someone from using ODBC on their own machines to commit acts of evil).

FoxPro drivers and Linking to access question
Provider=MSDASQL.1;Persist Security Info=False;User ID=user;Data Source=CommAssoc;Initial Catalog=db One simple way of creating these connection strings is to add a data Specifically what paramaters do I use for the 'provider' and 'connectionstring?' I have set up an ODBC connection called 'VFP6' that works.

Translation issue
Views can be great under certain circumstances, but as you have seen, used incorrectly they can be slower than accessing the data across a network. so it is not quite as portable, but you gain quite an advantage in performance, because, although you use an ODBC connection, you don't go thru the ODBC translation

VB newby SQL question
Stefan Wuebbe stefan.wue...@gmx.de microsoft public fox programmer exchange Jeff, To get started you may want to have a look at c. how to create a central error handler d. how to connect to an Access MDB file from FoxPro If there are web sites, books, etc., that can help me out, please let me know.

How do I use Foxpro files with ADO
I am going to establish the ODBC connection while programming/debugging my program on the road, with a stand-alone notebook running on battery. Obviously the data won't be a Please advise... TIA Willianto PS. I already have SQL Server Dev. Ed. in my desktop. I use Visual FoxPro 7.0 as the development platform.

ODBC error with PHP and IIS5
Now for the meat of this posting: To access a database via ODBC, you must first create an ODBC connection to the database. 1) Open Control Panel, and then select ODBC. 2) When the Data Sources dialog appears, select Add. 3) If you have installed all of the drivers properly, you should see the following Access

Foxpro and the Web
Go grab the ODBC driver for mysql. Install and create a DSN for your mysql database. Then go into VFP and open your DBC, add it as a connection. Better fix <INPUT TYPE="hidden" NAME="item_name" VALUE="ConsultaingAssistance"> I have the Que book, "Special Edition, Using Visual FoxPro 6", but all it ever

RDO, ODBC And FoxPro tables
nl_Nospam> wrote in message news:MPG.1662e6fcce25fd359896c9@news.euronet.nl... On this moment I'm trying to update a program I have to push data in a database on an automated basis. The data is collected throug Visual FoxPro from an ODBC connection (which can't be queried by sql itself because of stability issues).

Appmodeler reengineering
Now, the supplier of Database A has changed the rules and is providing the data in a series of CSV files rather than the foxpro (DBF) tables of old and I am now faced with the challenge of finding some reliable way to re-create the "queryable" functionality of the old DBF tables or I will have to re-write a major

newbie data transfer ? with SQL server 7.0
GraphMan tbart...@hotmail.com microsoft public excel programming In article <7cfd01c075bb$0721e590$1e83300a@cpmsftngxa03>, "Jeremy Thompson" <thompso...@wellmark.com> wrote: I've been tasked with creating an application that can be used = Enterprise wide=20 that can connect to any ODBC compliant data source and

newbee, need to open a .dbf file
I believe it is also possible to create databases in SQLServer or Oracle using the CREATE DATABASE statement but I am not sure it is supported through an ODBC connection (I always use the DBMS utilities). Once you have a database and are connected to it you can use the CREATE TABLE statement to build the tables.

Translation issue
Howie howardr...@yahoo.com microsoft public scripting vbscript Hello, I have this code below working fine. There are two routines: SetKey and RemoveKey I had Connection Set rs = New ADODB.Recordset 'OPEN ODBC CONNECTION TO ACCESS BARSCAN FOXPRO DATABASE cn.Open "Provider=MSDASQL.1;Data Source=IntegrityDB" cn.

ODBC Restarting
Anders Altberg x_pra...@telia.com microsoft public fox programmer exchange You can use FoxPro 2.6 tables or create an ODBC connection to FoxPro tables using any later version Visual FoxPro. I have become involved in a situation where I will be supporting at least for the short term a Foxpro 2.6 application.

VFP and Access ODBC etc
Hi, Iīm developing an interdev web project(version 1) using odbc connection with visual foxpro table (.dbf) but there are some problem that I donīt know what. I create a ODBC FILE DSN and when use to add a data conection occurs the erro: [microsoft][odbc driver manager] data source name not found and no default

Need Help converting VBA to VBS
I have been able to READ the data through an ODBC connection. I am trying to find a way to WRITE or INSERT a record. Has anybody in here done it? done some work in the past in retrieving data from and updating tables on As400. The purpose was to set a subset of a table ready on the as400 with data in Foxpro.

MS Access to Clipper DBF Files
siteID=11518 Keep an eye on the product lifecycle for Visual FoxPro here: http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv - VFP5 Mainstream Support retired June 30th, 2003 - VFP6 Mainstream Support retires Sept. 30th, 2003 Hi, if I try to add an ODBC connection (System or User) in the ODBC Data

FoxPro Linked Tables and ODBC
I'm an ODBC novice. I am using Visual FoxPro and need to process data in a table in a remote database. So far in my application I have successfully created an ODBC connection and an SQL VIEW of the table in the remote database. My code for this is: OPEN DATABASE WORK1 CREATE SQL VIEW items_view ; CONNECTION

Performance?
I don't know what your toolset is, that's why I suggest using SQLServer DTS to get the data to your final destination. If you don't have SQL Server, you will have to use VB to open and read the foxpro database. If you are on familiar ground here, ok fine. If not, I suggest using ODBC connection wizard to simplify

ADO and VFoxPro db
It also uses an ODBC connection to a SQL backend that complicated things a bit. It's not pretty and took a while to debug, but I'm pretty satisfied as it stands. We have been ask to build a new database for the charity and are bring forward 7 years of data from an old MS-DOS FoxPro DB. The original database had

Utilizing temporary tables via an ODBC connection?
As you have discovered your RDO calls are passed to ODBC which passes them to Jet/DAO which passes them to the Fox ISAM driver which gets the data from When I create an ODBC connection to a FoxPro table does it just invoke Jet and use the same ISAM that would be used if I had attached a FoxPro table in Access?