Post reply

clarify some conecpts of SQL client

  • July 22, 2011 at 9:44 am

    #254155

    I would like to clarify some concepts for installation.

    If a person only needs a sql server client, does it mean to install sql server workstation tool - and it means to install only Sql server management studio?

    And if we only want to install sql server client, it doesn't need a license, correct?

    And What is sql server native client? is it a driver? or it's SSMS, or part of ssms?

    Thanks

  • July 22, 2011 at 2:23 pm

    #1357296

    What do you define as a "SQL Server client"?

    If you want to access data on a server, you could either use SSMS or any type of ODBC connect (e.g. ACCESS, EXCEL a.s.o.). SSMS doesn't need a license. The system you connect to does.

    You could also look into the Express Edition of SQL Server. There's are no license costs involved either.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • July 22, 2011 at 2:44 pm

    #1357305

    Thanks, and what is the difference between native client and ssms?

  • July 22, 2011 at 3:29 pm

    #1357324

    sqlfriends (7/22/2011)

    Thanks, and what is the difference between native client and ssms?

    Straight off the web:

    The SQL Server Native Client...

    ...contains the SQL Server ODBC driver and the SQL Server OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply