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'

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 :(

RE: NUMERIC type makes trouble in MS Access

Here an update:

by default, MS Access sets linked tables with "unlimited" NUMERIC
to DECIMAL with "precision: 28" and "decimals: 6" (MS Access names).
Trying to read a value [INSERT INTO public.demo VALUES (1.0 / 3)]
breaks with an error.

When creating the column using NUMERIC(28, 24), MS Access shows this:
"precision: 28" and "decimals: 24".

Re: NUMERIC type makes trouble in MS Access

Some additional information about supported functions and mappings:

<a href="https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm" title="https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm">https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm</a>
<a href="https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions.htm" title="https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions.htm">https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions...</a>

Does PGSQL-ODBC map NUMERIC the same way (to SQL_NUMERIC)?

MS Access: still having problems with NUMERIC

Hi there,

three months ago I reported a problem when using the ODBC driver
version 10 or higher in connection with Access 2010 with field
type NUMERIC.

Unfortunately I haven't received any feedback yet. Shall I ask
the question again?

Best regards,
Tobias

psqlODBC 10.03.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 10.03.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

high cpu on idle state

Sorry to bother if my question is irrelevant
but I really would like to understand why
idle persistent connection would take more than 25% of a cpu

top -c

63844 postgres  20   0 4677440 289168 287320 S  33.9  0.9   0:03.43
postgres: freeswitch freeswitch 10.0.0.1(48634) idle
62774 postgres  20   0 4677480 286488 284636 S  29.9  0.9   1:22.17
postgres: freeswitch freeswitch 10.0.0.228(29664) idle
 4901 postgres  20   0 4677480 280812 278968 S  27.6  0.9   2:43.71
postgres: freeswitch freeswitch 10.0.0.5(39044) idle
 4847 postgres  20   0 4677480 279468 277624 S  24.9  0.8   2:35.25
post

Bug?

Hi,

I noticed high cpu usage with idle connections using

psqlodbc last git version:

10793 postgres  20   0 4677484 329672 327772 S  29.2  1.0 2:21.43
postgres: freeswitch freeswitch 10.0.0.228(50478) idle
12708 postgres  20   0 4677508 323524 321652 S  27.6  1.0 0:49.71
postgres: freeswitch freeswitch 10.0.0.230(56582) idle
12725 postgres  20   0 4677508 329232 327360 R  24.9  1.0 0:52.27
postgres: freeswitch freeswitch 10.0.0.5(6330) SELECT

3 nodes are connected through VPN with tinc, freeswitch is a voip server
that establishes permanent connection.

any idea?

Fedora 26 64bits

po

32-bit odbc source compilation failed

Hi,
We hope this message finds you well.
We are looking for a 32-bit compatible ODBC driver for RedHat Linux 7.4 64 -bit version for connecting 32-bit application to a 32- bit Data Source.
We downloaded the driver 'psqlodbc-10.02.0000.tar.gz' from the URL <a href="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2fwww.postgresql.org%2fftp%2fodbc%2fversions%2fsrc%2f&amp;umid=76FF58ED-6C26-0805-A753-765F80188BA7&amp;auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-e50cc6da79abab78c719160d67495dc9ce4fc6f9" title="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2fwww.postgresql.org%2fftp%2fodbc%2fversions%2fsrc%2f&amp;umid=76FF58ED-6C26-0805-A753-765F80188BA7&amp;auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-e50cc6da79abab78c719160d67495dc9ce4fc6f9">https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%...</a> released on 30-03-2018.

When we try to compile it,which failed with below error.

Build with Oracle Solaris Studio

Hi,

the small patch attached makes psqlodbc buildable using Oracle Solaris
Studio (tested with version 12.3).

Regards,
Maxim

Bug report: x64 Row status Array uses wrong data type

Hi

Thank you for psq odbc driver!

I've found an issue with 64 bit driver.
The array returned from fetch for row statuses uses 16 bit values
instead of 64 bit values.

Tested on x64 Windows (7, 10, srv2012 and srv2016)
with 64 bit psqlodbc-09.06.0500 (Unicode and ANSI)
Client is set ODBC version 2

Changing SQLUSMALLINT to SQLSETPOSIROW in descriptor.h
for two structs and in the code handling these structs fixed the issue.
Code in psqlodbc-10.02.0000 is the same for these parts.

struct IRDFields_
{
StatementClass *stmt;

MySQL Cluster Manager 1.4.6 has been released

Dear MySQL Users,

MySQL Cluster Manager 1.4.6 can be downloaded from
the My Oracle Support (MOS) website.

Problem with ODBC class

Hi, ALL,
Is there a reason why following function returns empty string?

SQLHSTMT stmt = 0;
SQLHDBC hdbc = 0;
int result = 0;
SQLLEN cbTableName = SQL_NTS, cbSchemaName = SQL_NTS;
SQLWCHAR *table_name = NULL, *schema_name = NULL, *qry = NULL;
SQLWCHAR *owner = NULL;
std::wstring query;
if( pimpl->m_subtype == L"PostgreSQL" )
query = L"SELECT u.usename FROM pg_class c, pg_user u,
pg_namespace n WHERE n.oid = c.relnamespace AND u.usesysid =
c.relowner AND n.nspname = ?

MySQL for Visual Studio 1.2.8 has been released

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release
of MySQL for Visual Studio 1.2.8.

This is a maintenance release for 1.2.x.

Mroonga 8.02 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.02 has been released!

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

ODBC 2.0 Bug: wrong timestamp data type

Hello!

I used the latest driver version
(psqlodbc_10_02_0000-x64.zip).
If your application uses ODBC version 2.0. When you
call SQLGetTypeInfo, the driver reports supported data
types that are not available for version 2.0. The first
iteration of the result of this function for the timestamp
data type is SQL_TYPE_TIMESTAMP. If you then call
SQLBindParameter, ODBC Manager returns s1003 (SQL1).log).
The error could be corrected (SQL2.log).

bigint disparity between two installations

I have a database on PostgreSQL 9.3 that I am accessing using psqlodbc
version 9.03.04.00 on a couple of different Windows machines.

I have some bigint fields that are truncated on only one of the machines.
I have called both of their odbc setups up and compared them screen by
screen a few times and they are setup the same.

A value that is stored in the database is: -40581311272
This value is read correctly on two of the machines, but is returned as
-405813112 on the third.

Registering DSN with odbcconf.exe overwrites the connection attributes with defaults

With the following command, the SSLmode of the DSN is defaults to disable,
even the "prefer" option is provided in the connection attributes.

odbcconf.exe /A {CONFIGDSN "PostgreSQL Unicode(x64)"
"DSN=test3|SSLmode=prefer"}

During the configDSN, first the connection attributes are parsed in
ParseAttributes function and later all the values are replaced with
defaults using getCiAllDefaults.

ODBC - psqlodbc-7.2.3

Hi,

I am not sure when i compiler the source using make, it failed. it worked fine when in execute the configure command.

I can't use the latest release. it does not work for me on the Solaris 10.

root@m# ./configure

checking for a BSD-compatible install... ./install-sh -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... nawk
checking whether make sets ${MAKE}... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
checking for C compiler default output...

MySQL Cluster 7.6.5-dmr 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.6.5-dmr, 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 Cluster 7.4.20 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 upg

MySQL Cluster 7.5.10 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.10, 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 Cluster 7.3.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 (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.3.21, has been released and can be downloaded from

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

MySQL Connector/Python 8.0.11 has been released

Dear MySQL users,

MySQL Connector/Python 8.0.11 is the first GA release version
of the MySQL Connector Python 8.0 series. This series adds 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/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

Syndicate content