How To Port A Plugin To Another Computer ?

Jul 10, 2007

Good afternoon,



I've developed a clustering plugin for SQL Server 2005 but now I want to port the .dll so my algorithm can run on another machine. Both machines have SQL Server 2005 installed, but different versions of Windows.



What are the steps I need to follow to port the plugin ?



Any help will be very appreciated.



Thanks a lot once more,



-Renan

View 3 Replies


ADVERTISEMENT

How To Get Strings From Inside A Plugin ?

Mar 13, 2007

Good morning everybody,

I'm here once again asking for help. Here's my problem:

I have a table that I use in my text mining clustering third-party algorithm. The table is as follows:

ID: primary key (int)

ID_DOC: an ID I use to know from what document a term came from (int)

ID_TERMO: the term ID (int)

TERMO: the term itself (varchar(max))

FREQ: the term frequency, usually TFxIDF (real)

Alright... I need the term itself to do some visualization. What I want to do is to get each case's term and store'em on a vector<char*>. So I did some changes on the ProcessCase method. In this method the data (each variable of the case) can be accessed rolling over the case using a DM_STATE_VALUE* as follows:

DM_STATE_VALUE* xpto = (DM_STATE_VALUE*) rgValue;

for(unsigned int i=0;i<_cAttribute;i++) { // _cAttribute is the number of variables

double aux = xpto.r8;

//Do some calculation using aux

}

Alright... It works quite well when I only have real and int data types on the database. But how the get the term collumn (varchar(max)) ?

How to modify the DM_STATE_VALUE union to accept strings as well ?

Any clues are wellcome.

Thanks a lot once more,

-Renan

View 4 Replies View Related

Custom Plugin And AdomdConnection

Jan 1, 2008

Hi,

I want to create a Data Mining Plugin-Algorithmn that uses existing mining models in the current DB. Is there a way to get a AdomdConnection from within an (Managed) Plugin-Algorithmn? This Connection should point to the current SSAS-Database.

Regards,
Manfred

View 1 Replies View Related

How To To Develope A New PlugIN Algorithm

Oct 18, 2006

I have a code for Nearest neighbour algorithm, I want to build a datamining algorithm using that code..

I have the following link that includes the source code for a sample plug-in algorithm written in C#.

