The Client-side of SQL Server in SBS 2003 [Windows Small Business Server 2003 Best Practices book excerpt]

Folks – this is the infamous ‘da purple book and I am the author. Each day I post up a passage as a virtual book reading – yee-haw!

The Client Side

The client side speaks to the wide range of applications that use SQL Server, including:

                      Third-party applications, such as Microsoft Great Plains account­ing software.

                      Microsoft Access running on the SBS user’s workstations.

                      Microsoft Excel spreadsheets that link to databases housed on an SBS server machine running SQL Server.

                      Microsoft Visual Basic-created applications that use SQL Server. These are typically homegrown applications written by either an employee at an SBS site or a consultant to use data stored and managed by SQL Server.

                      Other applications. I’ve seen a wide range of applications, including Microsoft Excel, Word, and PowerPoint, that access a SQL Server database to extract and place data. The advanced pivot table feature in Microsoft Excel works very nicely with SQL Server-based data.


BEST PRACTICE: Client-side applications typically connect to SQL Server (running on the SBS server machine) via the following database application program interfaces (APIs):

                      Open database connectivity (ODBC). ODBC is the connector by which many front ends running on the clients (a.k.a. client applications) connect to the SQL Server database. I’ll show you ODBC in action shortly.

                      Object linking and embedding (OLE). OLE, in English, is what I like to think of as copy-and-paste kept alive. When you paste data from one source to another and you change the data back at the source, it’s automatically updated at the destination you created. With respect to SQL Server, imagine a Microsoft Excel spreadsheet containing financial information from a SQL Server­


 Visit for additional SMB and SBS book, newsletter and conference resources.

Chapter 14 Database Management With SQL Server 2000

based table. The financial information changes in the table and the Microsoft Excel spreadsheet is updated automatically. Plain and simple!

                      ActiveX Data Objects (ADO). This is a connector that, among other things, provides record-level access to VSAM, AS/400, and PDS data

                      Remote Data Objects (RDO). RDO provides a framework for using code to create and manipulate components of a remote ODBC database system.

                      XML. Enough said!




Harry Brelsford, CEO at smb nation

Microsoft Small Business Specialist SBSC, MBA, MCSE, MCT, MCP, CNE, CLSE, CNP

PS – did u know I host a technology conference in the New York City area each spring? Save the date for March 6-8, 2009 and watch “voice meet data” in the SMB space!

PPS – my SBS 2008 book will be out in mid-November 2008!

PPPS – my Microsoft Response Point Primer book is here NOW!


Leave a comment

Filed under Book

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s