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