I have been asked to make an application work with SQLserver 2000. It
currently supports MS Access and Oracle.  The database itself has been
successfully ported, but now its time to make the application code work.
Does anybody have any tips on doing this?  Are there major SQL language
differences between Oracle and SQLserver.

The application uses ODBC and DAO for data access.

Thanks

I haven't tried to go that direction so can't say.  There are things in SQL
Server that are non-Ansi standard and might not port well to Oracle so it
wouldn't surprise me if the same is true the other way.  A simple way of
tracking might be to look at an Oracle-oriented book and look for the
non-Ansi approaches, then check your SQL for them.

For the most part, things should work.   Sorry can't be more help, but since
no one had responded in a day thought I'd contribute a wee bit.

Marty