Post reply

ODBC - Select works Update does not

  • December 27, 2002 at 10:04 am

    #64093

    I have successfully connected to SQL Server 2000 Personal Edition using an ODBC driver. I can use the SELECT statement but UPDATE, INSERT and DELETE all fail with a message "3001, invalid parameter". I have verified the SQL statements work in Query Analyzer. I have change the user to SA to make sure no security limitations are present.

    Any ideas?

    Thanks

  • December 30, 2002 at 8:00 am

    This was removed by the editor as SPAM

  • December 30, 2002 at 9:01 am

    #445249

    Dificult one without some additional information.

    First of all, do you have a 'parameter' in your select statements WHERE clause, and does that work without problems?

    When you are updating, inserting or deleting are you trying to do something with strings? In that case, you should check the settings for the QUOTED_IDENTIFIERS for your ODBC connection or use single quotes for your strings.

    If that does not work, post (piece) of your code.

  • December 30, 2002 at 12:41 pm

    #445274

    I have changed the quote identifiers and the updates are now working. I haven't checked inserts yet but expect the same result.

    Thanks,

Viewing 4 posts - 1 through 3 (of 3 total)

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