Re: Using DBSERVERENUM with C++

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alan Brewer [MSFT] (alanbr_at_microsoft.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 09:58:28 -0800

DBServerEnum is part of the DB-library API, and I would not recommend using
that API in anything other than maintaining existing DB-Library
applications. Even with existing DB-Library applications I would rewrite
them to use another data access API if I were doing anything other than very
light maintenance. The following warning has been in every SQL Server 2000
service pack readme, and in each update to the SQL Server 2000 Books Online:

Warning While the DB-Library API is still supported in Microsoft SQL Server
2000, no future versions of SQL Server will include the files needed to do
programming work on applications that use this API. Connections from
existing applications written using DB-Library will still be supported in
the next version of SQL Server, but this support will also be dropped in a
future release. When writing new applications, avoid using DB-Library. When
modifying existing applications, you are strongly encouraged to remove
dependencies on DB-Library. Instead of DB-Library, you can use Microsoft
ActiveX® Data Objects (ADO), OLE DB, or ODBC to access data in SQL Server.

Jim's suggestion for using DMO is good. Also, some of the other APIs, such
as the ODBC SQLBrowseConnect function, could offer the functionality you
need. 

-- 
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Relevant Pages

  • Re: Is that a joke ?
    ... > engineers. ... I was talking about applications like cad, cam, engineering stuf, math, ... > new Longhorn API has been dismissed. ... LH must run in 64bit processors too, so native code must be ...
    (microsoft.public.dotnet.general)
  • Re: RISC OS source code release news
    ... I've got business ... applications that run on the OS that make it useful for most users and I ... some developers away from time spent on applications into time spent on ... Until there is a stable API ...
    (comp.sys.acorn.misc)
  • Re: State of Linux graphics
    ... As long as Render is capable of exposing enough information about the GL ... formats for 2D applications to operate, ... > difficult problem at the hardware level. ... GL is not a very friendly 2D application-level API. ...
    (Linux-Kernel)
  • Re: [Python-Dev] PEP 324: popen5 - New POSIX process module
    ... > needs - having different API for them is reasonable. ... "Fixing popen2" would mean a break old applications; ... My guess is that an communicate() method that uses asyncore ... Writing a good popen module is hard. ...
    (comp.lang.python)
  • Re: Application Security
    ... these Windows Forms applications, ASP.NET applications, Windows services, or ... I assume that your C# clients are not distributed to end users. ... > There is a global SQL Server userid and password. ...
    (microsoft.public.dotnet.security)