RE: SQL error msg?????
- From: "Ian Parr" <IanParr@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 12 Sep 2005 02:06:03 -0700
Jenny
many thanks for the quick response.....it seems that the SQLOLEDB.RLL
file is not in the "<Program Files>\Common Files\System\Ole DB"
directory.....There is a copy in the Service pack directory and this also
contains a copy of the SQLOLEDB.DLL that matches the one in the "<Program
Files>\Common Files\System\Ole DB" directory....Can I just copy the missing
file across or are there other issues to be aware of.....
""Jenny wu [MSFT]"" wrote:
> Hi,
>
> Thanks for posting here! I am sorry for the delayed response due to
> weekend. Please understand that the newsgroups are staffed weekdays by
> Microsoft Support professionals to answer your systems and applications
> questions. Your understanding is greatly appreciated!
>
> Generally the issue could be caused by the following:
>
> - The file and file path are not where expected.
> - The resource DLL (SQLOLEDB.RLL) is not loaded.
> - The versions of SQLOLEDB.DLL and resource DLL don't match.
>
> 1. Please check the "<Program Files>\Common Files\System\Ole DB" for these
> two files (SQLOLEDB.DLL and SQLOLEDB.RLL).
>
> 2. Also check the permissions set to the "<Program Files>\Common
> Files\System\Ole DB" directory. By default the following groups have
> permissions on this directory and those are inherited from parent directory:
>
> Administrators: Full Control
> Authenticated Users: Read & Execute, List Folder Contents, Read
> Server Operators: Modify, Read & Execute, List Folder Contents, Read, Write
> SYSTEM: Full control
> CREATOR OWNER: Full Control applies to Subfolders and files only
>
> 3. Check current MDAC:
>
> 301202 How to check for MDAC version
> http://support.microsoft.com/?id=301202
>
> Generally, a mismatched file is not a problem if the file version is higher
> than the expected version. If you find that MDAC files are missing or have
> file versions that are lower than expected, extract the correct versions of
> these files from the i386 folder on SBS 2003 Disk 1, or copy the files from
> a known good SBS 2003 computer. To replace these files, start the server in
> Safe Mode, rename any older versions of the MDAC files in the folder where
> the files are installed and in the Dllcache folder, and then copy the
> correct versions to the folder where the files are installed and to the
> Dllcache folder. For detailed steps, see the Workaround section of either
> of the following KB articles:
>
> 883547 You receive an "Unable to connect to database" error message when
> you install SharePoint Portal Server 2003 or Windows SharePoint Services
> http://support.microsoft.com/?id=883547
>
> 838176 "Setup failed while installing sub-component Base DAV protocol"
> error message when you install Windows Small Business Server 2003 or
> Exchange Server 2003
> http://support.microsoft.com/?id=838176
>
> NOTE: These articles specifically describe replacement of the oledb32.dll
> file. However, you can use these steps to replace other MDAC files that are
> missing or mismatched.
>
> 4. The SQLOLEDB is installed automatically when you install MSDE. You could
> also try installing a dummy MSDE instance and upgrading it to SP4.
>
> If the issue persists, please help me collect some information to further
> troubleshooting the issue:
>
> 1. Have you installed any MS SQL in member server? Have you installed any
> third-party database on the SBS server box?
> 2. What is your MDAC version including all subcomponents? Please ensure you
> have replaced all mismatched files as the 3rd step.
> 3. Which operation you did to lead to the issue happened? Can you get me
> the screen shot when the issue happened for further analyze?
> 4. Please save a text copy of the application/ system log:
>
> A. Open Event Viewer: Start -> All Programs -> Administrative Tools ->
> Event Viewer.
> B. Right-click on Application/ System log and select "Save Log File As?".
>
> Please add all files to a zip file and send to my mailbox:
> v-yanniw@xxxxxxxxxxxxx
>
> Hope this helps. I am currently standing by for your test result. We are
> gad to help!
>
> Have a nice day!
>
> Best Regards,
>
> Jenny Wu
> Microsoft CSS Online Newsgroup Support
> Get Secure! - www.microsoft.com/security
> ======================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --------------------
> >Thread-Topic: SQL error msg?????
> >thread-index: AcW1TDsIgWvN6thHTPuJ48nG72sjoQ==
> >X-WBNR-Posting-Host: 212.139.185.221
> >From: "=?Utf-8?B?SWFuIFBhcnI=?=" <IanParr@xxxxxxxxxxxxxxxxxxxxxxxxx>
> >Subject: SQL error msg?????
> >Date: Fri, 9 Sep 2005 07:39:06 -0700
> >Lines: 14
> >Message-ID: <7DCFC298-76C3-46FF-8CB9-2AF55757C266@xxxxxxxxxxxxx>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.windows.server.sbs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:152048
> >X-Tomcat-NG: microsoft.public.windows.server.sbs
> >
> >I have SBS2k3 premium edition running .....all has been fine until
> yesterday
> >and I started getting an error msg from SQL (I think)......the error is as
> >follows:
> >
> >'Unable to load SQL Server OLEDB provider resource DLL'
> >
> >this requestes an ok to continue...and then clears only to reappear at
> >random intervals...... the event viewer is not very helpful as it suggests
> re
> >installing the application...
> >
> >SQL is not installed on this machine ....only the desktop engine...
> >
> >any ideas????
> >
> >
>
>
.
- Follow-Ups:
- RE: SQL error msg?????
- From: "Jenny wu [MSFT]"
- RE: SQL error msg?????
- References:
- SQL error msg?????
- From: Ian Parr
- RE: SQL error msg?????
- From: "Jenny wu [MSFT]"
- SQL error msg?????
- Prev by Date: Re: microsoft.public.exchange.admin,microsoft.public.windows.server.sbs
- Next by Date: RE: domain users have no access to outlook/outlook express
- Previous by thread: RE: SQL error msg?????
- Next by thread: RE: SQL error msg?????
- Index(es):
Relevant Pages
|
