Hello, You can use Perl with DBI module. MSSQL DB can be accessed using Sybase DBI driver. In this case access to your DB would look like: $dbh = DBI->connect(dbi:sybase:dbhost:dbname, user_name, password) || die "Can't connect: $DBI::errstr\n"; $sql="SELECT my_column from some_table"; $sth = $dbh->prepare($sql) || die "Can't execute: $DBI::errstr\n"; $sth->execute || die "Can't execute: $DBI::errstr\n"; while ($hash_ref=$sth->fetchrow_hashref) { push @my_array, $hash_ref->{my_column} } $sth->finish; $dbh->disconnect; Regards. Alex -------------------
Hi
I have a problem that I hope someone here has overcome, we have
some
corporate databases still on MS Windows 2000 server and running SQLserver 2000, I am hoping that someone has found a query tool that will allow LINUX users to access(query) the databases. Any and all help is greatly appreciated.
Thanks Much
Rich
Richard A Sharpe Database Analyst and Administration (DBA) Sqlserver/DB2 Amherst Technologies 40 Continental Blvd Merrimack, NH 03054 PHONE .......(603) 579-6180 / (800) 431-8031 Cell phone ..(603) 320-7785 FAX ...........(603) 578-1072 EMAIL .......rsharpe@amherst1.com / Webpage ...www.amherst1.com
"Tenemos que tener fe" ("We must have faith")
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com