can not connect to msde
Hi ,
I installed MSDE from my ofice 2002 CD. I did not set up my password and my user id is still at default "sa". I am trying to connet to my database just as mentioned in wrox book "begining ASP 3.0".I just can not connect to MSDE from my ASP page and keep geting this error.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
**********
My code is asp to connect is
objConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=iffo;Data Source=local;Initial File Name=D:\Program Files\Microsoft SQL Server\MSSQL\Data\iffo.mdf"
************
I wrote this code exactly as it was given in this wrox book, only thing I am not sure here is that I don't know what that Catalog means, I am assuming it is also the name if the database
thanks
|