We help IT Professionals succeed at work.

MSDataShaping giving error after migrating to SQL Server 2008

237 Views
Last Modified: 2016-12-11
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
Comment
Watch Question

Big MontyWeb Ninja at large
CERTIFIED EXPERT

Commented:
try the following with your connection string:

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

Author

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

Author

Commented:
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?
Big MontyWeb Ninja at large
CERTIFIED EXPERT

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

https://support.microsoft.com/en-us/kb/328306

Author

Commented:
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????
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.