Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Wrox Announcements and Feedback > All Other Wrox Books
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 6th, 2003, 07:18 AM
ne0 ne0 is offline
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

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

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?
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:58 PM.


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