Home All Groups Group Topic Archive Search About

annoying SQL Server error message



Author
17 Mar 2006 3:47 PM
Dominic30
Hi,

We have developped many applications, for a major customer, connected
to the same SQL Server database. Those apps have been programmed in VB6
and VB.NET. The SQL Server is located on a dual-processor server,
running Windows 2000 Server, with 3 gigs RAM. The apps are installed on
Windows 2000 and Windows XP/SP2 client.

And the Windows 2000 client PC's, there is no problem at all. But, on
the XPs, we have, this error message popup: "Unable to load SQL Server
OLEDB provider ressource DLL. The application cannot continue". Look
like it appears randomly.

The same application, when installed on a Win2000, don't have any
problem at all. Just the damn XP machines. We cannot change the OS of
these PC's (enterprise rules).

This error is a major problem because it stops the application until
you acknowledge the error. The app is used for realtime control of a
factory, so, you see the problem...

XP workstation uses MDAC 2.8 SP1 for Windows XP SP2
2000 uses MDAC 2.6 RTM
Apps has been compiled on a MDAC 2.8 SP1 Win XP SP2 computer

How can I fix this??

thanks a lot for your help, it's really appreciated.

Author
17 Mar 2006 4:29 PM
Jack Vamvas
1)Have you got the latest MDAC installation ?
2)Track down all instances of sqloledb.rll and sqloledb.dll   . Make sure
they are the latest versions and match up


--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm


Show quoteHide quote
"Dominic30" <gag***@videotron.ca> wrote in message
news:1142610474.169168.15240@i40g2000cwc.googlegroups.com...
> Hi,
>
> We have developped many applications, for a major customer, connected
> to the same SQL Server database. Those apps have been programmed in VB6
> and VB.NET. The SQL Server is located on a dual-processor server,
> running Windows 2000 Server, with 3 gigs RAM. The apps are installed on
> Windows 2000 and Windows XP/SP2 client.
>
> And the Windows 2000 client PC's, there is no problem at all. But, on
> the XPs, we have, this error message popup: "Unable to load SQL Server
> OLEDB provider ressource DLL. The application cannot continue". Look
> like it appears randomly.
>
> The same application, when installed on a Win2000, don't have any
> problem at all. Just the damn XP machines. We cannot change the OS of
> these PC's (enterprise rules).
>
> This error is a major problem because it stops the application until
> you acknowledge the error. The app is used for realtime control of a
> factory, so, you see the problem...
>
> XP workstation uses MDAC 2.8 SP1 for Windows XP SP2
> 2000 uses MDAC 2.6 RTM
> Apps has been compiled on a MDAC 2.8 SP1 Win XP SP2 computer
>
> How can I fix this??
>
> thanks a lot for your help, it's really appreciated.
>
Are all your drivers up to date? click for free checkup

Author
17 Mar 2006 4:36 PM
Dominic30
1) Yeah, I've got the latest MDAC installation. Anyway, I can't
installed another MDAC version on the XP machines, the install failed.

2) These files match up yes. I've checked all the station and it's
looks fine.

any more idea?

by the way, thanks for the reply
Author
17 Mar 2006 4:51 PM
Jack Vamvas
In what path is the SQLOLEDB.RLL  file ?
You mention that all the apps are using the same sql server. Is this though
Linked Servers?


--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Show quoteHide quote
"Dominic30" <gag***@videotron.ca> wrote in message
news:1142613417.547606.39710@z34g2000cwc.googlegroups.com...
> 1) Yeah, I've got the latest MDAC installation. Anyway, I can't
> installed another MDAC version on the XP machines, the install failed.
>
> 2) These files match up yes. I've checked all the station and it's
> looks fine.
>
> any more idea?
>
> by the way, thanks for the reply
>

Bookmark and Share