(managed plug-in framework that's available for download here: )http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en#DMAPI.

But i am confused on where to insert my algorithm logic?

View 3 Replies View Related

Managed Plugin-Algorithmn

Dec 30, 2007

Hi,

I spent the last days programming a managed datamining plugin-algorithmn for SSAS 2005 and have troubles with the Prediction-Method.

Die Prediction-Methode of the "Shell-Algorithm" leads to an error-message on execution of the prediction-query (Internal Error: Unexprected Error ... dmxpredict.cpp Row 205 ...).

Can anyone provide me with a very simple implementation of this Method which just says that for every output-attribute the first (discrete) state should be predicted with a probability of, let's say, 90 % ?

Best Whishes
Manfred

View 5 Replies View Related

Any Other Plugin Algorithm Developed??

Sep 19, 2006

hi,

as we know we get clustering algorithm with managed plugin algorithm API

does anyone have developed any other plugin algorithm as i want to check what are the things that needs to be modified. i am not data mining algorithm developer but i just want to check where we have to make changes. i would be better if i get source code for algorithm other than clustering

ANOTHER PLUGIN ALGORITHM REQURIED??



thanks in advanced

View 4 Replies View Related

Error Registering Plugin

Nov 13, 2007

Good evening everyone,

I'm following the steps of the tutorial on how to construct a managed data mining plugin in C#.

Once created the Metadata, Algorithm and Navigator classes I tried to register it on Analisys Service by running the XMLA template written on the tutorial but I got the following error:

Unable to retrieve a list of supported data mining algorithms. Make
sure you are connected to the correct Analysis Services server
instance and the Analysis Services server named localhost is running
and configured properly. You can continue with a default list of data
mining algorithms

The GUID in the XMLA is correct as so the service name. The SQL Server engine runs fine.

I noticed that when I run this XMLA, the file msmdsrv.ini is modified, so in DataMining/Algorithms session a new entry is correctly created, enabled and the GUID is also set correct.

I also tried to ignore the XMLA setting up msmdsrv.ini manually but it also didn't work.

The build process is fine, both DMPluginWrapper and the Shell are registered by gacutil and I restarted (also try to stop and start) the server.

Any ideas will be very appreciated.



Thanks,

-Renan

View 17 Replies View Related

Analysis Services Plugin Debug

Mar 20, 2007

Hi!

I am working on an AS Algorithm Plugin . I want to debug it in the AS Server, but I cant figure out how it works. Now I every time install and deploy the plugin, but if I catch an exception, it just shows me the message, not the stack trace. Anyone, something friendlier method?

Sorry for my poor English!

Bye,
Laci

View 6 Replies View Related

Data Mining Plugin And Lift Chart

Jan 1, 2008

Hi,

I tried to create a lift chart with my custom plugin-algorithmn. The chart seems to be correct, but before it is drawn, an error occours:


Function ... Row 1 ... Column 43 ... cannot be used in this context.
(I've translated the key facts of this error message from german)

What did I do wrong?

Best wishes,
Manfred

View 12 Replies View Related

Some General Questions About The Managed Plugin-Algorithmn Wrapper

Dec 31, 2007

Hi,

After I've written my first Plugin-Algorithmn, I have some general questions about the Managed Plugin-Algorithmn wrapper.

What does the Property "support" express in view of predictions? Is it the overall number of cases the found rule works for?

What's the difference between AdjustedProbability and Probability ?

There is a probability for a specific StateStatistic and one for the whole AttributeStatistic.
What does the latter one express? Perhaps the overall probability that the discovered rules will lead to correct results for this attribute ? Let's say I have two rules for an attribute. Rule A has a probability of 0.5 and Rule B has a probability of 0.66. What would be AdjustedProbability.Probability in the case? The mean of 0.5 and 0.66 ?


Best whishes,
Manfred

View 5 Replies View Related

Msmdsrv.ini (Split Post): Error Registering Plugin

Jan 23, 2008



hello,everyone,I also met a problem.
I stoped the SQL Server Analysis Services first, and registered the GAC successfully,
then modified the msmdsrv.ini manually.In fact,I found the format of my msmdsrv.ini is diffirent from the one mentioned in the tutorial,it just like below:

<DataMining>
...
<Algorithms>
.
.
.
<MyCompany_Managed_Plugin_Algorithm>
<Enabled>1</Enabled>
</MyCompany_Managed_Plugin_Algorithm>
.
</Algorithms>
<Services>
...
<MyCompany_Managed_Plugin_Algorithm>
<ProgID>44503EAB-570E-4b25-A9F4-043949A7D78E</ProgID>
</MyCompany_Managed_Plugin_Algorithm>
...
</Services>


when i restarted the the AS,
some error information displayed in event viewer,
" can't load MyCompany_Mamaged_Plugin_Algorithm data mining Algorithm provider(ProgID,
can't create Algorithm Provider program for MyCompany_Managed_Plugin_Algorithm,
ProgID does not exist in the server configuration file"


I am confused by it and have not any idea to solve it.
some one can give tips?
thanks.

View 3 Replies View Related

Visual Studio Team System And SSMS - Anyone Got The Plugin To Work?

May 30, 2006

We have a large number of SPs in our databases and decided it was time to get some source control. I have VSTS team explorer installed and working in visual studio, but I cannot get the plugin for SSMS to work - it just says none in the current source control plug-in dialogue box - nothing when I drop it down either.

Any ideas what I am doing wrong?

View 1 Replies View Related

How To Know Whether A Computer Is A Sql Server According To The Name Of Computer?

May 9, 2004

Thanks a lot

View 6 Replies View Related

Error On Custom Data Mining Plugin: Content Type Mismatch

Jan 11, 2007

Good afternoon,

I'm doing a custom clustering plugin for text to pre-process ("clean" the texts), calculate weights, estimate the number of clusters (using the PBM index) and finally, do the actual clustering.

So... I've made each of these modules on C++ and I'm putting them all togheter on the plugin.

My database (MDB file) has only one table, with only two fields within: a key (auto-incremental) and a small text. What I intend to do is to get the text in each test case, store them togheter somewhere and call my classes to cluster these texts.

I'm trying to log the texts in a file (just a test) on the ProcessCase method, in the CaseProcessor class. I've did it with no problems with numerical data.

But when I load the MDB file on the Mining Structures Wizard, it says the content type of the field holding the texts is "Continous" and the data type is "Text". Actually, when I saw it I didn't really mind.

But when I run the mining model it gives me the following error: "Error 1 Error (Data mining): The data type of the Table1.Texto mining structure column must be numeric since it has a continuous content type (Content is set to Continuous or Key Time or Key Sequence). 0 0 "


So... How do I change this content type ? (the content type combobox on the Mining Structures Wizard couldn't the changed)

Can anyone help me on this, please ?

Thanks a lot.

View 6 Replies View Related

Custom Plugin Error: How To Pass Information To Mining Model Viewer?

Jan 17, 2007

Good morning,

Well... As I said in other topics, I'm doing a clustering plugin for text mining. I'm facing many problems and, with your help, solving them one by one.

First of all, thanks a lot again.

Well... I've made a clustering function that is actually working very well. But I'm exporting its results to a log file I use as an algorithm trace for debugging.

My clustering method returns a vector containing information of what cluster each register belongs. For instance:

vector[0] = 1 -> The register of index 0 belongs to cluster 1.

vector[1] = 9 -> The register of index 1 belongs to cluster 9.

vector[2] = 2 -> The register of index 2 belongs to cluster 2.

...

And so on.

But... I know that none of the Navigation methods receives a structure like this one discribed above. I only use it to log the results to debug the algorithm.

But how to pass this information (what register (or test case) belongs to what cluster) to the Navigation ?

Thanks a lot again, and any help will be very appreciated.

 

View 1 Replies View Related

How To Access The Data From A Custom Data Mining Plugin ?

Dec 20, 2006

I'm stucked in a problem and I thought if you would be so kind as to helping me to resolve it.

I'm implementing a clustering algorithm plugin for text mining. I've already read the tutorials and sample codes provided by the MSDN Library.

Well... My problem is: I can't go through the data when the Predict method is called. I've read that this method implements the "core" of the custom algorithms. Here is a small snippet of my code for you to understand my doubt:

STDMETHODIMP ALGORITHM::Predict(/* [in] */ IDMContextServices* in_pContext,/* [in] */ DM_PREDICTION_FLAGS in_Flags,/* [in] */ IDMAttributeGroup* in_pPredAttGroup,/* [in] */ DM_CaseID in_CaseID, /* [in] */ ULONG in_ulCaseValues,/* [in] */ DM_ATTRIBUTE_VALUE* in_rgValues,/* [in] */ ULONG in_ulMaxPredictions,/* [in] */ ULONG in_ulMaxStates, /* [out] */ DM_ATTRIBUTE_STAT** io_prgPredictions,/* [out] */ ULONG* out_pulPredictions) {

for(UINT i=0;i<in_ulCaseValues;i++) {
DM_ATTRIBUTE_VALUE& dmattributevalue = in_rgValues;
ULONG iAttribute = dmattributevalue.Attribute;
if (iAttribute == DM_UNSPECIFIED)
continue;
double dblValue = ::DblContinuous(dmattributevalue.Value);
char buffer[129];
sprintf(buffer,"%f ",dblValue);
RENAN_Log::log(buffer);
}
return S_OK;
}

As you can see, I'm going through in_rgValues to get its values, but i'm only obtaining the first register of the table on the database. I need to roll over a kind of resultset so I could access all the registers I need. Is there any way to do so ?

I expected Predict() received a matrix containing all my data, but the only thing I noticed that could represent the data is that in_rgValues vector. So I can go through this vector, but it holds only the first register of the table in the database (that's what's being saved on my log). I need all of the registers in order to pre-process the data and implement my clustering algorithm.

Well... That's it... I would be very pleased if you could help me.

View 7 Replies View Related

Com + ....what Port Does It Use?

Apr 8, 2004

Hello,
I hope someone could help me out here.....

I have set up a new web server in my DMZ. This web server needs to "talk" to an application server located on my LAN. It communicates via a COM + Component.

I would like to keep the access that is open between the DMZ & LAN to minimal, obviously for security reasons. Does anyone know what port is used for COM + communication?


Thank you!


Spootnicks

View 2 Replies View Related

SQL Port

May 29, 2007

in SQL 2005, how do you find out what port number SQL is using and how can we change it Static port?

thanks,

View 1 Replies View Related

Port 1433 Is Already In Use...........

Jun 7, 2000

Ok,

The Scenario is as follows:

24/7 Production Call Centre server running NT4.0 and SQL 6.5 with all the latest service packs.

SQL mail fails(with dull regularity) and the SQL server services stop.

When the SQL server Services are restarted an error message appears stating that Port 1433 is in use after which nobody can connect via TCP/IP. Obviously the port believes the previous SQL session is still running, and won't release the port to the "New Application requesting it".

On a unix system you can force a port reset so you don't need to shutdown and restart the box. Can you do this from either SQL or NT?

Any solutions would be greatly appreciated the DBA's are 100 Miles from the Servers, so restarts are reliant on other people!

View 2 Replies View Related

Change PORT

Jan 31, 2003

Is there any way that I can avoid using 1433,1434 port on the clustered servers?

I have a active/passive (SQL1-active,SQL2-passive) cluster server and another active/passive cluster (SQL2-passive,SQL1-active).

(Its a Quassi active/active server)

I want to change all the sql server ports to other than 1433 and 1434.

Should I change in the registry
Localmachine-software-microsoft-mssqlserver-client-supersocketnetlib-tcp

or
Localmachine-software-microsoft-mssqlserver-mssqlserver-supersocketnetlib-tcpport

or
anywhere else?

Any suggestions are always welcome

View 7 Replies View Related

Port 1433

May 4, 2001

Does anyone have an idea on why when using IP with port 1433 that on the SQL 2000 Server a bind failure happens on port 1433 and are not able to get to the SQL using IP but you can use Named Pipes.

Would greatly appreciate any help.

Walter

View 3 Replies View Related

Deadlock With Port: 0

Apr 13, 2006

I've been diagnosing deadlocks for a last couple weeks at a client site and I understand the KEY: and TAB: locks issues. However, the client recently experienced a series of multi-branch deadlocks for which I can find no information. Attached is the deadlock text from the ERRORLOG. Any help would be much appreciated.

Nick

View 2 Replies View Related

Port 1433

Feb 2, 2004

Did a search on port 1433 but nothing came up in the search.
This question is more geared to DBAs more then SQL developers.

I have a SQL 2000 server on a win2k3 machine. For some reason it will not listen in on TCP port 1433.
Shared memory and Named Pipes do though.

I checked the Server Network Utility and I see TCP/IP listed right under Named Pipes and I see that the default port is 1433.

Any ideas how to get SQL to listen on that port?

View 14 Replies View Related

Port Numbers

Jun 2, 2008

Hi Gurus,

Iwant to know PORT number of B on A server.
Iam following the following process to get B PORT number.

1) Loging to server A.
2)Opened SQL Server Configuration Manager.
3)Opened SQL Server 2005 Network Configuration.
4)Opened TCPIP properties of Protocol for B.
5)On that opened IP Address TAB
6)Got PORT number from TCP Dynamic Ports

