Mon premier blog

Microsoft Inside Ole 2 Kraig Brockschmidt
Publisher: Microsoft Press

However I created the linked server through which I can access Specifically, an OLE DB data source points to the specific database that can be accessed using OLEDB. Number: $80040E14 Source: Microsoft OLE DB Provider for SQL Server Description: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "CMSLIVE" was unable to begin a distributed transaction. The file format signatures used by these tools don't distinguish different types of MS Office files, so when I run foremost for example, I end up with a directory of file names with the generic ".ole" extension: # ls 00003994.ole Updated 2/17/02., Last Saved By: Hal Pomeranz, Name of Creating Application: Microsoft Excel, This example exercises one of my pet peeves: piping grep into awk. I was unable to do it since MS SQL provides only two non SQL Subscriptions/Publishers options. HelpFile: HelpContext: $00000000 SQLState: 42000 (no accepted answer; only answer doesn't help); How to Insert into remote table using Linked server withint Transaction? A really smart guy, Kraig Brockschmidt, wrote a book called Inside OLE and did this while on the DRG payroll. Great article, thank you very much. The question I have is how to pull data from mySql and directly insert into Sql Server table? DRG bought and gave away tons of these books to try and I think you will see more and more “mini-microsoft” voices screaming louder to make sure these things get into that DNA. Let's try and create MySQL linked Server on MS SQL . Microsoft will still compete with you, your mom, dad, sister, uncle, and dog if there is money on the table. Note: The workbooks as a data source from inside the farm scenario works in the way when using the Microsoft OLE DB provider for Analysis Services (MSOLAP).