Hi!
I have some problem on chapter 08 from book
Proffesional Active Server Pages 3.0
I type default.asp then click to one of two links
*Using the Connection Object
That give me links to another default.asp page which is
in connection folder. There are two files, defalut.asp
and Connection.asp
I click on "Create a Connection Object" and I got
these msg:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNMPNTW]Specified SQL server not found.
/wrox/Chapter 08/Connection/Connection.asp, line 23

I checked file Connection.asp line 23 and there are:
"conPubs.Open strconn"

I didnt see any specific information what should i do
before try that example. Is there anything i missed to make
that example works?
Any help will appreciated!

At some point, (I don't have the book handy) you are told to define the sqlserver name. Check where strConn is defined and make sure the name of YOUR sqlserver is in there.



Hal Levy
Daddyshome, LLC

Thanks, but i am not so sure sqlserver name is a problem. These are
example codes:

<%
Dim conPubs

Set conPubs = Server.CreateObject("ADODB.Connection")

conPubs.Open strConn

If ConPubs.State = adStateOpen Then
   Response.Write "Connection to " & conPubs.DefaultDatabase & " created succeassfully"
else
   Repsonse.Write "Connection failed"
end if

conPubs.Close

set conPubs = Nothing

%>

Again,

in your sample you put: strConn is defined somewhere. Your problem is with the contents of strConn. It's not pointing at your database server.

Hal Levy
Daddyshome, LLC

I think you got the point Hal!
I just checked chapter 08 and there is two file. one is default.asp,
second which have definition of strConn Connection.asp These are codes of connection.asp:
<% strConn = "Provider=SQLOLEDB; Data Source=WATCHER; " & _
            "Initial Catalog=pubs; User Id=davids; Password=whiskey"
%>
I create in sql 7.0 database named WATCHER, but something is still wrong.
I got same message. Anyway, i know whats wrong thank you for your help