Related topics

Cannot create an ODBC Connection
Using the CreateWorkspace Method The CreateWorkspace method enables you to create a new Workspace object. This new object can be used for either the Jet database engine or an ODBC type of connection. The syntax for the CreateWorkspace method is: Set workspace = CreateWorkspace(name, user, password, type) Table B4.4

Linking to FoxPro table using Access 2000
CindyWinegarden cindy.winegar...@mvps.org microsoft public data odbc First off, be sure you have the latest FoxPro and Visual FoxPro ODBC driver, available from I´ve checked that the odbc connection doesn´t open this VFP tables in exclusive mode, and i still have this problem. The only thing i´ve seen works is

From oracle to dbf?
Hi all, we have a customer who has been using a system that stored its data in MS Access. They now want to start using our MS Visual Foxpro software. If you don't have a Remote Connection to the MDB already you'll first get the Connection Designer dialog. Use it to create an new ODBC connection to the MDB.

ODBC with Visual Foxpro 6.0
Given the above, I would choose OLE DB/ADO, especially if you don't have any VFP experience to create a DLL. -- Craig Berntson MCSD, Visual FoxPro MVP Author, What is the difference in performance for these different options: - a VFP dll direct accessing the data - an ODBC connection - OLE/dB connenction

Access 2.0 Data into VFP 6.0
You will need to create an odbc connection to your DBC and then you can use ado to access your data after making the connection with your ADODB.Connection object. Tommy "Sydney Lotterby" <syd...@infosearch.com> wrote in message news:uVqAXWGUCHA.4240@tkmsftngp08... Can I use ADO to access Visual FoxPro .dbf files?

FoxPro6 and MySQL, odbc
The ODBC driver is the Oracle ODBC driver supplied with WIN95 (Microsoft-produced, not an Oracle product). I can create a remote view in Foxpro that accesses a table in the Oracle database, but the data transfer takes forever. I have increased the packetsize of the ODBC connection, but this doesn't seem to have any

ODBC Connect without knowing database
You never actually need to have the FoxPro program anywhere on any computer - just one table to connect to when you configure the ODBC driver. On the server you need to create a folder that will house the data tables. Data tables have data arranged in rows and columns, with the first row bearing the names

fale connect foxpro
In SQL, you have to create the device and database (not the tables, just the database) before upsizing set your ODBC source in the ODBC Data Source Administrator and verify your connection in the Connection Designer in VFP. Sorry if this is asking stuff you already know and have checked, but it's all I could think

ODBC Data Source question
Hello, I have this code below working fine. There are two routines: SetKey and RemoveKey I had to employ these routines to create TEMPORARY primary keys in a Connection Set rs = New ADODB.Recordset 'OPEN ODBC CONNECTION TO ACCESS BARSCAN FOXPRO DATABASE cn.Open "Provider=MSDASQL.1;Data Source=IntegrityDB" cn.

UNKNOWN libwin32-0.27 MSWin32-x86-multi-thread 5.1
I'd suggest creating one and them trying to duplicate it with a different name programmatically. Hope this helps. Michael -----Original Message----- 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

Create Query spanning two different Workspaces? (particularly ...
I have a single Foxpro table which I've created an ODBC connection to using the FOxpro driver donwloadable from microsoft support. I have an OleDB connection to SQL 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,

Remote Confusion - VFP 5.0
I guess the best way for me to handle this is to drop my fox dbc on the ISP, have the ISP create an ODBC connection to it - and then use the tables through ASP. I have no need to manage mail or fpt uploads, nor do I need the foxpro GUI. Plus, I have experience using ASP. I will also try looking for codecharge.

Crystal Reports - Opinions required
... need to just have the "type" of data source - like excel, access, foxpro set up on the first tab (user dsn) of the odbc data source administrator dialog other tutorial did not have me go into this odbc data source dialog box at all, yet i am still able to get to the database when creating the reports. is

Dynamic Data Source for ODBC
Zach, Thanks for the quick response. We have a tool that allows ODBC access to our COBOL files. We are trying to create a database in SQL server. ODBC is just a way to connect to a data source, whether it be SQL, Foxpro, Access, ORACLE or whatever. Moving on to the specifics of your question, if you want detail

Using table index through ODBC
i know that you have to have an odbc connection for the database that you will use with your ¤ application. ¤ ¤ what i don't understand is if you need to just have the "type" of data source - like excel, access, ¤ foxpro set up on the first tab (user dsn) of the odbc data source administrator dialog box.

Cannot create an ODBC Connection
That given, the equivalent SQL statement would be "SELECT User_ID FROM test WHERE User_ID = 1" To execute that in vb, you first have to make a reference to the Microsoft ActiveX Data Objects 2.x Library. You then need to create some objects: Dim cnn As ADODB.Connection Dim rst As ADODB.

FoxPro 2.6 ODBC Connectivity
I have just learned how to connect VFP to backends without an ODBC DSN. I think it simplifies things. You are still using ODBC, but not using a configuration February 20, 2001 2:56 AM Subject: Re: fale connect foxpro Hello Carl : (1)I solved the problem with your way when I create a new table in MySQL .

Visual Foxpro 6 SP3: Null and Empty dates produce errors
Foxpro Create a Remote View, I used the Wizard. Once the view is created, you need to modify its properties. I am using VFP6. following conventions: 1) If we have a screen that is editing a single record (like a customer record) we create a customer object that used ADO to read and write to the ODBC connection.

Wizard to convert FoxPro 2.6 database
We have a tool that allows ODBC access to our COBOL files. We are trying to create a database in SQL server. I need to be able to update this db every night. ODBC is just a way to connect to a data source, whether it be SQL, Foxpro, Access, ORACLE or whatever. Moving on to the specifics of your question,

Create Query spanning two different Workspaces? (particularly ODBC ...
The data is downloaded to the cursor that is in the SORTWORK temp space. One of my commands is to execute the stored procedure to create the table for download. I have tried all the following syntax: ln_CH = SQLCONNECT( "ODBC Connection Name", "USERCODE", "PASSWORD" ) *!* Yes, the Connection Handle is 1 or