Hi Pertti.
Thanks for your reply.

Do you know if there are any(many?) difference between say VFP Sql and SQl Server SQL, or is there anywhere I can get a lsit of the differences.

Regards,
Gerard


>Gerard:
>
>You can edit the config file on site with notepad or whatever, as long as the output remains straight text. Also, a while back Rick Strahl published a utility for doing this in a more organized manner in Code -magazine, I believe.
>
>There are some important SQL syntactical differences between the various backends, so you need to do some conditional bracketing of your straight SQL commands to handle these differences properly.
>
>
>Pertti
>
>>
>Hi Jason. thanks for your reply.
>>I have downloaded the guide and gone through it.
>>
>>My understanding from your reply (and reading the guide) is that with MM, because the data access is defined in an App.config file, my requirement is satisfied.
>>
>>Doe this mean that I can have just one copy of the app, which I distribute.
>>I then go onto the Clients site and edit the App.config at the site , to specify the database type ?.
>>
>>If so, how do I edit this file on site. Do I use a text editor or is there a utility to edit the App.config file ?
>>
>>Regards,
>>
>>Gerard
>>
>>
>>
>>>Gerard,
>>>
>>>With MM, this is easily accomplished using database sets, each potentially with its own data access class. All of this is set in the app.config file
>>>
>>>Follow my signature link to Oak Leaf Enterprise's homepage and download the latest developer's guide. See the "Specifying Connection Strings and Database Settings" child node of the "Data Access with Business Objects" topic for specifics.
>>>
>>>Hope this answers your question,
>>>---J
>>>
>>>>Hi.
>>>>I am having a look at using MM for .net development and have one specific question. (I have not used .net yet...)
>>>>
>>>>I will need to deploy the APP in sites where the backend database will be different, i.e in one site it may be VFP, in another it may be Sql server and in another perhaps MySqL.
>>>>
>>>>Is it possible to have one App, but deploy it in different sites.
>>>>i.e. Can the actual 'backend database ' parameters be set up in such a way that they are store in a parameter File.
>>>>
>>>>Ideally then , when the App is deployed, it should be just a matter of changing the 'Database Parameter ' file.
>>>>
>>>>I wuld appreciate any comments on how this can be done , and if not possible in MM, perhaps there are other products that can do it ?
>>>>
>>>>Regards,
>>>>
>>>>Gerard