Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > BOOK: Expert One-on-One Visual Basic 2005 Database Programming
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Expert One-on-One Visual Basic 2005 Database Programming
This is the forum to discuss the Wrox book Expert One-on-One Visual Basic 2005 Database Programming by Roger Jennings; ISBN: 9780764576782
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert One-on-One Visual Basic 2005 Database Programming section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old February 14th, 2006, 02:02 PM
Wrox Author
Join Date: Feb 2006
Location: Oakland, CA, USA.
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default Fixes for Chapter 1's OleDbDataObjects Project

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.

Note: 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.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 16 Try It Out doesn' t work + Fixes VictorVictor BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 3 December 12th, 2007 09:04 AM
sort - some fixes in my previous Q kgoldvas XSLT 0 July 17th, 2007 09:35 AM
Chapter 10 fixes .MAttButler BOOK: Professional Web Parts and Custom Controls ASP.NET ISBN: 0-7645-7860-X 2 September 3rd, 2006 08:02 PM
Chapter 4 Car project brandsxb VB.NET 2002/2003 Basics 1 September 16th, 2003 02:52 PM
Hot Fixes to Patches Walden SQL Server 2000 2 September 16th, 2003 12:48 PM

All times are GMT -4. The time now is 10:19 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.