On Thu, 26 May 2005 04:47:15 GMT, "Jozef" <NO****@NOSPAM.com> wrote:
I'm just wondering if anyone here uses MSDE, and if so, do you use ODBC or
is there a better way to connect? I'd like to start using it just because
of it's scalability if nothing else, but would like to know more about it
from experienced developers.
Any help is appreciated.
I've used MDSE with both ADPs and MDBs using ODBC, and it works great. The
only problem is that you don't get the SQL Server client tools. Using an ADP
to manage a server database can replace some of what the client tools would
do, but far from all of it.
Many Microsoft developer packages (such as Access 2002 and Office 2002
developer editions) include the Microsoft SQL Server Developer edition, you do
get the client tools with that, and those client tools can manage an MSDE
server just fine. Note that the license will not allow you to use the
developer edition server in your production environment, so you'll still have
to use MSDE for that until you scale up to the SQL Server standard edition.