Wondering How to Uninstall/Remove unixODBC

[Charlie McKeon]

Hi.

I'm trying to adapt a PHP web application to a changeover in database management system (DBMS) from MySQL to Vertica.

In Vertica's Programmer's Guide I read

For 64-bit Linux installations, Vertica requires that the UnixODBC driver version 2.2.14 be compiled using the BUILD_LEGACY_64_BIT_MODE option, which sets SQLLEN to 4 bytes, instead of the default 8 bytes.

Follow these instructions to install UnixODBC on 64-bit Linux:

1. Uninstall/Remove unixODBC 2.2.11 or 2.2.11 from the machine.

I am wondering how to do that. (I asked Vertica about it weeks ago but got nothing from them.) Does someone here know how?

[Nick Gorham]

Hi,

if your existing unixODBC was installed from source, its just a case of removing the libodbc*.so files from your lib directory. That should be enough. if it was installed by a package manager, use that to remove the package.

BTW. with 2.2.14 the default SQLLEN was 4 bytes, With the current 2.3.0 build the default is 8 bytes.