Friday, February 17, 2012

Connecting VB Express files to SQL Server Management Studio Express

Really confused ... I created 2 tables in a VB Express program (which went well). Problem is that I can't see/find those tables with MSME. I don't really understand how to connect the MSME to where the tables are. I created the tables under \My Documents\Data and they are DBapp.mdf + DBapp_log.LDF and the tables are Items and Preferences. The VB application can "see" the tables OK.

Do I need to move the tables to C:\Program Files\Microsoft SQL Server\MSQL.1\MSQL\DATA (like the Adventureworks installation which I haven't done) or what?

Please help a newbie

Thanks

George

Are you suing a user instance or a server attached instance ? If you are not sure post the connection string here, that we can see which method you are using. If you are using a user instance, you won′t see them in the managment studio unless you attach the database to the server. Visual Studio can also make them viewable in the Server Explorer.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

The express products can only use the sql express system if it is installed as a instance name called ".\SQLEXPRESS". Also when it does create files it creates them as a user instance. This means that the files are not attached to the actuall engine untill the application starts. If you do want to use these database files from the SQL Management Studio you will have to attach these to the engine. To do this I would copy the files to another directory (Say c:\Data" and then from the Management Studio under the databases tab right click and select attach....

No comments:

Post a Comment