Showing posts with label property. Show all posts
Showing posts with label property. Show all posts

Monday, March 19, 2012

How to use PublisherEncryptedPassword?

I'm doing merge replication over the net using the ActiveX replication
library.
The SQLMergeClass has a property called PublisherEncryptedPassword
(string). There is absolutely no documentation for this anywhere on the
web (that I can find, anyhow).
How do I use this? Do I have to provide an encrypted password? If so,
what type of encryption do I use?
I'm assuming that this exists to enable me to send an encrypted
password instead of plain text.
Thanks for any info -
JJ
have you tried
declare @.retcode int
declare @.distributor_enc_password nvarchar(524)
set @.distributor_enc_password='stuff'
EXEC @.retcode = master.dbo.xp_repl_encrypt @.distributor_enc_password OUTPUT
print @.distributor_enc_password
print @.retcode
This property is hidden and undocumented. It could be used in WSM.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1123031272.303748.285010@.g44g2000cwa.googlegr oups.com...
> I'm doing merge replication over the net using the ActiveX replication
> library.
> The SQLMergeClass has a property called PublisherEncryptedPassword
> (string). There is absolutely no documentation for this anywhere on the
> web (that I can find, anyhow).
> How do I use this? Do I have to provide an encrypted password? If so,
> what type of encryption do I use?
> I'm assuming that this exists to enable me to send an encrypted
> password instead of plain text.
> Thanks for any info -
> JJ
>
|||Thanks - that shows me how to encrypt my password, but I am not able to
authenticate with it for some reason.
Does PublisherEncryptedPassword replace PublisherPassword?
I am not using WSM.
JJ

Wednesday, March 7, 2012

How To use Data Mining HTML Tree Viewer

Hi!

I try to use Data Mining HTML Tree Viewer, but has some problem. In the Connection property, i can't set a new connection to this property.

Help me!!!

The Connection property should be used in the code behind the web page. When the web application already initialized an OleDb connection pointing to an Analysis Services server, that connection can be reuased by the web controls.

An example (assuming a Tree viewer control on the page, named DMDecisionTreeViewer1)

System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection();

cn.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost; Initial Catalog=MyCatalog";

DMDecisionTreeViewer1.Connection = cn;

DMDecisionTreeViewer1.Model = "MyModel";

DMDecisionTreeViewer1.Tree = "SomePredictableColumn";

If a connection is not available in the web application (the general case), then the Connection property should be ignored and, instead, the Server and Database properties of the controls should be populated. If, in the code above, the properties are set as below:

DMDecisionTreeViewer1.Server = "localhost";

DMDecisionTreeViewer1.Database= "MyCatalog";

then the result will be the same as using the connection created above (the control will create a connection by itself and use it in populating the tree content)

Hope this helps