Make an odbc connection with Oracle Instant Client

Thursday, July 15, 2010

This how you do it:

download client basic from oracle
download odbc client from oracle from here http://www.oracle.com/technology/software/tech/windows/odbc/index.html
combine unzipped file into a single directory in same directory
create a path to directory
create tns service string with host: port: sid (remember to use fully qualified names (com.foo.app)

create an odbc connection under administrativee tools > ODBC connections
Data source name: (tns name) server.foo.com
//host.foo.com:1533/sid.foo.com

Labels: oracle odbc