Hello all,

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.
Phil.

Um... I believe this is a MySQL forum, not a MSSQL forum...

----------
---Snib---
----------

<><

Is MySQL not the same as MSDE??

Oh, no, not at all.

The MSDE, the Microsoft Data Engine is a limited version of Microsoft's SQL Server, without the front end tools.

MySQL is an open source database, that runs on lots of different platforms.


You may be better of in the SQL Server forum.

That said, are you sure the instance name of your MSDE installation is IValue? It's odd that the server has the same name as the database. How did you install MSDE?

You may also want to check that you are allowed to access the server with the ASPNET account. Do you have something like the Enterprise Manager to connection to your MSDE installation?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.