LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 09-25-2006, 02:29 PM   #1
mr_scary
Member
 
Registered: Aug 2006
Posts: 39

Rep: Reputation: 15
accessing MS-SQL from Linux


I would like to perform SQL queries on a Microsoft SQL server from a RedHat server. Does anyone know the best way to accomplish this?

Peter
 
Old 09-25-2006, 03:15 PM   #2
hob
Senior Member
 
Registered: Mar 2004
Location: Wales, UK
Distribution: Debian, Ubuntu
Posts: 1,075

Rep: Reputation: 45
You need to use the relevant drivers for whatever application framework you are using: (PHP, OpenOffice.org, etc.). Linux doesn't have a standard global set of (ODBC) drivers as Windows does.
 
Old 09-25-2006, 03:21 PM   #3
mr_scary
Member
 
Registered: Aug 2006
Posts: 39

Original Poster
Rep: Reputation: 15
I'm studying a Perl solution. I need to install some Perl modules (DBI, DBD:Sybase) and FreeTDS. It looks feasible but now I am reading that this will not work with MSSQL versions beyond SQL Server 2000.
 
Old 09-25-2006, 04:37 PM   #4
hob
Senior Member
 
Registered: Mar 2004
Location: Wales, UK
Distribution: Debian, Ubuntu
Posts: 1,075

Rep: Reputation: 45
I beleive that Open Source drivers for MS SQL have to be developed by reverse-engineering (by the FreeTDS project), so it wouldn't surprise me if this is problematic...

I haven't used newer versions than SQL Server 2000, so the only suggestion that I can give myself is that you could investigate whether the newer versions have some kind of backward-compatibility mode where they speak the same version of TDS as SQL Server 2000.
 
  


Reply

Tags
microsoft, sql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Sql - stored procedures, views, and dynamic sql generation LXer Syndicated Linux News 0 08-17-2006 06:33 AM
SQL: old sql dump not loading into new db BrianK Linux - Software 1 07-25-2006 11:55 PM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 02:20 PM
Which SQL is suitable for EMbedded SQL on C? hk_michael Programming 4 01-10-2005 05:07 PM
sql on linux juanb Linux - Software 1 08-10-2004 09:23 PM


All times are GMT -5. The time now is 12:35 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration