Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Tree [be5d89] v2.50.3 /
History



File Date Author Commit
samples 1999-04-26 Patrick van Kleef Patrick van Kleef [54aa9c] * Removed CVS Id tag from header so Makefile.am...
.cvsignore 1999-01-18 Patrick van Kleef Patrick van Kleef [213bad] * Added unwanted files
.indent.pro 1999-01-18 Patrick van Kleef Patrick van Kleef [e5674e] * Set default options
AUTHORS 1999-03-17 Patrick van Kleef Patrick van Kleef [d964ff] * Added Per Schroder who contributed the VMS pa...
COPYING 1999-01-18 Patrick van Kleef Patrick van Kleef [17be76] * Added information on LGPL licensing
ChangeLog 1999-06-25 Patrick van Kleef Patrick van Kleef [2aeff6] * Added latest changes to the log
IAFA-PACKAGE 1999-01-18 Patrick van Kleef Patrick van Kleef [fe1abb] * Version number is now set to 2.50
INSTALL 1999-01-18 Patrick van Kleef Patrick van Kleef [5ee3b2] * Added to comply to GNU standards
Makefile.am 1999-06-25 Patrick van Kleef Patrick van Kleef [48a24c] * Added sql.h, sqlext.h and sqltypes.h to the l...
Makefile.in 1999-06-25 Patrick van Kleef Patrick van Kleef [a6c5dc] * Regenerated (pvk)
NEWS 1999-01-18 Patrick van Kleef Patrick van Kleef [80ba0b] * Added new files to comply with standard GNU s...
README 1999-06-25 Patrick van Kleef Patrick van Kleef [0946cd] * Updated README to reflect the current state o...
aclocal.m4 1999-04-24 Patrick van Kleef Patrick van Kleef [cd09c7] * Updated to more recent version of libtool 1.2...
catalog.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
config.guess 1999-04-24 Patrick van Kleef Patrick van Kleef [cd09c7] * Updated to more recent version of libtool 1.2...
config.h 1999-04-26 Patrick van Kleef Patrick van Kleef [3c5086] * Set default system wide odbc.ini to /etc/odbc...
config.sub 1999-04-24 Patrick van Kleef Patrick van Kleef [cd09c7] * Updated to more recent version of libtool 1.2...
configure 1999-06-25 Patrick van Kleef Patrick van Kleef [cd4275] * Regenerated file (pvk)
configure.in 1999-06-25 Patrick van Kleef Patrick van Kleef [ad342d] * Fixed check for default SYS_ODBC_INI when con...
connect.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
dlf.c 1999-04-24 Patrick van Kleef Patrick van Kleef [eda42f] * Small code cleanups (pvk)
dlf.h 1999-04-24 Patrick van Kleef Patrick van Kleef [eda42f] * Small code cleanups (pvk)
dlproc.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
dlproc.h 1999-04-24 Patrick van Kleef Patrick van Kleef [eda42f] * Small code cleanups (pvk)
execute.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
fetch.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
hdbc.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
hdbc.h 1999-03-16 Patrick van Kleef Patrick van Kleef [6ec9a0] * Wrote new handle validation checks to make th...
henv.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
henv.ci 1999-04-24 Patrick van Kleef Patrick van Kleef [9c4399] * Use the libtool define to check for underscor...
henv.h 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
herr.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
herr.ci 1999-03-22 Patrick van Kleef Patrick van Kleef [891ac8] * Fixed a couple of typos (pvk)
herr.h 1999-01-18 Patrick van Kleef Patrick van Kleef [a6b729] * Re-indented code
hstmt.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
hstmt.h 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
info.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
install-sh 1999-01-18 Patrick van Kleef Patrick van Kleef [5d082d] * Added support for automake 1.4, autoconf 2.13...
iodbc.def 1999-04-24 Patrick van Kleef Patrick van Kleef [da6571] * Added Windows link file for iodbc.dll (pvk)
iodbc.exp 1999-06-25 Patrick van Kleef Patrick van Kleef [0134b4] * Removed empty line as this causes confusion t...
isql.h 1999-06-25 Patrick van Kleef Patrick van Kleef [6bd76f] * Renamed isql.h, isqlext.h and isqltypes.h to ...
isqlext.h 1999-06-25 Patrick van Kleef Patrick van Kleef [6bd76f] * Renamed isql.h, isqlext.h and isqltypes.h to ...
isqltypes.h 1999-06-25 Patrick van Kleef Patrick van Kleef [6bd76f] * Renamed isql.h, isqlext.h and isqltypes.h to ...
itrace.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
itrace.h 1999-01-18 Patrick van Kleef Patrick van Kleef [a6b729] * Re-indented code
libiodbc.spec 1999-06-25 Patrick van Kleef Patrick van Kleef [a0dfc4] * Added sql.h, sqlext.h, sqltypes.h to the list...
ltconfig 1999-04-24 Patrick van Kleef Patrick van Kleef [cd09c7] * Updated to more recent version of libtool 1.2...
ltmain.sh 1999-04-24 Patrick van Kleef Patrick van Kleef [cd09c7] * Updated to more recent version of libtool 1.2...
main.c 1999-04-24 Patrick van Kleef Patrick van Kleef [eda42f] * Small code cleanups (pvk)
misc.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
missing 1999-01-18 Patrick van Kleef Patrick van Kleef [5d082d] * Added support for automake 1.4, autoconf 2.13...
mkinstalldirs 1999-01-18 Patrick van Kleef Patrick van Kleef [5d082d] * Added support for automake 1.4, autoconf 2.13...
odbc.ini.sample 1999-01-18 Patrick van Kleef Patrick van Kleef [0fc4e5] * Added sample odbc.ini file
prepare.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
result.c 1999-06-25 Patrick van Kleef Patrick van Kleef [ba28dc] * Use sql.h and sqlext.h instead of the nonstan...
sql.h 1999-06-25 Patrick van Kleef Patrick van Kleef [6bd76f] * Renamed isql.h, isqlext.h and isqltypes.h to ...
sqlext.h 1999-06-25 Patrick van Kleef Patrick van Kleef [6bd76f] * Renamed isql.h, isqlext.h and isqltypes.h to ...
sqltypes.h 1999-06-25 Patrick van Kleef Patrick van Kleef [d6be95] * Changed typedef for SQLHENV, SQLHDBC, SQLSTMT...
vmscompile.com 1999-03-17 Per Schroder Per Schroder [806bbe] * Added support for VMS (ps)

Read Me

#
#  README
#
#  (C) 1999 OpenLink Software Inc.
#
#  The iODBC driver manager.
#
#  This library is free software; you can redistribute it and/or
#  modify it under the terms of the GNU Library General Public
#  License as published by the Free Software Foundation; either
#  version 2 of the License, or (at your option) any later version.
#
#  This library is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
#  Library General Public License for more details.
#
#  You should have received a copy of the GNU Library General Public
#  License along with this library; if not, write to the Free
#  Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.


1. iODBC driver manager platform availability

    iODBC driver manager has been ported to following Unix platforms: 

	SunOS		4.1.x		Sun Sparc
	HP/UX		9.x, 10.x	HP9000 s700/s800
	HP/UX		9.x 		HP9000 s300/s400		
	IBM AIX		3.x, 4.x 	IBM RS6000, PowerPC
	Sun Solaris	2.x		Sun Sparc, PCx86
	SGI Irix SVR4	5.x, 6.x	IP12 MIPS, IP22 MIPS
	NCR SVR4 	3.x		NCR 3435
	UnixWare SVR4.2 1.x, 2.x	x86
	DEC Unix(OSF/1)	3.x, 4.x	DEC Alpha
	FreeBSD		2.x		x86
	BSDI BSD/OS 	2.x		?
	Linux ELF 	1.2.x, 1.3.x	x86
	SCO OpenServer 	5.x 		x86
	Max/OS SVR4	1.x		Concurrent Maxion 9200 MP
	DG/UX		5.x		Aviion
	OpenVMS		6.x		DEC Alpha
	Windows NT	4.x		x86
	
    
    As the iODBC driver manager uses autoconf/automake/libtool it should
    be portable to most modern UNIX platforms out of the box. However if
    you do need to make changes to the code or the configuration files,
    we would appreciate you share your changes with the rest of the
    internet community by mailing your patches to iodbc@openlinksw.com
    so we can include them for the next build

    Porting of iODBC driver manager to some non-UNIX operating systems
    such as Windows family(3.x, 95, NT), OS/2 and Mac is supported but has
    not been compiled and tested recently. Of cause, you need to supply
    a make/build file and a short LibMain for creating the iodbc.dll.



