SQLOLEDB error using ASP and SQL 7

SQLOLEDB error using ASP and SQL 7

Post by Davi » Fri, 06 Dec 2002 09:26:06



I get the following error using this asp generated SQL command:

error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc access to OLE DB
provider 'SQLOLEDB' has been denied. You must access this provider
through a linked server.

/1.asp, line 30

Line 30 is the open statement: rs.Open q, Application("DINO_SQL")
q = SELECT ii.* FROM OPENROWSET('SQLOLEDB', 'DINO;dino_sql;abc123',
'SELECT * FROM DINO.dbo.T_ICMS_IMPORT' ) AS ii