Linux - SQL 7

Esteban Aranda earanda at tracker.com.ar
Mon Dec 20 12:59:45 EST 1999


I'm trying to solve the problem :)

When I try to install the DBD::Sybase the program answer: (sorry for my bad
english)

Please set SYBASE in config or set the $sybase environment variable at
Makefile.PL..???

What I write in the variable?

Thank you again :))


> -----Mensaje original-----
> De: bounce-freetds-97371 at franklin.oit.unc.edu
> [mailto:bounce-freetds-97371 at franklin.oit.unc.edu]En nombre de Brian
> Bruns
> Enviado el: Viernes, 17 de Diciembre de 1999 06:05 p.m.
> Para: TDS Development Group
> Asunto: [freetds] Re: Linux - SQL 7
>
>
>
>
> 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
> >
>
>
> ---
> You are currently subscribed to freetds as: earanda at tracker.com.ar
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>




More information about the FreeTDS mailing list