关于oracle的blob和access的ole对象

meduke 2014-04-15 06:05:23

oracle的blob和acess的ole都是保存图片文件的二进制数据，到时候需要二者互相转换。
这个应该是可以实现的吧，有什么需要注意的地方吗？

...全文

181 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

meduke 2014-04-17

打赏
举报

引用 3 楼 guwei4037 的回复:

肯定没问题。主要你保存的时候没有发生“数据截断”之类的情况，才读出来就能还原成原来的图片。然后再以二进制流的形式保存到oracle肯定可以。

ok 这几天又被其他事情给占用了。我也要找个时间自己去试一下

全栈极简 2014-04-15

打赏
举报

肯定没问题。主要你保存的时候没有发生“数据截断”之类的情况，才读出来就能还原成原来的图片。然后再以二进制流的形式保存到oracle肯定可以。

本拉灯 2014-04-15

打赏
举报

没问题的呀，用程序转是可以的。

meduke 2014-04-15

打赏
举报

我感觉应该是可以的，但是查了资料很多地方说不行。你把图片转为2进制保存到blob中去，再把它读出来，实在不行你先把读出来的数据保存成一张图片，然后access读取你保存的图片，在转为2进制保存到ole中去。这样应该是可以的吧。但是效率一定很低

包 adodb_toolbox 允许通过 Microsoft 的 ADO（ActiveX 数据对象）OLEDB 组件与不同类型的数据库进行通信。该软件包旨在用于 Microsoft SQL Server、Oracle、Microsoft Access、MySQL 和其他数据库。这个包可以连接到十几种不同的数据库类型，执行各种不同的查询类型，并将结果转换为 MATLAB Struct 数据结构以及常规单元表。 Matlab结构输出使用的格式与xml_io_tools和csv2struct库使用的格式相似。支持读取和写入 BLOB 对象。这个包可以被研究、修改、定制、重写和在其他包中使用，没有任何限制。包含并记录了所有代码。软件是根据BSD许可（随附）分发的。

除unidac外我愛用的一套，可存取不同資料庫，取代掉BDE，僅供各位同好試用，喜歡的話請購買支持開發者。 SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland/CodeGear/Embarcadero Delphi v.5 - 10, 2010, XE-XE10 and C++Builder v.5 - 2010, XE-XE10. It uses the native application programming interfaces to access to the following SQL-servers: IBM DB2 Universal Database Informix Server Interbase/Firebird Server Microsoft SQL Server MySQL Server Oracle Database Server PostgreSQL Server SQLite Database Sybase Adaptive Server Enterprise and Adaptive Server Anywhere Unify (Centura, Gupta) SQLBase Server ODBC datasources OLEDB datasources Using of SQLDirect Component Library gives you the following advantages: connecting to the following SQL servers using 32-bit native application programming interfaces (API): Centura SQLBase Server 6(+), IBM DB2 Universal Database with CAE v5.2, Informix Server 7.2(+), Firebird, Interbase, MySQL 3.23(+), Oracle Server 7.2(+) with SQL*Net 2.2(+), Microsoft SQL Server, PostgreSQL 7.1(+), SQLite, Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open Client, which is supported by Anywhere ver.6 as native interface), ODBC and OLEDB datasources. no distributing, installing and configuring the BDE or ODBC simultaneous access to the supported servers using Delphi 5, 6, 7, 9(2005), 10(2006), 2007, 2009, 2010, XE-XE7 or C++Builder 5, 6, 2006, 2007, 2009, 2010, XE-XE7 (Pro and above) to develop Client/Server applications query with an updatable result set query with macro support table component thread safe BLOB-fields (including LOB and BFILE for Oracle8) stored procedure support (with mutiple result sets for IBM DB2, Microsoft and Sybase SQL Server) bi-directional and unidirectional result sets cached updates record filtering support of data-aware components InfoPower support using images stored by Centura SqlWindows(or Team Developer) in their proprietary format interfaces (public methods and properties) of SQLDirect components are compatible with standard BDE data access components (TSession, TDatabase, TQuery ..). Thread Safety Note Thread safety is supported by the following software: Oracle SQL*Net 2.3 or above Centura SQLBase Ver. 7 or above IBM DB2 Ver. 5.2 or above Microsoft SQL Server Ver. 6 or above MySQL Sybase ASE and ASA through OpenClient Ver. 11.1 or above SQLDirect 6.5 was released. Delphi/C++Builder 10.1 Berlin support ftStream-Parameter support support ftWideString support (SQLBase 11.5+) bugfixes

可以取代BDE的好東西，這版支援Delphi XE connecting to the following SQL servers using 32-bit native application programming interfaces (API): Centura SQLBase Server 6(+), IBM DB2 Universal Database with CAE v5.2, Informix Server 7.2(+), Firebird, Interbase, MySQL 3.23(+), Oracle Server 7.2(+) with SQL*Net 2.2(+), Microsoft SQL Server, PostgreSQL 7.1(+), Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open Client, which is supported by Anywhere ver.6 as native interface), ODBC and OLEDB datasources. no distributing, installing and configuring the BDE or ODBC simultaneous access to the supported servers using Delphi 5, 6, 7, 8, 9(2005), 10(2006), 2007, 2009, 2010, XE or C++Builder 5, 6, 2006, 2007, 2009, 2010, XE (Pro and above) to develop Client/Server applications query with an updatable result set query with macro support table component thread safe BLOB-fields (including LOB and BFILE for Oracle8) stored procedure support (with mutiple result sets for IBM DB2, Microsoft and Sybase SQL Server) bi-directional and unidirectional result sets cached updates record filtering support of data-aware components InfoPower support using images stored by Centura SqlWindows(or Team Developer) in their proprietary format interfaces (public methods and properties) of SQLDirect components are compatible with standard BDE data access components (TSession, TDatabase, TQuery ..).

使用数据源为System.Data.Oledb,Provider为Oracle Provider For .Net没用OracleClient，因为这个只能用在OracleProvider要改为Oracle Proider form Net,默认的MS Oledb For Oracle不支持高版本Oracle（8.0以上）ConnectionString如下：Provider=OraOLEDB.O...

110,545

社区成员

642,580

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧

+ 用AI写文章