MYBLOB_DEMO - Demonstrate the use of the MYBLOB tool kit
MYBLOB_OPEN - Open the connection to a MySQL database
MYBLOB_COMMAND - Send an SQL statement to a MySQL database
MYBLOB_FROM_DB - Retrieve a blob (binary large object) from a MySQL database
MYBLOB_TO_DB - Send a blob (binary large object) to a MySQL database
MYBLOB_CLOSE - Close the connection to the MySQL database
* Install MyODBC from www.mysql.com * Insert your own MySQL database parameters in myblob_demo.m
* Run myblob_demo
When running myblob_command, i get the following error.
Error using COM.ADODB_Recordset/Open
Invoke Error, Dispatch Exception:
Description: The connection cannot be used to perform this operation. It is either
closed or invalid in this context.
Help File: C:\WINDOWS\HELP\ADO270.CHM
Help Context ID: 12ee52
Nice. I was wondering if anybody has tried to write to a BLOB not from a file but directly from a Matlab matrix variable? Say, a 5x5 double matrix? Skip writing to a .mat and reading back out of the file to save time?
@Lucy: Matlab 2008b seems to work with the MySQL ODBC 3.51 Driver and the MySQL ODBC 5.1 Driver. If you want to use the MySQL ODBC 5.1 Driver you have to change line 22 in myblob_open.m from
'driver=MySQL ODBC 3.51 Driver; ' ...
'driver=MySQL ODBC 5.1 Driver; ' ...
06 Oct 2008
using Matlab 2008a and MySql 5.0 for Win32:
??? Invoke Error, Dispatch Exception:
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error in ==> myblob_open at 40
Error in ==> myblob_demo at 26
connection = myblob_open (user, password, server, database);
08 May 2008
Beware, this only seems to work on windows.
20 Sep 2006
nice, just what I was looking for.
23 Jun 2006
Works well, even if you don't need blob capability.