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.