connect to mssql


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting connect to mssql
# 1  
Old 10-17-2005
connect to mssql

Hi - can any one tell me is it possible to connect to mssql and fetch the data from unix shell scripts
# 2  
Old 10-17-2005
Install UnixODBC + FreeTDS, and use the isql utility. Try something like

isql -H hostname -U user < filename.sql

But if you would like to get the return resultset, probably you should place that part of the program in Perl instead, as it can be used with the Perl ODBC package to get the resultset through the DBI just as other database backends.
# 3  
Old 10-18-2005
hi, i have done this, but still i am getting error "[ISQL]ERROR: Could not SQLConnect" i guess this requires a dsn which i am not aware of how to create one. thanks for letting me know that.

Cheers,
Waseem
# 4  
Old 10-18-2005
I didn't use a DSN for connect when I used it. I just specified the host, port number, username and password and it worked for me. Make sure the SQL server accepts standard (password) authentication. i.e. mixed authentication mode rather than just Windows authentication. Maybe check the firewall also if that matters.

I will just say try to use the MSSQL Enterprise Manager or Query Analyzer to test the connection first, then if that's okay try do so with isql/tsql.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connect direct - SFTP - List of servers that I can connect

Greetings Experts, I am working for a bank client and have a question on connect-direct and SFTP. We are using Linux RedHat servers. We use connect-direct to transfer (NDM) files from one server to another server. At times, we manually transfer the files using SFTP from one server to another... (2 Replies)
Discussion started by: chill3chee
2 Replies

2. Cybersecurity

When i start CSF i cant connect VPS or download any data into it It appears i cant connect Linux VP?

It appears i cant connect linux VPS server via SSH or i cant SCP any file to it and i cant wget any file TO it (from inside it) while CSF (Config Server Firewall, LFD is running. Just after isntall in default configuration and after changing TESTING mode to LIVE mode. Trying to wget & install... (1 Reply)
Discussion started by: postcd
1 Replies

3. Shell Programming and Scripting

MSSQL or SQL SERVER or SQLSERVER?

hi, i'll want to try on the parameter with three possibility because mine colleagues usally to work on the other name folders. for example: MSSQL SQL SERVER SQLSERVER case $q in a) echo -ne "Work database: " echo "" echo " 1) ORACLE" echo... (4 Replies)
Discussion started by: gsflash80
4 Replies

4. UNIX for Dummies Questions & Answers

Want to connect through different ip

Hi Folks, I want to connect to a unix machine that is on ip 10.240.234.52 and I presently on ip 172.234.456.77 , I need to change the port by removing my lan wire and attaching it to different port, is there any ways through which I can remain on 172.234.456.77 ip and I can connect to unix machine... (3 Replies)
Discussion started by: SankalpS
3 Replies

5. AIX

AIX Remote Connect Fail With “No more multiple IP addresses to connect” Error

We have a production server at a client site running AIX. And recently when users are trying to connect to it via telnet, it prompts "No more multiple IP addresses to connect". Can I know what does this error mean? and how to rectify this? Thanks. (2 Replies)
Discussion started by: a_sim
2 Replies

6. HP-UX

Connect to MP

Hi all, I am trying to connect to the MP via ethernet cable but puTTY keeps saying no route to host. I assume there is something wrong on the laptop itself. It is a new one and the previous one could connect. How do I setup this damn thing up so I can connect? Any help is appreciated. ... (4 Replies)
Discussion started by: macgre_r
4 Replies

7. Shell Programming and Scripting

linux ISQL and MSSQL unload results to file

Hello, I am using suse 10.1 and isql from unixodbc to connect to a MS SQL server. I got everything to work fine. What do I need to unload the results from the sql to a file? I attempted to put unload to in my sql statement but got a error. I don't see in the isql help where it has a option to... (0 Replies)
Discussion started by: benefactr
0 Replies

8. AIX

AIX to access MSSQL server

Anyone can provide a solution for how AIX to access Microsoft SQL server ? (0 Replies)
Discussion started by: hellboy01
0 Replies

9. UNIX for Dummies Questions & Answers

cant connect

ok the fact taht i cant even connect to the school UNIX server isnt good. thats where the project is. the server address is telnet://164.106.464.10 when i type it in and press enter a window pops up and it says Connecting to 164.106.464.10 then it just closes. doesnt say anything (or it... (6 Replies)
Discussion started by: Combat Form
6 Replies
Login or Register to Ask a Question