|
| | | StrataFrame Beginner
 
Group: Forum Members
Last Login: 11/02/2006 10:04:26 AM
Posts: 18, Visits: 22 |
| Hello,
it would be a nice feature if I could connect my StrataFrame WinApp to a WebService and use a foreign SQL server database. Can I do this and if yes, how can I do this? In my view it could be a part of the ConnectionManager.
...gerhard... |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 2:14:29 PM
Posts: 4,901, Visits: 4,886 |
| | This is what our Middle Tier Enterprise server ultimately does. It does much more than just expose SQL Server through a web service though. Attached is a white paper on the Middle Tier Enterprise Server. As for exposing SQL Server, you do not need a web service for this. You can just make your SQL Server accessible externally and then turn on encryption. Obviously this is not as optimized as the Middle Tier Server so it will not be as fast and it does not protect the SQL Server from the outside world. There is a new data access class called EnterpriseServerDataItem which allows a connection to be established to the Middle Tier Enterprise server. Obviously none of this has been released as of yet. But connecting to the server is literally as easy as connecting to a SQL Server connection.
|
| |
| | | 
StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 3:04:33 PM
Posts: 380, Visits: 1,922 |
| I’d like to expand on Gehard’s question and ask if there is a way or plans to provide a way to connect a StrataFrame WinApp to web services provided by others. This could be a mainframe app. Is the new data EnterpriseserverDataItem class limited to establishing connections to the StrataFrame Enterprise Server or will it allow connections to other web services? -Larry |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 2:14:29 PM
Posts: 4,901, Visits: 4,886 |
| Is the new data EnterpriseserverDataItem class limited to establishing connections to the StrataFrame Enterprise Server or will it allow connections to other web services? The EnterpriseServerDataSourceItem is exclusive to StrataFrame's Middle Tier Enterprise Server. There is a lot of logic specific to the Middle Tier Enterprise server just as there would be in SqlDataSourceItem or VFPDataSourceItem. In fact, there is actually more because there is logic for encryption and custom serialization to make things as fast as possible. If you want to talk to a disparate web services not related to StrataFrame, you will want to create your own data source item. Basically you will inherit the DbDataSourceItem and start adding your functionality. Obviously this is a bit of a simple explanation. Here is the problem with us just creating a "one class does it all" data source to talk to a web service....every connection is different. It depends on how it has been exposed and developed as to what is required by the data acces layer. |
| |
|
|