1
vote
1answer
155 views

silent failure while creating odbc data source

I just got really confused trying to create an ODBC data source in Windows 2003 R2. I can create a connection to my chosen server (a MS SQL Server) on the "user DSN" tab, but when I try to do the ...
0
votes
2answers
1k views

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread ...