Professional Web Applications Themes

OLE Error when connect to Sqlserver2000/Windows 2003 - ASP Database

Hi all, I have a ASP application using MDAC 2.52 and running on a NT4 server. The application connects easily to SQLServer2000 running on a w2k0 server. But it doesn't work on SQLServer2000 on a w2k3 server. - The error message is : "Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Access denied. " - Using osql or isql, the connection works fine. - I suspect a problem with MDAC 2.5 Does anybody have an idea ? Thanks for your help RJP The code is : " aconDB.Provider = "SQLOLEDB" aconDB.Properties("Data Source").Value = "SQLServer name" aconDB.Properties("Initial Catalog").Value = "database ...

  1. #1

    Default OLE Error when connect to Sqlserver2000/Windows 2003

    Hi all,

    I have a ASP application using MDAC 2.52 and running on a NT4 server.
    The application connects easily to SQLServer2000 running on a w2k0 server.
    But it doesn't work on SQLServer2000 on a w2k3 server.

    - The error message is :

    "Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNMPNTW]Access denied. "

    - Using osql or isql, the connection works fine.

    - I suspect a problem with MDAC 2.5

    Does anybody have an idea ?

    Thanks for your help
    RJP

    The code is :
    "
    aconDB.Provider = "SQLOLEDB"
    aconDB.Properties("Data Source").Value = "SQLServer name"
    aconDB.Properties("Initial Catalog").Value = "database name"

    'Connexion NT
    'aconDB.Properties("Integrated Security").Value = "SSPI"

    'Connexion SQL Server
    aconDB.Properties("User ID").Value = "username"
    aconDB.Properties("Password").Value = "password"

    aconDB.ConnectionTimeout = 20
    aconDB.CursorLocation = adUseClient
    aconDB.Open
    "
    rjp Guest

  2. #2

    Default OLE Error when connect to Sqlserver2000/Windows 2003

    Hi all,

    I have a ASP application using MDAC 2.52 and running on a NT4 server.
    The application connects easily to SQLServer2000 running on a w2k0 server.
    But it doesn't work on SQLServer2000 on a w2k3 server.

    - The error message is :

    "Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNMPNTW]Access denied. "

    - Using osql or isql, the connection works fine.

    - I suspect a problem with MDAC 2.5

    Does anybody have an idea ?

    Thanks for your help
    RJP

    The code is :
    "
    aconDB.Provider = "SQLOLEDB"
    aconDB.Properties("Data Source").Value = "SQLServer name"
    aconDB.Properties("Initial Catalog").Value = "database name"

    'Connexion NT
    'aconDB.Properties("Integrated Security").Value = "SSPI"

    'Connexion SQL Server
    aconDB.Properties("User ID").Value = "username"
    aconDB.Properties("Password").Value = "password"

    aconDB.ConnectionTimeout = 20
    aconDB.CursorLocation = adUseClient
    aconDB.Open
    "
    rjp Guest

  3. #3

    Default Re: OLE Error when connect to Sqlserver2000/Windows 2003

    >- The error message is : 

    Try:

    Why do I get database-related 80004005 errors?
    http://www.aspfaq.com/show.asp?id=2009

    Jeff
    Jeff Guest

Similar Threads

  1. Replies: 1
    Last Post: June 7th, 01:23 AM
  2. MXML and IIS 6 (windows 2003) Server Error
    By ScoMac in forum Macromedia Flex General Discussion
    Replies: 6
    Last Post: July 21st, 10:42 PM
  3. Soap Clientes can't connect to Windows 2003
    By Farrusco in forum ASP.NET Web Services
    Replies: 0
    Last Post: September 28th, 06:29 PM
  4. Windows 2003 IIS error
    By Morne in forum Windows Server
    Replies: 1
    Last Post: June 18th, 07:02 AM
  5. Error when attempting to connect to VS.net 2003 ASP.NET
    By Daniel O'Connell in forum ASP.NET Web Services
    Replies: 1
    Last Post: December 9th, 08:59 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