Thanks Paul

>Hi Rex,
>
>My Oracle dba has just set up my tables in the test database.
>
>I'll probably change my application logon screen to allow the switch between prodution and test databases later today or tomorrow.
>
>I have two entries in my tnsnames.ora, one for production, one for test.
>
>I have two system dsn defined in the ODBC administrator, one for production and one for test.
>
>I have one connection in my vfp database.
>
>I'll use dbsetprop to change the datasource from test to production.
>
>? DBsetPROP("connect_oracle", "connection", "datasource","test")
>
>? DBsetPROP("connect_oracle", "connection", "datasource","production")
>
>That's the plan. I'll let you know how it works.
>
>Paul
>
>
>
>>>I'm away from the office until next week. I'm going to be doing the same setup as you describe. I have a similar setup for an application in MS SQL Server.
>>>
>>>Let's talk next week.
>>>
>>>Paul
>>>
>>>>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