Date: Mon, 04 Dec 2006 17:14:43 -0500 From: "Brian J. McGovern" <mcgovern@beta.com> To: questions@freebsd.org Subject: Looking for a cookbook on Oracle clients... Message-ID: <200612042214.kB4MEhmD047158@spoon.beta.com>
next in thread | raw e-mail | index | archive | help
All, I have a task that requires I extract a data set from a MySQL server, and push it on to an Oracle (9i) server. I figured I'd go the ODBC route, and installed unix_odbc_driver and its dependencies. However, its pretty clear that I don't fully understand what I'm doing, and each step forward is costing me half a day of debugging, reading code, and banging my head against the wall. From the documents I can find on the web, it seems all I should have to do is install, configure my odbc.ini and odbcinst.ini files, and go. So, the questions: 1.) Is anyone using unixODBC and oracle_driver_odbc against a 9i server? 2.) If so, can someone send me their .ini files and any other environment and oracle settings they needed to do to make it work (mine are below)? 3.) Have people moved over to the instantclient in ports? If so, does anyone have some sample code to test the basic ability to connect? -Brian [Oracle] Description = Oracle Configuration Driver = Oracle Trace = Yes TraceFile = /var/log/odbc.log Database = eengstg Servername = oracle_server UserName = XXXXXXXX Password = XXXXXXXX Port = 1521 [Oracle] Description = Oracle driver for FreeBSD Driver = /usr/local/lib/liboraodbc.so Setup = /usr/local/lib/liboradbS.so
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200612042214.kB4MEhmD047158>