Read a SQL xXpress Created Database

Thanks for the advice. I deleted the exe and re worded my question :

Hi All,

I am a newbie. I am using SQL SERVER EXPRESS ( Free Version ) and the
Free version of VB.net 2005. I have created a Database inside the VB.net
IDE and can use it with the program fine. How do I view this same database
with another program ? I found the Database viewer and I can't seem to get this program to read the database. I am not sure what the connection
values should be using this program to read a mdf file created by SQL EXPRESS.

Fo Instance my when I login to SQLSERVER express management console the dialog box uses the following :

Server Type : Database Engine
Server Name : MATPM\SQLEXPRESS
Authentication : Windows Authentication
User Name : myname
Password :

This database view app I found shows a SQL dialog box like below

User Name : sa
Password:
Database :
SQL Server:

What do I do here ? I had put the path to the *.mdf file and all combinations
and I can't open the database. I can use database explorer in VB.net to create databases and alter them. What does it use as a connection string ?
How do I access databases created by visual studio. I want to write a program that uses databases and I want a VB program to switch between them and create new ones. Is there a sample program here someplace.

Nick

Hi hspc,

Thanks for your response although I am still a bit confused as to the order of things. So what you are telling me is that a "Databse" must be attached to the Sql Server before it can be opened ? How does VB.net open it as it wasn't attached until I just did it as you instructed ?

Here is the code snippet that builds the Database connection string :

Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0" & _
"Data Source=" & Me.database & "" & _
"Jet OLEDB:System database=" & SQLServer & "User ID =" & userName & "Password =" & password & ""
m_sConnectString = connString
database.connectString = connString
connectedFlag = database.Connect()

It will look nothing like the string example you gave. I gues what I am asking is how can I open or change or create databases under VB.net control. Suppose I wanted to write a program that keeps track of DVD movies. I want to be able to create and load multiple databases and manipuate them via a VB.net program. Do you know of any sample apps that show how this is done? I thought it was like when you create a text file. Many apps open the text file.

Thanks in Advance,

Nick

No SQL is correct. This sample program shows that it can connect to either and apparently the logic is incorrect and perhaps that is why the program will not connect to the SQL express database ? This sample I could not get to compile so I am stuck with the EXE in the zip I found it from.
I am going to try to write my own using the connection string method that you outlined. I will keep you posted. Maybe it is the program and not what
I was entering. Thanks...