SQL Server Access Library for DBTools.h
SQL Server Access Library for DBTools.h
| |||||||||||||||||||||||||||||||||||||||||||
Since 1997 I have been heavily involved in SQL database development. The last three years almost exclusively as a Win32/SQL Server developer. Most of that development work was done in ODBC. While ODBC is a powerful tool for application work, it is tedious, highly error prone, and time consuming to use. During a brief programming assignment with JAVA, I became familiar with JDBC. I was unhappy that a similar kind of API set was not available to C++ programmers. Then by great fortune I discovered SQLAPI and realized that it was just what I had been looking for.
In June of 2001, my company began a project to develop a major voice mail / unified messaging product that would have an extensive SQL Server database component supporting both the Win32 GUI and many NT service programs. SQLAPI was chosen as the development tool for the database interface. After nine months of programming using SQLAPI, I wonder how I ever got along without it. I would never consider going back to ODBC and with SQLAPI's multi platform support, I won't have to.
I have been purchasing software development tools for more than 25 years and I can say that the customer support from SQLAPI has been excellent with quick, informative responses to my questions. I have no reservations about strongly recommending SQLAPI to any developer involved in database application work no matter what the platform or the database product.
After using SQLAPI for 15 years, I still believe it to be the best database interface library available. As CTO, my company's telephony services platform grew significantly in both scope and complexity over that period. Just prior to my recent retirement, this platform was serving more than 125,000 users. It started day-one using SQLAPI for all of its SQL Server database access and it still does. It would not surprise me if that platform ran for another 10 years - the SQLAPI license was the most cost effective software investment I ever made. I simply cannot imagine writing a complex database app without using SQLAPI.
I get the error: [DBNOTFOUND] No access library
When trying to establish a connection to my database using DBTools.h++, I get the error: [DBNOTFOUND] No access library
Cause
This is a general error indicating the DBTools.h++ core library is unable to find the access library you specified in the first parameter of the call. This may be due to incorrect linking, not including the additional object file required when using static libraries, incorrect environmental settings, or even misspelling the name in the first parameter to . If shared or DLL libraries are used, be sure to put that filename as the first parameter. If one of the hardcoded strings for static libraries was erroneously used, it could have generated the DBNOTFOUND error.
Action
First, make sure you have followed every step in the DBTools.h++ installation (or build) guide. This guide contains valuable information on how to compile, link, and execute a program that uses DBTools.h++.
Next, make sure all the files (lib and object files) were added to the project or makefile, especially the object file.
If you're still having problems, try some of the following suggestions:
- If static libraries are used, make sure you linked to the access library (UNIX: ) file, verify there is an object file (UNIX: ) in the workspaces lib directory, and make sure the static access library string was specified (i.e. ORACLE, SYBASE_CT), as opposed to the filename of the library () as the first parameter to , as described in section 2.1 of your access library guide.
- If shared or dynamic libraries are used, make sure that the directory with the or files is in your dynamic loading path. For Windows, this directory should be in your . On Solaris: make sure this directory is in your . Check the DBTools.h++ readme file or your system documentation for all other platforms. Also, make sure your database client is properly set up. Check your DBTools.h++ build or installation guide for more information.
What’s New in the SQL Server Access Library for DBTools.h?
Screen Shot
System Requirements for SQL Server Access Library for DBTools.h
- First, download the SQL Server Access Library for DBTools.h
-
You can download its setup from given links: