Re: SQL Permission question

From: Uri Dimant (urid_at_iscar.co.il)
Date: 12/15/04


Date: Wed, 15 Dec 2004 12:29:32 +0200

Drew
It seems that dll is corrupted.

"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:uMGiOle4EHA.824@TK2MSFTNGP11.phx.gbl...
> I would like to know what the permissions should be for the following
> directory on my SQL Server.
>
> <Program Files>\Common Files\System\Ole DB folder
>
> I am having a really annoying error message and found that this directory
> needs Full Control permissions for everyone. My administrator is leery of
> letting everyone have full contol of this folder.
>
> Here is the error message that I am recieving.
>
> "Unable to load SQL Server OLEDB provider dll. The application cannot
> continue"
>
> I have reapplied the service packs, and reinstalled MDAC.
>
> This error rears it's ugly face on simple errors, like trying to SELECT a
> column that isn't there, or making a typo in a statement.
>
> Thanks,
> Drew Laing
>
>



Relevant Pages

  • SQL Permission question
    ... I would like to know what the permissions should be for the following ... letting everyone have full contol of this folder. ... Here is the error message that I am recieving. ... "Unable to load SQL Server OLEDB provider dll. ...
    (microsoft.public.sqlserver.security)
  • Re: Help on Connection Code
    ... What is the error message? ... If it is related to the permissions, ... > work on my XP workstation connecting to our Live SQL server. ... > Dim ConnectionString As String ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Server and Creating Tables/Queries
    ... I get an error message ... > with the Software that I got my database from? ... This is a permissions issue. ... If you are not the SQL Server DBA, ask her to make you a user on the ...
    (microsoft.public.access.adp.sqlserver)
  • Can not backup or restore SQL server
    ... Error message is: ... Cannot load the DLL xpstar.dll, or one of the DLLs it ... Running Windows SBE 2003, SQL server 2000 SP3 ...
    (microsoft.public.sqlserver.tools)
  • Re: The Cannot load the DLL... Mystery
    ... Make sure the DLL is on all nodes. ... I support the Professional Association for SQL Server ... "Steve Clark" wrote in message ... > Here's my error message: ...
    (microsoft.public.sqlserver.clustering)