Wrox Programmer Forums
All Other Wrox Books Do you have a question about a Wrox book that isn't listed anywhere on p2p.wrox.com or where the forum is locked? Here's a forum to post questions about any other Wrox book so that other readers or one of the authors can help you with your questions. IF YOU ARE LOOKING FOR CODE DO NOT ASK "Where can I find the code for this book?" That question is answered here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the All Other Wrox Books section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #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

  #2 (permalink)  
Old August 6th, 2003, 12:12 PM
RbH RbH is offline
Registered User
Join Date: Aug 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

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?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sql Server Problem monika.vasvani SQL Server 2000 2 December 14th, 2006 03:09 PM
Facing problem with Sql server dsekar_nat SQL Server 2000 2 July 27th, 2006 02:52 PM
problem in with sql server Hussainrahmani ASP.NET 1.0 and 1.1 Basics 0 October 12th, 2005 06:04 PM
SQL Server Problem! Jane SQL Server 2000 1 October 12th, 2004 08:52 PM
sql server syntax problem mateenmohd SQL Server 2000 3 June 23rd, 2003 07:31 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.