Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL 2000 and Prevasive
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...- Linguinut
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Your Opinions
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...- Linguinut
- Post #2
- Forum: Microsoft: ASP.NET
-
SQL 2000 server and FoxPro 2.6
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...- Linguinut
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Converting Linked Server to SQL Database
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...- Linguinut
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
