LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-21-2004, 12:24 PM   #1
vil
LQ Newbie
 
Registered: Mar 2004
Location: india
Posts: 2

Rep: Reputation: 0
Connecting to MSSQL Server 7 from Linux


hi all

i want to access MS SQL Server 7.0 database from my Linux Machine using JSP.

i am right now having Mandrake linux,probably 9.1..
iam ready to install some other Linux if needed

i do not know which Driver can help me to connect to windows from Linux,

can anyone suggest for the Freely available Driver that can be used to connect to an Windows Data Source from Linux Machine and any another Resource which help me in in this Task

thanks
 
Old 06-21-2004, 02:25 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 914Reputation: 914Reputation: 914Reputation: 914Reputation: 914Reputation: 914Reputation: 914Reputation: 914
http://www.unixodbc.org/



Cheers,
Tink
 
Old 06-24-2004, 07:29 PM   #3
jlemonier
LQ Newbie
 
Registered: Jun 2004
Posts: 1

Rep: Reputation: 0
the question:
if using EasySoft's client/server odbc-odbc bridge drivers (which cost $100 & $400),
how can they be accessed via Zope?

what I've found so far (unixODBC is far from answering the original question)
iodbc and unixodbc are both odbc "DriverManagers", not "Drivers".

Trying to access SQL Server and Interbase databases running on Windows
from Linux seems to still be an expensive proposition.

from http://www.unixodbc.org/,
you'll find the list of drivers here: http://www.unixodbc.org/drivers.html

and most of them reference a 30-day trial of an EasySoft driver.
That driver has a client AND server component.
Client = $100,
Server = $400

The server runs on one Windows machine and makes ALL windows odbc connections on that machine accessible via the client EasySoft OOB client/driver running on Linux.

I'm still trying to get a proof-of-concept using the 30-day trial.
A demo connection is setup on install ... which isn't accessible/visible in Zope running on Linux.
Only MySQL and GadFly connections are visible.

what a joyous migration ....
 
Old 07-07-2004, 12:46 PM   #4
mychl
Member
 
Registered: Jul 2001
Location: Earth
Posts: 164

Rep: Reputation: 30
freetds.org

Works for me... and supports 4.2 and 7 for MS SQL servers.

Between unixodbc.org and freetds.org there is more than enough documentation to get you going.

GL
 
  


Reply


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
Connecting from WINXP to a RH Linux Server dennis35 Linux - Newbie 2 11-22-2005 11:07 PM
From a Fador REdhat web server to MSSQL 2000 llyr Linux - Networking 0 01-14-2004 05:22 PM
Linux connecting to Windows Server? lucky mikey Linux - Networking 4 10-14-2003 09:19 AM
MSSQL Enterprise for Linux aliensub Linux - Software 2 02-04-2003 08:43 PM
connecting linux to a nt server FNC Linux - Networking 2 07-10-2001 10:19 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:40 PM.

Main Menu
Advertisement
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
Open Source Consulting | Domain Registration