Linux - SQL 7

Brian Bruns camber at umcc.ais.org
Fri Dec 17 16:05:16 EST 1999




On Fri, 17 Dec 1999, Esteban Aranda wrote:

> 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.
>
You'll need two things.  First the FreeTDS C libraries (specifically
ctlib). You need to configure these with the --with-tdsver=4.2 (or 7.0,
but that is experimental at this point).  Once made and installed you'll
need the DBD::Sybase module for Perl. (Sybase and MS SQL use the same
protocol, so it works despite its name ;-)
 
Once you install freetds you'll need to add an entry in
/usr/local/freetds/interfaces for the dataserver you want to access.  

For more info on DBD::Sybase check out http://www.mbay.net/~mpeppler

Brian

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




More information about the FreeTDS mailing list