maillist at kkendrick.net
maillist at kkendrick.net
Tue Sep 6 20:42:45 CDT 2005
John, I don't remember how I happened upon this link, but perhaps it will help with your problem. 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 Kay -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, September 06, 2005 7:16 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] MyMovieCollection database AFAIK EM does indeed work with the express version if you own EM, which I do. In fact however you can alter the table structure from right inside of the VB project. I am still getting an error however so... No clue what is happening at this point. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Tuesday, September 06, 2005 5:05 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] MyMovieCollection database John, Since it is the "Express" version, you are out of luck. There is no UI. EM will not work with SQL Express. The best thing to do is to create the ALTER TABLE statements and use ADO to execute them against the database. Robert _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com