Skip to Content.
Sympa Menu

freetds - Re: Linux - SQL 7

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Esteban Aranda" <earanda AT tracker.com.ar>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Linux - SQL 7
  • Date: Mon, 20 Dec 1999 14:59:45 -0300


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')
>





Archive powered by MHonArc 2.6.24.

Top of Page