Linked Server

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc access to OLE DB
provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this
provider through a linked server.
I got the above error while acessing a database, what can be the problem ?
can any assist in this error message ? Thank alot.
Hi
Try
SELECT <column lists> FROM ServerName.DataBase.dbo.Table
I assume you have already created a linked server.
"kcThong" <kcThong@.discussions.microsoft.com> wrote in message
news:313C084F-1FAA-4DD2-99D4-CF94E3E47FD0@.microsoft.com...
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc access to OLE DB
> provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this
> provider through a linked server.
> I got the above error while acessing a database, what can be the problem ?
> can any assist in this error message ? Thank alot.
>
|||KC,
Or if you'd prefer not to create a linked server (sp_addlinkedserver) you
can alternately use the OPENROWSET function for one time operations. For
more information see:
http://msdn.microsoft.com/library/de...oa-oz_78z8.asp
HTH
Jerry
"kcThong" <kcThong@.discussions.microsoft.com> wrote in message
news:313C084F-1FAA-4DD2-99D4-CF94E3E47FD0@.microsoft.com...
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc access to OLE DB
> provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this
> provider through a linked server.
> I got the above error while acessing a database, what can be the problem ?
> can any assist in this error message ? Thank alot.
>