Re: SQL -> Oracle



Though there are a lot of possible solutions, one you might consider:

www.sql-direct.com

It has components that work not too differently than the BDE
components, but uses the native DB API. It supports a fair number of
database servers, like Sybase, Oracle, MS, etc.

Note that I've not personally used it with Oracle or MS SQL Server,
but it does support those. I've only used it with Sybase and
Firebird. But, I believe that a large number of their users use MS
and Oracle.

I've not personally written any applications where I've supported
multiple choices for the server engine, so I've never worried about
SQL dialect issues.
.



Relevant Pages

  • SUMMARY: Hardening Solaris 8 with Oracle
    ... Oracle *not* offering a CLI install is a new trend. ... My reason for asking about Oracle Reports Server was a recent issue I ... # To Support X-Application need the LibC library ...
    (SunManagers)
  • RE: ADSI as linked server
    ... This is Mark, a SQL Server Engineer. ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.connect)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • RE: xp_cmdshell, Access Denied, Further Investigation Reveals
    ... context in which the SQL Server service is running. ... xp_cmdshell will impersonate the SQL Server ... Agent proxy account, ... Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.security)
  • RE: Sharpoint Error in SBS 2003
    ... > Have you upgraded the Sharepoint WMSDE to SQL server? ... > A supported hotfix is now available from Microsoft, ... > To resolve this problem immediately, contact Microsoft Product Support ...
    (microsoft.public.windows.server.sbs)