Re: Difference between tsql and libsybdb

On Mon, 24 Sep 2012 12:33:05 +0200
Alberto Pulvirenti <[email protected]> wrote:

> I have implemented a C++ class which makes use of the libsybdb to
> connect to a SQL Server 2008 database and allow for some standard
> queries.

You may wish to look at sourceforge.net/projects/dbstreams/.  :-)

> if I try to log into the same DB on the same instance using my
> class, it fails because it is kicked out by the logon trigger.
> What I do is just creating a LOGINREC object and set it with what is
> needed to access the DB (user, password, port, host, etc,), which is
> nothing more and nothing less than what I put in the command line
> when I call tsql.
> 
> I called the admins of that SQL Server instance and the only help I
> got was the log of some error message which is the following:
> 
> >> SELECT failed because the following SET options have incorrect
> >> settings:
> 'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'.
> >> Verify that SET options are correct for use with indexed views
> >> and/or
> indexes on computed columns and/or filtered indexes and/or query
> notifications
> >> and/or XML data type methods and/or spatial index operations

Look at the login process for bsqldb.  Also perhaps try the source code
from the Tenderfoot section of the UG.  It sounds like your server may
require you to call dboption() before dbopen().  

HTH.

--jkl