Microsoft.Data.Odbc.OdbcCommand CommandText MAX length.

Below is an example of a VERY long SQL command generated by an Add-In.
My question is does anyone know if there is a maximum size imposed by either
the Microsoft.Data.Odbc.OdbcCommand field or the
Microsoft.Data.Odbc.ExecuteNonQuery() command?

I'm afraid if the query gets too big, an OdbcExcpetion will be thrown. Not
sure what the limit is?

<<<< SQL Example SNIP >>>

INSERT INTO dtens_lqm_fw_queues_budgetstoryqueue_v1_cls.TransferQueue
(Action, EventName, EventLocation, FromEmail, Attendees, EventStartDate,
EventStopDate, Memo, ExchUniqueId) VALUES ('CHANGE', 'Here''s the Media
Story', 'Mtns, Utah', 'Paul.Kelley@place.com', 'Paul.Kelley@place.com;',
'8/21/2009 2:00:00 PM', '8/21/2009 2:30:00 PM', '<<ABCSTORY>>
Min Story Depth:5
Max Story Depth:12
Budget Summary:Here’s a budget summary
Edition Name:Daily Experience
Page Name:Back
Department Name:News
Event Name:Inauguration Day
Run Date:01/20/2009
<<ABCSTORYEND>>
********************
<<ABCMEDIA>>
Media Type:Photo
Number of Photos:12
Budget Run Date:03/01/2009
Event:s
Edition:s
Contact Name:gg
Contact Phone:555-4444
Address:123 Street
City:Provo
State:Utah
Directions:There and back again.
Notes:Some notes
Story Name:Some story name.
<<ABCMEDIAEND>>
',
'040000008200E00074C5B7101A82E00800000000D0F6740E6822CA01000000000000000010000000B2D52BAB53A87544B5553FD249066739')

<<<< SQL Example END >>>>

Outlook related how?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"pkelley" <pkelley DeleteThis @discussions.microsoft.com> wrote in message
news:CFEB8AC8-6974-4C56-9A81-A45B1AAFB5B5@microsoft.com...
> Below is an example of a VERY long SQL command generated by an Add-In.
> My question is does anyone know if there is a maximum size imposed by
> either
> the Microsoft.Data.Odbc.OdbcCommand field or the
> Microsoft.Data.Odbc.ExecuteNonQuery() command?
>
> I'm afraid if the query gets too big, an OdbcExcpetion will be thrown.
> Not
> sure what the limit is?
>
> <<<< SQL Example SNIP >>>
>
> INSERT INTO dtens_lqm_fw_queues_budgetstoryqueue_v1_cls.TransferQueue
> (Action, EventName, EventLocation, FromEmail, Attendees, EventStartDate,
> EventStopDate, Memo, ExchUniqueId) VALUES ('CHANGE', 'Here''s the Media
> Story', 'Mtns, Utah', 'Paul.Kelley@place.com', 'Paul.Kelley@place.com;',
> '8/21/2009 2:00:00 PM', '8/21/2009 2:30:00 PM', '<<ABCSTORY>>
> Min Story Depth:5
> Max Story Depth:12
> Budget Summary:Here’s a budget summary
> Edition Name:Daily Experience
> Page Name:Back
> Department Name:News
> Event Name:Inauguration Day
> Run Date:01/20/2009
> <<ABCSTORYEND>>
> ********************
> <<ABCMEDIA>>
> Media Type:Photo
> Number of Photos:12
> Budget Run Date:03/01/2009
> Event:s
> Edition:s
> Contact Name:gg
> Contact Phone:555-4444
> Address:123 Street
> City:Provo
> State:Utah
> Directions:There and back again.
> Notes:Some notes
> Story Name:Some story name.
> <<ABCMEDIAEND>>
> ',
> '040000008200E00074C5B7101A82E00800000000D0F6740E6822CA01000000000000000010000000B2D52BAB53A87544B5553FD249066739')
>
> <<<< SQL Example END >>>>