viewpoint-particle

Author Topic: SQL Linked Server - lessons learned  (Read 1585 times)

stanl

  • Pundit
  • *****
  • Posts: 793
SQL Linked Server - lessons learned
« on: January 14, 2014, 05:42:01 am »
I plan to post scripts showing how to create a linked server to SQL Server Express 2008 R2 (link an access db) - with two CLR classes, System.Data.OleDb and System.Data.SqlClient

But first, lessons learned.  (1) I was not really dedicating time to the scripts. Just tried to quickly adapt a working COM/ADO script. (2) I relied too much on C# and Powershell scripts, and seemed to think that o = ObjectClrNew("System.Data.SqlClient") was appropriate, therefore confusing the namespace with a class (an assumption based on looking at C#) (3) I do know the difference between synchronous and asynchronous.... and by looking into both the OLEDB and SQLClient classes, see that the latter supports asynchronous which begin with "Begin".

I expect to be writing scripts for a real SQL Server (not my local Express) so there is a lot more testing as I want to link/unlink local Access and Excel files to perform specialized queries combing Server and local data.

I feel like a lot of the young people today who say "I know how to drive, but I'm used to automatic, and the standard shift confuses me".  Been spoiled by successes with COM.

the end