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
