Solved

SQLSRV32.DLL problem with SQL Server ODS Gateway application

Posted on 1998-12-22
2
408 Views
Last Modified: 2012-08-13
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
Comment
Question by:taranni
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
tchalkov earned 300 total points
ID: 1092357
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
 

Author Comment

by:taranni
ID: 1092358
We rebuilt Microsoft's sample ODS gateway application after installing service pak 4.  This does not resolve the problem.
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question