SQL 2000 server and FoxPro 2.6

[cp84]

I have to import and modify Foxpro 2.6 .dbf files in a .NET application using SQL 2000. Is it best to use "Linked Server" as sugested by MS or can a schema file be used and if so whats the best software to create it.

All replies most appreciated.

 

[Linguinut]

When you say "import and modify", do you mean that you will be storing this data separately? A linked server will update the tables directly. I have a similar setup with a Btrieve application (both FoxPro and Btrieve are using a file system for the database structure). It is rather slow working through a linked server. You may be better off using the OLEDB/ODBC driver to access the files directly. Create the DSN, then in .NET point your ADO.NET connection to this DSN. I also am using the old ADO connections in some of my .NET forms, too. It works just fine.


Linguinut
------------------
Bill Cunnien
ConBrio Consulting

 

[cp84]

Thanks Linguinut, I had been lead to believe that this was not possible and that "Linked Server" was the way to go.
However, I have trawled through my Wrox books but cannot find how to connect to a local System.DSN.

Is this the way you suggest.

Your help much appreciated