[dba-SQLServer] [dba-VB] MyMovieCollection database

John W. Colby jwcolby at colbyconsulting.com
Mon Sep 5 08:54:31 CDT 2005


I cannot attach the database using enterprise manager.  When I try to do so,
it opens a find dialog, which I use to find the movie database.  As soon as
I select the database, I get an "attach as" down in the bottom of the
dialog, but it is "hardwired" for D:\... Which is a CD drive on my laptop.
If I attempt to change the D:\ to C:\ the "OK" button grays out and I am no
longer allowed to continue.

So little time, so much time wasted trying to get Microsoft stuff to work.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Monday, September 05, 2005 9:34 AM
To: bheid at appdevgrp.com; dba-vb at databaseadvisors.com; SQLServer
Subject: [dba-VB] MyMovieCollection database


The starter kit for VB Express called MyMovieCollection appears to be
working, however one of the fields in the SQL Server database is too short -
the WebPageLink field.  This database is used by the application but AFAICT
I am not given any tools to work with the database itself.  If this were in
Access I would just open it and modify the length of the field and be done,
but this is SQL Server.

Can anyone tell me how to "attach" to this SQL Server database using SQL
Enterprise manager so that I can make the mod necessary to allow this to
work?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Monday, August 29, 2005 11:33 AM
To: dba-vb at databaseadvisors.com
Subject: RE: [dba-VB] VB.Net - RSS reader - I have success...


Cool!  Thanks John.

Bobby

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Wednesday, August 24, 2005 7:11 PM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] VB.Net - RSS reader - I have success...


Well, I have a vb.net program reading an rss feed and storing fields in a
table.  Cooool stuff.  When I'm finished massaging the code I'll post it to
show how I did it.

John W. Colby
www.ColbyConsulting.com 

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com




_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com







More information about the dba-SQLServer mailing list