Skip to Content.
Sympa Menu

freetds - Re: Linux - SQL 7

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Linux - SQL 7
  • Date: Mon, 20 Dec 1999 16:08:52 -0500 (EST)



The SYBASE variable should be set the location that freetds was installed,
by default this is /usr/local/freetds, otherwise it is whereever you
specified if you changed it by setting --prefix.

If you are using apache (if this is a CGI script) then you may want to
edit httpd.conf and define it using the SetEnv directive.

brian

On Mon, 20 Dec 1999, Esteban Aranda wrote:

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





Archive powered by MHonArc 2.6.24.

Top of Page