Rex,

The way to do this really depends on how you're telling Oracle which database to use. If you're specifying the database in the DSN, you can change the DSN. You can do this programatically or manually. For more info on doing it programatically check out Mark McCassland's article in the UT knowledge base on connecting to Oracle.

If you're setting the database as part of the connection in your DBC you can change the connection settings. This can be done manually using the Database Designer or in code using DBSETPROP().

You may also be selecting the database by sending a command to Oracle using SQLEXEC(). I don't know how you do this in Oracle. In SQL Server it's USE dbname.



>All,
>
>I have 2 Oracle databases, Test and Production. I want to be able to run my application on either transparently. If I edit the ODBC connection information, will this work? Seems to me there is/should be some way to make this work.
>
>Thanks
>
>Rex