Jim Lawrence (AccessD)
accessd at shaw.ca
Sat Jul 17 11:31:37 CDT 2004
Hi Marty: Fine piece of investigation. I was just about to install SQL Empress on my 2003XP server, one with SQL 2000/EM and would have lost the manager. I wondering if there is a work around as I was hoping to have an application put together using Access2003 or VB.Net and SQL Express, by the end of the summer. Looks like that will not be possible for a while. I guess if the application is assembled, using SQL2000, the table structure/SP etc.. should be portable to SQL Express, on a XP box and Express. A little off topic: I have been trying to find some info on reporting capabilities of VB.Net...does it have any or does it require a third-party product like VB6? Has anyone worked or found a good site with code related to extending VB.Net grid capabilities? Any suggestions will be appreciated. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of MartyConnelly Sent: Saturday, July 17, 2004 8:48 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Some quick install notes and warnings on SQL Express2005 SQL Express 2005 is Yukon and replacement for MSDE. However, like MSDE, SQL Express does not have any administrative interfaces. Review the installed documentation and its own BOL to learn more about SQL Express. They are supposed to bring out a Beta EM, backward compatible with MSDE. Some notes I have picked up that may help. 1------------------------------------------------- SQL Express can't run on XP Home, so what is the purpose? One of the purposes for SQL Express is deployment with applications instead of JET. Now the software companies involved have to force their clients to buy XP Pro???? Arrrghhhh! There are rumors you may be able to modify TCP ports to get around this. System Requirements for Express http://lab.msdn.microsoft.com/express/sysreqs/ 2 -------------------------------------------------- FAQ: Installing SQL Express side by side with SQL 2000 Enterprise Manager seems to break EM. It is still broken when You uninstall Express. SQLDMO9 is culprit. http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172956.aspx http://blogs.msdn.com/sqlexpress/archive/2004/07.aspx 3 ------------------------------------------- I noticed that the DTS Runtime will not be included. In Access, you get the DTS Runtime when you install MSDE. Does this mean that DTS will not be available in Access? Currently, I use DTS to interact with SQL Server databases hosted at ISPs. It is a quick and easy solution to use the DTS Wizard to upload data from the Access database to the SQL Server database using bulk insert. I would hate to see that go away. 4 ------------------------------------------------- SQL Server Express does not have any connection limits. 4GB max size It doesn't install any test databases but there is a sample pubs database script install from download pages. I think you can install side by side with MSDE but you will break EM 5.-------------------------------------------------- SQL Server 2000 Reporting Services fails after installing SQL Server 2005 Fix here http://blogs.msdn.com/sqlexpress/archive/2004/07/07/175820.aspx -------------------------------------------------------------------- Welcome to the Visual Web Developer 2005 Express Edition Beta Guided Tour http://beta.asp.net/GuidedTour/s2.aspx Beta Private newsgroup -- good for problems microsoft.private.sqlserver2005.express http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl cid=us Express overview http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/ sseoverview.asp -- Marty Connelly Victoria, B.C. Canada _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com