Thread: Re: [BUGS] Sorry to bother you. Please tell me exactly how the compiler was built ODBC

Hi Копыченко-san.

sorry late reaction.

Here is explanation of the build method.
http://psqlodbc.projects.postgresql.org/win32-compilation.html
however, VS2012 is referred to by the reason Microsoft always
offers the newest IDE. I had not used VS2012 yet..:-(
therefore, It does not know whether it can build satisfactory.

then, build environment to recommend has Platform SDK.
It is "Windows SDK for Windows Server 2008 and .NET Framework 3.5"
http://www.microsoft.com/en-us/download/details.aspx?id=11310

P.S)
this subject have a desirable ODBC mailing list.
Please use here. thanks.
pgsql-odbc@postgresql.org

Best regards,
Hiroshi Saito

(2012/10/12 23:29), Копыченко Павел wrote:
> Sorry to bother you. Please tell me exactly how the compiler was built ODBC
> driver psqlodbc-09.01.0200 architecture for Windows 64? What exact version
> of the compiler? please
>
>



I've built psqlODBC-09.01.0200 sources on Windows 64. The testing with PostgreSQL 9.2 version gives the error "Could not connect to the server". I picked up the Windows installer of yours (psqlodbc_09_01_0200-x64.zip) and I see that the connection is successful.

I'm using Visual Studio 2010 and this is the command to compile:

nmake /f win64.mak ANSI_VERSION=yes PG_INC=%PG_HOME_PATH%\include PG_LIB=%PG_HOME_PATH%\lib SSL_INC=%OPENSSL_PATH%\include SSL_LIB=%OPENSSL_PATH%\lib LINKMT=no USE_SSPI=yes CPU=X64 CFG=Release ALL

On Sun, Oct 14, 2012 at 12:22 PM, Hiroshi Saito <hiroshi@winpg.jp> wrote:
Hi Копыченко-san.

sorry late reaction.

Here is explanation of the build method.
http://psqlodbc.projects.postgresql.org/win32-compilation.html
however, VS2012 is referred to by the reason Microsoft always
offers the newest IDE. I had not used VS2012 yet..:-(
therefore, It does not know whether it can build satisfactory.

then, build environment to recommend has Platform SDK.
It is "Windows SDK for Windows Server 2008 and .NET Framework 3.5"
http://www.microsoft.com/en-us/download/details.aspx?id=11310

P.S)
this subject have a desirable ODBC mailing list.
Please use here. thanks.
pgsql-odbc@postgresql.org

Best regards,
Hiroshi Saito


(2012/10/12 23:29), Копыченко Павел wrote:
Sorry to bother you. Please tell me exactly how the compiler was built ODBC
driver psqlodbc-09.01.0200 architecture for Windows 64? What exact version
of the compiler? please





--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs



Hi Sandeep-san.

please use psqlodbc-09.02.0100.tar.gz.
http://www.postgresql.org/ftp/odbc/versions/src/

It Inoue-san fixed VS version problem error.h.
==
Don't #include errno.h on Windows. VC10 or later intentionally changed
 the values of error numbers like EINTR, EWOULDBLOCK.

http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=cf6d2079ec25fc8acca0b776ca3901dc83b13867
==

Regards,
Hiroshi Saito

(2013/06/20 17:59), Sandeep Thakkar wrote:
> I've built psqlODBC-09.01.0200 sources on Windows 64. The testing with
> PostgreSQL 9.2 version gives the error "Could not connect to the
> server". I picked up the Windows installer of yours
> (psqlodbc_09_01_0200-x64.zip) and I see that the connection is successful.
>
> I'm using Visual Studio 2010 and this is the command to compile:
>
> nmake /f win64.mak ANSI_VERSION=yes PG_INC=%PG_HOME_PATH%\include
> PG_LIB=%PG_HOME_PATH%\lib SSL_INC=%OPENSSL_PATH%\include
> SSL_LIB=%OPENSSL_PATH%\lib LINKMT=no USE_SSPI=yes CPU=X64 CFG=Release ALL
>
> On Sun, Oct 14, 2012 at 12:22 PM, Hiroshi Saito <hiroshi@winpg.jp
> <mailto:hiroshi@winpg.jp>> wrote:
>
>     Hi Копыченко-san.
>
>     sorry late reaction.
>
>     Here is explanation of the build method.
>     http://psqlodbc.projects.__postgresql.org/win32-__compilation.html
>     <http://psqlodbc.projects.postgresql.org/win32-compilation.html>
>     however, VS2012 is referred to by the reason Microsoft always
>     offers the newest IDE. I had not used VS2012 yet..:-(
>     therefore, It does not know whether it can build satisfactory.
>
>     then, build environment to recommend has Platform SDK.
>     It is "Windows SDK for Windows Server 2008 and .NET Framework 3.5"
>     http://www.microsoft.com/en-__us/download/details.aspx?id=__11310
>     <http://www.microsoft.com/en-us/download/details.aspx?id=11310>
>
>     P.S)
>     this subject have a desirable ODBC mailing list.
>     Please use here. thanks.
>     pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
>
>     Best regards,
>     Hiroshi Saito
>
>
>     (2012/10/12 23:29), Копыченко Павел wrote:
>
>         Sorry to bother you. Please tell me exactly how the compiler was
>         built ODBC
>         driver psqlodbc-09.01.0200 architecture for Windows 64? What
>         exact version
>         of the compiler? please
>
>
>
>
>
>     --
>     Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org
>     <mailto:pgsql-bugs@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/__mailpref/pgsql-bugs
>     <http://www.postgresql.org/mailpref/pgsql-bugs>
>
>
>
>



Hi Hiroshi

I used psqlodbc-09.02.0100 and it works fine. Thanks.

I also back ported this patch to psqlodbc-09.01.0200 and it also works fine there as well. I hope this is fine.


On Thu, Jun 20, 2013 at 6:05 PM, Hiroshi Saito <hiroshi@winpg.jp> wrote:
Hi Sandeep-san.

please use psqlodbc-09.02.0100.tar.gz.
http://www.postgresql.org/ftp/odbc/versions/src/

It Inoue-san fixed VS version problem error.h.
==
Don't #include errno.h on Windows. VC10 or later intentionally changed
 the values of error numbers like EINTR, EWOULDBLOCK.

http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=cf6d2079ec25fc8acca0b776ca3901dc83b13867
==

Regards,
Hiroshi Saito

(2013/06/20 17:59), Sandeep Thakkar wrote:
> I've built psqlODBC-09.01.0200 sources on Windows 64. The testing with
> PostgreSQL 9.2 version gives the error "Could not connect to the
> server". I picked up the Windows installer of yours
> (psqlodbc_09_01_0200-x64.zip) and I see that the connection is successful.
>
> I'm using Visual Studio 2010 and this is the command to compile:
>
> nmake /f win64.mak ANSI_VERSION=yes PG_INC=%PG_HOME_PATH%\include
> PG_LIB=%PG_HOME_PATH%\lib SSL_INC=%OPENSSL_PATH%\include
> SSL_LIB=%OPENSSL_PATH%\lib LINKMT=no USE_SSPI=yes CPU=X64 CFG=Release ALL
>
> On Sun, Oct 14, 2012 at 12:22 PM, Hiroshi Saito <hiroshi@winpg.jp
> <mailto:hiroshi@winpg.jp>> wrote:
>
>     Hi Копыченко-san.
>
>     sorry late reaction.
>
>     Here is explanation of the build method.
>     http://psqlodbc.projects.__postgresql.org/win32-__compilation.html
>     <http://psqlodbc.projects.postgresql.org/win32-compilation.html>
>     however, VS2012 is referred to by the reason Microsoft always
>     offers the newest IDE. I had not used VS2012 yet..:-(
>     therefore, It does not know whether it can build satisfactory.
>
>     then, build environment to recommend has Platform SDK.
>     It is "Windows SDK for Windows Server 2008 and .NET Framework 3.5"
>     http://www.microsoft.com/en-__us/download/details.aspx?id=__11310
>     <http://www.microsoft.com/en-us/download/details.aspx?id=11310>
>
>     P.S)
>     this subject have a desirable ODBC mailing list.
>     Please use here. thanks.
>     pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
>
>     Best regards,
>     Hiroshi Saito
>
>
>     (2012/10/12 23:29), Копыченко Павел wrote:
>
>         Sorry to bother you. Please tell me exactly how the compiler was
>         built ODBC
>         driver psqlodbc-09.01.0200 architecture for Windows 64? What
>         exact version
>         of the compiler? please
>
>
>
>
>
>     --
>     Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org
>     <mailto:pgsql-bugs@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/__mailpref/pgsql-bugs
>     <http://www.postgresql.org/mailpref/pgsql-bugs>
>
>
>
>





Hi Sandeep-san.

Good:-)
However, psqlODBC is latest version to be able to connecting each
release version of Postgres. why did you use the old driver?

Regards,
Hiroshi Saito

