I have created a db in MS SQL as well as having created some ASP pages using VB
.NET that connect to the MS SQL DB.
I now want to use MSDE as the database engine, so...
I scripted the MS SQL db and then created the MSDE database.
I have also changed the Connection string to use the new MSDE connection.
I can see the database objects (tables, sp's etc) within the Server Explorer tab within the vs solution however...
I cannot connect to the database when running the ASP pages.
The error msg is "SQL Server does not exist or access denied"
My MSDE connection string is 'Data Source=(Local)\IValue;Initial Catalog=IValue;Integrated Security=SSPI'
WHERE the MSDE Instance is IValue and the database is also called IValue.
Any help would be greatly appreciated.