Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: Error in create sp

    hi every one

    when i want to create a stored procedure that contain character " with a ado component , i receive this error message :

    'Parameter object is improperly defined. inconsistent or incomplete information was provided.'

    but if i create this procedure from query analyzer , this sp creates successfuly.


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    My guess would be that the client side (probably VB) code doesn't properly escape the quotation mark, and since the Transact-SQL doesn't need to escape the quote it isn't a problem there. I'd suggest that you post the VB code you are using so that we can see if that is your problem.


  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    It's the QUOTED_IDENTIFIER setting on connection object vs. your QA. On the client side set this setting to be the same as in QA (in Connection Options menu item in QA).
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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