Connecting to SQL Server from Unix | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Connecting to SQL Server from Unix

Has anyone tried to connect to a SQL Server 2K running on Windows 2000 from a unix machine? If so then could you provide me some help?
Thanks in advance
Microsoft does not provide any ODBC libraries for Unix, but there are a couple third-party drivers out there. It appears that while you can find open-source dirver managers, the drivers themselves are generally commercial products. Some of these drivers appears to actually be bridges, that is they talk with a component on Windows, which in its turn talk to SQL Server, presumably through Microsoft’s own ODBC drivers. This may be slower than a driver that talks directly to SQL Server. http://www.datadirect-technologies.com/ &http://www.openlink.co.uk/ are the ones supplies these drivers. Recently I foundhttp://www.unixodbc.org/ an open source project provides the driver manager. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I have downloaded and installed the Microsoft JDBC on the unix server and now I’m trying to connect to the SQL Server at the Unix Prompt using:<br /><br />java -classpath /home/user/sqljdbc/lib/msbase.jar:/home/user/sqljdbc/lib/msutil.jar:/home/user/sqljdbc/lib/mssqlserver.jar "jdbc:microsoft<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qlserver:"//servername<br /><br />and it’s giving me "Exception in thread "main" java.lang.NoClassDefFoundError: jdbc:microsoft<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qlserver:"<br /><br />How do I resolve it? Can’t I just connect to SQL Server from the unix command prompt?
Which webserver you’re using?
Try establishing connection to the database by command line, try :
telnet 1433
Also check TCP/IP is the enabled protocol on the SQL server.
You cannot connect directly from the unix command prompt it should be by the way of driver/session. Also try using FreeTDS tool. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi All I have a server unix. Database is SQL. I do not know how to login SQL of this unix server. Pls help me Thank you so much all
See if this helps: http://www.sommarskog.se/mssqlperl/unix.html
Welcome to the forums.
Did you check about FreeTDS tool in this case?
]]>