Connection to Microsoft CRM 3.0

Posted February 18th, 2008 by MLagna

I have been trying to connect to the target source (which is Microsoft CRM 3.0) but I am having the following error message:

Unable to create MS CRM COM object. in ConnectTargetandResolve (spectab.bas) (25519)

NOTE: Be sure to check the log file for additional information.

NOTE: Be sure to check the log file for additional information.

when I access the error log for the application I can find the following error details:

02/18/2008 14:25:41 2 19 O Global From Connect (driver): SQL state 01000, message:
[Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

02/18/2008 14:26:06 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:26:06 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:26:09 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:26:09 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:26:20 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:26:20 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:27:11 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:27:11 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:27:21 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:27:21 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:57:12 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:57:12 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 14:57:26 4 19 E Microsoft CRM 3.0 Unable to create MS CRM COM object.
02/18/2008 14:57:26 4 19 E Microsoft CRM 3.0 Unable to create MS CRM COM object.
02/18/2008 15:00:35 4 19 E Microsoft CRM 3.0 Unable to create MS CRM COM object.
02/18/2008 15:00:35 4 19 E Microsoft CRM 3.0 Unable to create MS CRM COM object.
02/18/2008 15:00:37 4 19 E Microsoft CRM 3.0 Unable to create MS CRM COM object.
02/18/2008 15:00:37 4 19 E Microsoft CRM 3.0 Unable to create MS CRM COM object.
02/18/2008 15:00:41 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 15:00:41 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 15:11:21 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 15:11:21 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 15:11:37 4 19 O Global Unable to create MS CRM COM object.
02/18/2008 15:11:37 4 19 O Global

any help would be appreciated.

‹ Can the XBase downloader export RBase? pervasive v8 > mssql 2000 ›

RE: Connection to MS CRM 3.0

On February 19th, 2008 jterrell said:

Hi,

Here is some additional information that may help resolve the error you are getting:

Microsoft CRM 3.0 Connector .dll File Registration

The Integration Architect installer automatically registers Microsoft CRM .dll files for the following .NET Framework versions:

  • 1.0.3705
  • 1.1.4322
  • 2.0.50727

To verify these versions, select the Microsoft CRM entry in Add/Remove Programs or look in C:/Windows/Microsoft.NET/Framework.

If you have .NET Framework versions other than one of the versions listed above, you must register the Microsoft CRM .dll files manually using the following steps.

To manually register Microsoft CRM .dll files:

  1. Locate the latest version of .NET Framework.
  2. Locate the file regasm.exe. It should be in the path environment variable or called with absolute paths.
  3. Locate DJMsCrmComObj.dll and DJMsCrmComObj3.dll in the InstallDir\Common800 folder.

    4. These files should be in that directory or called with absolute paths.

  4. To register the files, open a command prompt and type the following:
    • regasm.exe DjMsCrmComObj.dll /tlb /codebase
    • regasm.exe DjMsCrmComObj3.dll /tlb /codebase

Please let us know if this resolves the problem.

- Jo

RE: Connection to MS CRM 3.0

On February 21st, 2008 Anonymous said:

after I have executed the dll registration the target source started to work correctly.

thanks for your help.

RE: Connection to MS CRM 3.0

On February 21st, 2008 jterrell said:

Hi MLagna,

Excellent! And thank you for letting us know you have successfully connected to MS CRM 3.0 with the Data UpLoader to MS CRM 3.0.

Good luck with your data conversion!

- Jo

RE: Connection to Microsoft CRM 3.0

On February 18th, 2008 jterrell said:

Hi MLagna,

There are several steps you must follow to configure your workstation before DataTools can connect to MS CRM 3.0. Those steps are detailed in the documentation inside the Data UpLoader to Microsoft CRM. Here's how to find that documentation:

  1. Launch the Data UpLoader to Microsoft CRM.
  2. Click on the Help button (a blue question mark on the right end of the button bar).
  3. In the Help window, if the tabs labeled "Contents", "Index", etc., are not displayed by default, click on the "Show" button.
  4. Click on the "Index" tab and enter "Microsoft CRM" (without the quotation marks) in the keyword box.
  5. The second help topic that displays should be "Microsoft CRM 3.0". Double click on it to open the Help topic in the right side of the Help window.
  6. Follow the configuration instructions. Tip: Print out the instructions because it will be much easier to follow the steps.

Let us know if you need additional assistance.

- Jo

RE: Connection to Microsoft CRM 3.0

On February 19th, 2008 Anonymous said:

I have followed the instruction given, but this does not change the status of the connection. I am still receiving the error message:

Unable to create MS CRM COM object. in ConnectTargetandResolve (spectab.bas) (25519)

any ideas