RE: [SLE] Query tool to access MS SQLserver from SuSE 8.2

12 May 2003


      OK, I will give that a try, it should be fine in the short term until I can
write something, I guess saying they are stupid is a bit harsh, they just
don't like change, but at least they decided to go with LINUX, but still
like some of their old apps that they felt comfortable with.

Rich
...
-----Original Message-----
From: Alex Daniloff [mailto:alex@daniloff.com]
Sent: Monday, May 12, 2003 12:22 PM
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
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

Sharpe, Richard

tags

participants (1)