How to connect Unix and Sql Server 2005?

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support How to connect Unix and Sql Server 2005?
# 8  
Old 01-18-2012
Following you link, point 2:
Quote:
In some cases you may need the network (client) software from your database vendor.
Quite sure it applies to microsoft product (SQLServer), though Microsoft SQL Server improved performance with ODBC, JDBC and ADO.NET database drivers suggest it may work... but it is silent with which version...

Last edited by vbe; 01-18-2012 at 11:31 AM.. Reason: typos..
# 9  
Old 01-18-2012
Can you explain:
Quote:
I use window 7 and there is unix installed in it
Not sure what we should understand by that...
What about the server holding the SQLserver database?
# 10  
Old 01-18-2012
Quote:
Originally Posted by parthmittal2007
but i have downloaded from data direct connection

---------- Post updated at 09:25 AM ---------- Previous update was at 09:19 AM ----------

and the link is
DataDirect Connect and Connect XE for ODBC Software for UNIX/Linux
And you will note that in point 5 of the instructions it says to enter "eval". You will need to buy a license at some point to continue using it.
# 11  
Old 01-18-2012
What is more pertinant is that this is just the ODBC drivers. They are just an add-in to Progress 4GL database engine (which is a very old product - now updated and rebranded as "Progress OpenEdge").
Operational Responsiveness, Business Process Management, Complex Event Processing and SOA Infrastructure | Progress Software

If the O/P is both a Progress 4GL and MSSQL expert then it might be possible to get this ODBC to work. Our attempt some years ago was a failure and we changed to Progress Webspeed (pay software).

I'm still unclear whether this is a training exercise or a live issue. In similar training threads we see people using MySQL on both Linux and Microsoft platforms. I cannot comment on that product but others can.
# 12  
Old 01-18-2012
Hi,

For sql server 2005 from linux, you can use FreeTDS.org

Hope this helps
# 13  
Old 01-18-2012
I developed FreeTDS-based s/w under Linux recently working with SQL Server 2000 and 2005, although this app has not been deployed in production yet. There is a good support forum on their web site.
# 14  
Old 01-18-2012
Like Migurus said, you can use unixODBC in combination with FreeTDS on linux to connect to MS SQL server. I have set up several VM's and it works fairly well.
Padow
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. AIX

Connect to database server and execute sql

I have a requirement and below is the detail. Create a shell script and needs to run in server "a". Connect to teradata database server "b". execute the .sql file from server "a" Save the output of the query to a file in server "a" Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies

2. AIX

Connect to a SQL server from AIX

Hello aix community, After scouring the internet to find a step by step process, I've exhausted my efforts. Although I have learned a lot which brings me to this forum. I'm totally new and hope to ask the right questions. What is the easiest way to connect to a SQL server from aix? ... (2 Replies)
Discussion started by: TechStudent36
2 Replies

3. SuSE

Connect to SQL server from Linux

I am trying to establish connection with SQL server 2008 through ODBC on Linux. First step would be 1. How to verify if ODBC driver for SQL server is installed on Linux OS. PLease let me know how to do it/ if there is any link which could be helpful in this context. thanks in advance (1 Reply)
Discussion started by: cvsanthosh
1 Replies

4. Shell Programming and Scripting

how to Connect from ksh script to SQL server

I need to connect sql server 2008 from korn shell script. Can you please give me the script which connects sql server 2008 from korn shell script. (2 Replies)
Discussion started by: santoshhegde
2 Replies

5. Shell Programming and Scripting

Unix with sql Server 2005

Hello All I am getting a problem.What i want to do is to connect unix(korn shell) and sql server 2005. But it is not happening. The task is to schedule a job using crown or something else that connect with sql server 2005 and run the query and save the result in a text file. (5 Replies)
Discussion started by: parthmittal2007
5 Replies

6. Shell Programming and Scripting

connect to SQL server from shell script

Hi all, I need to connect to SQL server from shell script. Then need to execute queries from shell script as below 1. To compare values of an array with SQL table's entry. I am using solaris-5.1 to run shell script and want to connect to SQL-5.1 which is installed on SantOS. Kindly let... (3 Replies)
Discussion started by: amitbhelave
3 Replies

7. Solaris

connect to SQL server from shell script

Hi all, I need to connect to SQL server from shell script. Then need to execute queries from shell script as below 1. To compare values of an array with SQL table's entry. Kindly let me know on how to do this Thanks, Double post. Continue here (0 Replies)
Discussion started by: amitbhelave
0 Replies

8. AIX

IBM DB2 UDB to SQL Server 2005 Porting

Hi All, Am porting my application from AIX to Windows. As a part of this I need to port the Database in IBM DB2 UDB to SQL Server 2005. Is there any Guide/Doc/Article available on this? How to convert the stored procedures and physical data from DB2 to SQL Server 2005? Thanks in Advance (0 Replies)
Discussion started by: mvictorvijayan
0 Replies

9. Solaris

Connect From VB to SQL Server

Dear All Now I can't connect from VB to Sybase on Unix. How could I do? Please help me. (0 Replies)
Discussion started by: Than Chanroeun
0 Replies
Login or Register to Ask a Question