I have used the odbc backend, although in our case it was not on UNIX, and
there were quite a few issues with it.
In particular, before SQLDescribeColumns you need to ensure you really have
the result set back you are expecting, and must call SQLMoreResults until
you get it.
Have you traced into the SQL calls themselves to see what is returned?
On Mon, Mar 19, 2012 at 2:38 AM, Simon Walter <[email protected]> wrote:
> On 03/19/2012 11:05 AM, Paul Harris wrote:
> >
> >
> > On 19 March 2012 09:31, Simon Walter <[email protected]
> > <mailto:[email protected]>> wrote:
> >
> > On 03/17/2012 10:00 PM, Paul Harris wrote:
> > >
> > >
> > > On 16 March 2012 08:42, Simon Walter <[email protected]
> > <mailto:[email protected]>
> > > <mailto:[email protected] <mailto:[email protected]>>> wrote:
> > >
> > > On 03/15/2012 03:07 PM, Simon Walter wrote:
> > > > Hi all,
> > > >
> > > > I'm trying read some data from an SQL Server database via ODBC
> > > ala SOCI.
> > > > Everything seems to work except for varchar columns.
> SQLDescribeCol
> > > > generates an error and odbc_soci_error
> > > > "column size" is thrown (soci/src/backends/odbc/statement.cpp -
> > > > odbc_statement_backend::column_size())
> > > >
> > > > I've tried different DBs on the same server, and I still get
> > the same
> > > > problem.
> > > >
> > > > The code is as simple as it gets:
> > > >
> > > > std::string resName;
> > > > int res = 5;
> > > > session mssql(odbc, connectString);
> > > > mssql<< "select name from test.dbo.res where id = :res",
> use(res,
> > > > "res"), into(resName);
> > > >
> > >
> > > A follow up to this:
> > >
> > > I've tried the using row.get<string>(0) with the same results:
> > >
> > > /usr/local/include/soci/row.h:68: T soci::row::get(size_t)
> > const [with T
> > > = std::basic_string<char, std::char_traits<char>,
> > std::allocator<char>
> > > >]: Assertion `holders_.size() >= pos + 1' failed.
> > >
> > > and a odbc_soci_error with "column size".
> > >
> > > I've tried the same queries with libodbc++ and get back
> results
> > > correctly.
> > >
> > > I don't see how something as common as that would be a bug,
> > but perhaps
> > > no one is using odbc. I'm using unixODBC 2.2.14.
> > >
> > > How can I verify this is (not) a bug with unixODBC?
> > >
> > > Thanks,
> > >
> > > Simon
> > >
> > >
> > > Does this look related?
> > >
> > > https://issues.asterisk.org/jira/browse/ASTERISK-16946
> > >
> > > I have stumbled onto unixodbc bugs before, the one I hit still
> > exists in
> > > the current Debian unixodbc, although its fixed in the latest
> > unixodbc
> > > source release.
> > >
> > > Are you running a 64-bit machine?
> > > Does the bug occur on a 32-bit machine?
> > >
> >
> > Thanks Paul,
> >
> > It looks like it could be related. However, I am using a 32-bit OS
> > (debian 6) VM hosted on a 64bit machine. So I don't think any 64bit
> > issues are a problem here. Though, it does look like it could be a
> > unixODBC issue. Is there any way I could verify it is indeed unixODBC
> > before I go through with building everything?
> >
> > Simon
> >
> >
> > Well then it probably won't be a 32-64 bit issue (I used schroot to
> > allow me to install and run 32 bit debian inside my 64 bit debian).
> > Unless you are connecting to a 64 bit server.
> >
> > I think I verified my bug by compiling unixodbc in debug-mode, so then I
> > could step through the unixodbc code that was called from my app (as its
> > a library that you link to).
> >
> > And/or, build and use the latest unixodbc, see if the bug occurs. It
> > will require automake/configure/make to /usr/local since debian doesn't
> > have the latest unixodbc.
> >
> > cheers
> > Paul
> >
>
> OK, it looks like I'll have bite the bullet and get building unixODBC.
>
> Cheers,
>
> Simon
>
> --
> simonsmicrophone.com
>
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
>
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
