Skip Menu |
 

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 20206
Status: rejected
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: william [...] knowmad.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.13
Fixed in: (no value)



Subject: DBD::ODBC maps column names incorrectly with unixodbc
Download (untitled) / with headers
text/plain 628b
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
Download (untitled) / with headers
text/plain 1005b
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
Download (untitled) / with headers
text/plain 158b
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.
Download (untitled) / with headers
text/plain 400b
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


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.