There comes a time in every programmers life when the intrinsic Visual Basic data control just isnt enough. Its the point most programmers plunge into the crazy world of COM components, SQL Server and MTS. But the path has traditionally been a difficult one - with no singular publication dealing with every principle. Until now.
Im currently checking out 'Professional Visual Basic 6 Databases', one of the newest Wrox publications that promises to take the reader straight to the enterprise VB-database level.
The book takes off with a general introduction to databases, great for beginners or those wanting to brush up on that enigmatic DB-terminology.
Pace soon quickens however, with talk of the client-server and 3-tier model by chapter two. The book then moves onto data access technologies, covering OLE DB, ADO, ODBC, RDO, DAO, ODBCDirect and any other acronyms that are lying around.
Conversation soon turns to upsizing from a good ol Access database to the grandeur of SQL Server. SQL as a query language is also thoroughly covered, as is the growingly popular ADO object model.
Youll also find the likes of Microsoft Transaction Server (MTS), data warehousing and reports all within the binds of this #35.99 publication.
It's obvious from the very first chapter that youre reading the works of an industry professional that's been there, done that. Author Charlie Williams doesnt just talk theory instead, he constantly relates programming practice to real world uses and how it all fits within the role of your project. He discusses factors you need to consider and highlights the benefits of certain routes experienced notes from the field, if you will - advice rarely given in the traditional textbook.
If you're wanting to jump on that enterprise bandwagon but need to take those database skills to another level, I can personally recommend this excellent Wrox publication. Easy to read and with constant references to real-life applications, this book is a must for all serious VB developers. Seriously!