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

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
ComexITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
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
ComexITAuthor Commented:
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
Dave BaldwinFixer of ProblemsCommented:
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
ComexITAuthor Commented:
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
Dave BaldwinFixer of ProblemsCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.