Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

There are no Columns in the Result Set

Symptoms

During the export of tables from PostgreSQL database through the ODBC connection the following message arises: “There are no columns in the result set”.

Cause

PostgreSQL ODBC DSN is not properly tuned on your PC.

Solution

Please, in the ODBC Administrator open the ODBC DSN that you use to connect to the PostgreSQL database, click the “Datasource” button and on “Advanced Options” page check the option “Use Declare/Fetch” in your PostgreSQL driver, like it is specified in the picture below:


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/troubleshooting-guide/postgresql/export-conversion/no_columns_in_result_set.txt · Last modified: March 20, 2013, 04:14:22 AM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement