We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running on a Solaris (2.5.1, 8.x or 10.x) box. We found one product/library that seems to provide the interface we need, called "EnterpriseDB". Are there others? Or is there a different way to accomplish what we want to do?
Write simple wrapper programs on the windows machine that use ODBC or similar, then use sockets or a higher level protocol to talk from the Solaris box to those wrapper programs.
Okay, we understand the (web service) code needs to go on the MS-SQL box. But how does a process on the Solaris box talk to that web service on the MS-SQL machine?
You need to use odbc as stated in the previous post by porter. This is not dependent on any web services you may have. The easiest way I would solve this is by writing a java app to use a jdbc-odbc connection to send sql statements to the MS-SQL server.
