View Single Post
  #1 (permalink)  
Old August 6th, 2003, 07:18 AM
ne0 ne0 is offline
Registered User
Join Date: Jul 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with SQL Server

I'm still a beginner with ASP and SQL. When a try to connect to a SQL server I get this error :
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
I know that the SQL Server has to be configured, but I don't know how ( I's running Win XP SP1 and IIS 5.1). I've searched at Google, but I didn't find anything that solves my problem.
 This is the connection string which I use to connect to the SQL : strConn = "Provider=SQLOLEDB; Data Source=WATCHER; " & _
            "Initial Catalog=pubs; User Id=davids; Password=whiskey"
(this is a sample from one of the Wrox books)
How to solve the problem ?
With many thanks