Linux - SQL 7

Esteban Aranda earanda at tracker.com.ar
Fri Dec 17 12:47:25 EST 1999


Sorry if the question it's too stupid, but I don't know how to use the
module freetds.

I´m using perl/DBI/DBD-ODBC to connect with my SQL7 in Win98/NT and my code
is something like this:

my ($sel) = " Select cod_atributo, cod_atributo_c from orden_busqueda".
		" where tipo_entidad = 'ED'".
		" order by orden";
my ($desc_te);
my $dbh1 = DBI->connect("dbi:ODBC:EntryDatabase", "user", "password");
my $sth1 = $dbh1->prepare( $sel );
$sth1->execute();
$sth1->bind_columns( undef, \$cod_atributo, \$cod_atributo_c );
while($sth1->fetch()) {
	print "code:".$cod_atributo;
	print "code2:".$cod_atributo_c;
}
$sth1->finish();
$dbh1->disconnect();

How can I do that in Linux with perl/DBI/FreeTDS ?

Thank you very much.

´¯`·.¸¸.·´Esteban·´¯`·.¸¸.·´
Earanda at tracker.com.ar
Buteler & Peralta Ramos





More information about the FreeTDS mailing list