Professional Web Applications Themes

Problems connecting to SQL from ASP page - ASP Database

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 ...

  1. #1

    Default Problems connecting to SQL from ASP page

    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.

    Shawn Guest

  2. #2

    Default Re: Problems connecting to SQL from ASP page

    On Fri, 18 Jun 2004 12:11:59 -0700, "Shawn"
    <anonymousdiscussions.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
    Jeff Cochran Guest

  3. #3

    Default Re: Problems connecting to SQL from ASP page

    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"
    ><anonymousdiscussions.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 Guest

  4. #4

    Default Re: Problems connecting to SQL from ASP page


    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"
    >><anonymousdiscussions.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 Guest

  5. #5

    Default Re: Problems connecting to SQL from ASP page

    "Shawn" wrote in message news:1eb4101c45620$a60823b0$a101280aphx.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 Doentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
    MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]


    Roland Hall Guest

Similar Threads

  1. Problems connecting to FMS 2
    By tawse in forum Macromedia Flash Flashcom
    Replies: 7
    Last Post: March 22nd, 08:41 PM
  2. Problems connecting to the SQL database (2)
    By reidarT in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 10th, 07:07 PM
  3. problems connecting to database from outside.
    By David in forum ASP Database
    Replies: 6
    Last Post: July 12th, 09:00 PM
  4. Problems connecting to .asp page
    By j d in forum ASP Database
    Replies: 1
    Last Post: October 13th, 09:22 PM
  5. Replies: 4
    Last Post: July 13th, 01:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139