RE: [SLE] Query tool to access MS SQLserver from SuSE 8.2
Thanks, that would be fine for me and few other's but what I need is a query tool that stupid users can use like they have in MS Sqlserver (query analyzer), type in your select statement and press run, get a window back with the results. Thanks Rich
-----Original Message----- From: Alex Daniloff [mailto:alex@daniloff.com] Sent: Monday, May 12, 2003 11:46 AM To: =?iso-8859-1?q?=22Sharpe@gate.daniloff.com; ?= Richard" Cc: suse-linux-e@suse.com Subject: Re: [SLE] Query tool to access MS SQLserver from SuSE 8.2
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 Mon, 2003-05-12 at 11:01, Sharpe, Richard wrote:
Thanks, that would be fine for me and few other's but what I need is a query tool that stupid users can use like they have in MS Sqlserver (query analyzer), type in your select statement and press run, get a window back with the results.
You have "stupid users" on Linux? Awesome! You could just wrap what was already posted in an web page on a small Apache server. (The PHP calls look almost the same, so you could easily do it in that, too.) Then everyone could use the same front end to these legacy systems. Then you could convert the backend. Then you've just alleviated another Windows-only app. ;-) dk -- David "Dunkirk" Krider, http://www.davidkrider.com Acts 17:28, "For in Him we live, and move, and have our being." Linux: Will you use the power for good... or for AWESOME?
Rich, You can use OpenOffice or StarOffice as a substitution to M$ query analyzer. In this case you'll connect OO/SO to MSSQL through ODBC driver. Your "stupid" users will have that nitty gritty graphical interfaces like Data Manager and ODBC Configuration to connect to DB server. This is what our engineers used before they learned Perl and MySQL. Regards. Alex -------------------
Thanks, that would be fine for me and few other's but what I need is
a query
tool that stupid users can use like they have in MS Sqlserver (query analyzer), type in your select statement and press run, get a window back with the results.
Thanks
Rich
-----Original Message----- From: Alex Daniloff [mailto:alex@daniloff.com] Sent: Monday, May 12, 2003 11:46 AM To: =?iso-8859-1?q?=22Sharpe@gate.daniloff.com; ?= Richard" Cc: suse-linux-e@suse.com Subject: Re: [SLE] Query tool to access MS SQLserver from SuSE 8.2
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
participants (3)
-
Alex Daniloff -
David Krider -
Sharpe, Richard