• SQL Developer
• SQLpal
• perl
  • DBD::Oracle includes install instructions in README.win32.txt. OMG, if you want to compile it, it looks hellacious.
  • you can also just use Strawberry Perl which includes support for ODBC.
    • "What are the practical differences between DBD::Oracle and DBD::Oracle"? I'm glad you asked:
      If you're already using ODBC for other databases, go ahead and use ODBC. If you find a speed or feature deficiency, you can always go to DBD::Oracle.

      Having said that, you'll still need the oracle client software on your machine to use the ODBC interface, so installing DBD::ODBC probably won't save you any time or effort on the installation phase. So if you don't have DBD::ODBC on your machine, and you don't anticipate doing so, you might just try DBD::Oracle first.

  • OKAY then. Well, it turns out that installing DBD::Oracle on Strawberry Perl isn't that difficult either. Go strawberry!
  • so... is it possible to create a .msi installer so other people can use my app semi-easily? Answer: sort of, maybe

DBD::ODBC

• how to install and create a DSN
• note that you do NOT need to create a DSN — search for "without DSN" here
• information on getting the right DSN string:
  • OraFaq.com
  • DSN and DBQ are Sources of Confusion When Connecting [to Oracle] via ODBC
• there are two different drivers you can use:
  • Microsoft ODBC for Oracle / MsOrcl32.dll (comes stock, installed)
    • DSN-less documentation
      • better documentation here
    • this has some issues connecting
  • Oracle's own / SqOra32.DLL (you have to install this separately)
    • DSN-less documentation
    • more info

DBD::JDBC

• useful tips