SQL Server Express and VB6 (by yag)

Published 27 October 04 09:05 AM

Scott Swigart over at 3Leaf has posted a blog entry titled "SQL Express: The Little Engine that Could". In it, he shows how the great new capabilities of SSE can be used by VB6 developers instead of Jet (Access) databases.

My only response to this is "yup!" <g>. SQL Server Express is one of the projects I've most enjoyed working on in this release. The ability to have a database that is XCOPY deployable, that can be connected to via a file path, that will run as Normal User and needs no upgrading to work under SQL Server is awesome . Before I came to Microsoft, one decision we often had to make was how to support both local data stores and SQL Server as the application grew or moved to a larger office. SSE now gives us the best of both worlds - the ease of Access or Fox data files, with the simple movement to SQL Server.

by vsdata
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# vgblog@thegillfamily.us (vern) said on October 27, 2004 11:11 AM:
I can't find anything on MS's website that discusses moving db's from MSDE to SSE. Is this going to be "seamless"? I have never even tried moving a db from MSDE to SQL Server, so I have no base for comparison.
# Jürgen Wondzinski said on October 28, 2004 8:33 AM:
So, if this is such an exiting and easy to deploy puppy, why isn't it included in the upcoming VFP9 version?
# yag said on October 28, 2004 9:32 AM:
Simple answer, Woody. VFP9 is shipping before SQL Server Express does. So, VFP9 will ship with the latest version of MSDE - and you'll be able to do a free download of SQL Express when it ships.

yag
# yag said on November 1, 2004 4:27 PM:
You should be able to simply detach the database from MSDE and use it for SSE.

yag
# DienBaQuan said on November 10, 2004 9:18 PM:
Please to show me using vb6 to rename a SQL server column name?
I'm looking forward to receiving from your reply!
Regard

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required

This Blog

Syndication

Page view tracker