Can I use ELF products with SQL Server, Oracle and other ODBC data sources?
As of VB ELF 2.0, we now support SQL Server 7.0 T-SQL as well as Oracle’s PL/SQL dialect. Every feature available in the earlier Jet-only version of the software has been extended to these new dialects — whether or not they are natively supported by the language. In other words, you can ask pivot table questions, like: “Show the average order subtotal, giving the customer down and month of order date across during 1999.” — VB ELF will create SQL for either SQL Server 7.0 or Oracle to generate the grid. No need for custom solutions like expensive and confusing OLAP tools! Need FULL JOIN capability in either MS Access or Oracle, but are frustrated because they don’t support it? VB ELF will emulate the FULL JOIN capability of SQL Server 7.0 by constructing the Union of two inverted joins. Sounds hard? — nope, it’s easy as clicking the FULL JOIN radio button. Because we now support both Jet attachment and the newer OLE DB Provider data access standards, you can have client-server effici
Related Questions
- After dragging the ports of three sources (sql server, oracle, informix) to a single source qualifier, can u map these three ports directly to target?
- Is there any issue with using ODBC to access the data in the Oracle Database on a Shared Oracle Server?
- Can I use ELF products with SQL Server, Oracle and other ODBC data sources?
