MDAC Error (Ole Db) when connecting to Project Server 2003

[newbie2k6]

Hello:

I am new to project server 2003 and WSS. This is an old project that has
been in place for over a year now. Project Server 2003, Sql Server 2000 and
WSS. A customized component (ASP.NET 1.1 app) has been added to this project
server which is using ProjectServer DB on SqlServer 2000. We have an ODBC
datasource "ProjectServerDSN" created to connect to DB and are using OLEBD
connection to connect to project server db. Lately, we are getting these
weird MDAC errors and the event log shows these 4 errors logged when this
MDAC error occurs. These MDAC errors show up once or twice a day and we
restart the iis to clear it off. I have spent lot of time debugging and could
not resolve yet. Any help or pointers would be of great help in the right
direction.

** We have MDAC 2.8 SP2 on WINDOWS Server 2003 SP1 installed

////// MDAC Error
Error - The following error occured: The .Net Data OLE DB Provider
(System.Data.OleDb) requires Microsoft Data Access Components(MDAC) version
2.6 or later.

////// event log error I
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Cannot open database requested in login
'ProjectServerDSN'. Login fails.]]></Description>

//////////////////////////////////// 2nd error

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServerDSN'. The error code was also included.]]></Description>

///////// 3rd error log

Component: Unknown Component Name
File: C:\Office\dev\project\WebClient\source\server\pjnpesvc\PjNpeSvc.cpp
Line: 147
Error Number: 0x80020009
Description: <Description><![CDATA[Cube Processing Failed]]></Description>

///// 4th error log

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServerDSN'. The error code was also included.]]></Description>

 

[Rolly Perreaux]

Hello:

I am new to project server 2003 and WSS. This is an old project that has
been in place for over a year now. Project Server 2003, Sql Server 2000 and
WSS. A customized component (ASP.NET 1.1 app) has been added to this project
server which is using ProjectServer DB on SqlServer 2000. We have an ODBC
datasource "ProjectServerDSN" created to connect to DB and are using OLEBD
connection to connect to project server db. Lately, we are getting these
weird MDAC errors and the event log shows these 4 errors logged when this
MDAC error occurs. These MDAC errors show up once or twice a day and we
restart the iis to clear it off. I have spent lot of time debugging and could
not resolve yet. Any help or pointers would be of great help in the right
direction.

** We have MDAC 2.8 SP2 on WINDOWS Server 2003 SP1 installed

////// MDAC Error
Error - The following error occured: The .Net Data OLE DB Provider
(System.Data.OleDb) requires Microsoft Data Access Components(MDAC) version
2.6 or later.

////// event log error I
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Cannot open database requested in login
'ProjectServerDSN'. Login fails.]]></Description>

//////////////////////////////////// 2nd error

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServerDSN'. The error code was also included.]]></Description>

///////// 3rd error log

Component: Unknown Component Name
File: C:\Office\dev\project\WebClient\source\server\pjnpesvc\PjNpeSvc.cpp
Line: 147
Error Number: 0x80020009
Description: <Description><![CDATA[Cube Processing Failed]]></Description>

Hi Newbie,

Try troubleshooting your MDAC errors with MDAC Utility: Component
Checker.
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-
4b43-bf53-14332ef092c9&DisplayLang=en

It's a very handy tool for troubleshooting these types of errors

Just remember that all your client machines connected need to have the
same version. You can also download MDAC 2.8 here:
http://www.microsoft.com/downloads/details.aspx?DisplayLang=en&FamilyID=
6c050fe3-c795-4b7d-b037-185d0506396c

Good Luck!

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[newbie2k6]

Hi Rolly:

I ran the MDAC utility and it shows "MDAC 2.8 SP2 on WINDOWS Server 2003
SP1". So it has current version of MDAC and all the clients have the same
version. I read that MDAC 2.8 is supported on WIN 2K, WIN NT and WIN XP (x86
family) BUT we have MDAC 2.8 on WIN 2003 Server. Is that generating errors?

Thanks in advance for your help!

 

[Rolly Perreaux]

Hi Rolly:

I ran the MDAC utility and it shows "MDAC 2.8 SP2 on WINDOWS Server 2003
SP1". So it has current version of MDAC and all the clients have the same
version. I read that MDAC 2.8 is supported on WIN 2K, WIN NT and WIN XP (x86
family) BUT we have MDAC 2.8 on WIN 2003 Server. Is that generating errors?

Thanks in advance for your help!

Hi Newbie,

Actually here's what it says:
"No installation support for this stand-alone release is offered for the
Microsoft Windows Server 2003 operating system because this same version
of MDAC is included with Windows Server 2003

http://support.microsoft.com/Default.aspx?kbid=828396

I think the key to your problem is located in Error 1

///// MDAC Error
Error - The following error occured: The .Net Data OLE DB Provider
(System.Data.OleDb) requires Microsoft Data Access Components(MDAC)
version
2.6 or later.

////// event log error I
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Cannot open database requested in
login
'ProjectServerDSN'. Login fails.]]></Description>


Now I'll be the first to tell you that I'm not a developer by any
stretch of the imagination, but this looks like the problem to me:

File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp

Can I assume that this is the code written for the "customized component
(ASP.NET 1.1 app) has been added to this project server"?

If it is, then I would get the developer of this app to post this same
question in the microsoft.public.project.developer newsgroup.

Sorry, I wish I could help you more :-(

--
Rolly Perreaux, PMP, MCSE
Project Server Trainer/Consultant

TriMagna Corporation
Microsoft Gold Partner
http://www.trimagna.com

 

[newbie2k6]

Rolly,

Thanks for your reply. The error specified in .cpp file is not custom coded.
It is the file that comes with Project Server.

---File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp

I will post it on developer newsgroup also if it makes more sense to be there.

Thanks.


: