What I'm Up To

    follow me on Twitter

    Recent Stuff

    Previous Stuff

    Recent Comments

    Links

    Subscribe to
    Posts [Atom]


    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:

    posted by Joe at 11:38 AM 0 Comments