use DBI; use JDBC; $user="xxxx"; $password="xxxx"; $url = "jdbc:teradata://172.28.130.20/;databaseName=NED_BASE_VIEWS"; $url =~ s/([=;])/uc sprintf("%%%02x",ord($1))/eg; print $url; $dbh = DBI->connect("dbi:JDBC:hostname=172.28.130.20;port=1025;url=jdbc:teradata://172.28.130.20/;databaseName=NDW_JRNL_VIEWS", $user, $password);