How To Enable Ah Hoc Query In SQL 2000

Hi guys

 I have a program which imports data into sql server from csv files. This program uses the something like this

 

CREATE PROCEDURE MyImport

(

@FileName AS VARCHAR(200)

)

AS

SET NOCOUNT ON

DECLARE @SQL VARCHAR(4000)

SET @SQL = ' SELECT *

FROM OpenRowset(''MSDASQL'', ''Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:;'', ''SELECT * FROM ' + QUOTENAME(@FileName) + '' + ''') as t

'

EXEC (@SQL)

 

when i excute this i get a permission error saying the account i specified in the web config doesn't have rights to run these type of scripts. I tried using the sa account which works. But its not recommended to setup applications to access the database using the sa account.

i did some research and i found out that yon can actually enable that by change a registry key. But i cant find the MSDASQL datasource under ms sql server providers in the registry.

Any other ways i can enable this?