DevHeads.net

Database

Watch 2012 Northern Trust Open Live Online TV Stream golf

Watch 2012 Northern Trust Open Live Online TV Stream golf
2012 0Northern Trust Open
Match Scheduled 16-19th February 2012
Pacific Palisades, California
Purse: $6,600,000
PGA Tour
when will start 2012 Northern Trust Open Live streaming online tv golf match.It will be held on 16th February 2012 and end 19th February 2012.And how can watch 2012 Northern Trust Open online streaming live match.In the world 2012 Northern Trust Open golf streaming PGA Tour are famous to all golf faners.
2012 Northern Trust Open Live Online

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

^^**wAtcH^^**Aston Villa vs Manchester City Live Stream Soccer Online February 12, 2012

wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

Rule module implementation Bug problem

Hi Dear,
I have a doubt regarding following procedure , it work fine in Article but not
in "Page" creation (I mean the link is not proper), please help me with a
solution , pls follow the steps and try to create an article and basic page
and click the status link , you got my problem .

To display an 'Add More [Content_type]' link after user saves new content, do the following:

1. Go to admin/config/workflow/rules
2. Click Add New Rule
3. At admin/config/workflow/rules/reaction/add, give your new Rule a name, something like

'Add more content link'

Postgresql Drivers

Hello,

I'm checking to see if there is a free OLE DB driver available. If not, is there a free ODBC driver?

Kind Regards,
Kelly

Kelly Schattle
Business Intelligence Analyst
Hexagon Manufacturing Intelligence
T: +1 401.886.2240
E: Kelly. ... at hexagon dot com<mailto:Kelly. ... at hexagon dot com>

Hexagon Metrology, Inc.
250 Circuit Drive
North Kingstown, RI 02852

Step-by-Step Tutorial: How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud

Good morning from Singapore,

You can read my step-by-step tutorial on How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were configured in RAID 1 mirroring array.

<a href="https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to-setup-your-own-e-commerce-online-store-using-woocommerce-3-4-5-wordpress-4-9-8-and-centos-1805-lamp-in-amazon-aws-cloud/" title="https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to-setup-your-own-e-commerce-online-store-using-woocommerce-3-4-5-wordpress-4-9-8-and-centos-1805-lamp-in-amazon-aws-cloud/">https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to...</a>

<a href="https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html" title="https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html">https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-set...</a>

Thanks for reading!

info on open tables

Hi all

I am hoping this mail finds all well.

I have a question about mysql open tables and open_table_cache which I do not seem to be finding the answer to on the internet.

We are busy investigating an issue on a server where we have erattic behaviour.

During the times when it experiences issues, I found that there is always about 4-5 processes on mysql that gets stuck on "closing table" state and once the software (opensips) is restarted due to a sigfault, then these queries are killed as well.

Based on information found we added grafana graphs and did notic

Mroonga 8.07 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.07 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Why this code fails

Hi,
Following code fails with the error "Invalid column nuber in DescribeCol".

I'm trying to run it with the iODBC DM and the official PG ODBC driver.

