I am using the following code and i get the below error

use DBI;
use DBD::JDBC;

my $url="JDBC:gfsql://cqserver=fiappl03itf:30305";
my $hostname="fiappl03itf.fmrco.com";
my $port=30305;
my $dsn ='jdbc:gfsql';
my
$dbh= DBI->connect("DBI::$dsn;hostname=$hostname;port=$port;url=$url;jdbc_character_set=ASCII") or

die "Couldn't connect to database: " . DBI->errstr;

$sth = $dbh->prepare("select cusip,source from TT_VIEW");
$sth->execute();
while ($row = $sth->fetch()) {
print $row;
}

I am getting the below error.

Can't connect to data source jdbc:gfsql;hostname=fiappl03itf.fmrco.com;port=30305;url=JDBC:gfsql://cqserver=fiappl03itf:30305;jdbc_character_set=ASCII, no database driver specified and DBI_DSN env var not set at jdbc_conn.pl line 16

Hi,

I think the connection string is wrong...looking at the docs:
http://search.cpan.org/~vizdom/DBD-JDBC-0.70/JDBC.pod

It should be more like "dbi:JDBC:hostname...". See that documentation for full details of the module - I'm not in any way familiar with it so I can't tell you any more than it can.

Jonathan
###
for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
(tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
/(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");