Problems connecting to SQL from ASP page

[Shawn]

I'm having the weirdest problem. I have just installed
sql server (msde), vs.net on my laptop. I copied all my
databases and websites to the IIS directory so I can serve
the pages. I'm getting the error below. When I try to
view the pages, I get this error. I read the aspfaq and
tried each of the hostnames in the connection string and
they did not work. Is it something i may be over looking,
maybe the IUSR_ account or something. Anyhow, any and all
help would be appreciated.

Shawn

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.

[Jeff Cochran]

On Fri, 18 Jun 2004 12:11:59 -0700, "Shawn"
<anonymous@discussions.microsoft.com> wrote:

>I'm having the weirdest problem. I have just installed
>sql server (msde), vs.net on my laptop. I copied all my
>databases and websites to the IIS directory so I can serve
>the pages. I'm getting the error below. When I try to
>view the pages, I get this error. I read the aspfaq and
>tried each of the hostnames in the connection string and
>they did not work. Is it something i may be over looking,
>maybe the IUSR_ account or something. Anyhow, any and all
>help would be appreciated.
>
>Shawn
>
>Microsoft OLE DB Provider for SQL Server (0x80004005)
>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
>exist or access denied.

Show your connection string. This is normally a permission error, but
it may be you're trying to access a server that really isn't there.
Take a look at connection strings:

[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

Jeff

[Shawn]

Here's the connection string I am using:
--------------
MyConnStr = "provider=SQLOLEDB; network=DBMSSOCN;
server=myserver;"
MyConnStr = MyConnStr & "database=mydb;
uid=myusername; pwd=mypassword;"
set ADODBConn = Server.CreateObject
("ADODB.Connection")
ADODBConn.open MyConnStr
---------------

Any and all help would be appreciated. The sql server
msde and windows xp pro (IIS) are on the same machine.

>-----Original Message-----
>On Fri, 18 Jun 2004 12:11:59 -0700, "Shawn"
><anonymous@discussions.microsoft.com> wrote:
>

>>I'm having the weirdest problem. I have just installed
>>sql server (msde), vs.net on my laptop. I copied all

my

>>databases and websites to the IIS directory so I can

serve

>>the pages. I'm getting the error below. When I try to
>>view the pages, I get this error. I read the aspfaq

and

>>tried each of the hostnames in the connection string

and

>>they did not work. Is it something i may be over

looking,

>>maybe the IUSR_ account or something. Anyhow, any and

all

>>help would be appreciated.
>>
>>Shawn
>>
>>Microsoft OLE DB Provider for SQL Server (0x80004005)
>>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does

not

>>exist or access denied.

>
>Show your connection string. This is normally a

permission error, but

>it may be you're trying to access a server that really

isn't there.

>Take a look at connection strings:
>
>[url]http://www.able-consulting.com/ADO_Conn.htm[/url]
>
>Jeff
>.
>

[Shawn]

OK, fixed it. I removed this network=DBMSSOCN; and it
worked. What does the DBMSSOCN do?

Thanks for your help.

Shawn

>-----Original Message-----
>Here's the connection string I am using:
>--------------
> MyConnStr = "provider=SQLOLEDB; network=DBMSSOCN;
>server=myserver;"
> MyConnStr = MyConnStr & "database=mydb;
>uid=myusername; pwd=mypassword;"
> set ADODBConn = Server.CreateObject
>("ADODB.Connection")
> ADODBConn.open MyConnStr
>---------------
>
>Any and all help would be appreciated. The sql server
>msde and windows xp pro (IIS) are on the same machine.
>

>>-----Original Message-----
>>On Fri, 18 Jun 2004 12:11:59 -0700, "Shawn"
>><anonymous@discussions.microsoft.com> wrote:
>>

>>>I'm having the weirdest problem. I have just

installed

>>>sql server (msde), vs.net on my laptop. I copied all

>my

>>>databases and websites to the IIS directory so I can

>serve

>>>the pages. I'm getting the error below. When I try

to

>>>view the pages, I get this error. I read the aspfaq

>and

>>>tried each of the hostnames in the connection string

>and

>>>they did not work. Is it something i may be over

>looking,

>>>maybe the IUSR_ account or something. Anyhow, any and

>all

>>>help would be appreciated.
>>>
>>>Shawn
>>>
>>>Microsoft OLE DB Provider for SQL Server (0x80004005)
>>>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does

>not

>>>exist or access denied.

>>
>>Show your connection string. This is normally a

>permission error, but

>>it may be you're trying to access a server that really

>isn't there.

>>Take a look at connection strings:
>>
>>[url]http://www.able-consulting.com/ADO_Conn.htm[/url]
>>
>>Jeff
>>.
>>

>.
>

[Roland Hall]

"Shawn" wrote in message news:1eb4101c45620$a60823b0$a101280a@phx.gbl...
:
: OK, fixed it. I removed this network=DBMSSOCN; and it
: worked. What does the DBMSSOCN do?

Obviously it keeps it from working! (O:=

Network=DBMSSOCN" tells ODBC to use TCP/IP rather than Named Pipes
[url]http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q238/9/49.ASP&NoWebContent=1[/url]

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]