[soci-users] ODBC - list data sources

Discussion:

John Skiff

2013-05-20 14:23:59 UTC

Hi,

I'm new to SOCI and LIKE what I've tried so far. We currently use ODBC
via wxODBC to access MS SQL Server. I've decided to replace wxODBC with
SOCI. As time permits I hope to also replace our usage of the OCI and
Sqlite APIs with SOCI as well.

The only only feature that we have to have that I haven't found in SOCI
so far is a way to list the available ODBC data sources. Does SOCI
contain such a feature? If not I'll write it myself.

Thanks,
john

Neil Morgenstern

2013-05-20 14:30:10 UTC

Permalink

Using SOCI with ODBC doesn't prevent you from also using parts of ODBC
that are not supported by SOCI. For example, when we needed to do Bulk
Copy, we didn't use SOCI for this.

We did adapt SOCI-ODBC to work with stored procedures. I did e-mail
the list sometime ago with some of the changes we had to make to the
ODBC add-on. In particular there was a bug where it wasn't checking
for more results, I think it's SQLMoreData() or something like that.
The data came back with not having sufficient columns because of this.

We also had to handle output parameters that didn't work with SOCI. I
can't remember if we ever handled return values (other than ones that
indicate pass/failure).

We actually used a library that wrapped SOCI so the user of our
library didn't need to know if a particular function was implemented
through SOCI or not.

Post by John Skiff
Hi,
I'm new to SOCI and LIKE what I've tried so far. We currently use ODBC
via wxODBC to access MS SQL Server. I've decided to replace wxODBC with
SOCI. As time permits I hope to also replace our usage of the OCI and
Sqlite APIs with SOCI as well.
The only only feature that we have to have that I haven't found in SOCI
so far is a way to list the available ODBC data sources. Does SOCI
contain such a feature? If not I'll write it myself.
Thanks,
john
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
soci-users mailing list
https://lists.sourceforge.net/lists/listinfo/soci-users

John Skiff

2013-05-20 15:01:02 UTC

Permalink

Sounds good. Thanks for your response.

John

Post by Neil Morgenstern
Using SOCI with ODBC doesn't prevent you from also using parts of ODBC
that are not supported by SOCI. For example, when we needed to do Bulk
Copy, we didn't use SOCI for this.
We did adapt SOCI-ODBC to work with stored procedures. I did e-mail
the list sometime ago with some of the changes we had to make to the
ODBC add-on. In particular there was a bug where it wasn't checking
for more results, I think it's SQLMoreData() or something like that.
The data came back with not having sufficient columns because of this.
We also had to handle output parameters that didn't work with SOCI. I
can't remember if we ever handled return values (other than ones that
indicate pass/failure).
We actually used a library that wrapped SOCI so the user of our
library didn't need to know if a particular function was implemented
through SOCI or not.

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
soci-users mailing list
https://lists.sourceforge.net/lists/listinfo/soci-users