Microsoft.Data.Odbc.OdbcCommand CommandText MAX length.

Status
Not open for further replies.
P

pkelley

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 >>>
 
K

Ken Slovak - [MVP - Outlook]

Outlook related how?

"pkelley" <pkelley> 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 >>>>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Microsoft Outlook is requesting data from the server Using Outlook 2
Abraham Microsoft limitation !!!! Using Outlook 8
C Outlook 365 Microsoft Support - Please Advise Using Outlook 3
Z New minimum Outlook for Windows version requirements for Microsoft 365/Exchange Online Using Outlook.com accounts in Outlook 25
Y Disable Microsoft Outlook Test Message Using Outlook 5
V Outlook 2021 Microsoft Office Pro Plus 2021 - Inexpensive Lifetime License Using Outlook 0
I Exchange 2019 - MICROSOFT-CORP-MSN-AS-BLOCK Exchange Server Administration 0
D Change Microsoft Account password - what to do to update on all devices Using Outlook 4
D Microsoft Exchange account - Remote management Using Outlook.com accounts in Outlook 1
F Microsoft Outlook Connector 14.0.6123.5001 - Help! Using Outlook 6
R Microsoft Outlook 2016 - Gmail not sending, asks for password for SMTP, tried different ports Using Outlook 23
A Backup Email Accounts On OutLook For Mac 2016 (Microsoft 365 subscription version) Using Outlook 0
M Microsoft 365 Outlook keeps requesting password on Local Account Using Outlook 1
A calendar invites sent from Microsoft Outlook to Mac Outlook is not working Using Outlook 2
N .pst archive from work will not open/import on Microsoft 365 Exchange Server Administration 0
A Microsoft Personal vs Work Accounts in Outlook Using Outlook.com accounts in Outlook 7
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1
S Adding new Exchange (2016) rule very slow down Microsoft Outlook Exchange Server Administration 0
Commodore Microsoft Exchange Add-in Using Outlook 2
C Copy Task to Non-Microsoft PIM "Rainlendar" Using Outlook 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Cannot start Microsoft Office Outlook Error Message Using Outlook 0
J Microsoft Exchange Emails - Shared Accounts Exchange Server Administration 3
R Microsoft Outlook can't translate this document. Using Outlook 1
tswatek Microsoft Outlook has stopped working Using Outlook 13
I Microsoft Security Update KB3097877 Using Outlook 14
R Microsoft Outlook 2010 - Non Cached Mode Using Outlook 0
padubajacket Microsoft Outlook has stopped working Using Outlook 2
E Microsoft Office Outlook 2007 Send Error Using Outlook 11
TotallyConfused Godaddy Microsoft exchange 2007 stopped updating Exchange Server Administration 1
S Outlook 2013 not fixed correctly by Microsoft!! Using Outlook 3
THOMAS BRAXTON Microsoft Office 2010 problems Using Outlook 1
Angger Microsoft Outlook 2010 Automatically Restarting Using Outlook 2
S Microsoft office Cannot complete operation error Outlook VBA and Custom Forms 1
Glyn Outlook Microsoft on a Sony Android Using Outlook 4
R The action cannot be completed. The connection to Microsoft Exchange is unavailable. outlook must be Using Outlook 1
K Outlook keeps prompting for Microsoft username and password for share calendar Using Outlook 0
M connection to the microsoft exchange server has been lost. outlook 2007 Exchange Server Administration 0
D Microsoft Outlook Not Responding Using Outlook 0
G Microsoft Outlook 2010 Add-On Using Outlook 2
J Microsoft Outlook 2007 Font Size Too Small Using Outlook 1
G Cannot start Microsoft Outlook Using Outlook 1
P BCM 2013, Microsoft SQL Server 2008 R2 (SP2), attachment issue n database size BCM (Business Contact Manager) 2
J archiving deleted e-mails on Microsoft Exchange Exchange Server Administration 7
M I cannot start Microsoft Outlook 2013 directly opening a .eml message Using Outlook 1
A "Microsoft Exchange Add-In" (UmOutlookAddin.dll) + Outlook Security Form ... Using Outlook 4
D Zoom in Microsoft Outlook Views? (Not Messages) Using Outlook 2
W Microsoft Mail & 2010 Outlook Using Outlook 1
M Microsoft Outlook Hotmail Connector Error: The text exceeds the limit of 1024 Using Outlook.com accounts in Outlook 1
M Anyone with this Microsoft Outlook issue can help? Using Outlook 1

Similar threads

Top