Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sql native client but access want to install odbc driver on the server

Posted on 2014-08-04
5
Medium Priority
?
147 Views
Last Modified: 2015-01-22
Hi,

We have a SQL 2008 r2 Server that is running in Native Mode, one of our software supplier has said we need to make it so that we install a odbc driver on the server so we can add it to the user pcs so that they can access data quicker..... We are a bit lost on this as not SQL server experts, Do we need to install anything on the server and any config or just download and install client on pcs.

Thanks
0
Comment
Question by:ComexIT
  • 3
  • 2
5 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 40239662
The SQL Native Client needs to be installed on the client's pcs so they can connect to the SQL Server.  It can be found on this page http://www.microsoft.com/en-us/download/details.aspx?id=16978 in the Install Instructions section.  You must install the version that matched the client's system configuration, X86 or X64.
0
 

Author Comment

by:ComexIT
ID: 40239678
Sorry, I think that is the way it is running at the moment ..... they have asked for a ODBC driver to be installed on server ?
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 40239693
The SQL Native Client IS the ODBC driver.  It is installed with the SQL Server and needs to be installed on any clients that need to connect to it.  I don't know of any other driver that is recommended.
0
 

Author Comment

by:ComexIT
ID: 40239708
No prob, I am slightly confused as i would have thought that it would have been there already, Is there any way to check on the server which connections it is able to receive or will it receive all of them by default ?

Thanks
0
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 1500 total points
ID: 40239798
The server does not 'use' the ODBC driver, the clients do.  The ODBC driver / SQL Native Client connect to either the SQL daemon or the SQL Browser service.  On this machine, they are listed in Services as 'sqlservr.exe' and 'sqlbrowser.exe'.  The ODBC driver connects to the 'sqlservr.exe' service if it uses the IP address and to the 'sqlbrowser.exe' if it connects to the 'instance name'.

The drivers are listed in the ODBC Admin panel.  In the SQL Configuration Manager (either the program or the Admin panel),  you need to set the Server and the Native client to use the same protocols.  In addition, you need to tell the server to accept remote TCP/IP connections.

This image shows the setup on this computer.  Both the server and the SQL Native Client must be set up to use the same protocols so they can talk to each other.
SQL Connections
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question