Am i going n right way.
If not please advice me the right way to get port numbers.


Thanks,
ServerTeam

View 8 Replies View Related

SQL Port Number

Aug 23, 2007

1. Is there a quick way to find out what port number SQL is listening to? I have 10 instances running on one server and I could find out by going to SQL log but it's bit time consuming.

2. quick way to change the port number?

thanks

View 1 Replies View Related

Non Standard Port

Oct 30, 2007

I'm trying to setup SQL Server 2005 Express to communicate through a non standard port. I can connect to SQLServer on a remote machine using port 1433 when it is set as such but when I change the server to another port and try and connect using SSMSE I can't get through. I'm specifying the ip address and a colon followed by port number to connect.

For example: 123.123.123.123:1234

Any ideas?

----------------------------------
Standing on the shoulders of giants

View 9 Replies View Related

Port Not Open; How-to?

Jan 7, 2008


Not sure how this particular topic should be labeled but I figured I would start here.

I have a third party Time and Attendance program that uses SQL 2000 and IIS on top of Win2003.
It also uses a client side program that sits on an XP box that pulls Time clocks entries than passes that info to the SQL server.
We recently needed to move to a different service, still utilizing the same Time and Attendance program but a different client utility that pulls the Time clocks. Both the client and Time and Attnedants program are developed by the same company.
All that being said the new clock utility cannot connect to the SQL service.
The difference between the 2 utilities is the first utility uses UDP, the second uses TCP and requires port 5405.
Basically the way I€™m seeing things is that the server does not have port 5405 open this also confirmed by the company the wrote the program.
There is no firewall on this server. RRAS is installed but does not have any filters enables which I believe means it will receive and pass all protocols to all ports.
Using a port scan utility it shows port 5405 not to be open
How can I get port 5405 open?

View 5 Replies View Related

SSIS Port

Jan 23, 2007

Hi:

Just wanted to find out what port does SSIS utilizes when communicated with a remote SQL Server. Is it 1434, 1433 or something? I have a SSIS Package on Server 1, which which does inserts on SQL DB on Server 2. I think between Server 1 and Server 2, some ports are being blocked because the 2 servers are separated by a firewall. When SSIS makes connection to Server 2 (SQL), what ports does it use? Also, any other tips would also help. Here is the error I am getting:


Cannot connect to 10.xx.xx.xx.

===================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

View 12 Replies View Related

Tcp/ip Port Change

Nov 8, 2006

I installed a new instance and changed the default tcp/ip port and configured the applications. based on request i have changed the port to default 1433. now the problem is, the instance is not coming up. Then I restored the port now its working fine. But the application user wants 1433. could you please tell me why the instances is not comming up if the port is 1433? Thanks in advance

View 7 Replies View Related

Sql Port 1433

Apr 29, 2008

i am asked to change the default port 1433 to some other name by the audit team.
is it safe to change the port in cluster mode.

View 17 Replies View Related

Port Usage

Jan 19, 2007

 

The powers that be at my company have decided to redisign our network.  The big change is that they are completely separating the two domains, whereas I guess right now one runs inside of the other.

What this means to me is that I need to get a document together which shows all the connections between different SQL servers, web pages and services that I've created over the last year.

My question is, what ports do all of these things use to communicate with SQL Server 2000?  I believe the only connections right now are using ADO/ADO.NET,  or straight SQL Linked Servers.

 

View 5 Replies View Related

Port Sql 2000 To Sql 2005

Apr 17, 2007

Need url on good kb or article on converting sql 2000 to sql 2005 (full version not express)
Thanks,
Michael Oard

View 4 Replies View Related

Need A Way To Port From Informix To Sql Server

Jan 5, 2001

Hi,

Could anyone tell me how the data can be ported from informix to sql server ?

Is there a way to run the informix query from sql server ?

Thanks,
Vijay.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved