headers
Frediano Ziglio | 6 Feb 23:01
Picon

Re: Return value of SQLRowCount with operations producing no result

It seems only print test fails and also the line is executed only using FreeTds without dm, so probably is too
strong. I'll check ms behaviour asap. I'm still without a personal computer.

Yesterday I updated "nightly" tests.

Bye
Frediano Ziglio

On 17/gen/2012, at 03:45, "James K. Lowden" <jklowden <at> freetds.org> wrote:

> On Sat, 14 Jan 2012 09:16:51 +0000
> Frediano Ziglio <freddy77 <at> gmail.com> wrote:
> 
>>> The 24000 diagnostic is not a valid return code for SQLRowCount().  
>> 
>> I don't remember why there is this if... I should check on cvs
>> history. Have you tried unittests??
> 
> Committed change to src/odbc/odbc.c revision 1.588.  
> 
> I didn't look at the unit tests for this.  
> 
> --jkl
Permalink | Reply | 0 comments |
headers
Frediano Ziglio | 6 Feb 23:07
Picon

Re: mars?


On 15/gen/2012, at 16:46, Björn Lundin <b.f.lundin <at> gmail.com> wrote:

> Hi, I  just found this freedts thingy,
> and i read through the FAQ which states that MARS
> is not supported, and some reason why so.
> 
> However, a bit further down, there is a passus that
> suggests it _might_ be supported in the future?
> 

As usual I have a patch, but currently I'm unable to bring it to a proper state :(

> So my question is if there are any plans to do so?
> 

No!

> Reason I ask is that I work on a system, that was developed
> many years ago (1990-ish) and that is uses the concept
> of opening a cursor, looping through the recordset,
> and use some of those values retrieved to update other
> tables within that loop.
> It was developed on Mimer, then ported to Oracle.
> 
> Last year, I ported it to MS sql-server, and boom/bang/crash,
> the mars feature came up. I had not heard of dbs not supporting it
> before, so I was a bit surprised.
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Frediano Ziglio | 6 Feb 23:17
Picon

Re: NVARCHAR Columns Dropped from Query Result

You should send us a odbc trace with simple query and security stuff removed. 0.91 support nvarchar much
better than 0.64 (it can use wide encoding directly without losing characters). You can also try to use a
single character encoding like iso8859-1, this could help to solve some problems with some client that
does not like no_total reply.

Frediano Ziglio

On 19/gen/2012, at 02:05, Jason Lincoln <jlincoln <at> yahoo.com> wrote:

> It appears the problem is with Oracle heterogenous database connectivity and not with unixODBC or
FreeTDS.  I'm still at a bit of a loss as to why it was working flawlessly before the SP3 patch with FreeTDS 0.64.
> 
> On Jan 16, 2012, at 3:48 PM, Jason Lincoln wrote:
> 
>> My freetds/unixODBC Oracle XE Heterogenous database connectivity setup was working great until SP3
came along recently.  I was unable to connect until I upgraded to the latest freetds version (0.91) using
tdsver=7.1.  Now I am able to connect to SQL Server from Oracle using unixODBC/freeTDS but columns are
dropped.  Seriously.  I can run a query in SQL Developer on Windows with a connection to the SQL Server DB and
get all the columns in the table but when I run the same query (select * from ...@mssql) from an Oracle DB it
drops all nvarchar columns.
>> 
>> Anyone have any suggestions?
>> 
>> Thanks,
>> Jason
Permalink | Reply | 0 comments |
headers
dmarrer | 7 Feb 02:02
Picon
Favicon

Daymel Marrero Viñas está ausente de la oficina.

_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |
headers
dmarrer | 7 Feb 02:02
Picon
Favicon

Daymel Marrero Viñas está ausente de la oficina.

_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |
headers
dmarrer | 7 Feb 02:02
Picon
Favicon

Daymel Marrero Viñas está ausente de la oficina.

_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |
headers
dmarrer | 7 Feb 08:01
Picon
Favicon

Daymel Marrero Viñas está ausente de la oficina.

_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |
headers
dmarrer | 7 Feb 08:01
Picon
Favicon

Daymel Marrero Viñas está ausente de la oficina.

_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |
headers
dmarrer | 7 Feb 08:01
Picon
Favicon

Daymel Marrero Viñas está ausente de la oficina.

_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |
headers
Björn Lundin | 7 Feb 12:24
Picon

Re: mars?


> Using odbc you can change cursors type in order to achieve this behavior. Ctlib should support cursor too
but I don't remember the state
Thanks for suggestion , but i solved that one using as you say mars=enabled on the odbc connection. 

I'll look at unix odbc then. 
--
Björn 
_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Permalink | Reply | 0 comments |

Gmane