I have a VFP9 app that uses remote views to connect to an Oracle backend.

Before I can run my views, I need to issue this:

alter session set global_names=false;

..so easy enough I do this:

lnConnectionString = 'DSN=myDSN;UID=myUserName;PWD=myPassword;SERVER=myServer
lnConnectionHandle = SQLSTRINGCONNECT(lnConnectionString)
lnEResult = SQLEXEC(lnConnectionHandle, 'alter session set global_names=false')

..which appears to work. Now what I want to do is have my remote views use the connection I just created (since this "session" has the configuration I want). ..so I thought I could just do this next:

Use myRemoteView in 0

...but it does not work.

If I do this it does work:
lnEResult = SQLEXEC(lnConnectionHandle, 'alter system set global_names=false')

...however that is setting a system setting in the Oracle database and our DBA will probably have a stroke if I ask to do that.

Any ideas?

Thanks!

update: Yes I have my remote views set to "share connection" :)