My application uses multiple named datasources, it is possible to set each via the shared settings file. I could not get the Shared Settings File Wizard to add mutliple connections.

There are 3 VFP and one SQL, so they are of mixed type as well.

Thanks,

Keith

Keith Chisarik

Thanks Ill take that into consideration. Let me rephrase, how do you create multiple named connections in the Shared Settings File Wizard

The workstation count is in the 100 ballpark, would you consider that "too many people hitting the shared settings file all at the same time" ?

I was thinking since they are just reading, that it wouldnt be a problem...

Keith Chisarik

Keith, I lied.  The shared settings file only holds one data source at a time....however, you can create 3 and them read them in.  Yesterday I created a post showing how to circumvent the ConnectionStringWizard and just loading in the settings file.  You could create 3 shared settings files and then read them in and create your data sources like this:

http://forum.strataframe.net/FindPost31649.aspx