Trafodion Windows ODBC driver crashes on Windows 8 machine

[Jieping Zhang]

Trafodion Windows ODBC driver doesn't work on Windows 8 machine. After created a data source using MS ODBC Administrator, test connection will fail with error "ODBC Administrator has stopped working, Restart/Debug the program" returned, so no connection to server could be made.

[Daniel Lu (ping-lu)]

We have way to prove it is win8 ODBC Administrator’s issue. what I did was:
1. I copied odbcad32.exe from win7 system C:\windows\system32 folder to win8 machine. And run it and test the connection in it(I’ve created a DSN “traf dsn”). It ran very well and test successfully.
2. If you ran the win8 native odbcad32.exe you will have this problem. If you replace the win8 one with win7 one, the issue will disappear.
3. Open the test dialog for trafodion dsn on win7 odbcad32.exe you will found the Server ID was filled automatically by info from the DSN. But win8 one is not, it is empty.
4. I’ve tried with ODBCTEST, it work as expected.
Mean times, this only occur with 64 bit win 8 system and 64bit driver

Actually, we have some debug session on driver for this issue about 1Yr before. It turned out 64 bit win8 odbcad32.exe have some wrong code which is only for 32bit app(technically speaking, using 32bit HWND pointer). We’ve been trying to open a MS supports for win8 64 ODBC Administrator, but we were failing to get the MS support account information. So we were holding on this issue.

Version number for odbcad32.exe
in Win7
6.1.7600.16385
In Win8
6.2.9200.16384
If win8 ODBC have something special they should have some document/spec for it. and wish ww developer to follow up. but I can’t found any doc and changes for win8 on internet.

[Aruna Sadashiva (aruna-sadashiva)]

Looks like there is an issue with Windows 8 ODBC Administrator. This post is for Postgres, but should apply for all drivers, there is a workaround that we maybe able to use:

http://social.technet.microsoft.com/Forums/windows/en-US/4cea8098-fa08-489f-99ca-ee3ab5592dc0/odbc-data-source-administrator-64bit-crashes-when-i-try-to-invoke-postgresql-ansix64-or?forum=w8itprogeneral

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Lu, Ping (Daniel, HPIT-GADSC)
Sent: Wednesday, May 28, 2014 12:10 AM
To: Sadashiva, Aruna
Subject: [Bug 1323746] Re: Trafodion Windows ODBC driver crashes on Windows 8 machine

We have way to prove it is win8 ODBC Administrator’s issue. what I did was:
1. I copied odbcad32.exe from win7 system C:\windows\system32 folder to win8 machine. And run it and test the connection in it(I’ve created a DSN “traf dsn”). It ran very well and test successfully.
2. If you ran the win8 native odbcad32.exe you will have this problem. If you replace the win8 one with win7 one, the issue will disappear.
3. Open the test dialog for trafodion dsn on win7 odbcad32.exe you will found the Server ID was filled automatically by info from the DSN. But win8 one is not, it is empty.
4. I’ve tried with ODBCTEST, it work as expected.
Mean times, this only occur with 64 bit win 8 system and 64bit driver

Actually, we have some debug session on driver for this issue about 1Yr before. It turned out 64 bit win8 odbcad32.exe have some wrong code which is only for 32bit app(technically speaking, using 32bit HWND pointer). We’ve been trying to open a MS supports for win8 64 ODBC Administrator, but we were failing to get the MS support account information. So we were holding on this issue.

Version number for odbcad32.exe
in Win7
6.1.7600.16385
In Win8
6.2.9200.16384
If win8 ODBC have something special they should have some document/spec for it. and wish ww developer to follow up. but I can’t found any doc and changes for win8 on internet.

--
You received this bug notification because you are subscribed to Trafodion.
Matching subscriptions: traf
https://bugs.launchpad.net/bugs/1323746

Title:
  Trafodion Windows ODBC driver crashes on Windows 8 machine

Status in Trafodion:
  In Progress

Bug description:
  Trafodion Windows ODBC driver doesn't work on Windows 8 machine. After
  created a data source using MS ODBC Administrator, test connection
  will fail with error "ODBC Administrator has stopped working,
  Restart/Debug the program" returned, so no connection to server could
  be made.

To manage notifications about this bug go to:
https://bugs.launchpad.net/trafodion/+bug/1323746/+subscriptions

[Daniel Lu (ping-lu)]

fix it by geting rid of windows buggy API (DialogBoxParam ). creating windows process ourselves.