SQLSERVER with Excel VBA

rajtou
rajtou used Ask the Experts™
on
Hi

I am using Sqlserver with Excel VBA. Sql server is at remote server machine. I have instance of Sqlserver is installed in my machine also. I am using Adodb connection 2.8 library to connect the excel with server.The tool is working fine at my machine

when i am sharing tool to end users they do not have sql server at there machine. they are getting  ODBC manager error.

Please let me know whether i need to install sqlserver to all the  machines or any driver can serve the purpose.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can install the SQL Server native client (sqlncli.msi), which is free.

You'll find it about 3/4 down the page in this link:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16177

HTH,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial