> Will SQL sver and Oracle work the same way?
The ODBC interface is DBMS-agnostic BUT....
You need to make sure any SQL statements you use are also common, as SQL
statements are passed by Driver Manager to the the ODBC driver "as is."
Oracle especially supports a lot of functions and notation which are not
supported by any other DBMS... but Oracle also supports "portable" SQL - a
bit more effort to write, but it will work against non-Oracle datasources.
Example: Oracle supports a 'nullif' function which is not supported by
MS-Jet (Access).. although both DBMSs provide an ODBC interface. If you
need what 'nullif' does but the statement needs to execute against Jet, you
need to change your SQL.
(I have no clue if nullif is supported by SQL Server).
Michael C. Mattias
Tal Systems Inc.
Racine WI
[EMAIL PROTECTED]
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
