How to Handle BLOBs via ODBC ?
eferreyra needed to store .doc and .pdf files in Informix via ODBC from a Clarion 5.0 application; FILETOBLOB worked over JDBC but ODBC returned a Not implemented message (IDS 7.31 in production, 9.40 in development). Marco Greco noted smart blobs do not exist in IDS 7 and environments should have comparable versions. Jonathan Leffler advised using BYTE blobs, which Informix ODBC should handle.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database, the scenario is: production enviroment: IBM Informix Dynamic Server Version 7.31.FD8 on SunOS 5.9 development enviroment: IBM Informix Dynamic Server Version 9.40.UC7 on Red Hat Enterprise Linux 2.6.9-5.ELsmp Applications acces via ODBC to this databases, i try send FILETOBLOB function but always get an "Not implemented yet" message, via JDBC works, but is not an option (applications are Clarion 5.0 made) Some suggestion ?
eferreyra wrote: > Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database, > the scenario is: > > production enviroment: IBM Informix Dynamic Server Version 7.31.FD8 on > SunOS 5.9 > development enviroment: IBM Informix Dynamic Server Version 9.40.UC7 on > Red Hat Enterprise Linux 2.6.9-5.ELsmp > > Applications acces via ODBC to this databases, i try send FILETOBLOB > function but always get an "Not implemented yet" message, via JDBC > works, but is not an option (applications are Clarion 5.0 made) > > Some suggestion ? Well, although I'm sure you are getting the -999 on your development environment, and thus the next comment does not apply (yet), I thought I'd save you a considerable amount of wasted time anyhow - smartblobs are not a feature of 7. In general it is a good idea to have development, test and production environment on at least comparable versions. As for the -999 on ODBC vs no error on JDBC, I'd say that the argument list you are passing to FILETOBLB differs in the two cases, but it's hard to point you in the right direction without seeing some hard SQL. Not that I'm asking to see some, if you see what I mean... -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm
ok, thats why i put the ids 7 version in the mail. Now how i can handle the storing of files in IDS 7 via ODBC ? Or should i use other DBMS ? E. Ferreyra Marco Greco ha escrito: > eferreyra wrote: > > Hi, i need to store "files" (.doc, .pdf, etc.) in an informix database, > > the scenario is: > > > > production enviroment: IBM Informix Dynamic Server Version 7.31.FD8 on > > SunOS 5.9 > > development enviroment: IBM Informix Dynamic Server Version 9.40.UC7 on > > Red Hat Enterprise Linux 2.6.9-5.ELsmp > > > > Applications acces via ODBC to this databases, i try send FILETOBLOB > > function but always get an "Not implemented yet" message, via JDBC > > works, but is not an option (applications are Clarion 5.0 made) > > > > Some suggestion ? > > Well, although I'm sure you are getting the -999 on your development > environment, and thus the next comment does not apply (yet), I thought I'd > save you a considerable amount of wasted time anyhow - smartblobs are not a > feature of 7. > > In general it is a good idea to have development, test and production > environment on at least comparable versions. > > As for the -999 on ODBC vs no error on JDBC, I'd say that the argument list > you are passing to FILETOBLB differs in the two cases, but it's hard to point > you in the right direction without seeing some hard SQL. Not that I'm asking > to see some, if you see what I mean... > > > -- > Ciao, > Marco > ______________________________________________________________________________ > Marco Greco /UK /IBM Standard disclaimers apply! > > Structured Query Scripting Language http://www.4glworks.com/sqsl.htm > 4glworks http://www.4glworks.com > Informix on Linux http://www.4glworks.com/ifmxlinux.htm
eferreyra wrote: > ok, thats why i put the ids 7 version in the mail. > > Now how i can handle the storing of files in IDS 7 via ODBC ? Use BYTE blobs instead. Informix's ODBC should handle them; it pre-dates version 9 of IDS (IUS). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/