Re: [Iodbc-macosx] Using the iodbctest application

[Ted T. Jr <tth...@op...>]

Hi, Donato --

On May 13, 2011, at 12:27 PM, Donato Azevedo wrote:

> Good'ay gentlemen,
> 
> I have been trying, unsuccessfuly, to use the iodbctest application to test a connection to a firebird databse. Using the graphical tool (iODBC Demo) I am able to connect, and thus, I suppose the problem is from where the iodbctest is reading its config, and how do I point it to the same configuration the iODBC demo uses (the one configured using the iODBC administrator)
> 
> I suppose iODBC was installed in a non standard location and I can't really find it... not even where the installed openlink driver is installed.
> 
> Thanks mates!


If you start iODBC Test with the double-clickable script, 
/Applications/iODBC/iODBC Test.command, it should work just 
as /Applications/iODBC/iODBC Demo.app ...

Note that OpenLink Software produces iODBC as well as the driver
you're apparently working with.

iODBC is bundled into Mac OS X by Apple, though they still ship
a long-outdated version, and they only bundle dylibs.  

You can get the latest version, which will not replace the Apple-
bundled dylibs by default, but will install both dylibs and 
Frameworks, here --

   <http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac_OS_X>

You can also get a script there which *will* replace the Apple-
shipped dylibs with the latest version.

If iodbctest has been built properly, it should call the iODBC
Driver Manager, which will use default System and User configuration
files respectively found at --

   /Library/ODBC/odbc.ini
   /Library/ODBC/odbcinst.ini

-- and --

   /Users/*/Library/ODBC/odbc.ini
   /Users/*/Library/ODBC/odbcinst.ini

In some cases, the following files may exist (and if so -- their 
content should generally be merged with the latter two above and 
then the following two files dropped) --

   /Users/*/.odbc.ini
   /Users/*/.odbcinst.ini



If iodbctest hasn't been built properly, you can force *one* pair 
of configuration files to be used by setting the environment 
variables, e.g., to use System DSNs --

   ODBCINI = /Library/ODBC/odbc.ini
   ODBCINSTINI = /Library/ODBC/odbcinst.ini

(If these variables are set, *no other* configuration files will
be used, no matter their location.)

I hope this helps.

Ted



--
A: Yes.                      http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Evangelism & Support         //        mailto:tth...@op...
                             //              http://twitter.com/TallTed
OpenLink Software, Inc.      //              http://www.openlinksw.com/
        10 Burlington Mall Road, Suite 265, Burlington MA 01803
                                 http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs              http://www.openlinksw.com/weblogs/virtuoso/
                               http://www.openlinksw.com/blog/~kidehen/
    Universal Data Access and Virtual Database Technology Providers