[code]
int ODBCDatabase::AskPostgresForLogFile()
{
int result = 0;
SQLWCHAR *columnName = new SQLWCHAR[256], *columnData;
SQLSMALLINT columnNameLen, columnDataType, columnDataDigits,
columnDataNullable;
SQLLEN columnDataLen;
SQLULEN columnDataSize;
std::wstring query = L"SHOW log_directory";
std::vector<std::wstring> errorMsg;
SQLWCHAR *qry = new SQLWCHAR[query.length() + 2];
memset( qry, '\0', query.length(

psqlodbc && nested transaction

Hi,
I have got some problems about psqlodbc.
1. I have read documents about odbc(Microsoft) <a href="https://docs.microsoft.com/zh-cn/cpp/data/odbc/transaction-performing-a-transaction-in-a-recordset-odbc?view=vs-2017" title="https://docs.microsoft.com/zh-cn/cpp/data/odbc/transaction-performing-a-transaction-in-a-recordset-odbc?view=vs-2017">https://docs.microsoft.com/zh-cn/cpp/data/odbc/transaction-performing-a-...</a>
It mentions that " Only one level of transactions is supported; you cannot nest transactions. " What about postgresodbc ???
2.

Building programs with libpq

Hi,
<a href="https://www.postgresql.org/docs/9.5/static/libpq-build.html" title="https://www.postgresql.org/docs/9.5/static/libpq-build.html">https://www.postgresql.org/docs/9.5/static/libpq-build.html</a> tells I
need pkg-config to supply to the Makefile to be able to build the
program.

However it is availble on *nix only and not on Mac.

Is there Mac equivalent?

I'm doing development on Xcode, so maybe pg-config is enough?

Thank you.

Use of undocumented functions

I've been looking at use of undocumented Postgres functions and I found four in the ODBC driver:

The POWER function maps to pow. It should be power. pow works but is undocumented.
The CONCAT function maps to textcat. It should be concat. textcat works is undocumented.

The LEFT and RIGHT functions are set to map to ltrunc and rtrunc. These functions don't exist - it should just be left and right. The driver also doesn't report that LEFT and RIGHT are supported.

Thanks,
Dan

Wrong column size using MIN/MAX without return result

Hi all,

We've experiencing an issue using the driver version 10.03.0000 under
unixODBC 2.3.1 environment.

When we use MIN/MAX functions in a query returning CHAR without results,
the column size is wrong.

Building libpq independently of server

Hi,
Is there a way to build libpq on OSX without buillding the whole server?
I will connect to external server and don't want to build everything
just to get a client library.

If I can't - is there a reason?
I mean it is a client-server DBMS and it should be possible to build
one without the other.

There was a package called libpq that can be installed independently
on *nix, but for some reason it is no longer available.

Can anyone help?

Thank you.

Clinical Trials access

Hi,

Just a short recap and trying to connect the dots between two groups.

First, I've had great responses by both the postgresql group and the Duke
group (Sheri Tibbs). I now have a working connections for both pgadmin3,
pgadmin4, 32bit ODBC and 64bit ODBC drivers. There were some issues with my
account along with slightly confusing instructions that caused my issues
with access.

However, the current instructions for pgadmin3 still needs to be updated as
well as those for pgadmin4. Also, it might be really helpful if Duke also
listed the steps for ODBC drivers.

A problem with odbc connection

Hello there,

I have experiencing a problem with odbc connection to postgresql.
I have rhel 7.4 and postgresql-odbc.x86_64 (09.03.0100-2.el7) installed.

Application shows following error: [unixODBC]ERROR: Unsupported startup
parameter: geqo

I've tried to add to the setting in files /etc/odbcinst.ini and
/etc/odbc.ini:
set geqo = 0
set geqo = off
geqo = 0
geqo = off

Unfortunatelly, it didn't help to fix the problem.
Could you please advice how the problem can be fixed?

Best regards,
Ivan

Windows setup

Hi,

I'm sorry to bother your for a simple question, but I think it will help a
lot of people and I will do my best to share it with Medical school
librarians and others who will find it very useful.

ClinicalTrials.gov is the repository where the US stores information on
clinical trials. It's a great resource for medical researches and the
public.

They have a method (database version in postgreSQL) to access the data
directly.

PostgreSQL on OSX

Hi,
I just purchased a brand new Apple laptop which has High Sierra
pre-installed and I
tried to install PostgreSQL on it.
I downloaded version 10.5 from the PostgreSQL web site , but trying to
run the installer, I got:

[quote]
PostgreSQL is not optimized for your Mac.
This app needs to be updated by its developer to improve compatibility.
[/quote]

The installer starts nevertheless and will probably finish, but I'm
just curious if everything will work properly? Or even better question
- when there will be a version compatible with High Sierra?

Thank you.

QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

Hello,

*QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released
: <a href="https://www.qxorm.com/" title="https://www.qxorm.com/">https://www.qxorm.com/</a>

*QxOrm library 1.4.5 changes log :*
* - Support MongoDB database : QxOrm library becomes a C++/Qt Object
Document Mapper ODM library !- For more details about MongoDB integration,
see QxOrm manual (<a href="https://www.qxorm.com/qxorm_en/manual.html#manual_95" title="https://www.qxorm.com/qxorm_en/manual.html#manual_95">https://www.qxorm.com/qxorm_en/manual.html#manual_95</a>
<https://www.qxorm.com/qxorm_en/manual.html#manual_95>) and new sample
project available in ./test/qxBlogMongoDB/ directory- QxOrm library is now
available on GitHub (official repository) : <a href="https://github.com/QxOrm/QxOrm" title="https://github.com/QxOrm/QxOrm">https://github.com/QxOrm/QxOrm</a>
<https://github.co

UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

Dear,

First of all, thank you for your attention.

I have the following packages installed in my Linux OS Centos
3.10.0-514.el7.x86_64:

postgresql-libs-9.2.23-3.el7_4.x86_64
postgresql-odbc-09.03.0100-2.el7.x86_6

I already have a PostgreSQL ODBC connection configured and functional, but
when trying to create the new connection below and use the Isql utility to
perform a test I am getting the error below, I did not find much about it,
would you like to know how to proceed in this case?

*follows the odbc.ini conf:*

[BHIP_PGSQL]
Driver=/usr/lib64/psqlodbcw.so
Description = Banco de dados BH

Mroonga 8.06 - Fast fulltext search for all languages on MySQL

Mroonga 8.06 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

MySQL Connector/J 5.1.47 GA has been released

Dear MySQL Users,

MySQL Connector/J 5.1.47, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector/J is available in source and binary form from the
Connector/J download pages at
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
and mirror sites as well as Maven-2 repositories.

MySQL Connector/J (Commercial) is already available for download on
the My Oracle Support (MOS) website.

I can not find complete documentation pages from PostgreSQL ODBC Homepage

Hi,

I tried to find some documentation on configuring psql-ODBC.

And I found that there is no link to all doc pages, for example,
<a href="https://odbc.postgresql.org/docs/config-opt.html" title="https://odbc.postgresql.org/docs/config-opt.html">https://odbc.postgresql.org/docs/config-opt.html</a> can not be opened directly
from the homepage.

Can someone please add hyperlink to all doc pages?

Thanks a lot.

MySQL Connector/NET 6.10.8 has been released

Dear MySQL users,

MySQL Connector/NET 6.10.8 is the fifth GA release with .NET Core
now supporting various connection-string options and MySQL 8.0 server
features.

To download MySQL Connector/NET 6.10.8 GA, see the "Generally Available
(GA) Releases" tab at <a href="http://dev.mysql.com/downloads/connector/net/" title="http://dev.mysql.com/downloads/connector/net/">http://dev.mysql.com/downloads/connector/net/</a>

Changes in Connector/NET 6.10.8 (2018-08-14, General Availability)

Functionality Added or Changed

* Optimistic locking for database-generated fields was
improved with the inclusion of the [ConcurrencyCheck,
DatabaseGenerated(DatabaseGeneratedOption.Computed)]
a

what is the rationale for not allowing LOCK TABLES in a stored procedure

Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an explanation as to *why* that is. Could someone please
enlighten me?

Thanks

Issue with ODBC connection when export Database

Dears

I am trying to export my DB that was on SQL 2008 to 2017 SQL server & I
succeeded, and I am trying to connect the exported database into odoo(Ver
11) by making link server to PostgreSQL.

MySQL Connector/ODBC 5.3.11 has been released

Dear MySQL users,

MySQL Connector/ODBC 5.3.11, a new version of the ODBC driver for the
MySQL database management system, has been released.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select the driver
type you need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL version from 5.5.

This is the fifth release of the MySQL ODBC driver conforming to the
ODBC 3.8 specification.

ODBC Driver - MS SQL 2014 Compatible

Hi

We need an ODBC driver that is compatible with our MS SQL data warehouse in order to import activity data from our Radiology system.

We have set up an SSIS package that runs fine in de-bug mode with the SQL server setting as MS SQL Server 2016 but when we change this or attempt to run it as a job it fails to bring in the full datasets with no error message.

I have tried to determine the version of the driver that installed on the server but cannot see a readme file or any about information in the ODBC manager.

Please can you recommend a version (and where we can download it) that we can

MySQL Shell 8.0.12 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Shell 8.0.12 is a maintenance release of MySQL Shell 8.0 Series
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.

MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Shell 8.0.12.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Connector/Node.js 8.0.12 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Connector/NET 8.0.12 has been released

Dear MySQL users,

MySQL Connector/NET 8.0.12 is the second general availability release of
MySQL Connector/NET to add support for the new X DevAPI. The X DevAPI
enables application developers to write code that combines the strengths
of the relational and document models using a modern, NoSQL-like syntax
that does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Cluster 7.4.21 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.  This
storage engine provides:

  - In-Memory storage - Real-time performance
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure and
    on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached and
    JavaScript/Node.js)

MySQL Cluster 7.4 makes significant advances in performance; operational
efficiency (such as enhanced reporting and faster restarts and up

MySQL Community Server 5.5.61 has been released

Dear MySQL users,

MySQL Server 5.5.61 is a new version of the 5.5 production release of
the world's most popular open source database. MySQL 5.5.61 is
recommended for use on production systems.

MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL Database, taking advantage of
the latest multi-CPU and multi-core hardware and operating systems.

MySQL Connector/J 8.0.12 has been released

Dear MySQL users,

  MySQL Connector/J Version 8.0.12 is the second GA release of the 8.0
  branch of MySQL Connector/J. It is suitable for use with MySQL Server
  versions 5.5, 5.6, 5.7, and 8.0.

MySQL Cluster 7.2.34 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication
  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http and Memcached)

MySQL Cluster 7.2.34, has been released and can be downloaded from

  <a href="http://www.mysql.com/downloads/cluster/" title="http://www.mysql.com/downloads/cluster/">http://www.mysql.com/downloads/cluster/</a>

where you

MySQL Cluster 7.5.11 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.11, has been released and can be downloaded from

  <a href="http://www.mysql.com/dow" title="http://www.mysql.com/dow">http://www.mysql.com/dow</a>

MySQL Community Server 5.6.41 has been released

Dear MySQL users,

MySQL Server 5.6.41, a new version of the popular Open Source Database
Management System, has been released. MySQL 5.6.41 is recommended for
use on production systems.

For an overview of what's new in MySQL 5.6, please see

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

     Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6 are
     available both as a "full" installer and as a "web" installer.  The
     full installer is significantly larger and comes bundled with the
     latest software releases available.

MySQL Community Server 5.7.23 has been released

Dear MySQL users,

MySQL Server 5.7.23, a new version of the popular Open Source
Database Management System, has been released.

MySQL Community Server 8.0.12 has been released (part 2/2)

[Due to size limitation, this announcement is split in two. This is
part 2]

Bugs Fixed

* Important Change; JSON: The JSON_TABLE() function now
automatically decodes base-64 values and prints them
using the character set given by the column
specification. (Bug #90157, Bug #27729112)
References: See also: Bug #89847, Bug #27613276.

* Important Change: MySQL now allows a query having a WITH
ROLLUP modifier to use DISTINCT. See SELECT Syntax
(<a href="http://dev.mysql.com/doc/refman/8.0/en/select.html" title="http://dev.mysql.com/doc/refman/8.0/en/select.html">http://dev.mysql.com/doc/refman/8.0/en/select.html</a>), for
more information.

MySQL Enterprise Backup 8.0.12 has been released

Dear MySQL users,

MySQL Enterprise Backup 8.0.12, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle.

MySQL Community Server 8.0.12 has been released (part 1/2)

[Due to size limitation, this announcement is split in two. This is
part 1]

Dear MySQL users,

MySQL Server 8.0.12, a new version of the popular Open Source
Database Management System, has been released.

MySQL Workbench 8.0.12 has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.12 as our first general
availability (GA) for MySQL Workbench 8.0.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number of
platforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.12 (2018-07-27, General Availability)

   Known limitation of

MySQL Connector/C++ 8.0.12 has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.12 is the second GA release version of the MySQL
Connector/C++ 8.0 series.

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

Crash in CC_from_PGresult

Our customers are crashing on Windows in CC_from_PGresult up to version 10.2.0 of the 64-bit driver. Do you know if this crash is fixed in a later version? Or what can I do to help get it fixed?

The call stack in 10.2.0 is:
psqlodbc35w!CC_from_PGresult+0xb1
psqlodbc35w!CC_send_query_append+0x1081
psqlodbc35w!QR_next_tuple+0xc7e
psqlodbc35w!SC_fetch+0x16d
psqlodbc35w!PGAPI_ExtendedFetch+0x100d
psqlodbc35w!SQLFetch+0xe9
odbc32!SQLFetch+0x35a

Thanks,
Dan

Getting an error for unixODBC library "odbcinst" not found while executing ./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10 in SuSE Linux 12.0 SP1

Hello,

I am trying to install PostgreSQL ODBC drivers in SuSE Linux 12.0 SP1 where
I am getting following error:
configure: error: unixODBC library "odbcinst" not found

I am able to see below libraries though under usr/lib64
libodbcinst.so.2 -> libodbcinst.so.2.0.0
libodbcinst.so.2.0.0

I did set the LD_LIBRARY_PATH to /usr/lib64 and set LDFLAGS=-ldl too.
However while executing below command I am getting an error:
./configure --with-unixodbc=/usr --with-libpq=/apps/PostgreSQL/10/data

I have tried to change --with-unixodbc multiple times but getting same
error.

ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'"

I've ported a powerbuilder application to postgresql. Tested ok on windows
10 64, was installed on two win10-64 other computers, all connecting the
postgresql database in the localhost with access via odbc. The third of
them presented the error detailed below in the logs (mylog and psqlodbc)
integrally copy and paste.
Can anyone help me?

- The application send the connect command and receive error "IM001"as a
response.
- The ODBC DSN interface test shows "connection successful".
- The log tell us that the connection to the database was effectively
completed by the driver.

psqlodbc Windows Server 2016

Dear PG-Team,

one Question: Which Version of psqlodbc_*.zip (<a href="https://www.postgresql.org/ftp/odbc/versions/msi/" title="https://www.postgresql.org/ftp/odbc/versions/msi/">https://www.postgresql.org/ftp/odbc/versions/msi/</a>) is compatible with Windows Server 2016?

Thanks for your answer!

Mit freundlichen Grüßen
Christian Haunsberger
Sachgebietsleiter
Anwendungsentwicklung BAU/ÖSI

ANN: Upscene releases Database Workbench 5.4.4

Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool:

" Database Workbench 5.4.4 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL.

ODBC cliens is hanging if network connection is broken

Hello PostgreSQL Community!

I downloaded and installed the latest version of PostgreSQL from
<a href="https://www.postgresql.org/ftp/source/v10.4/" title="https://www.postgresql.org/ftp/source/v10.4/">https://www.postgresql.org/ftp/source/v10.4/</a> on my SLES 12 system.
Here is my configuration of unixODBC:

odbcinst,ini
[PostgreSQL]
Description=PostgreSQL ODBC driver
Driver=/usr/local/lib/psqlodbcw.so
FileUsage=1

odbc.ini
[sles12-1]
Description = PostgreSQL connection to rtpdb
Driver = PostgreSQL
Database = rtpdb
Servername = sles12-1
Username =
Password =
Port = 5432
Protocol = 7.4+
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ConnSettings =

As a Driver in odbcinst.ini I specified the p

Windows 10 password problem

Hi, I'm running Postgres 10.3 (linux) with pg_hba configured to require
password (md5). The ODBC 32bit connection is set up properly and test
connection button shows success. I've got an application using ODBC 10.03
drivers on Windows 10 which can not connect using this connection and the
error message is: authentication failed for user. Postgres logs the same
error message.

I've got it working fine in Windows 8.1 and below.
Did anyone encounter anything like that ?

Patch to support service parameter & german translation

Hi,

attached three patches:

0001-Add-support-for-service-connection-parameters-TODO-U.patch

Adds support for the service parameter in connections
(see <a href="https://www.postgresql.org/docs/current/static/libpq-pgservice.html" title="https://www.postgresql.org/docs/current/static/libpq-pgservice.html">https://www.postgresql.org/docs/current/static/libpq-pgservice.html</a>)

0002-add-german-translation.patch

Adds German UI. Also includes some dialog layout fixes for the U.S.
version.

0003-Add-service-control-to-japanese-dialog.patch

Add the service field to the japanese ui (please check
the label - translated using google).

Please review and if ok apply. Thanks.

Jürgen

ANN: Stored routine debugger Hopper, version 2.0.1 released

Dear ladies and gentlemen,

Upscene Productions is proud to announce version 2.0.1 of "Hopper", a stored
routine debugger for InterBase, Firebird and MySQL.

Major version 2 has a fully renewed user interface, support for Firebird 3
packages, stored functions, MySQL diagnostic-statements, binary data in
variables and much more.

For more information, see <a href="http://www.upscene.com/go/?go=news&amp;id=20180627" title="http://www.upscene.com/go/?go=news&amp;id=20180627">http://www.upscene.com/go/?go=news&amp;id=20180627</a>

With regards,

Martijn Tonies

Upscene Productions
<a href="http://www.upscene.com" title="http://www.upscene.com">http://www.upscene.com</a>

Setting statement_timeout

Since 9.5 the Postgresql ODBC driver sets a default statement timeout.
According to Hiroshi the specific value (30 seconds) isn't set in the
driver but "from apps or middlewares". We have two applications which
issue queries which may take more than 30 seconds. One of which was
developed in house, so we can simply override the default in the
application (just issue "set statement_timeout = 299000" after
connecting), but the other one is commercial closed source software.

So my question is: Is there a way to change this setting globally (via
ODBC configuration, registry, whatever)?

Regarding life cycle information of psqlODBC

Hi,

I would like to know the source for obtaining life cycle information of
different versions of psqlODBC.

Thank you

Regards
Saksham Rastogi

psqlodbc driver issue with Win10 Update 1803

After updating their PCs several of our customers have heavy difficulties to
connect to their postgresql servers.

MySQL Cluster 7.6.6 GA has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Paritioning (Sharding) - Read & write scalability
- Transactional consistency across partitioned and distributed datasets
- Parallel cross partition queries such as joins
- Active-Active/Multi-Master geographic replication
- 99.9999% High Availability with on-line maintenance and no single point of
failure
- NoSQL and SQL APIs (including C++, Java

VB6 ODBC

Hello sir's
We want to run A VisiualBasic6 application connected with postgreSQL.
This application was running with Windows XP over many years.
Now the PC must be replaced by W7pro 64bit system.
I have installed postgreSQL 8.4 and psqlodbc_9_00_0310-x64 and later versions.
The W7 ODBC (32bit) datasource administrator does find : PostgreSql30 unicode(x64) source. Connection test ok.

RE: Bug report: x64 Row status Array uses wrong data type

I consider this closed as "bug in implementation by Oracle".

Thank you Clemens and Hiroshi for your time and effort!

Jari Siikarla

Mroonga 8.03 - Fast fulltext search for all languages on,MySQL

Mroonga 8.03 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready. It uses Groonga as a storage
and fulltext search engine.

Document:
<a href="http://mroonga.org/docs/" title="http://mroonga.org/docs/">http://mroonga.org/docs/</a>

How to install: Install Guide
<a href="http://mroonga.org/docs/install.html" title="http://mroonga.org/docs/install.html">http://mroonga.org/docs/install.html</a>

Blog:
<a href="http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html" title="http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html">http://mroonga.org/en/blog/2018/05/29/mroonga-8.03.html</a>

Changes:
<a href="http://mroonga.org/docs/news.html#release-8.03" title="http://mroonga.org/docs/news.html#release-8.03">http://mroonga.org/docs/news.html#release-8.03</a>

The main changes are as follows.

Re: NUMERIC type makes trouble in MS Access

Interesting detail: It's not an Access problem.

I've tested it with Python and Libre Office Base. NUMERIC without
precision gets set to 28,6 => like in Access.

Would it perhaps better to use MEMO instead of VARCHAR?
MEMO allows more than 8,000 chars in "Base" and some gigabytes in
Access.

But there's not enough space for an additional toggle switch :(

Syndicate content