VFP and Strataframe collaboration


Author
Message
AlexSosa
AlexSosa
StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)
Group: Forum Members
Posts: 35, Visits: 138
Trent L. Taylor (04/25/2007)
This is a perfect place to use the Enterprise Server.  It will reside on the server and execute your queries or sprocs locally.  You can use COM, but this becomes much more cumbersome and not as efficient.

Unfortunately Enterprise Server is too much and too expensive for this situation.  We hope to eventually have dozens of installations each with its data but only one to three users.  If later that is extended to providing centralized data for many clients, it would be another story.

How would the COM approach work?

Thanks,  Alex

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
How would the COM approach work?

If you are going to have the need for clients to talk to a remote database, then you will have to use some type of remote approach such as Remoting, Serialization, Sockets, VPN....something before you even get to the COM class.  At that point creating the COM is the simple part.  You just have to create a class library that is COM Visible and expose the logic that will be used to talk to the databases via business objects.

AlexSosa
AlexSosa
StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)StrataFrame Beginner (43 reputation)
Group: Forum Members
Posts: 35, Visits: 138
Trent L. Taylor (04/25/2007)
If you are going to have the need for clients to talk to a remote database, then you will have to use some type of remote approach such as Remoting, Serialization, Sockets, VPN....something before you even get to the COM class.  At that point creating the COM is the simple part.  You just have to create a class library that is COM Visible and expose the logic that will be used to talk to the databases via business objects.

Thanks, I'll look into that.

Alex

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search