We have an application written in C++ that is based on the sample Gateway application provided with SQL Server 6.5. The Gateway uses ODS (Open Data Services) to talk to clients and provides the clients access to the database. The ODBC driver that we use is SQLSRV32.DLL (version 2.65)(we are running on NT). Everything was working fine until we upgraded to service pack 4 of SQL Server 6.5. This included an upgrade to SQLSRV32.DLL (version 3.50) which caused lots of problems for us. No matter what error message our gateway application attemts to return to the client application, the message description is always 'lost' and the error number is always 40002. (We are using RDO from VB)
We have a small sample VB application which does nothing but demonstrate the problem trying to communicate with Microsofts's sample gateway application... so we know it is not our code.
We got no help from Microsoft because they apparently don't support using SQLSRV32.DLL as the ODBC driver for ODS Gateway applications. The driver we are 'supposed' to use is ODSGT32.DLL, however, we have different problems with this one.
Can anyone out there help? We are getting ready to upgrade to 7.0 and do not want to be 2 revs behind in our ODBC driver, if it will even work with 7.0.