troubleshooting Question

MSDataShaping giving error after migrating to SQL Server 2008

Avatar of shawnda v
shawnda vFlag for United States of America asked on
Microsoft SQL ServerASPMicrosoft Legacy OSMicrosoft SQL Server 2008Windows Server 2008
7 Comments1 Solution255 ViewsLast Modified:
I have a Classic ASP & ASP.Net application that I have moved from Windows Server 2003 to Windows Server 2008R2. I have successfully moved this program to Windows Server 2008R2 before, but for some reason, this time, I am getting an error anytime the Classic ASP pages attempt to use MSDataShaping.  All other Classic ASP pages work fine. It is only when they try to use MSDataShaping.

Please help! I have been searching for an answer for weeks :(

Here is the error:
--------------------------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server->DLL.Shape_DB.ShapeCMdWithRS(SHAPE {select * from employees where username in (select mgr_username from employees where empID in (select empID from time_off_requests where mgr_code=0)) order by last_name, first_name} APPEND ([select time_off_requests_view.*, employees.mgr_username as username from time_off_requests_view inner join employees on employees.empID = time_off_requests_view.empID where mgr_code=0} relate username to username) as timeoff, ...)@WEBSITENAME[version 4.0.480] error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

My Connection String:
--------------------------------------------------------------------------------
Provider=MSDataShape; Data Provider=SQLOLEDB; Data Source = .\SQLEXPRESS; Initial Catalog=; User ID=;Password=


Here is the MSDataShaping Code (From the DLL):
--------------------------------------------------------------------------------
Function TimeOffAdminPending() As ADODB.Recordset

TimeOffAdminPending = RunCmdWithRS("select * from time_off_request_view where mgr_code =0 and empID in (select empID from employees where mgr_username = '" & username & "')")

End Function


My MDAC version:
--------------------------------------------------------------------------------
6.1.7601.17514
ASKER CERTIFIED SOLUTION
shawnda v

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros