Posted by Robert G Laurin on July 27, 2011 at 05:58:36:
In Reply to: Re: ODBC versus MYSQL for an connection to an AS400 machine posted by Jim Guerber on July 26, 2011 at 16:06:57:
When you say you could connect the ODBC to Comet32 with the all the limitation, does that include a 252 bytes command string? Or will we benefit from Comet32's larger variables?
Current ODBC works. It is slow, but it works. My biggest beef with it is the 252 bytes command string. It makes it very difficult to write to whatever is at the other end and it also limits query string size (try reading a file with a few AES_ENCRYPTed with 64 or 128 bytes keys).
Query works pretty good, possible to read lots of data in one query - grabbing one record at the time.
INSERT/UPDATE are a bit of a pain because of the record size limitation.
Personally, I love the MySQL interface. It is amazingly fast. Maintaining two separate sources because of some incompatibility is a drag.
I was wondering.... What about the OleDB ? We have a few critical programs that use it - not to talk to a fax driver, but to control AcrobatReader thru the SDK. Unless there's a method for having a Comet program talk directly to a Windows program (Visual Studio).
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.