Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: need help with asp connection to sql server 2003

    hello
    i am new to ASP. i'm trying to create a small application on my default website on my computer. this application is supposed to connect to an SQL server (which i already have configured) and return rows from a table. but it's giving me an error saying th OLE DB provider for SQL server does nnot exist or acess denied. error numbe is HTTP 500.100
    could anyone help me?
    can u also suggest any online asp tutorials that are trustworty???
    thx

  2. #2
    Join Date
    Jul 2011
    Posts
    1

    Question Tech Architect/DBA/Developer

    I would be glad to help if you can provide an example of the code?

    Here is a link you will want to keep W3Schools ASP Introduction

  3. #3
    Join Date
    Jul 2011
    Posts
    14
    It sounds like you may need to install the OLEDB provider for SQL Server. There isn't an SQL Server version 2003 that I'm aware of, so I'll assume that's the Windows version and guess you're running SQL Server 2005? Make sure that's correct before installing the following:

    Download Details - Microsoft Download Center - Feature Pack for SQL Server 2005 Nov 2005

    If you scroll down you'll see some files SQLServer2005_ASOLEDB9*.msi. Choose the right one for your platform and see if that works.

Posting Permissions

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