sqlcmd vs osql RRS feed

  • Question

  • Hi,

    I'd read that osql is using odbc connection since SQL Server 2000. sqlcmd uses ole db connection from SQL Server 2005 to 2008R2. SQL Server 2012 and beyond, it uses odbc. Anyone knows the rational or the history ?

    Is odbc slower than ole db ? I have an application which uses osql to connect to SQL Server 2008. Should they be using sqlcmd instead ?

    Please advise.

    TIA !

    Tuesday, February 3, 2015 3:53 AM


All replies