Hi Jeff, MySQL - 3.23.55 -NOTE- In order to get iODBC working, (I'm reasonably sure it was iODBC - I've been concurrently trying to install MyODBC, iODBC and DBD::ODBC for the last 3 weeks or so, and I just recently got iODBC and MyODBC working,) I had to download the source and compile it with the --enable-thread-safe-client option set. Both versions are 3.23.55.
I'm curious about the DBI_USER & DBI_PASS vars - (I do have them set.) Arent't the user and pass for a DSN determined in the odbc.ini file(s)? If I have a DSN called myodbc3, the USER and PASS are specified in there anyway. As to Standard or Max, I'm not sure. Actually, that may be a bit complex - the server I have running on this machine is a binary distribution I got from: http://www.entropy.ch/software/macosx/mysql/ However, as I mentioned earlier, I had to download the source & recompile with the --enable-thread-safe-client in order to get iODBC working, so the client is part of what I got from www.mysql.com. If it helps, in the source directory where I comiled the client libs, at the top of INSTALL-SOURCE it says 'Quick Standard Installation of MySQL' Hope this helps, and thanks for the quick reply, Chris > Chris, > > FYI -- it's been one of my tasks to get MyODBC up anyway...so this will > doevetail into what I'm doing. Which version of MySQL did you get, > Standard or Max? > > Do you have DBI_USER and DBI_PASS set? > > Jeff > > > > > > > Hi, > > > > I've been trying to get DBD::ODBC to work on a Mac OS 10.2 > > machine using MyODBC/iODBC. For now I just want it to connect > > to the MySQL server running on localhost - eventually I need > > it to connect to a TSM server, but for now I just want it to > > pass the tests. > > > > I know that iODBC/MyODBC/MySQL are all working because I can do this: > > > > [izzy:Perl/darwin/DBD-ODBC-1.04] chris# odbctest DSN=myodbc3 > > iODBC Demonstration program This program shows an interactive > > SQL processor > > Driver: 03.51.05 > > > > SQL> show tables > > > > Tables_in_test > > ---------------------------------------------------------------- > > test > > > > result set 1 returned 1 rows. > > > > ++++++++ > > I made sure /etc/odbc.ini, ~/.odbc.ini and > > ~/Library/ODBC/odbc.ini all look the same, which is like so: > > > > ... > > [myodbc3] > > Driver = /usr/lib/libmyodbc3.dylib > > Description = MySQL ODBC 3.51 Driver DSN > > SERVER = localhost > > PORT = 3306 > > USER = root > > Password = > > Database = test > > OPTION = 3 > > SOCKET = > > ... > > > > I noticed one of the help files said to use UID in place of > > USER, but that had no effect. > > > > when I run make test, the following happens: > > > > [izzy:Perl/darwin/DBD-ODBC-1.04] chris# make test > > TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch > > -Iblib/lib -I/System/Library/Perl/darwin > > -I/System/Library/Perl -e 'use Test::Harness qw(&runtests > > $verbose); $verbose=1; runtests @ARGV;' t/*.t > > t/01base............1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok > > t/02simple..........1..19 ok 1 Test 2: connecting to the > > database dubious > > Test returned status 0 (wstat 10, 0xa) > > DIED. FAILED tests 2-19 > > Failed 18/19 tests, 5.26% okay > > > > ++++++++++ > > That's not a verbose enough answer for me to figure out > > what's causing that, so I'm hoping one of you might know what > > I'm doing wrong. > > > > BTW, my $DBI_DSN is > > dbi:ODBC:myodbc3 > > > > Thanks, > > > > Chris > > > > > >
