Hi Robert,

Have you tried the FoxPro and Visual FoxPro OLE DB data provider,
downloadable from msdn.microsoft.com/vfoxpro/downloads/updates ? A typical
OLE DB data provider connection string (in VB) looks like:

connString = "Provider = VFPOLEDB.1; Data Source = C:\Temp;"

You can only work with Visual FoxPro ODBC or OLE DB in a 64-bit environment
in compatibility mode. There are no plans to create a 64-bit FoxPro ODBC
driver or OLD DB data provider. I'm told there will, however, be a .NET data
provider for FoxPro.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
[email]cindy@cindywinegarden.com[/email]


"Robert Hooker" <rhooker@noemail.noemail> wrote in message
news:ONrcPwV7GHA.4476@TK2MSFTNGP04.phx.gbl...
[color=blue]
> It actually fails here:
> dbConnection.Open();[/color]
[color=blue][color=green]
>> "ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support
>> this function"[/color][/color]
[color=blue][color=green]
>> try
>> {
>> string connectionStatement = "Driver={Microsoft Visual FoxPro
>> Driver};SourceType=DBF;SourceDb=C:\\temp";
>> string createTableStatement = "CREATE TABLE [c:\\temp\\test]
>> FREE(field1 C(10), field2 C(10), field3 C(10))";
>>
>> OdbcConnection dbConnection = new OdbcConnection(connectionStatement);
>> dbConnection.Open();[/color][/color]
[color=blue][color=green]
>> How can I get my program to work in Vista (32 and 64bit)?[/color][/color]