Working with Native ODBC Environments

The database server code, in ospace/database/server/, requires ODBC headers and libraries to successfully build the dbserver application.

Installing and configuring the platform's ODBC environment and any necessary ODBC drivers for underlying databases is outside the scope of this document. Consult your platform documentation for information on setting up the ODBC environment. For ODBC drivers for a particular database, consult the database vendor's documentation.

After successfully configuring the platform's ODBC environment the Database<Toolkit> Server can be built. If the platform's ODBC headers and libraries are not located in the traditional system directories then modifications may need to be made to the build files located in ospace/database/server/ and possibly to the ospace/database/server/dbsrvodbc.cpp file.

All code that uses platform native ODBC is isolated to the ospace/database/server/dbsrvodbc.cpp file, an excerpt of which is shown here.

Excerpt from <ospace/database/server/dbsrvodbc.cpp>


  ...

//
// The dbserver makes use of an ODBC driver manager.
// Include the traditional ODBC interface headers here
//
#ifdef WIN32
#include <windows.h>
#endif
#include <sql.h>
#include <sqlext.h>

...

In the file ospace/database/server/dbsrvodbc.cpp any ODBC include files, typically sql.h and sqlext.h, must be included.