Avatar of shawnda v
shawnda v
Flag 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:
Microsoft SQL Server 2008Microsoft SQL ServerASPMicrosoft Legacy OSWindows Server 2008

Avatar of undefined
Last Comment
shawnda v

8/22/2022 - Mon
Big Monty

try the following with your connection string:

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

Changing the Connection String to SQLOLEDB.1 didn't have any affect. Any other ideas?
shawnda v

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?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Big Monty

almost sounds like it's not installed on the server. did you go through this checklist to help in troubleshooting?

shawnda v

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????
shawnda v

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
shawnda v

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.