<p>This command line:</p>
<pre><code>hobbes@metalbaby:~$ sqlt -f DBI -t GraphViz --db-user username --db-password '...' \
--dsn 'dbi:JDBC:hostname=localhost:9001;url=jdbc:sqlserver://10.0.0.5'
</code></pre>
<p>returns:</p>
<pre><code>Error: translate: Error with parser 'SQL::Translator::Parser::DBI': JDBC not supported
at /usr/share/perl5/SQL/Translator/Parser/DBI.pm line 154.
</code></pre>
<p>If you're not familiar with <code>DBD::JDBC</code>, here is my synopsis: the thing has at least two components: a standalone java application which speaks JDBC on one side and listens for incoming connections on the other. It acts as a proxy... The perl part of <code>DBD::JDBC</code> talks to the little server. So, a variety of RBDMS are made available to perl's <code>DBI</code> via this bridge. (I guess DBI is to perl as JDBC is to Java?)</p>
<p>So I looked around a little and determined that I should implement <code>SQL::Translator::Parser::DBI::JDBC</code>. I inspected <code>SQL::Translator::Parser::DBI::SQLServer</code> for guidance. I quit when I saw the following in the <code>DBD::JDBC</code> <code>README</code> file.</p>
<blockquote>
<p>NOT YET IMPLEMENTED<br>
DBI-defined methods, including </p>
<pre><code> DBI->data_sources('JDBC'), $dbh->data_sources
the metadata methods $dbh->table_info, $dbh->tables,
$dbh->type_info_all, $dbh->type_info, $dbh->column_info,
$dbh->primary_key_info, $dbh->primary_key,
$dbh->foreign_key_info
</code></pre>
</blockquote>
<p>Meanwhile, I'll return to trying to use <code>unixODBC</code> to talk to MS SQL Server.</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-translator/issues/53">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAjN6NrDCvHye0xkw2aPjldp2tZ7oks5oE6zZgaJpZM4ENm_7.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/dbsrgits/sql-translator/issues/53"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>