[CSHARP-1135] CSharpDriver-1.7.0.4714 and CSharpDriver-1.10-rc0 dlls couldn't be registered Created: 01/Dec/14  Updated: 05/Apr/19  Resolved: 01/Dec/14

Status: Closed
Project: C# Driver
Component/s: Setup
Affects Version/s: 1.7
Fix Version/s: None

Type: Task Priority: Blocker - P1
Reporter: Deepak Assignee: Unassigned
Resolution: Done Votes: 0
Labels: driver, question
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Windows 7 (32 bit)



 Description   

Hi,

Trying to load data from Mongo to SQL 2008 using SSIS 2008.
CSharpDriver-1.4.2.4500 works fine for me as the dlls are registered automatically. But CSharpDriver-1.7.0.4714 and CSharpDriver-1.10-rc0 don't work fine. I couldn't registers those dlls using gacutil. I get error "Unkown error". I am stuck here and couldn't proceed further. I need the latest drivers as old drivers doesn't have features.

My Mongo source has many embedded documents with a dynamic schema. How to do I load these embedded documents using SSIS?

Let me also know if there are any other better option to load embedded documents using SSIS.

Thanks in Advance.

Regards,
Deepak



 Comments   
Comment by Craig Wilson [ 04/Dec/14 ]

Yes, go back to a version where we strong-signed the dlls for you. Previous versions, however, don't necessarily work with the newer server versions. I would strongly encourage you to simply build them yourself and sign them with a key you or your company uses. Our signing was with a key that was public, so it amounted to providing no security at all. It's easy to do this as all you need is msbuild. Simply pull the source code and run `.\build.cmd Build` and you'll be built. Now you just need to customize the project to include signing.

Comment by Deepak [ 04/Dec/14 ]

[We used to strongly sign the .dlls which allowed them to be installed into the GAC. Strong signing is not typically done anymore and caused more problems than it solved as a majority of users do not install into the GAC. As such, if you need to install into the GAC, you'll need to build the .dlls yourself with strong signing enabled.]

– If I am not building my own dlls then what are all the other options to use these dlls (drivers - C# 1.5 and above) in my SSIS package to connect Mongo?

Comment by Craig Wilson [ 01/Dec/14 ]

Deepak,

I'm not sure what you mean by, "load embedded documents." Simply querying for documents will pull back embedded documents and arrays by default. As far as SSIS goes, we haven't played with it. I presume MongoSSIS works, but have never worked with it.

This type of question is better suited for our google group (https://groups.google.com/forum/?pli=1#!forum/mongodb-user) or stackoverflow. There are a greater number of users watching those that might be able to answer your question better.

Comment by Deepak [ 01/Dec/14 ]

Please advise me how to load embedded documents. Some links explaining these should be great for me.
And is there any better tool plugins like MongoSSIS? Or can I use MongoSSIS?

Comment by Craig Wilson [ 01/Dec/14 ]

We used to strongly sign the .dlls which allowed them to be installed into the GAC. Strong signing is not typically done anymore and caused more problems than it solved as a majority of users do not install into the GAC. As such, if you need to install into the GAC, you'll need to build the .dlls yourself with strong signing enabled.

Generated at Wed Feb 07 21:38:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.