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'

Repository odbc driver AIX 7.1

Hi,

I'm trying to find out a repository of odbc driver package for AIX 7.1, but
I only found postgresql server packages, is there any repository ?
If there isn't any repository, could I use cross-compile odbc driver from
linux x64 to aix 7.1 power ? could you share me any documentation that
explain the compilation process ( I supposed that it's in a different way
of <a href="https://odbc.postgresql.org/docs/unix-compilation.html" title="https://odbc.postgresql.org/docs/unix-compilation.html">https://odbc.postgresql.org/docs/unix-compilation.html</a> explains ) ?

Thanks

Mroonga 8.09 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.09 has been released!

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

Estimate mysqldump size

Hello,

Is there a way that gives an estimate of the size of a mysqldump such a
way that it would always be larger than the real size?

So far, I have found:

mysql -s -u root -e "SELECT SUM(data_length) Data_BB FROM
information_schema.tables WHERE table_schema NOT IN
('information_schema','performance_schema','mysql');

but the result may be smaller than the real size.

I am writting a program that takes the result of mysqldump and pipe it
in a tar file.

Segmentation fault in case Debian9+odbc+pgsql10.6

Hi guys,

FYI - I noted that i have not problems with Deb9+pgsql9 and with
Deb8+pgsql10
But!

Segmentation fault in case Debian9+odbc+pgsql10.6

Hi guys,

FYI - I noted that i have not problems with Deb9+pgsql9 and with
Deb8+pgsql10
But!

bugfix: bit/varbit type support

hi, all

patch attached,please review.

support the type BIT/BIT VARYING
1. calculate column length correctly.
2. reverse type name correctly

it cause SQLColAttribute can not get
SQL_DESC_BASE_COLUMN_NAME/SQL_DESC_TYPE_NAME.

ODBC driver on OSX

Hi,
I downloaded the source code and then did:

./configure
make
sudo make install

on the sources

Then I opened iODBC DM 64-bit but couldn't find any references to the driver.

What did I do wrong?

This is on OSX 10.13.6 High Sierra.

Thank you.

psqlODBC 11.00.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 11.00.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.

Mysql-proxy Load balancer for replication servers.

Hello Folks,

I have installed mysql-proxy in multiple Freeswitch PBX servers
and they are Live and I have master ans salve mechanism configured for
MySQL, Eventually, I want a mechanism which can balance a load of query on
mysql servers like round robbin fashion, but the lua script in mysql-proxy
is not balancing it properly.

Is there anyone who can help to achieve this scenario.

*Thanks & Regards,*
*Dhaval Chaudhary*
Jr. Software Engineer
[image: Ecosmob Technologies Pvt. Ltd.]
<https://htmlsig.com/t/000001C50ZHN>
Ecosmob Technologies Pvt.

FAQ update

Hi

Can someone please replace my name on the FAQ (
<a href="https://odbc.postgresql.org/faq.html" title="https://odbc.postgresql.org/faq.html">https://odbc.postgresql.org/faq.html</a>) with whatever is appropriate now
please?

Thanks!

MySQL Encryption-at-rest capability

Hi MySQL Community,

Greetings !

I have a query regarding encryption-at-rest feature in MySQL Community Edition -

What i understand is that Encryption-at-rest is supported from MySQL-5.7.11 community edition and only on file-per-table basis which means encryption at table-level can be implemented - is that correct ?

Also, if you can help us understand the security compliance requirements (like PCI-DSS etc.) this encryption can satisfy, that would be great. Thanks in advance !

Please confirm !
Regards,
Ven

enhanced SQLSpecialColumns

hi, all

patch attched,please review.

If a table has not WITH OIDS option.
Try to find primary-key(prefered)/unique index.
If it has not either of them, returns "ctid" as text type.

ODBC SQLSpecialColumns bugfix

hi, all

odbc patch attached.

if a table does not exist,
SQLSpecialColumns returns oid/xmin incorrectly.

Does the psqlodbc driver support asynchronous queries?

Hello everyone,

I'm trying to run asynchronous queries with unixODBC + psqlodbcw.so in
linux (RHEL5), but I can not do it.

The next code:

//-------
// Get the Async state
SQLINTEGER attrState;
SQLGetConnectAttr(hstmt, SQL_ATTR_ASYNC_ENABLE, &attrState, 0, NULL);
std::cout << "Async is set to: " << attrState << std::endl;
// Enable Async Operation - if ASYNC is not allowed, SQLSetStmtAttr
// will return an error
retcode = SQLSetStmtAttr (hstmt, SQL_ATTR_ASYNC_ENABLE,
(SQLPOINTER) SQL_ASYNC_ENABLE_ON,
SQL_IS_INTEGER);
CHECK_ERROR(retc

Out of memory while reading tuples

Hi,

Postgres 10.4 64bit on Windows
psqlODBC 10.03.0000
- Use Declare/Fetch is off
- Cache size is 10'000'000

Issuing a simple select statement with Microsoft Access gives me the following
ODBC error:

"Out of memory while reading tuples.; memory allocation error??? (#4)"

The statement returns 822701 rows (via JDBC), average row size is 100 bytes.

On <a href="https://odbc.postgresql.org/docs/config.html" title="https://odbc.postgresql.org/docs/config.html">https://odbc.postgresql.org/docs/config.html</a> it says:
"Cache Size: When using cursors, this is the row size of the tuple cache. If not
using cursors, this is how many tuples to allocate memory for at any given time.

Problem compiling in mac os with unix odbc

Hi pgsql odbc folks,

I'm having problems compiling this code.

I installed unixodbc like this:

I'm running this to compile it

But I'm facing some errors, all similar to this one:

^

Could you help me out?
Do you know what I'm doing wr

Connections from mysql8.0 to mysql5.1 - bad handshake

I'm trying to configure replication of a mysql5.1 database master server
to a mysql8.0 database server.
But the replication connection will not succeed.

I don't believe the issue is directly related to replication, because
any connection attempt from mysql8.0 to mysql5.1 fails as follows.
As run from the mysql8.0 server:
$ mysql -h db5.1server.mydomain.com -u my_user -p
Enter password:
ERROR 1043 (08S01): Bad handshake

Given the following bug report, what I am trying to do does not sound
hopeful:
<a href="https://bugs.mysql.com/bug.php?id=90994" title="https://bugs.mysql.com/bug.php?id=90994">https://bugs.mysql.com/bug.php?id=90994</a>

I'm in the middle of a transition from centos6 to ce

SQLExecDirectW returns SQL_SUCCESS even if sql finishes with error

Hi,

I have a problem in psqlODBC.

SQLExecDirectW() returns SQL_SUCCESS even if sql finishes with error when client_min_messages = fatal.
It works correctly when client_min_messages = error.

I think the cause is following.

connection.c
CC_send_query_append()

...
while (self->pqconn && (pgres = PQgetResult(self->pqconn)) != NULL) // (1)
{
int status = PQresultStatus(pgres); // (2)

if (discardTheRest)
continue;
switch (status)
{
...
case PGRES_BAD_RESPONSE:
case PGRES_FATAL_ERROR:
handle_pgres_error(self, pgres, "send_query", res, TRUE); // (3)
...

When cli

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

Hi there,

In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user?

With regards,

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

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

Log file

Hi, ALL,
I'm trying to test the functionality of logging on my older Mac with
PostgreSQL 9.1.

I see that the logile is created with the owner of postgres and the
group of wheel.

Is there a way to make it open with "<current_user><current_user>"?
Or I will have to change the owner/group manuall every time I will
access the file?

Thank you.

High cpu usage

Good day all

Hoping this mail finds you well.

I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month.

We are running an opensips server on Centos 6.5 , using mysql 5.7.13 which was installed via Tarball file.

The server is setup as a slave and master and receives updates from opensips config nodes as well as registrations from workers.

Replication is paused during the day and forward replication (master) is disabled at the moment.

However , we are getting

MySQL Cluster 7.6.8 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.8, has been released and can be downloaded from

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

MySQL Cluster 8.0.13-dmr has been released

Dear MySQL Users,

MySQL Cluster is the distributed database combining massive
scalability and high availability. It provides in-memory
real-time access with transactional consistency across
partitioned and distributed datasets. It is designed for
mission critical applications.

MySQL Cluster has replication between clusters across multiple
geographical sites built-in.

MySQL Cluster 7.5.12 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.12, 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>

ANN: Upscene releases Database Workbench 5.4.6

Upscene releases Database Workbench 5.4.6

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

“ Database Workbench 5.4.6 "

This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure, a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

Here's the full list of

MySQL Connector/NET 8.0.13 has been released

Dear MySQL users,

MySQL Connector/NET 8.0.13 is the first version to support
Entity Framework Core 2.1 and the third general availability release
of MySQL Connector/NET to add support for the new X DevAPI,which
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 Community Server 5.5.62 has been released

Dear MySQL users,

MySQL Server 5.5.62 is a new version of the 5.5 production release of
the world's most popular open source database. MySQL 5.5.62 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 Community Server 5.6.42 has been released

Dear MySQL users,

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

MySQL Connector/Node.js 8.0.13 has been released

Dear MySQL users,

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

MySQL Community Server 5.7.24 has been released

Dear MySQL users,

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

MySQL Connector/ODBC 8.0.13 has been released

Dear MySQL users,

MySQL Connector/ODBC 8.0.13 is a new version in the MySQL
Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server.

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 server version from 5.5.

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

MySQL Workbench 8.0.13 has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.13 as our general available (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
ofplatforms 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.13 (2018-10-22, General Availability)

* Server Support

*

MySQL Router 8.0.13 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Router 8.0.13 is a new release for MySQL Router 8.0 series.

MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Router 8.0.13.

The MySQL Router is a new building block for high availability solutions
based on MySQL InnoDB clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applicat

MySQL Enterprise Backup 8.0.13 has been released

Dear MySQL users,

MySQL Enterprise Backup 8.0.13, 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 Enterprise Backup is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.13 only supports MySQL Server 8.0.13. For
earlier versions of MySQL 8.0, use the MySQL Enterprise Backup version
with the same version number as the server.

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

[This is part 2 of the announcement]

Bugs Fixed

* Important Note: The libevent library included with the
MySQL Server was upgraded to version 2.1.8. (Bug
#28207237)

* InnoDB; Partitioning: Removed old InnoDB handler and
partitioning code that referenced .frm files, and thus no
longer had any purpose. (Bug #27995316)

* InnoDB: An assertion was raised during a DROP TABLE
operation. A thread that was accessing the table through
the memcached API released metadata locks before
releasing the table.

MySQL Connector/C++ 8.0.13 has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.13 is a new 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.

MySQL Community Server 8.0.13 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.13, a new version of the popular Open Source
Database Management System, has been released.

Crash in 64 bit ODBC driver when using bookmarks

Dear Sir or Madam,

I think I have found a bug in the PostgreSQL ODBC driver (of which I am using the latest version 10_03).
I am using SQLBindCol to bind a bookmark column of type SQL_C_VARBOOKMARK.

Everything works perfectly when I compile my application in 32 bit mode and use the 32 bit ODBC driver.
With the 64 bit driver I get an instant crash (memory exception).
With logging turned on, the last entry in the mylog is the following:
[SC_Create_bookmark]3133: entering type=-2 buflen=64 buf=000000000C6AF268

I can also attach a debugger and the crash happens at the following line:

What is the problem with this code?

Hi, ALL,

[code]
std::wstring query1 = L"SHOW log_directory";
std::wstring query2 = L"SHOW log_filename";
SQLWCHAR *qry1 = new SQLWCHAR[query1.length() + 2];
SQLWCHAR *qry2 = new SQLWCHAR[query2.length() + 2];
memset( qry1, '\0', query1.length() + 2 );
memset( qry2, '\0', query2.length() + 2 );
uc_to_str_cpy( qry1, query1 );
uc_to_str_cpy( qry2, query2 );
RETCODE ret = SQLAllocHandle( SQL_HANDLE_STMT, m_hdbc, &m_hstmt );
if( ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO )
{
ret = SQLPrepare( m_hstmt, qry1, SQL_NTS );
if( ret != S

TR: Request for quotation and partnership for ODBC Driver

Dear Sir,

DATAVENIR is a software reseller company in France and french speaking countries.

One of our education (Research Center) customers is looking to renew his license ODBC Driver
Can you send me your best price with our discount for :

,- 1 license Actual ODBC mysql server and ODBC postgresql server Driver for Open Source Databases (server edition)
- 1 license Actual ESS Adaptateur (server edition)
For Mac OS

Best regards,

Vedaste BARNIER
[cid:image005. ... at 01CCBBE1 dot C3134F00]<http://www.datavenir.com/>

PS + : Spécialiste distribution logiciel, nous pouvons vous renseigner sur + de 10

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

Syndicate content