Yes, you can do that.
You need to change the connection string
in the connection defined in the DBC via dbSetProp( 'MyConnection', 'CONNECTION', 'ConnectString', 'the new connection string goes here' )
>Hello Everybody!
> Is there a way that I can change where a remote view points to dynamically. Lets say that I created a remote view that points to Table1 in
>Server1, open the view using NODATA, can I change now the view to points to
>Table1 in "Server2" and then requery ?
> I tried SQLSETPROP(nHandle,"ConnectString",cMyNewString),
>but "ConnectString" is read only, any thoughs ?
>
> Thanx in advance!
Hector Correa