Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    165

    Unanswered: OLE/DB provider returned message: Deferred prepare could not be completed

    I'm running SQL Server 2000 and have added a SQL Server Express linked server. I'm using OPENQUERY to query the databases. When I run my query in Query Analyzer, my query executes perfectly. When I call the query in my ASP app, I get this error: OLE/DB provider returned message: Deferred prepare could not be completed. What could be causing this problem? I'm on a domain but I'm using SQL Server logins. Any ideas?

  2. #2
    Join Date
    Mar 2009
    Location
    US
    Posts
    1

    Hi

    Hi Guys,

    Just joined up, thought i would say Hi

    Jenny

  3. #3
    Join Date
    Nov 2004
    Location
    Canada
    Posts
    58
    check your syntax. It sounds like from the error message you are missing a closing apostrophe or something. Maybe the asp code is having an issue ending the open query statement?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •