Author |
Topic |
silver_surfer21
Starting Member
21 Posts |
Posted - 2011-03-14 : 12:37:11
|
Hi, can anyone tell me whether its still possible to get SimMetrics running for SQL Server and if so how to go about it? As I've tried following the only page I can find on the matter http://anastasiosyal.com/archive/2009/01/11/18.aspxand its 'step by step' guide doesn't have enough steps. It just says compile the jar and create a dll. I've tried running the jar in Eclipse but haven't been able to create a .dll file which it says is required for the next step.Any ideas? |
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-03-14 : 13:45:41
|
you don't use the jar. you have to build a .net dll, which you can do with the c# port. that port is here: http://sourceforge.net/projects/simmetrics/files/simmetrics.NET%20and%20amp_%20phonetics.NET/SimMetrics%20v1.5%20.NET%20update/ elsasoft.org |
|
|
silver_surfer21
Starting Member
21 Posts |
Posted - 2011-03-16 : 10:03:17
|
ok I've downloaded that and opened it in Visual C# but have no idea what to do with it, having never used it before. :( |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-03-17 : 08:46:03
|
you need to build the dll. did you build the SimMetrics.dll? That's step 2 in the step-by-step process here: http://anastasiosyal.com/archive/2009/01/11/18.aspx in this section "3. Adding string Metric functions in MS Sql Server"After you build it, continue with the rest of the steps.EDIT: actually it looks like you can skip some of the steps if you download this: http://anastasiosyal.com/code/TextFunctions.zip - it has the SimMetrics.dll built in it already, and has SQL scripts to import the dll and create the CLR functions giving you access to the apis. elsasoft.org |
|
|
silver_surfer21
Starting Member
21 Posts |
Posted - 2011-03-17 : 09:07:19
|
thanks, the reason I was having trouble is because my version of Visual Studio was too new for the download, but I've got it going now :) |
|
|
sadsa
Starting Member
1 Post |
Posted - 2011-11-21 : 08:02:30
|
Hello. Becouse the site is down, can you please upload TextFunctions.zip to another page? |
|
|
dom_usa
Starting Member
2 Posts |
Posted - 2012-07-24 : 12:36:03
|
Hi everyboy |
|
|
dom_usa
Starting Member
2 Posts |
Posted - 2012-07-24 : 12:37:23
|
Hi everyboy,with which MS Visual Studio Version does the code from the website mentioned above work? I tried 2010 and 2008 but did not succeed.thx |
|
|
fguiccia
Starting Member
3 Posts |
Posted - 2012-12-13 : 11:35:31
|
Working fine for me! you guys rock! Questions: Anybody had use the CompareStringMetrics function or child functions to group duplicates using big data sets?Any performance issues? I am going to start that exercise in a few minutes.Best regards,Ferruccio GuicciardiBI Consultant |
|
|
|