Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE/DB provider returned message: Unspecified error

Status
Not open for further replies.
StuWilson

StuWilson

Programmer
Oct 10, 2001
9
0
0
CA
I have 2 databases one in SQL server 2000 one in Access and I Have linked the Access DB into Sql Server Database as a linked server.

I can run the following query in SQL Server Query Analizer
and get no errors.

"SELECT fieldX FROM tblSqlServer
UNION
SELECT fieldX FROM ACCESSERVER...tblAccess"


However when I try to run the same query in an Active server page I get this error.

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

[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Unspecified error]"

Any help would be appreciated

 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
58
Virendra Yaduvanshi
Virendra Yaduvanshi
Auguy
  • Locked
  • Question
Move SQL DB to the Cloud and Access it From a .Net Program
Replies
0
Views
41
Auguy
Auguy
new_to_sql
  • Locked
  • Question
Access SQL Query Error
Replies
5
Views
83
dhookom
dhookom
Cpreston
  • Locked
  • Question
Do not understand Error message
Replies
4
Views
44
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top