Solved

SQLSRV32.DLL problem with SQL Server ODS Gateway application

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL - Rotating Values in SQL 9 52
Splitting the content of a column in SQL 11 20
MSSQL: Substring and Charindex error 7 17
Sql Query 4 14
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now