none
SQL server native client and ODBC client

    Question

  • Hi

    A basic question.

    Do we have to use a sql server native client  or a ODBC client (ODBC data source) together to access a database from a workstation.

    or we should use one of them.

    Also

    Does the native client driver installed on windows 7 system already or are they installed with isntallation of the native client.

    Regards.

     

    Sunday, January 06, 2013 6:23 PM

Answers

  • Do we have to use a sql server native client  or a ODBC client (ODBC data source) together to access a database from a workstation.

    or we should use one of them.

    Also

    Does the native client driver installed on windows 7 system already or are they installed with isntallation of the native client.


    The ODBC driver that ships with Windows is intended only for backwards compatibility.  This can provide basic connectivity but does not include post SQL Server 2000 features.  It is generally recommended that you use the SQL Server Native Client to access modern versions of SQL Server from native code.  See http://msdn.microsoft.com/en-us/library/ms810810.aspx. 

    .NET applications should use the Microsoft SQL .NET Data Provider (SqlClient) included with the .NET framework.  No separate install is needed.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    • Marked as answer by invincible1982 Tuesday, January 08, 2013 8:25 PM
    Tuesday, January 08, 2013 1:24 AM

All replies

  • You need to install native client on workstation to connect & use SQL Server.

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Monday, January 07, 2013 1:41 PM
  • Hello,

    Please, could you explain if you are accessing to a local database ( same computer for the SQL Server and the application which is accessing the database ) or if the application is running on the same computer computer where the SQL Server is installed ( local connection ) or running on another compurect ( remote connection ) ?

    If it is a local connection, the drivers are automatically installed> For a remote connection, you have to install the drivers (ODBC,OlEDB,SqlClient,....)

    Be careful to install drivers which are supported by your operating system and the SQL Server ( Please, could you give the version of your operating system and SQL Server ? )

    Have a nice day 


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Monday, January 07, 2013 10:23 PM
  • Do we have to use a sql server native client  or a ODBC client (ODBC data source) together to access a database from a workstation.

    or we should use one of them.

    Also

    Does the native client driver installed on windows 7 system already or are they installed with isntallation of the native client.


    The ODBC driver that ships with Windows is intended only for backwards compatibility.  This can provide basic connectivity but does not include post SQL Server 2000 features.  It is generally recommended that you use the SQL Server Native Client to access modern versions of SQL Server from native code.  See http://msdn.microsoft.com/en-us/library/ms810810.aspx. 

    .NET applications should use the Microsoft SQL .NET Data Provider (SqlClient) included with the .NET framework.  No separate install is needed.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    • Marked as answer by invincible1982 Tuesday, January 08, 2013 8:25 PM
    Tuesday, January 08, 2013 1:24 AM