Link to home
Start Free TrialLog in
Avatar of shawnda v
shawnda vFlag for United States of America

asked on

MSDataShaping giving error after migrating to SQL Server 2008

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:
Avatar of Big Monty
Big Monty
Flag of United States of America image

try the following with your connection string:

Provider=MSDataShape; Data Provider=SQLOLEDB.1; Data Source = .\SQLEXPRESS; Initial Catalog=; User ID=;Password=
Avatar of shawnda v


Changing the Connection String to SQLOLEDB.1 didn't have any affect. Any other ideas?
I don't know if this is related.....

I created a Test.UDL to test the SQL connection. If I select "MSDataShape" on the "Provider" tab, I get "Interface not supported" on the "Connection" tab.

Is there something that needs to be enabled for MSDataShape?
almost sounds like it's not installed on the server. did you go through this checklist to help in troubleshooting?
I've been pouring over that checklist, and I'm not finding anything that solves the problem.
Sorry it took me so long to respond, I just wanted to make sure I was thorough in checking everything I could have (plus I got pulled away to a couple other projects).

I am thinking maybe I am missing a DLL or an ActiveX file that Datashape is attempting to rely on??

Do you have any other ideas????
Avatar of shawnda v
shawnda v
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Unfortunately the suggestions did not lead me to a solution. I didn't get any further responses after my last comment, so I went ahead and found another way to get what I needed w/out resolving the error.