Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

SQLSRV32.DLL problem with SQL Server ODS Gateway application

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.
0
taranni
Asked:
taranni
1 Solution
 
tchalkovCommented:
Why don't you try recompiling your ODS aplication with the new libraries which come with SP4? If SQLSRV32.DLL is upgraded then the coresponding lib file is also upgraded.
0
 
taranniAuthor Commented:
We rebuilt Microsoft's sample ODS gateway application after installing service pak 4.  This does not resolve the problem.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now