Related topics

SQL to SQL ODBC access across the internet
Cindy Winegarden cindy.winegar...@mvps.org microsoft public data odbc Suresh K <suresh_pall...@rediffmail.com> inscribed in news:07d701c2c623$a7b6df50$d7f82ecf@TK2MSFTNGXA14 ... I am facing a peculiar problem while connecting Visual Foxpro Databases with ODBC connection. I am using Visual Foxpro only for the ODBC

Can VB create a ODBC Data source to a Fox Table Programmatically?
I find the easiest way to do this is to use the ODBC Administrator to create a file DSN, then open that .DSN file in a text editor and have a look at the IIS 5, and we have Visual FoxPro installed along with all the database drivers for FoxPro that we could find ... but we can't connect to the tables!

How to create ODBC connection (DSN) by code (VFP6.0)
I was hoping I would be able to create/use temp tables via SQL over the ODBC connection instead. -- William Fields MCSD - Microsoft Visual FoxPro US Have you considered writing a stored procedure (or view or nest of views) to return that data? OK - you don't really have the kind of optimisation for this you get

Access 2000 Linking to Visual FoxPro Tables
2) Within Delphi I am trying to write a central utility suite but have problems creating new data (currently the user selects 2 tables and which fields they managed to get an ODBC connection but still have problems if the database connected to is 2GB or >255 fields as FoxPro appears to load the data locally.

IIS issues (was Re: ILOVEYOU)
This may have failed depending on your ODBC Driver. This is not really a problem, it will default to another value. Using the cursor type of: 1 Setting the connection to only grab 8 rows maximum...Success! Using the maximum rows: 8 Cursor is currently named "". Renaming cursor to "TestCursor"...Success.

VFP for the web using a remote ISP
--Joel "Anders Altberg" wrote: You can use FoxPro 2.6 tables or create an ODBC connection to FoxPro tables using any later version Visual FoxPro. The beta for VFP9 is a free download from I have become involved in a situation where I will be supporting at least for the short term a Foxpro 2.6 application.

Foxpro to SQL Question
I also know that it becomes more complicated if you are converting Memo fields in FoxPro. I didn't have time to investigate or try much with this. A big plus that I believe to be true for BCP is that it is lightning-quick. I have seen BCP work and can confirm it is very fast. 2) Create an ODBC connection to the SQL

Pushing data into database
Here are a few ideas I have thought of: 2. Have the foxpro database make an ODBC connection to the SQL server and then update whatever it needs to. Problems with this: How would I upload any graphics to be displayed with the particular item? Is there a performance issue in creating ODBC connections?

CreateDatabase w/Security in VB
SQLConfigDataSource(0,1,"Microsoft Visual FoxPro Driver",settings) The SQLConfigDataSource should be in the ODBC help or else it can be looked up on the Microsoft site. The first two parameters are for data settings such as exclusive, the third is the driver, and the fourth of course is your settings.

More BrainStorming... a new pick GUI
The issue is when I set up the ODBC connection using the Microsoft FoxPro VSP driver version 6.01.8630.01 and I pick the directory where the free tables exist, This table is probably the biggest, ie, It has lot of data. I do not whether there is any size limitation. Any help will be greatly appreciated.

FoxPro Client/Server
Alternatively have you considered using Excel - since you seem familiar with it. Just grab your data via an odbc connection and save the worksheet as a dbf file? Does anybody know how to create dbf (FoxPro,dBase) files dynamically from Oracle database, via Internet? And its important to get this file right into

convert foxpro database to other ODBC database
Anders Karlsson a...@workmail.com comp databases ms-sqlserver microsoft public sqlserver odbc Maybe u do not have any user rights to create a file on the remote The problem here is that the FoxPro tables are held on a Novell 3.12 server and although I can set up create an ODBC connection through the ODBC data

Foxpro with Oracle 8i Lite
Putting this aside, let's assume that you have a valid data source (ie a database to connect to) and you want to create some tables, etc. We plan to use Visual Foxpro as a front end using ODBC to connect. Right now, we are prototyping on MySQL and MyODBC, but I want to keep it as portable as possible.

What program to use - VB5, VFoxPro 5, Access 97?
Regards, -- William Fields MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ "I have no special talents, I am only passionately curious" - Albert I was hoping I would be able to create/use temp tables via SQL over the ODBC connection instead. Well you could certainly do the job using ADO by

New to CodeBase and have some questions...
Author of Internet Applications with Visual FoxPro 6.0 Beth Massi <bmassi@_NOSPAM_hmtreturn.com> wrote in message news:7l09dh$9kp@dfw-ixnews19.ix.netcom.com... Im connecting to Oracle not SQL. Yes I am disconnecting the connection right after I retrieve the data. (everytime) Yes I have ODBC Connection pooling in

Visual FoxPro 6.0 Client Server To Oracle 7.3 ODBC Question
... what version was used to create the files, but I can access the tables manually as follows: There is an ODBC connection of type 'Visual Foxpro Database (DBC file) The actual tables come in 3 parts: the DBF file is the table itself, the FPT file (optional) contains the Memo field data, and the CDX (optional)

FoxPro6 and MySQL, odbc
188) says that a remote data source is "typically" a remote server for which you've installed an ODBC driver and set up an ODBC data source. Does this mean that you could also just as well connect to a FoxPro database directly without ODBC, or does this defeat the purpose and just cause extra overhead?

ASP,ODBC and VFP
Ok. I have a simple situation. I have a single Foxpro table which I've created an ODBC connection to using the FOxpro driver donwloadable from microsoft support. When I run the package, it screams at me because two of the datetime fields in the fox pro table have data it's not expecting. From what I can see,

Utilizing temporary tables via an ODBC connection?
What I am trying to accomplish The user has an Access Database in which she is creating queries. We need to update Foxpro tables based on the queries that on a named connection (the Access database) it's dialog provides me with a list of all the Tables and Queries from the Access file, I just have not been able

TIP for File DSNs
However when I try to create a query that spans the two workspaces, I get stumped. (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 properly, and that I am just lacking some necessary programming principle.