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.
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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.