Diff for "ODBCDriver" - Creative Computing Wiki

Differences between revisions 3 and 4

Installing ODBC driver manager (top level driver)

install unixODBC driver manager for Linux platform (WIN32 already have ODBC driver manager)

yum install unixODBC

tested configuration:

unixODBC-2.2.9-1 for Fedora Core 3
unixODBC-2.2.11-1 for Fedora Core 4

install ODBC driver for specific database (low level driver)

Linux/Postgres (do not use packages from yum, they are too old for Fedora Core 3/4, for 5-7 you can try but make sure that it will install 08.xxx version)

There is a source rpm on sam:/u2/programs/databases_and_odbc/postgresql-odbc-08.01.0200-1.2.src.rpm for Fedora Core 3 or 4 there are prebuild odbc on sam (Core 3) and fuzzy (Core 4). Just mount them somewhere somehow and do make install. Otherwise have a FUN

on Fedora Core 3
cd sam:/u2/vlad/psodbc/psqlodbc-08.01.0200
make install
on Fedora Core 4
cd fuzzy:/home/postgres/psqlodbc-08.01.0200
make install

Win32 connected to Linux/PostgreSQL server:
- download driver and other stuff from http://pgfoundry.org/projects/pgw32cli/, then follow instructions
Win32/MSSQL and */Oracle have drivers included in server or client packages

-  ⇤ ← Revision 3 as of 2006-07-20 03:51:02 → 
  Size: 1071
  Editor: yoch
  Comment:
+   ← Revision 4 as of 2007-07-05 02:49:29 → ⇥
  Size: 1201
  Editor: yoch
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 3:
-install unixODBC driver for Linux platform (WIN32 already have ODBC driver manager)
+install '''unixODBC driver manager''' for Linux platform (WIN32 already have ODBC driver manager)
 Line 11:
-=== install ODBC driver for specific database ===
 *Linux/Postgres (do not use packages from '''yum''', they are too old)
+=== install ODBC driver for specific database (low level driver) ===
 *Linux/Postgres (do not use packages from '''yum''', they are too old for Fedora Core 3/4, for 5-7 you can try but make sure that it will install '''08'''.xxx version)