If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > need help with asp connection to sql server 2003

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-01-11, 04:07
alice926 alice926 is offline
Registered User
 
Join Date: Jul 2011
Posts: 1
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
Reply With Quote
  #2 (permalink)  
Old 07-01-11, 12:20
ehauffen ehauffen is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 07-18-11, 01:33
BrianSteffens BrianSteffens is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On