Switching Databases Using ODBC Driver

[Duri]

I am writing a web interface for a database and i have one question to ask before i go ahead.

I wish to write the program to work on an oracle database but eventually it is going to be used with a Microsoft SQL sever.

Now my understanding is I can use an ODBC Driver for oracle and then simply swap drivers when i wish to switch databases.

Firsty am i right?

Secondly how do i use an ODBC driver in ASP/C#?

[russell]

that's right, as long as u dont use any proprietary syntax

see here (http://www.carlprothman.net/Default.aspx?tabid=90) for connection strings