Post reply

Large string of exec's

  • May 7, 2002 at 4:23 am

    #101141

    I have come accross an issue where a large batch / string of exec commands passed in to SQL Server using OLE DB from VB is getting truncated. We have tried setting the packet size but that didn't work.

    Does anyone know how to get around this restriction?

    Thanks

  • May 7, 2002 at 5:18 am

    #428574

    Can you post an example of a string and how you setup your connection, command, and recordset objects?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • May 7, 2002 at 5:35 am

    #428576

    I have found the problem...

    The data been processed contained char(0) characters that caused this type of error. Well, a character 0 I think is end of string or statement character so when SQL processed the string, it came accross a char(0) forcing this error.

    Thanks anyway

    Deon

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

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