Post reply

error 8180 - statement could not be prepared

  • November 30, 2009 at 8:38 am

    #71888

    users accessing a SQL2000 SP4 database via access97 are receiving ODBC - call failed error.

    profiling their access I can see error 8180 - statement could not be prepared.

    does this just mean what it seems to suggest - the statement is invalid in some way or something more than that.

    the query it is attempting to run looks good to me -

    SELECT "dbo"."tblCustomers"."Customer ID" FROM "dbo"."tblCustomers"

    this query would return 1.4 million rows if successful!

    It works using access2003.

    any suggestions?

    ---------------------------------------------------------------------

  • November 30, 2009 at 8:56 am

    #1085469

    Is that the only error or is it followed by an error 107 as well?

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • November 30, 2009 at 10:03 am

    #1085519

    cheers for the reply seth.

    there is no error 107. there are error 208's though.

    ---------------------------------------------------------------------

  • November 30, 2009 at 10:17 am

    #1085529

    Hrm... while your problem does not exactly fit this, it's a close enough parallel that the work around proposed for this might be worth trying.

    http://support.microsoft.com/kb/936223

    Is it an option to attempt to drop and re-create the linked server with a different provider?

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • November 30, 2009 at 10:49 am

    #1085565

    not sure thats closely enough related Seth. This is SQL 2000 throughout and communication is not via a linked server.

    ---------------------------------------------------------------------

  • November 30, 2009 at 10:54 am

    #1085572

    You're still using ODBC drivers coming the other way though aren't you? Via system DSN's? It's definitely not an exact match the article and you're probably right, it's likely not the issue, it was just the only thing I could dig up.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • December 1, 2009 at 6:34 am

    #1085741

    Seth, I think we broke SSC yesterday. After your post no more could be added for a couple of hours at least!

    It could be worth recreating their ODBC connection, I'll give it a go.

    ---------------------------------------------------------------------

  • December 1, 2009 at 7:20 am

    #1085778

    Hah, you're not kidding. It was like a 7 hour dry spell across all the forums I watch. I figured it had to be actually broken, that's way too long.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • December 18, 2009 at 9:52 am

    #1094139

    Did you ever figure this one out George?

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply