9/19/2020 Ms Sql Native Client Download
Nov 10, 2013 Hi All. Where can I download Microsoft SQL native client 10.0 only.
![]()
I am running MS SQL 2008 R2 on Windows Server 2008 R2. My clients are Windows XP.
I wrote an SQL query to fill an ISO requirement for HR. The query is simple, a jion between two tables and it runs for me. I the opened MS EXCEL 2010 and used MS Query, in manual mode, to enter the query. I have an SQL Native Client ODBC driver setup for the query. When I ran the query, it ran and populated Excel. I save the Excel file to a network share. I went to my HR office, setup the ODBC driver, connected to the share, opened the Excel file and everything worked. Wanting to make this available to all of my supervisors, I went to another PC, setup the ODBC driver, connected to the share and opened the Excel file. The update failed. The error was and Excel warning '[Microsoft][SQL Native Client][SQL Server]The SELECT permission was denied on the object 'tablename' database 'datbasename', schema dbo.'. I have verified the domain groups these two people are members of and there are only three that might impact SQL. I verified both had the same permissions to the Excel file. I'm stuck. If there permissions are the same to the file and SQL then it should run for both. What am I missing?
![]() Ms Sql Native Client Download
BTW - I get the same results on a third PC where I log in as me, then as each of them. It runs for me, it runs for HR but not for the third user.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |