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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distributed ado query problem

Status
Not open for further replies.
LucieLastic

LucieLastic

Programmer
May 9, 2001
1,694
GB
hi

Trying to run a distributed sql query in an TADOQuery. I'm using Delphi 7 and SQL Server 2000. The sql is using OPENROWSET. The query runs perfectly from within Query Analyser but when run from within Delphi I get the following error message:

'Deferred prepare could not be completed'

I have the Prepared property set to TRUE. Does anyone know what's causing this and how I can fix it?

Many thanks in advance,
lou

www.radbmx.co.uk
 
Status
Not open for further replies.

Similar threads

WolfstarUA
  • Locked
  • Question
Filtering AdoTable + dbrichedit
Replies
1
Views
508
DjangMan
DjangMan
Baldur3635
  • Locked
  • Question
Changing a Query at Runtime
Replies
16
Views
2K
Baldur3635
Baldur3635
s_s_s
  • Locked
  • Question
sql problem
Replies
2
Views
465
DjangMan
DjangMan
Baldur3635
  • Locked
  • Question
I have a problem with a DBGrid
Replies
2
Views
562
DjangMan
DjangMan
Baldur3635
  • Locked
  • Question
Now I really DO have a problem, - Sorting
Replies
3
Views
523
Baldur3635
Baldur3635

Part and Inventory Search

Sponsor

Back
Top