Query tool to access MS SQLserver from SuSE 8.2
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")
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
On Monday 12 May 2003 10:26, Sharpe, Richard wrote:
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
[trimmed 11 lines of .sig] FreeTDS works fine. I have also been playing with Mono recently and you can write apps with it (console is all I have done) that will talk to MS-SQL. -- Kelly L. Fulks Home Account
participants (3)
-
Alex Daniloff
-
Kelly L. Fulks
-
Sharpe, Richard