on 2012 Sep 11 8:01 PM
When I run a an insert statement with a large "contents" value I get an error "Could not execute statement. Server 'DirectoryServer': No such file or directory SQLCODE=-660, ODBC 3 State="HY000"
Anybody know why I'm erroring out? This happens when "contents" value is over 3000.
Does it work when you assign the file contents to a LONG VARBINARY variable and then use that variable within the insert, such as:
begin declare myBlob long varbinary; set myBlob = 0x5768656E20492072756E206120616E20696E736<skipped>206572; Insert into DBA.Attachments(Contents, File_Name) values (myBlob, 'test.txt'); end;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, that was just wild guessing - similar to that proxy table question... but Mark will know:)
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.