DevForce Classic: Object Mapping Tool Connection Issue

Object Mapping Tool Connection Issue

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=188
Printed Date: 12-Jun-2026 at 7:05am

Topic: Object Mapping Tool Connection Issue

Posted By: Customer
Subject: Object Mapping Tool Connection Issue
Date Posted: 12-Jul-2007 at 2:55pm

No matter what I try I am unable to establish a connection to any server or database both local and remote. I open the �Data Link Properties� dialog, on the provider tab I select �Microsoft OLE DB Provider for SQL Server� on the connection tab set the server name, use windows integrated security, and finally select a database on the selected server. I click �Test Connection� and get �Test connection succeeded� I click �Ok� on the �Data Link Properties� dialog, and the data source grid shows an error icon with �unable to connect�. I have also tried some of the other drivers listed on the Provider tab with no success.

I can use the Object Mapping tool�s generated connection string to connect to the same server in ADO code, the string is listed below.

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=IdeaBladeTutorial;Data Source=(local)

I have read your documentation, and looked at ibrunner.com but have not found anything referencing this problem. I have uninstalled and reinstalled IdeaBlade, this did not seem to help. I did not experience any problems during uninstall or install.

My configuration is as follows:

Visual Studio 2005 Professional Edition, with SP1 applied. (This problem existed before SP1 was installed)

IdeaBlade Version 3.4.0.3

Windows XP Professional SP2

SQL Server 2005 local

SQL Server 2000 remote

Any help you could provide would be greatly appreciated

Replies:

Posted By: IdeaBlade
Date Posted: 12-Jul-2007 at 2:57pm

The error that you are receiving indicates that your connection string is sufficient to be used at runtime, but is not sufficient to be used at design time (to give you access to the database schema information).

A likely cause of your error is:

(1) Wrong version of MDAC

Go to Program Files\Common Files\System\OleDB. Right-click on oledb32.dll and choose Properties and then select the Version tab. You should be using version 2.81.

If this doesn't fix your problem, it is likely due to some other supporting file required by SQL Server. If any case, if it is not an MDAC versioning problem, could you please send me the IdeaBlade.ibconfig file from your solution?

I also suggest running some of the completed tutorials.

Posted By: Customer
Date Posted: 12-Jul-2007 at 3:01pm

It is not an MDAC problem but after attempting to run several Instructional Unit solutions I got the listed error below. The solutions compile though.

IdeaBlade.Persistence.PersistenceServerException was unhandled

Message="Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified."

Source="IdeaBlade.Persistence"

StackTrace:

at IdeaBlade.Persistence.PersistenceManager.HandlePersistenceServerException(Exception pException, Boolean pTryToHandle, PersistenceOperation pOperation)

at IdeaBlade.Persistence.PersistenceManager.XFetchDataSet(IEntityQuery pEntityQuery)

at IdeaBlade.Persistence.PersistenceManager.XFetch(IEntityFinder pEntityFinder, WorkState pWorkState)

at IdeaBlade.Persistence.PersistenceManager.XGetEntities(IEntityQuery pEntityQuery, QueryStrategy pQueryStrategy, WorkState pWorkState)

Posted By: IdeaBlade
Date Posted: 12-Jul-2007 at 3:02pm

The missing System.EnterpriseServices.Wrapper.dll is the clue I needed. After doing some research this is what I have found:

This exception below is very interesting. I think that you may possibly have a corrupted 2.0 Framework. I searched the Internet for "Systems.EnterpriseServices.Wrapper" and found another person who had the same error:

http://72.14.253.104/search?q=cache:S7su9LfNWloJ:www.velocityreviews.com/forums/t114244-the-system-cannot-find-the-file-specified-exception-from-hresult-0x80070002.html+system.enterpriseservices.wrapper&hl=en&ct=clnk&cd=3&gl=us - http://72.14.253.104/search?q=cache:S7su9LfNWloJ:www.velocityreviews.com/forums/t114244-the-system-cannot-find-the-file-specified-exception-from-hresult-0x80070002.html+system.enterpriseservices.wrapper&hl=en&ct=clnk&cd=3&gl=us

At the end of this thread, there is the following advice:

I'm not too familiar with Enterprise Services. I can find a few
references online to people finding this file missing, but cannot seem
to find any resolutions (although quite a few suggestions of uninstall
and reinstall .NET framework 2.0). As a side thought, has the 2003
server had any of the 2.0 betas installed, and what is it now running?

Can you try the following: open a command prompt and navigate to
%windir%\assembly\GAC_32\System.EnterpriseServices \\2.0.0.0__b03f5f7f11d50a3a

Do a dir. There should be two files there
(System.EnterpriseServices.dll and the .Wrapper.dll). If there are,
then lets check the version. Copy the .Wrapper.dll to the root of C (or
somewhere else accessable to explorer) and bring up the properties.
Here on my 2000 box, the version is 2.0.50727.42, and I don't believe
that this should be different on 2K3, but I'm prepared to be very
wrong. If the files aren't there, then your Framework 2.0 install is
almost certainly bad, so a reinstall is indicated.

Hope this helps, but to be honest I'm grasping in the dark here.

I tried looking at the GAC and found the wrapper:

Posted By: Customer
Date Posted: 12-Jul-2007 at 3:04pm

You would be correct; neither of those enterprise services dll�s were present. I ran a .Net 2.0 framework repair and that has solved the problem. The files are their, the object mapping tool now works, etc, etc.

Thanks a bunch for all the help you have provided, I really appreciate it.