Subject: Re: Excel ODBC query loosing parameter when returning the query
 result directly to a pivot table.
To: pgsql-odbc@lists.postgresql.org
References: 
 <CADKKJw-jc6YCQkqmFrsDye2_qOe6QuP1XoC5f=CxYi_y77dhEQ@mail.gmail.com>
From: Danny Severns <djoesev@gmail.com>
Message-ID: <b231095b-478b-11d6-bc58-e55afc1f5cde@gmail.com>
Date: Wed, 8 Sep 2021 10:42:24 -0500
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: 
 <CADKKJw-jc6YCQkqmFrsDye2_qOe6QuP1XoC5f=CxYi_y77dhEQ@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------8199F7E0CBDF3AD9E69B3012"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/b231095b-478b-11d6-bc58-e55afc1f5cde%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------8199F7E0CBDF3AD9E69B3012
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

Have you tried looking at the Excel.dmp file that should have been 
created by the crash. You might also want to look at the windows event 
log to see if it is any help.  It sounds like a data type mismatch, but 
that is just a guess.

"It's so simple to be wise. Just think of something stupid to say and 
then don't say it." -Sam Levenson
On 9/8/2021 7:34 AM, Andreas Beier wrote:
> Hi everyone,
>
> I am using postgres odbc for quite a while within within excel using 
> parameters (i.e. using ?s within the query).
>
> When defining odbc queries in Excel I select "PivotTable Report" 
> instead of "Table", thus creating a pivot table directly without 
> having the raw data in an extra sheet.
>
> Once created, I can alter the query and define parameter (s)linking to 
> an excel cell.
>
> Everything works well until I (save and) reopen the file and try to 
> update: Than my excel crashs. :(
>
> I did find out, that the parameter definition I defined before is 
> empty when opening the file. When I do redefine it, everthing works 
> well again until I (save and) reopen the file and try to update: Than 
> my excel crashs. :(
>
> So it's very reproduceable.
>
> I am using the 32bit driver, latest version and I am running Excel 
> 2010 and 2016.
>
> Any idea whats wrong here?
>
> Thanks
> Andreas
>

--------------8199F7E0CBDF3AD9E69B3012
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body text="#0000ff" bgcolor="#FFFFFF">
    <p><font size="+1"><font face="Arial">Have you tried looking at the
          Excel.dmp file that should have been created by the crash. 
          You might also want to look at the windows event log to see if
          it is any help.  It sounds like a data type mismatch, but that
          is just a guess.</font></font><br>
    </p>
    <div class="moz-signature">"It's so simple to be wise. Just think of
      something stupid to say and then don't say it."
      -Sam Levenson</div>
    <div class="moz-cite-prefix">On 9/8/2021 7:34 AM, Andreas Beier
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CADKKJw-jc6YCQkqmFrsDye2_qOe6QuP1XoC5f=CxYi_y77dhEQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Hi everyone,</div>
        <div><br>
        </div>
        <div>I am using postgres odbc for quite a while within within
          excel using parameters (i.e. using ?s within the query).</div>
        <div><br>
        </div>
        <div>When defining odbc queries in Excel I select "PivotTable
          Report" instead of "Table", thus creating a pivot table
          directly without having the raw data in an extra sheet. <br>
        </div>
        <div><br>
        </div>
        <div>Once created, I can alter the query and define parameter
          (s)linking to an excel cell. <br>
        </div>
        <div><br>
        </div>
        <div>Everything works well until I (save and) reopen the file
          and try to update: Than my excel crashs. :(<br>
        </div>
        <div><br>
        </div>
        <div>I did find out, that the parameter definition I defined
          before is empty when opening the file. When I do redefine it,
          everthing works well again until I (save and) reopen the file
          and try to update: Than my excel crashs. :(
        </div>
        <div><br>
        </div>
        <div>So it's very reproduceable.<br>
        </div>
        <div><br>
        </div>
        <div>I am using the 32bit driver, latest version and I am
          running Excel 2010 and 2016.</div>
        <div><br>
        </div>
        <div>Any idea whats wrong here?</div>
        <div><br>
        </div>
        <div>Thanks</div>
        <div>Andreas<br>
        </div>
        <br>
      </div>
    </blockquote>
  </body>
</html>

--------------8199F7E0CBDF3AD9E69B3012--