Simon Hax wrote: > I don't know what JET is. > I testet ADO. That works. > But it'is slow and you have to write some (to much) code. > > Much more better would be a solution like a direct LINK (like an Oracle > Database Link). > > as shown in my first email: > > insert into sqlitetable_columA select ColX from ta...@oracledb > > If you have 2 OracleDBs you can define a LINK from one OracleDB to the other, > which allows you then to do ..... Hi Simon, As you demonstrated in your email, it is relatively easy to remain in a homogeneous environment. Within this environment you should post any questions to the provider being Oracle. The provider interfaces the necessary connections. When these connections no longer suffice; external links may solve your problem. But normally you have to acquire the know-how.
As you have not explained the reasons why Oracle cannot fulfill your requirements and why you are trying to link to SQLite; any answers remain superficial. SQLite attaches dbs very easily and in the manner you indicated. Use Attach. If Oracle and SQLite were compatible you could simply attach dbs. As your example shows; Oracle and SQLite are two entirely different technologies offering diametrically opposed technologies. However it makes sense to connect these environments. Oracle has advertised on this list that Berkeley Db attaches to backend SQLite databases. Based on the Oracle concepts summarily presented; use Berkeley Db to connect Oracle to SQLite to achieve your targets if you cannot Attach. Unless you provide more information; this should keep you within homogeneous interfaces and fulfill your requirements. See the links at the bottom of this email for what Oracle advertises as solutions. - Gary Gabriel Oracle links from Oracle sources: "As you may have already heard, the latest release of Oracle Berkeley DB now supports SQL, via integration with the SQLite API." You can read the press release <http://www.oracle.com/us/corporate/press/063695>, review the documentation <http://www.oracle.com/technology/documentation/berkeley-db/db/index.html> or download <http://www.oracle.com/technology/software/products/berkeley-db/index.html> the release from the Oracle web site. You can get technical assistance on the Berkeley DB Forum <http://forums.oracle.com/forums/forum.jspa?forumID=271> or directly from Oracle Support <https://support.oracle.com/CSP/ui/flash.html#tab=SRHome%28page=SRHome&id=g1txr1mm%28%29%29> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users