Accessing VFP 6 Tables from SQL Server 2000 - DTS/Import Wizard

[Stewart Lane]

I am running SQL server 2K on XPSP2 and VFP 6. I downloaded and installed the
vfp odbc driver available from:

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

This page lists the driver under vfp 7. I am using 6.

I am getting an error during the import wizard which doesn't help me much to
solve the problem. The error dialog reads:

Error Source: OLE DB Provider for ODBC Drivers
Error Descript: [microsoft][odbc visual foxpro driver]sourceDB
Context: errror during initialization of the provider.

I get the same error whether I try to connect to a folder with a DBC or a
folder with free tables.

If you know of a solution to my problem, I'd appreciate some help.

I am trying to load a SQL server table with the data from a single dbf file.
I've already created the empty sql table with fields that exactly correspond
to the vfp DBF table.

Thanks in advance,
Stewart

[Dan Freeman]

Have you tried to go the other direction? Create a remote view on your SQL
database, then INSERT records into it and call Tableupdate().

Dan

Post by Stewart Lane
I am running SQL server 2K on XPSP2 and VFP 6. I downloaded and
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
This page lists the driver under vfp 7. I am using 6.
I am getting an error during the import wizard which doesn't help me
Error Source: OLE DB Provider for ODBC Drivers
Error Descript: [microsoft][odbc visual foxpro driver]sourceDB
Context: errror during initialization of the provider.
I get the same error whether I try to connect to a folder with a DBC
or a folder with free tables.
If you know of a solution to my problem, I'd appreciate some help.
I am trying to load a SQL server table with the data from a single
dbf file. I've already created the empty sql table with fields that
exactly correspond to the vfp DBF table.
Thanks in advance,
Stewart

[Stewart Lane]

No, I have not. I was trying to get use to DTS. I plan to port an
application to VB.NET and SQL Server from VFP. I figured I might as well get
used to the tools available in Enterprise Manager that comes with SQL Server.

I do appreciate your reply and will try your suggestion.

If anyone else can lend a hand with the error, I'd appreciate it.

I think I'll try posting this over in a SQL/DTS forum too.

Stewart

Post by Dan Freeman
Have you tried to go the other direction? Create a remote view on your SQL
database, then INSERT records into it and call Tableupdate().
Dan

Post by Stewart Lane
I am running SQL server 2K on XPSP2 and VFP 6. I downloaded and
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
This page lists the driver under vfp 7. I am using 6.
I am getting an error during the import wizard which doesn't help me
Error Source: OLE DB Provider for ODBC Drivers
Error Descript: [microsoft][odbc visual foxpro driver]sourceDB
Context: errror during initialization of the provider.
I get the same error whether I try to connect to a folder with a DBC
or a folder with free tables.
If you know of a solution to my problem, I'd appreciate some help.
I am trying to load a SQL server table with the data from a single
dbf file. I've already created the empty sql table with fields that
exactly correspond to the vfp DBF table.
Thanks in advance,
Stewart