(Fwd) plzzz help me out

----- Forwarded message from srilata devineni -----

Date: Tue, 12 Sep 2006 14:18:21 +0530
From: srilata devineni
To: Tim.Bunce@pobox.com, Anupama
Subject: plzzz help me out

HI, CAN ANY ONE HELP ME
ACTUALLY i'm new tp perl
I installed Active perl and DBImodule, DBD:: SQLite, DBD ::odbc, SQLserver 2000
now how to connect to sql server 2000 ,through perl script ,not throudg odbc connection .. is there any
way? ..
thanx


srilatha

----- End forwarded message -----

Re: (Fwd) plzzz help me out

On 9/12/06, Tim Bunce wrote:
> ----- Forwarded message from srilata devineni -----
>
> I installed Active perl and DBImodule, DBD:: SQLite, DBD ::odbc, SQLserver 2000
> now how to connect to sql server 2000 ,through perl script ,not throudg odbc connection .. is there any
> way? ..

Why do you not want to use ODBC? What would you rather use, and why?
The only relevant ways as far as this mailing list are concerned are
via DBI and DBD::ODBC. If you want to devise or obtain an
alternative, go to http://search.cpan.org/ to investigate your
options.

--
Jonathan Leffler #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

Re: (Fwd) plzzz help me out

On Tue, 12 Sep 2006 10:56:36 +0100
"Tim Bunce" wrote:

> I installed Active perl and DBImodule, DBD:: SQLite, DBD ::odbc,
> SQLserver 2000 now how to connect to sql server 2000 ,through perl
> script ,not throudg odbc connection .. is there any way? ..

=46rom a Linux client, I use DBD::ODBC driver to connect to a Microsoft
SQL Server database, it works fine. From Linux, another way is to use
DBD::Sybase, because Microsoft and Sybase are using the same
"Tabular Data Stream" protocol. But using DBD::Sybase to deal with a
Microsoft SQL Server brings a major limitation in my use: you can't
use ?-variable style in your prepared statements. A quick bench
revealed that DBD::ODBC was 50% slower than DBD::Sybase on a 1000
inserts script.

Under Microsoft Windows, you can also use DBD::ADO. As I don't run
Windows, I didn't try this solution.

Bye

--=20
Pierrick LE GALL
R&D engineer at Talend, Open data solution
http://talend.com