Cannot map an error code returned from unixodbc using PostgreSQL database -


i using postgresql using unixodbc driver, , while trying connection, error. printing value of pfnativeerror of sqlerror, , value of '26'.

i have gone through error codes returned postgresql, listed here: http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html#errcodes-table

i wanted know if unixodbc returns in pfnativeerror last 3 characters of error codes mentioned in link above? if true, assume possibility following error code:

22026 string data length mismatch string_data_length_mismatch

do let me know if thinking in right direction. also, issue i've noticed when postgresql has millions of rows, , query results in connection failure trying fetch lot of data (10ks). can give idea why problem might happening?

edit 1:

if of help, i'm getting following values szerrormsg:

  • error while executing query
  • could not send query(connection dead)

edit 2:

'26' returned in integer, , codes mentioned in link above in hex. 26 in decimal corresponds 1a in hex. unfortunately, not correspond thing in above mentioned documentation. out of ideas! can tell me different pfnativeerror codes correspond to?


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more