MSDE SQL Connection String Error

Hi;


Installed MSDE on computer by running:





c:setup INSTANCENAME="VSdotNET" SAPWD="PASSWORD" SECURITYMODE=SQL





REBOOTED AND sql SERVER iCON APPEARS on the lower desktop Icon bar, open it and it says:


Server: JOHN Servises: SQL Server Running \JOHN - MSSQLServer





opened a command prompt at c: and


entered osql -S JOHN -U sa -P password


and got the 1> reply on the next line





I typed EXIT





I had downloaded two scripts that create Pubs and Northwind SQL databases. I put them in the C: folder





I Typed at c:osql -E -i instpubs.sql





It created the pubs SQL database for me





I Typed at c:osql -E -i instnwinds.sql





It created the nwinds SQL database for me





I closed the command prompt and


went to the Administrator Tools in the Control Panel


I selected Data OLEDB Selected ADD entered Pubs and used default values for Pubs to create a connection Tested it OK





Then went and ran Visual Studio Net 2003


Checked to see if the pubs and northwind SQL databases where present in the Server Explorer drop down window.


I seleced the connect to database Icon and in it's Data Link Properties


I entered JOHN for server name


pubs for selected database on the server


with Provider as MS OLEDB for SQL Service


the Icon changed to connected.





I entered this in the code for page_load





Dim MyDS As New DataSet


Dim ConnStr As String


Dim SQL As String


ConnStr = "server=(local)C:Program FilesMicrosoft SQL ServerMSSQLData;database=pubs;Trusted_Connection=yes"





SQL = "SELECT * FROM Titles " & _


"SELECT * FROM Publishers"


Dim MySqlConn As New SqlConnection(ConnStr)


Dim MySqlAdapter As New SqlDataAdapter(SQL, ConnStr)





'The SqlDataAdapter will automatically open and


'close the SqlConnection


MySqlAdapter.Fill(MyDS)





But I can not get this to work it errors out on line:





MySQLAdapter.Fill(myDS)





with: [SqlException (0x80131904): Unknown ProviderError Locating Server/Instance Specified ]


System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317





I change ConnStr to this:





ConnStr = "server=(local)data;database=pubs; uid=sa; Pwd=password" & _


"Trusted_Connection=true"





and get this error:


[SqlException (0x80131904): Shared Memory Provider: The system cannot find the file specified.


]


System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317





I've tried so many combination with and without user and password, I just don't get it, spent three long days stuck here, can someone help me out.





Note:


C:Program FilesMicrosoft SQL ServerMSSQLData


Is the accual location on my machine that pubs database is located.





I can use the pubs SQL database in Web Matrix OK.


Thanks


pdqjohnny@hotmail.com