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 > >
