[AccessD] Microsoft SQL Server 2005 Express Edition

MartyConnelly martyconnelly at shaw.ca
Wed Nov 9 10:41:41 CST 2005


You have to watch out for a few problems because of the replacement of 
SQL-DMO by SMO which may cause a conflict

Download SQL Server Management Studio Express instead of old Express 
Manager if you are using latest version of Express CTP
http://msdn.microsoft.com/vstudio/express/sql/default.aspx


FAQ: How to connect to SQL Express from "downlevel clients"(Access 2003, 
VS 2003, VB 6, etc(basically anything that is not using .Net 2.0 or the 
new SQL Native Client))
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

FAQ: Installing SQL Express side by side with SQL 2000 Enterprise 
Manager seems to break it,
Because of changes in the SQL Server 2005 metadata we have updated 
SQLDMO, the new version is SQLDMO9, it should work with SQL Server 
7/2000 and 2005. For backwards compatibility it is installed by SQL 
Express so that existing DMO apps should just work. Due to the way that 
SQLDMO is versioned, only one version can exist on a machine at one 
time, so when Express is installed the SQLDMO9 version is the one that 
is registered
http://blogs.msdn.com/sqlexpress/archive/2004/07/04/172956.aspx

SMO Replaces SQL-DMO

http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=40993&DisplayTab=Article

Dan Waters wrote:

>It sounds like if I wanted to use a released version 2005 Express BE to an
>Access FE, and a customer already has SQL Server 2000 full version, then the
>two applications should not conflict.  Does this sound correct?
>
>Thanks,
>Dan Waters
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Josh McFarlane
>Sent: Wednesday, November 09, 2005 8:49 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Microsoft SQL Server 2005 Express Edition
>
>On 11/9/05, Dan Waters <dwaters at usinternet.com> wrote:
>  
>
>>John - what is the problem with 2005 Express?  Is there a discussion of
>>    
>>
>this
>  
>
>>you could point to, or has this been your experience?
>>
>>Thanks,
>>Dan Waters
>>    
>>
>
>Microsoft Visual Studio Beta products were not designed to be
>"side-by-side" installations. If you installed them with other
>previous products it would corrupt one of the installations.
>Supposedly this was for the beta builds only, but it wouldn't surprise
>me if there was a bug and some of the incompatibility seeped into
>Express Release.
>
>--
>Josh McFarlane
>"Peace cannot be kept by force. It can only be achieved by understanding."
>-Albert Einstein
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list