SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard Goof's Avatar
    Join Date
    Feb 2001
    Location
    Pittsburgh, PA
    Posts
    1,154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Weird SQL Server Error

    Hey guys, I'm getting this weird DB error in an ASP application:
    Code:
    Error Type:
    Microsoft OLE DB Provider for SQL Server (0x80004005)
    [DBNMPNTW]ConnectionOpen (CreateFile()).
    From looking on the web, it looks like this has to do with authorization if you use an NT account to access the database, but I'm using an SQL account and my other 20-30 SQL connections (which use the EXACT same connection string) run without a problem. The only thing that I could think of is that maybe my OLEDB drivers aren't up to date on my web server (they're 2.5 SP2, and 2.6 SP2 Refresh is the version that matches my SQL Server 2000 SP2 install). I'm going to try updating them, but does anyone else have any clue why this one connection won't work?

    Thanks,
    Goof
    Nathan Rutman
    A slightly offbeat creative.

  2. #2
    SitePoint Wizard Goof's Avatar
    Join Date
    Feb 2001
    Location
    Pittsburgh, PA
    Posts
    1,154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Problem solved! Upgrading to MDAC 2.6 SP2 Refresh worked wonderfully. I wish Microsoft would have just told me that!

    Goof
    Nathan Rutman
    A slightly offbeat creative.


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
  •