Connection to Microsoft SQL Server


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Connection to Microsoft SQL Server
# 1  
Old 01-21-2010
Connection to Microsoft SQL Server

Hi,

I am using "ksh" and trying to connect to the Microsoft SQL Server but it gives an error that is:
Code:
          DB-LIBRARY error:
          Unexpected EOF from SQL Server.

Can any one please help me to resolve this issue. And i am using Putty to connect to the Unix server.


Thanks

Last edited by zaxxon; 01-21-2010 at 05:51 AM.. Reason: use code tags please, ty
# 2  
Old 01-21-2010
Sounds very strange - please post what command you are issuing. ksh has no client built in to connect to a MS SQL server. You might need something like perl with an appropriate module for example.

Also use [code] and [/code] tags when posting code, data or logs to ensure readability and to preserve formatting etc.
# 3  
Old 01-21-2010
I am using:
Code:
   isql -S <Servername> -U <Username> -P <Password>

and also:
Code:
   fsql -S <Servername> -U <Username> -P <Password>



---------- Post updated at 03:33 PM ---------- Previous update was at 03:22 PM ----------

Can you provide a sample example to know how to use
Code:
 and

tags when posting code. Please.

---------- Post updated at 03:34 PM ---------- Previous update was at 03:33 PM ----------

Can you provide a sample example to know how to use
Code:
 and

tags when posting code. Please.

Last edited by anupdas; 01-21-2010 at 06:01 AM.. Reason: code tags again
# 4  
Old 01-21-2010
You got a 1st warning and a 2nd warning and both contained a preformatted message from Neo how to use code tags which explains it decent. You also got a PM from me where I stated when to use them.

Also you can just use the edit function on the posts I have edited for you already and check the code.
Login or Register to Ask a Question

Previous Thread | Next Thread

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

UNIX string connection to sql server db

Hi, i have to perform a connection from unix to sql server database, using TCP protocol. I have all connection parameters (user,pwd,server_name,port,db_name). How can i perform this connection, by unix console ? is it available a command similar to this one (for oracle): sqlplus... (1 Reply)
Discussion started by: nash83
1 Replies

2. UNIX for Dummies Questions & Answers

Test new DSN connection to sql server

I installed an odbc driver and created a DSN to connect to a sql server database on AIX 6. I want to know how to test the DSN from the command line. What syntax or commands do I use? ---------- Post updated at 11:44 AM ---------- Previous update was at 08:26 AM ---------- OK I figured out how... (9 Replies)
Discussion started by: Jdbrown239
9 Replies

3. SuSE

Syslog-ng 3.0.7 fails to insert into microsoft sql server

Dear All, Im currently configuring syslog-ng on SUSE Linux 10 SP2 to communicate with microsoft sql server 2005. I have installed freeTds 8.0. Tested TSQL ..works fine ISQL works fine. when testing with syslog-ng destination d_mssql { sql(type(mssql) host("ip address")... (0 Replies)
Discussion started by: SystemEng
0 Replies

4. Shell Programming and Scripting

(perl) Microsoft SQL Server client for solaris. cant find it...

let me save everyone the pain that it caused me. This is all free. And make sure it is in this order 1) make sure you have the latest version of perl installed 2) make sure you have NET:aemon installed 3) make sure you have RPC::PlServer & PlClient (the bundle has both) 4) make sure... (3 Replies)
Discussion started by: Optimus_P
3 Replies
Login or Register to Ask a Question