PxPlus User Forum

Twitter Twitter Twitter

Author Topic: ODBC 5.20 32bit  (Read 2288 times)

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 70
    • View Profile
ODBC 5.20 32bit
« on: December 18, 2018, 12:11:34 AM »
Hi All,

I am trying to install the ODBC 5.20 client on a windows 10 Pro 64 bit computer.
The server is running V14 (suite 2017 Upd1)
The desktops are all Windows Pro 64 bit version 17134
The 5.20 32 bit ODBC File Server is installed on the server.
Four desktops have the 5.20 32 bit ODBC driver installed and they work fine.
The fifth one is giving me a bucket load of grief.
I've tried installing the ODBC 5.20 32 bit as local admin, domain user and domain admin.
It installs OK but does NOT add the ODBC 32 bit setup to the start menu.
If I run the odbca32.exe from the Windows system32 folder and select ADD in either System DSN or User DSN it does NOT show the PxPlus ODBC driver (32bit)

Any suggestions?
Thanks
Mike H

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC 5.20 32bit
« Reply #1 on: December 18, 2018, 08:59:19 AM »
It sounds like there is something wrong/weird with that one machine if it installed on all of the other systems fine.

Have you tried right-clicking the installer and selecting 'Run as administrator' as a way to force the installer to have full access write to the machine. You should then get a User Account Control (UAC) pop-up asking you if the program should be allowed to make changes to your device, press Yes. After that the install should run with full access and it should all work correctly.

If that doesn't work then you may want to look at disabling your anti-virus. Some anti-virus packages can cause issues when wanting to do normal things like install legit software.

If that doesn't work I would try to figure out what is different about the system that doesn't work. I would also consider doing a repair/re-install of Windows on it.
Principal Software Engineer for PVX Plus Technologies LTD.

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 70
    • View Profile
Re: ODBC 5.20 32bit
« Reply #2 on: December 18, 2018, 04:45:12 PM »
I had already tried 'run as administrator'
I'm going to run the 1809 update and see what happens.
It is more or less a new windows install so at least as good as a repair.
Mike H

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 70
    • View Profile
Re: ODBC 5.20 32bit
« Reply #3 on: December 19, 2018, 05:22:34 PM »
I did the upgrade to windows 1809.
The odbca32 still does not appear in the start menu.
Running odbca32 does not find the PxPlus odbc driver.

Mike H

Mike King

  • Diamond Member
  • *****
  • Posts: 3810
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: ODBC 5.20 32bit
« Reply #4 on: December 19, 2018, 06:38:32 PM »
Just to be sure you are running the correct ODBC Admin -- the shortcut runs:

%windir%\syswow64\odbcad32.exe

And the title bar of the Windows reads:

ODBC Data Source Administration (32-bit)
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 70
    • View Profile
Re: ODBC 5.20 32bit
« Reply #5 on: December 20, 2018, 02:40:10 AM »
Loading odbca32 from the syswow64 worked.
I've always had success in the past loading from system32.
Something learned today!
Thanks
Mike H