Good morning!
1) Create a data source on the server that points to the Pervasive database (Pervasive ODBC drivers included on the CD's, or download from Pervasive, I think).
2) Create a linked server using the new data source.
3) Query data from the linked server using the openquery command...
Hi Jim,
Our conversion to ASP.NET is ongoing. And it is worth it. There are so many pros to the new technology. We have both ASP and ASP.NET pages running side-by-side with really no discernable difference in server load (we are converting page-by-page (not as bad as you might think)). Now...
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...
I have numerous stored procedures using the OPENQUERY method to select/insert/update data within a linked server. The application/database I am connecting to is a BTRIEVE database. Recently, I purchased an upgrade of the application so that it will run on SQL Server rather than BTRIEVE (a very...
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.