Accessing database from Linux?
-
Hello all -
I have a SQL Server database that is accessed from a TomCat webserver (on Linux) using jdbc. Is there a command line utility (like osql) that can be used to access my SQL Server from Linux?
Thanks in advance!
apf
-
I haven't used it, but there is SQSH. You may need the FreeTDS libraries to connect to SQL Server.
SQSH:
FreeTDS:
HTH.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Or you could move to IIS and win2000
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons -
Thanks for your comments. I'll try SQSH.
I didn't really need to mention TomCat. I'm just researching my options in copying data from an Oracle/PeopleSoft installation on Linux to a SQLServer 2000 db on Win2K.
apf
-
In addition to JDBC drivers for SQL Server, there are ODBC drivers that run on the *nix systems, too. If you're looking to have a script, this is ideal because this opens up your scripting languages as well. That way you write the script once, run many, since you may be performing the data conversion repeatedly.
When I was looking at possibly using PHP on a linux/Apache box for a project, I found using ODBC was an option. Ultimately I didn't go down that direction (had access to MySQL and we decided to go that direction... now if we can just get time to code since it's a personal project), but I did hold on to links of some of the articles. Here is a good article from PHPBuilder describing the options:
http://www.phpbuilder.com/columns/alberto20000919.php3?page=1
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Brian, have you done much work with FreeTDS? Enough to write an article maybe?:-)
Andy
-
No, but I've been working on a series about connecting through Perl. Just haven't had time to put the finishing touches. Might be good to do one on network tracing and what the FreeTDS team has uncovered...
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Thanks a lot for your input folks. That was a very good article on the PHP site that was referenced. I'm a little concerned that it was written in Sept., 2000 though. I'm going to continue my research. Let me know if you become aware of any updates!
Thanks again - apf
-
I'm going to be researching connecting to SQL Server via DBI on Linux in the near term... part of the series on connecting to SQL Server from Perl I've started. Hopefully I'll be able to run a test fairly soon at work. Myself and another PerlMonger/SQLServer DBA (goes by void on SQLServerCentral.com) will probably tackle it next week if we get time. Connecting from Win32 platforms is a breeze.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Great! I'm looking forward to it!
apf
-
Are you running peoplesoft on sqlserver?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply