I have been using Thearon Willis's book 'Beginning Visual Basic 2005 Databases' to learn about using SQL Server 2005 Express instead of Access 2000, which database I have used in the past, and as a hobbyist programmer, I have found the book very useful indeed.
At the outset, I have to admit that instead of using the project in the book, I am trying to adapt the methods to an old project of my own which used Access 2000 as its database. At first everything worked fine and I found a whole new way of dealing with Data Access using the WBAccess base class.
However, when I tried to migrate my database to SQL as described in Chapter 8, I ran into a number of problems mainly brought on by the fact that I am using the Express Editions of both Visual Basic 2005 and SQL Server 2005. Some of these problems, such as Windows Authentication, I managed to solve by reading through the threads opened by some of the contributors to this forum but one I can't solve:-
I created an empty SQL Server database using Visual Basic 2005 Express, which works differently from the process descibed in Chapter 1. (This included 14 tables , primary keys and relationships!) Unfortunately VB
Express appears to produce something called a User Instance, which I don't really understand, and as such, I can't connect to it through the usual Server - (local)\SQLExpress - in the migration program. I have tried using the Server Management Studion Express to attach the empty SQL database to my Server but without success. No doubt, had I been following the text in your book to the letter and created the ProjectTimeTracker database, the same problem would have arisen.
I would appreciate any help you can offer to allow me to continue to explore the rest of this excellent book.