The server must define a stored procedure, sp_mda, to indicate whether or not it supports the ct_send_data routine sending only text or image data without a SQL command. sp_mda is called only if the CS_SENDDATA_NOCMD connection property is set prior to logging in to the server.
If the server can receive text or image data without a SQL command, sp_mda returns:
Parameter |
Value |
---|---|
mdinfo |
“SENDDATA_NOCMD” |
querytype |
2 |
query |
senddata no cmd |
Adaptive Server cannot receive image or text data
without a SQL command.