QUESTION POSED ON: 01 July 2004
I'm having a problem executing a query on SQL Server 2000 via ASP. My problem is simple: I am able to execute the query within Query Analyzer without any problems, but when the same statement is executed via the ASP code I receive an access is denied error message.
The query is:
SELECT *
INTO jtest2
FROM
OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt;
*.csv)};DEFAULTDIR=C:temp;Extensions=CSV;',
'SELECT * FROM Contacts.CSV')
|
