View Complete Post
Access control lists (ACLs) can be complex beasts, and user interfaces for editing them are incredibly tricky to implement properly. That's why I was really excited when WindowsÃÂ® 2000 shipped with a programmable ACL editor, shown in Figure 1.
MSDN Magazine March 2005
I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked
out while listing the DB's.
I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.
I'm really desperate. Any help is very welcome.
Does Microsoft provide a list of T-SQL special characters in SQL Server 2005 that can be escaped?
I'm new to SSIS & require help for the below 2 query's:
1.We need to import data from Microsoft Access using SSIS 2005 to SQL server. Could you please let me know the steps involved to achieve this.
2. We have web access tool & data has been stored. I need to import the access data from the Web tool to SQL server using SSIS 2005
I would like to access MS SQL Server 2005 database from shell script resides on linux machine.
I am missing out the ODBC drivers that could achieve the task.
Let me know if there are any freeware ODBC drivers that can meet the requirement.
Any help appreciated. Thanks in advance.
A specified SQL Server instance name is not valid.
I have MS Accounting Professional 2009 installed on Windows Small Business Server 2008 with the accounting database in SQL Server 2005
I can access the database on the server using my client installation of MS Accounting and use it as expected
When I add another user I am unable to restrict the access rights of that user by selecting a role for them and restricting their access by denying them access to certain areas or providing read-only access to certain areas
What happens when we select a user and select a role and un-tick the Administrator rights box and click ok is that the user rights are not saved without administrator rights. When the user's rights are opened again, the Administrator box has a tick
in it again.
The sequence of events is exactly as described - untick the Administrator box, click ok, then select the user in the "Manage Users" list again, click "Edit" and there's a tick in the "Administrator" box.
In every other respect, MS Accounting appears to work ok, i.e. no error messages, no crashes.
We believe that we should be able to work around this issue by manually setting user access rights directly in the SQL database, but so far we have not been able to do that.
Has anyone ever experienced anything like this, can anyone provide any help or suggestions?
I have linked my tables, in SQL Server Express 2005, to MS Access 2007 and created a File DSN named LocalSQLServer.dsn. Both the front end (MS Access 2007) and the back end (SQL Express 2005) are on the same machine.
I am trying to check an open connection , and for that I have written a module -- Function CheckConnection(strFileDSNName As String, _
strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean
strConnect = "Provider=ODBC" & _
";FILE DSN =" & strFileDSNName & _
";Database=" & strDBName
I have created a form with a command button to check the connection, but it is giving the following error
"-2147467259; Method 'Close Connection' of Object'_CurrentProject failed
I am not able to figure it out, if the Connection Parameters that I have taken are correct or not. Please help me in this.
I'm trying to determine the minimal amount of access I can give my developers to be able to run create stored procedure scripts with an inclusion of the grant execute to the application user group.
We have been developing some interesting work arounds, but I think there must be an easier way to grant the access.
Grant Create Stored Procedure to user1 on a specific database
Grant Permission to Grant Execute permission for Stored Procedures on a specific Database to user1 for any user.