(2013/06/21 16:11), Sandeep Thakkar wrote:
> Hi Hiroshi
>
> I used psqlodbc-09.02.0100 and it works fine. Thanks.
>
> I also back ported this patch to psqlodbc-09.01.0200 and it also works
> fine there as well. I hope this is fine.
>
>
> On Thu, Jun 20, 2013 at 6:05 PM, Hiroshi Saito <hiroshi@winpg.jp
> <mailto:hiroshi@winpg.jp>> wrote:
>
>     Hi Sandeep-san.
>
>     please use psqlodbc-09.02.0100.tar.gz.
>     http://www.postgresql.org/ftp/odbc/versions/src/
>
>     It Inoue-san fixed VS version problem error.h.
>     ==
>     Don't #include errno.h on Windows. VC10 or later intentionally changed
>      the values of error numbers like EINTR, EWOULDBLOCK.
>
>     http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=cf6d2079ec25fc8acca0b776ca3901dc83b13867
>     ==
>
>     Regards,
>     Hiroshi Saito
>
>     (2013/06/20 17:59), Sandeep Thakkar wrote:
>     > I've built psqlODBC-09.01.0200 sources on Windows 64. The testing with
>     > PostgreSQL 9.2 version gives the error "Could not connect to the
>     > server". I picked up the Windows installer of yours
>     > (psqlodbc_09_01_0200-x64.zip) and I see that the connection is
>     successful.
>     >
>     > I'm using Visual Studio 2010 and this is the command to compile:
>     >
>     > nmake /f win64.mak ANSI_VERSION=yes PG_INC=%PG_HOME_PATH%\include
>     > PG_LIB=%PG_HOME_PATH%\lib SSL_INC=%OPENSSL_PATH%\include
>     > SSL_LIB=%OPENSSL_PATH%\lib LINKMT=no USE_SSPI=yes CPU=X64
>     CFG=Release ALL
>     >
>     > On Sun, Oct 14, 2012 at 12:22 PM, Hiroshi Saito <hiroshi@winpg.jp
>     <mailto:hiroshi@winpg.jp>
>     > <mailto:hiroshi@winpg.jp <mailto:hiroshi@winpg.jp>>> wrote:
>     >
>     >     Hi Копыченко-san.
>     >
>     >     sorry late reaction.
>     >
>     >     Here is explanation of the build method.
>     >
>     http://psqlodbc.projects.__postgresql.org/win32-__compilation.html
>     <http://postgresql.org/win32-__compilation.html>
>     >     <http://psqlodbc.projects.postgresql.org/win32-compilation.html>
>     >     however, VS2012 is referred to by the reason Microsoft always
>     >     offers the newest IDE. I had not used VS2012 yet..:-(
>     >     therefore, It does not know whether it can build satisfactory.
>     >
>     >     then, build environment to recommend has Platform SDK.
>     >     It is "Windows SDK for Windows Server 2008 and .NET Framework 3.5"
>     >     http://www.microsoft.com/en-__us/download/details.aspx?id=__11310
>     >     <http://www.microsoft.com/en-us/download/details.aspx?id=11310>
>     >
>     >     P.S)
>     >     this subject have a desirable ODBC mailing list.
>     >     Please use here. thanks.
>     >     pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
>     <mailto:pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>>
>     >
>     >     Best regards,
>     >     Hiroshi Saito
>     >
>     >
>     >     (2012/10/12 23:29), Копыченко Павел wrote:
>     >
>     >         Sorry to bother you. Please tell me exactly how the
>     compiler was
>     >         built ODBC
>     >         driver psqlodbc-09.01.0200 architecture for Windows 64? What
>     >         exact version
>     >         of the compiler? please
>     >
>     >
>     >
>     >
>     >
>     >     --
>     >     Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org
>     <mailto:pgsql-bugs@postgresql.org>
>     >     <mailto:pgsql-bugs@postgresql.org
>     <mailto:pgsql-bugs@postgresql.org>>)
>     >     To make changes to your subscription:
>     >     http://www.postgresql.org/__mailpref/pgsql-bugs
>     >     <http://www.postgresql.org/mailpref/pgsql-bugs>
>     >
>     >
>     >
>     >
>
>
>
>
>



Hi

Not using the older driver. Using 09.02.0100 now. :)

Thanks for your help.


On Fri, Jun 21, 2013 at 7:55 PM, Hiroshi Saito <hiroshi@winpg.jp> wrote:
Hi Sandeep-san.

Good:-)
However, psqlODBC is latest version to be able to connecting each
release version of Postgres. why did you use the old driver?

Regards,
Hiroshi Saito

(2013/06/21 16:11), Sandeep Thakkar wrote:
> Hi Hiroshi
>
> I used psqlodbc-09.02.0100 and it works fine. Thanks.
>
> I also back ported this patch to psqlodbc-09.01.0200 and it also works
> fine there as well. I hope this is fine.
>
>
> On Thu, Jun 20, 2013 at 6:05 PM, Hiroshi Saito <hiroshi@winpg.jp
> <mailto:hiroshi@winpg.jp>> wrote:
>
>     Hi Sandeep-san.
>
>     please use psqlodbc-09.02.0100.tar.gz.
>     http://www.postgresql.org/ftp/odbc/versions/src/
>
>     It Inoue-san fixed VS version problem error.h.
>     ==
>     Don't #include errno.h on Windows. VC10 or later intentionally changed
>      the values of error numbers like EINTR, EWOULDBLOCK.
>
>     http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=cf6d2079ec25fc8acca0b776ca3901dc83b13867
>     ==
>
>     Regards,
>     Hiroshi Saito
>
>     (2013/06/20 17:59), Sandeep Thakkar wrote:
>     > I've built psqlODBC-09.01.0200 sources on Windows 64. The testing with
>     > PostgreSQL 9.2 version gives the error "Could not connect to the
>     > server". I picked up the Windows installer of yours
>     > (psqlodbc_09_01_0200-x64.zip) and I see that the connection is
>     successful.
>     >
>     > I'm using Visual Studio 2010 and this is the command to compile:
>     >
>     > nmake /f win64.mak ANSI_VERSION=yes PG_INC=%PG_HOME_PATH%\include
>     > PG_LIB=%PG_HOME_PATH%\lib SSL_INC=%OPENSSL_PATH%\include
>     > SSL_LIB=%OPENSSL_PATH%\lib LINKMT=no USE_SSPI=yes CPU=X64
>     CFG=Release ALL
>     >
>     > On Sun, Oct 14, 2012 at 12:22 PM, Hiroshi Saito <hiroshi@winpg.jp
>     <mailto:hiroshi@winpg.jp>
>     > <mailto:hiroshi@winpg.jp <mailto:hiroshi@winpg.jp>>> wrote:
>     >
>     >     Hi Копыченко-san.
>     >
>     >     sorry late reaction.
>     >
>     >     Here is explanation of the build method.
>     >
>     http://psqlodbc.projects.__postgresql.org/win32-__compilation.html
>     <http://postgresql.org/win32-__compilation.html>
>     >     <http://psqlodbc.projects.postgresql.org/win32-compilation.html>
>     >     however, VS2012 is referred to by the reason Microsoft always
>     >     offers the newest IDE. I had not used VS2012 yet..:-(
>     >     therefore, It does not know whether it can build satisfactory.
>     >
>     >     then, build environment to recommend has Platform SDK.
>     >     It is "Windows SDK for Windows Server 2008 and .NET Framework 3.5"
>     >     http://www.microsoft.com/en-__us/download/details.aspx?id=__11310
>     >     <http://www.microsoft.com/en-us/download/details.aspx?id=11310>
>     >
>     >     P.S)
>     >     this subject have a desirable ODBC mailing list.
>     >     Please use here. thanks.
>     >     pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
>     <mailto:pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>>
>     >
>     >     Best regards,
>     >     Hiroshi Saito
>     >
>     >
>     >     (2012/10/12 23:29), Копыченко Павел wrote:
>     >
>     >         Sorry to bother you. Please tell me exactly how the
>     compiler was
>     >         built ODBC
>     >         driver psqlodbc-09.01.0200 architecture for Windows 64? What
>     >         exact version
>     >         of the compiler? please
>     >
>     >
>     >
>     >
>     >
>     >     --
>     >     Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org
>     <mailto:pgsql-bugs@postgresql.org>
>     >     <mailto:pgsql-bugs@postgresql.org
>     <mailto:pgsql-bugs@postgresql.org>>)
>     >     To make changes to your subscription:
>     >     http://www.postgresql.org/__mailpref/pgsql-bugs
>     >     <http://www.postgresql.org/mailpref/pgsql-bugs>
>     >
>     >
>     >
>     >
>
>
>
>
>




--
Sandeep Thakkar
Senior Software Engineer
EnterpriseDB Corporation
The Postgres Database Company
Phone: +91.20.30589505

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com/
Follow us on Twitter: http://www.twitter.com/enterprisedb

This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message.