Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-13 : 06:34:40
|
| mrinal writes "When I execute this script:---Read Text using OpenRowSetselect * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\External;','select top 5 * fromMytext.txt')I get this error:-Server: Msg 7415, Level 16, State 1, Line 2Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access this provider through a linked server.How do I resolve this access issue?" |
|
|
|
|
|
MSDASQL