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