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.