Solved

SQLSRV32.DLL problem with SQL Server ODS Gateway application

Posted on 1998-12-22
2
404 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

710 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