[ensembl-dev] Database names? show databases;

[Andy Yates]

Hi Maury,

It seems that this is a known "issue" with the MySQL/ODBC connector:

http://forums.mysql.com/read.php?37,206198,206198#msg-206198
http://bugs.mysql.com/bug.php?id=39965

A number of users there suggest some answers but it seems from the last post on the bug report that DATABASE is a required parameter in a connection String; something other connectors such as DBD::mysql & JDBC/ConnectorJ do not enforce. Unfortunately we don't support connections made via ODBC but it sounds like both Matthew & Beth have given some good suggestions to help you out. 

If you do find out anything else about this issue then please let us know as I'm sure others will find this useful in the future.

All the best,

Andy

Andrew Yates                   Ensembl Core Software Project Leader
EMBL-EBI                       Tel: +44-(0)1223-492538
Wellcome Trust Genome Campus   Fax: +44-(0)1223-494468
Cambridge CB10 1SD, UK         http://www.ensembl.org/

On 19 Jun 2012, at 11:25, Maury Markowitz wrote:

> On 2012-06-19, at 4:32 AM, Matthew Astley wrote:
>> (Maybe you've tried already, but) the schemas mysql and
>> information_schema should always be available.  Hopefully that's
>> enough workaround to get things going?
> 
> Perhaps... I'll definitely try.
> 
> So would this be a bug in ODBC then? Should I report it as such?
> 
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> List admin (including subscribe/unsubscribe): http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/