Bug #20206 for DBD-ODBC: DBD::ODBC maps column names incorrectly with unixodbc

Fri Jun 30 11:03:19 2006 Guest - Ticket created

Subject:

DBD::ODBC maps column names incorrectly with unixodbc

Hi Jeff, We've managed to get unixodbc working under Ubuntu so that we can read an MS Access database using the libmdb tools package. Yes, it was a complex setup. Perhaps we'll have time at the end of our project to send over some documentation. In the meantime, I want to point out a problem with the column_info function which is impacting the ability to do fetches into hashes. Instead of the column name showing up in column 4 of the column_info query, it's instead showing up in column 9. I suspect this is either a libmdb or unixodbc error but wanted to make you aware of it. Back to mapping arrays... Thanks, William

Wed Oct 18 05:04:18 2006 bohica [...] ntlworld.com - Correspondence added

On Fri Jun 30 11:03:19 2006, guest wrote: Show quoted text

> I suspect this is either a > libmdb or unixodbc error but wanted to make you aware of it.

I can almost guarantee this is not a unixODBC or DBD::ODBC issue and I think the most likely candidate is libmdb. I certainly get column names back in column 4 with a range of ODBC drivers, DBD::ODBC 1.13 and unixODBC 2.2.12: Show quoted text

SQL> create table fred (a int, b int, c int);

0 rows affected [martin@betdb testing]$ perl -e 'use DBI;$h = DBI->connect("dbi:ODBC:xxx","xxx","yyy");$s = $h->column_info(undef, undef, "fred", undef); $s->dump_results;' 'martin', 'dbo', 'fred', 'a', '4', 'int', '10', '4', '0', '10', '1', undef, undef, '4', undef, undef, '1', 'YES', '38' 'martin', 'dbo', 'fred', 'b', '4', 'int', '10', '4', '0', '10', '1', undef, undef, '4', undef, undef, '2', 'YES', '38' 'martin', 'dbo', 'fred', 'c', '4', 'int', '10', '4', '0', '10', '1', undef, undef, '4', undef, undef, '3', 'YES', '38' Look at what libmdb returns for the SQLColumns ODBC call. Martin

Wed Oct 18 05:04:19 2006 The RT System itself - Status changed from 'new' to 'open'

Tue Jul 17 10:42:34 2007 bohica [...] ntlworld.com - Correspondence added

If you are convinced this is a DBD::ODBC issues post back here the output from column_info and I'll take a look but I am fairly sure this is a mdbtools issue.

Tue Oct 09 05:19:18 2007 bohica [...] ntlworld.com - Status changed from 'open' to 'stalled'

Wed Apr 14 14:18:31 2010 bohica [...] ntlworld.com - Correspondence added

On Tue Jul 17 10:42:34 2007, MJEVANS wrote: Show quoted text

> If you are convinced this is a DBD::ODBC issues post back here the > output from column_info and I'll take a look but I am fairly sure this > is a mdbtools issue.

As I've heard nothing about this rt issue in over 6 months I am writing it off now. If you disagree with this let me know and I'll reopen the ticket. Martin -- Martin J. Evans Wetherby, UK

Wed Apr 14 14:18:32 2010 The RT System itself - Status changed from 'stalled' to 'open'

Wed Apr 14 14:18:51 2010 bohica [...] ntlworld.com - Status changed from 'open' to 'rejected'