2. How to build iODBC driver manager:

    step 1. Run configure to adjust to target platform
    step 2. Run make
    step 3. Run make install
   
    Here is an example:

   	$ ./configure --prefix=/usr/local --with-iodbc-inidir=/etc
	...
	...
	...
	$ make
	...
	...
	...
	$ su
	# make install
	...
	...
	...

    The configure program will examine your system for various compiler
    flags, system options etc. In some cases extra flags need to be
    added for the C compiler to work properly.

    E.g. on HP systems you may need:

	$ CFLAGS="-Ae -O" ./configure --prefix=/usr/local ..........


    Note that the path of the system wide odbc.ini file is calculated as 
    follows (based on flags to ./configure):

   	no --prefix			default is /usr/local/etc/odbc.ini 
	--prefix=/usr			/etc/odbc.ini
	--prefix=/xxx/yyy		/xxx/yyy/etc/odbc.ini
	--sysconfdir=/xxx/yyy		/xxx/yyy/odbc.ini
	--with-iodbc-inidir=/xxx/yyy	/xxx/yyy/odbc.ini


3. odbc.ini

    Driver manager and drivers use odbc.ini file or connection string
    when establishing a data source connection. On Windows, odbc.ini is
    located in Windows directory. 
   
    On UNIX, the iODBC driver manager looks for the odbc.ini file in the
    following sequence:

	1. check environment variable ODBCINI 

	2. check $HOME/.odbc.ini

	3. check home in /etc/passwd and try .odbc.ini in there

	4. system wide odbc.ini (settable at configuration time)


    Item 1 is the easiest as most drivers will also look at this variable.



    The format of odbc.ini( or ~/.odbc.ini ) is defined as:

	odbc.ini	  ::= data_source_list

	data_source_list  ::= /* empty */
			   | data_source '\n' data_source_list

	data_source	  ::= '[' data_source_name ']' '\n' data_source_desc

	data_source_name  ::= 'default' | [A-Za-z]*[A-Za-z0-9_]*

	data_source_desc  ::= /* empty */
			   | attrib_desc '\n' data_source_desc

	addrib_desc	  ::= Attrib '=' attrib_value

	Attrib		  ::= 'Driver' | 'PID' | 'UID' | driver_def_attrib

	driver_def_attrib ::= [A-Za-z]*[A-Za-z0-9_]*



    An example of an odbc.ini file:

	;
	;  odbc.ini
	;
	[ODBC Data Sources]
	Myodbc		= Myodbc
	Sample		= OpenLink Generic ODBC Driver
	Virtuoso	= Virtuoso

	[Sample]
	Driver          = /usr/local/openlink/lib/oplodbc.so.1
	Description     = Sample OpenLink DSN
	Host            = localhost
	UserName        = openlink
	Password        = xxxx
	ServerType      = Oracle 8
	Database        = 
	FetchBufferSize = 99
	ReadOnly        = no
	TraceFile       = /tmp/odbc.trace
	Trace           = 1

	[Virtuoso]
	Driver		= /usr/local/virtuoso/lib/virtodbc.so.1
	Address		= localhost:1112
	Database	= Demo

	[Myodbc]
	Driver 		= /home/patrick/src/iODBC/new/myodbc/myodbc.so
	HOST   		= localhost

	[Default]
	Driver 		= /usr/local/openlink/lib/oplodbc.so.1


4. Tracing

    iODBC driver manager traces driver's ODBC call invoked by the driver
    manager. Default tracing file is ./odbc.log. Tracing option (i.e.
    on/off or optional tracing file name) can be set in odbc.ini file
    (under a data source section) as:

	TraceFile = <optional_trace_file>
	Trace = ON | On | on | 1 | OFF | Off | off | 0

    If <optional_trace_file> is stderr or stdout, i.e.
   
        TraceFile = stderr 
   
    or

	TraceFile = stdout

    the tracing message will go to the terminal screen (if it is available).

    iODBC driver manager allows one to tune on/off tracing on selected
    connection(s). Different connections can share one or use different
    tracing file(s). ODBC calls on connections without tuning tracing
    on will not be traced.