View Single Post
  #1 (permalink)  
Old February 4th, 2004, 09:34 AM
isheikh isheikh is offline
Authorized User
 
Join Date: Feb 2004
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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