David, thanks for the reply.
this has me very confused, I have made a connection called pcrconnect and have built my remote views as the data source pcrconnect I'm using a IP address that will allow me to hit the server in our office from my home office. So what I did I change the IP address in the pcrconnect connection to the name of the server in our office and recompiled the code and installed the exe on a work station in our office. I would have thought at this point this would work.
But what is happening I get a connection failure and then the SQL server dialog box comes up with the IP address I used from my home office and not the name of the server. I can drill down and pick the server I want and all works well.
Thanks
>Randy,
>
>Sure.
>
>
>if ( "PROG-DFRANK" $ sys(0) )
> set path to office_dir_structure...
> lcConnectTo = "devsql02"
>else
> set path to home_dir_structure...
> lcConnectTo = "(local)"
>endif
>
>set classlib to microsystem additive
>
>public oSystem
>osystem = createobject( "sqlservermicrosystem" )
>with oSystem
> .cServername = lcConnectTo
> .cDatabase = "HHCommon"
> ? .GetConnection()
>endwith
>
>
>the microsystem class tree is an object wrapper around SPT calls.
>
>If you are using a DBC and remote views you can swap out the connection as appropriate.
>
>>Can a connection string be change at run time? I have develop an application from my home office and in my connection string I have the IP address for the server I'm hitting. Now I'm going to move my app in side the office I need to change the IP address to the server I'm wanting to use.
>>
>>I think this is what's going on the app runs fine from my home office I have move it to the office I'm getting the connection failure error and when the dialog box comes up I can enter in the IP address and all works fine.
Foxpro is a sweet puppy
'cept it barks every now and then =)