p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   All Other Wrox Books (http://p2p.wrox.com/forumdisplay.php?f=116)
-   -   Problem with SQL Server (http://p2p.wrox.com/showthread.php?t=2503)

ne0 August 6th, 2003 07:18 AM

Problem with SQL Server
 
Hi,
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
ne0


RbH August 6th, 2003 12:12 PM

The connection string looks OK. Are you sure the SQL Server service is running on Watcher? And is Watcher either your PC or on your local network?


All times are GMT -4. The time now is 08:29 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.