Blob using SQLPutData: getting Function Sequence Error

Blob using SQLPutData: getting Function Sequence Error

Post by Dwight Barke » Sat, 05 Feb 2000 04:00:00



I'm trying to use the SQL_LEN_DATA_AT_EXEC and SQLPutData to iteratively put
in pieces of Blob data.  I've tried a lot of different combinations of
statements and orders of things, nothing has worked so far.  I usually am
getting back "function sequence error" but when I look at the trace, the
order seems correct.

Do I have to pass a length value with SQL_LEN_DATA_AT_EXEC to use Jet and
SQL Server?  I've seen examples using 0, or SQL_DATA_AT_EXEC.

I'm running out of ideas.  I've looked all over, read, tried all kinds of
things.  About ready to just forget it and use multiple rows to store
multiple pieces of data, but jeez, what a pain.  Does this stuff work?
Anybody have suggestions of anywhere else to look?

 
 
 

1. Function Sequence Error using ODBC ->SQL

I keep getting a function sequence error when I do a simple "Select *
from TableName" from my VB 3.0 program.  All the permissions seem to be
set right, and I can run the same query logged in as the same ID in the
Object manager.  I've searched my help files and looked on Microsoft's
web site, but still no luck.  Anyone have a suggestion or two?

Jeff

2. Paradox query question...

3. sqlputdata and sqlgetdata with Blob field in SQL server

4. ORA-27069

5. ODBC error:S1010: [Microsoft][ODBC SQL Server Driver]Function sequence error

6. How to read Transaction Log???

7. Protocol error in TDS stream and Function sequence error in SQL 7.0 SP2

8. ISBN coding and book titles wanted

9. ODBC Error - Function sequence error

10. ODBC error: "function sequence error"

11. Rollback Error: Function Sequence Error with Sql Server 6.5 Database

12. MS Access sql error [Function sequence error]

13. JDBC Data type error returned: Function sequence error?