Chapter 1's OleDbDataObjects.sln project has a couple of problems that affect users who haven't installed SQL Server 2005 Developer or higher client tools:
1. SQL Server 2005 Express (SSX) doesn't install SQLXML 4.0, despite Adam Weiner's inference in an XMLTeam blog post that it does (http://blogs.msdn.com/xmlteam/archiv...27/485719.aspx
). Thus, I've modified the source code to CopyLocal Microsoft.Data.SqlXml.dll, which enables compiling the project when you're running SSX. The project won't run in this case, because the underlying SQLXML 4.0 COM object isn't installed. See the comments in the Main.vb
file regarding changes for SSX users.
There's no redistibutable for SQLXML 4.0, so you'll need to download SQLXML 3.0 SP3 from MSDN (http://www.microsoft.com/downloads/d...displaylang=en
) and install it, if you haven't installed the client tools for SQL Server 2005 Developer edition or higher. Bear in mind that SQLXML 3.0 doesn't implement the new features of SQLXML 4.0.
2. I accidentally built the updated version for the WROX site with a later version (8.0.50926) of the Visual Basic compiler than the RTM version. The later compiler is for the VB
-LINQ January Technical Preview. Unless you've installed the VB
-LINQ preview bits, you'll receive an error when you run the project (after making the preceding fixes, if necessary.) There's more info on VB
-LINQ at http://oakleafblog.blogspot.com/2006...s-january.html
If you can successfuly build the project from the WROX site's version with Ctrl+Shift+B, you can usually overcome this problem.
The updated version of the OleDbDataObjects.sln project from the OakLeaf FTP site includes fixes for the preceding problems. Due to the long lead time to update the WROX download site, these fixes haven't been applied to that ZIP file. If you want an updated version of the project, send mail to Roger_Jennings@compuserve.com
and I'll provide a file that contains this project only.
This message is part of my blog post at http://oakleafblog.blogspot.com/2006...ual-basic.html
and my Amazon Connect plog.