Related topics

list tables in ODBC Connection
You have a choice to use a Database Container (DBC) or not and their are pros and cons about each. First you have to setup your ODBC connection (make sure you have For all of you other FoxPro people who think I have not explored this idea, here are all the other failures (and ideas) that did not work: 1) Create

How to convert Data from Access to Visual Foxpro format
Rod rbran...@mdausa.org microsoft public vb database rdo I am creating a datacomm application in VB5 that will be going after data in FoxPro 2.6 tables. 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?

Best method advice....
The real answer lies in HOW the connection is going to be made. For example there are ODBC drivers for using FoxPro, or dbase files also, but once again, Thus, we have a universal exchange format!). In theory, the above means that if you got the admin of that server to create a vpn (virtual private network),

How to connect to FoxPro Free Tables using VB 6
Or a perl utility that would read the Foxpro database and generate the SQL commands needed to create the tables and indexes? (assuming you use some windows version :-) - Download the Powerdesigner 45 day trial from www.sybase.com - make an ODBC connection to your database - reverse engineer the datamodel - change

newbie data transfer ? with SQL server 7.0
Just like getting data out of a remote site using a running database. VB can use Access files without starting Access because it has its own Jet engine, due to its evolution. But it doesn't have FoxPro, Dbase, Oracle engines as well. Would you need to use an ODBC connection? Such is my understanding.

CreateDatabase w/Security in VB
Locally, in Access, I can load this new data without difficulty by creating an ODBC link in the Access DB to the FoxPro file and executing an insert query. that an ODBC connection can be made between the FoxPro table and an .asp page since I used .asp pages had to clean up the FoxPro test file (I don't have the

Linking Workbooks/Exporting Data remotely and ....
I am creating a datacomm application in VB5 that will be going after data in FoxPro 2.6 tables. Originally I was going to attach the Fox tables to an 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?

creating ODBC for compiled .exe on user computers
Create a dynamic document in Excel or Word that pulls the same query via ODBC over the WAN. I believe the results will speak for themselves. I use PHP under Apache, C, Sybase Central, and Visual FoxPro 7.0, as well as CodeCharge, and Dreamweaver MX as my development tools. Personally, I have found PHP calls for

foxpro to SQL Server conversion
RICHARD V HENNESSY rhenne...@inspiritec.org microsoft public vb database ado I need to write a setup program that will create the ODBC connection to the Visual FoxPro Driver automatically since the users would have no idea how to do it themselves. I don't know if this can even be done. Any suggestions would be

Can VB create a ODBC Data source to a Fox Table Programmatically?
Hi CB, Here's something I've posted elsewhere on creating an ODBC connection to FoxPro tables. Some of it may be helpful - Start with the latest ODBC driver To do this, navigate to your data directory and look for the presence of a DBC file. If it's there you have a "database" otherwise you have free tables.

Appmodeler reengineering
How are you connecting to the SQL Anywhere database in VFP? How does VFP crash (errors, Dr. Watson, etc.)? Are you running Windows 9x or NT? I was able to create a VFP DBC, add an ODBC connection to the DBC, create a remote view to a test table (fields id(integer), date1(date)), and insert any combination of data

VFP6 as middle tier DCOM Objects?
Can I create a connection-less recordset and manually populate it? A: YES! 2.)If I do above, will I have to worry about installing ADO support on all clients that run my If your dbf database is either foxpro or dBase you should be able to use ADO directly. <quote>Can't use ADO because an ODBC connection is not

Wizard trouble
I was using FoxPro database files at the time. Consequently it is impossible to have the mdb file hosted on a Mac and expect to use ODBC or anything else You can use the MS Query interface to create any SQL command and execute the command. No, you can not put the mdb file on a mac and connect to MS Access via

ODBC question
Only problem is I can't do any SQLEXEC statements or run/create stored procedures because I have no SQL 6.5 Server backend. My point was that you can set up an odbc connection to a foxpro database and run sqlexec statements on the connection and it's a minor issue to extract a data subset into a fox,

VFP 7.0 and IBM AS/400
Hi, if I try to add an ODBC connection (System or User) in the ODBC Data Source Administrator in WinXP, I always get the message: "You must first install the current version of Visual Foxpro ODBC driver. Goto microsoft.com .........etc." I did download the latest driver and installed it and I am still getting the

Help with offline SQL Data
Andrew Cutting capsolte...@hotmail.com alt comp lang php alt php alt php sql microsoft public data odbc microsoft public inetserver iis microsoft public inetserver I have tried creating the TESTDSN ODBC connection on SERVER2 but didn't make any difference. Questions: - Has anyone struck this problem before ?

JDBC Connection to Access... need help ...Paul?
Would this work? String FILENAME = "D:\\DATA\\data.mdb"; DriverManager.getConnection(URL + FILENAME , "ME", "password"); No, not if you are using ODBC. You have to first create an ODBC connection. On Windows, the ODBC setup is under Control Panel. That is where the true path is designated.

Linked Tables in Access - can they be seen through asp Pages ?
... sql tables / views and an ODBC connection was used to build add-on query applications... works well but ODBC can be slow if you have lots of data coming down My only point here is that there is a large number of basic tasks that developers need to accomplish when creating a application or interface is well

Visual C++ and FoxPro tables, help.
ODBC is not a data source. 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

newbie question....recordset look alike.
Hi, Source A is an ODBC Connection Destination connection is a SQL table When I create a Transformation between the two sources.... it says that I have to constaint leading to the DataPump so that it is executed before the copnnection is opened If using a DBF file whyc not use the DBase or Foxpro drivers?