SQL Server Performance

Connecting to SQL Server from Unix

Discussion in 'General DBA Questions' started by kumar, Feb 24, 2004.

  1. kumar New Member

    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
  2. satya Moderator

    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.
  3. kumar New Member

    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?
  4. satya Moderator

    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.
  5. thanhvm New Member

    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
  6. FrankKalis Moderator

  7. satya Moderator

    Welcome to the forums.
    Did you check about FreeTDS tool in this case?

Share This Page