Reg:Error in PULL (RDA) for data sync

Hi Darren & All,

Thanks! As per your guidance, i have tried in the pull method.Now i am getting error "The LocalTablename parameter is already specified".

Coding as follows:

string rdaOleDbConnectString = @."Provider=SQLOLEDB; Data Source=PRASSANA\PRASANA;Initial Catalog=master;User Id=sa;Password=master";
SqlCeRemoteDataAccess rda = null;
try
{
rda = new SqlCeRemoteDataAccess();
rda.LocalConnectionString = "Data Source=E:\\SampleTest.sdf";
rda.InternetUrl = "http://192.168.1.118/TEst/sqlcesa30.dll";
rda.InternetLogin = "IUSR_PRASSANA";
rda.InternetPassword = "PRASSANA";
rda.Pull("company", "Select * from company", rdaOleDbConnectString, RdaTrackOption.TrackingOn);
MessageBox.Show("Pull Method");
}
catch (SqlCeException)
{
Message.show(ex.message);
}
finally
{
// Dispose of the RDA Object
//
rda.Dispose();
}
}
Please guide me in detail, what mistake i have done in this method.

Thanks ,

Prasanna.

Hope these URLs help!

http://support.microsoft.com/kb/920272

and

http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PostID=274359

Thanks,

Laxmi

Reg:Error in PULL (RDA) for data sync

Hi Darren & All,

Thanks! As per your guidance, i have tried in the pull method.Now i am getting error "The LocalTablename parameter is already specified".

Coding as follows:

string rdaOleDbConnectString = @."Provider=SQLOLEDB; Data Source=PRASSANA\PRASANA;Initial Catalog=master;User Id=sa;Password=master";
SqlCeRemoteDataAccess rda = null;
try
{
rda = new SqlCeRemoteDataAccess();
rda.LocalConnectionString = "Data Source=E:\\SampleTest.sdf";
rda.InternetUrl = "http://192.168.1.118/TEst/sqlcesa30.dll";
rda.InternetLogin = "IUSR_PRASSANA";
rda.InternetPassword = "PRASSANA";
rda.Pull("company", "Select * from company", rdaOleDbConnectString, RdaTrackOption.TrackingOn);
MessageBox.Show("Pull Method");
}
catch (SqlCeException)
{
Message.show(ex.message);
}
finally
{
// Dispose of the RDA Object
//
rda.Dispose();
}
}
Please guide me in detail, what mistake i have done in this method.

Thanks ,

Prasanna.

Hope these URLs help!

http://support.microsoft.com/kb/920272

and

http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PostID=274359

Thanks,

Laxmi

reg. performance

Is there anyway pull logs and statistical information regarding performance
and Transaction database ?
Thanks
Kalyan
If you are talking about reading tran. log then there is 3rd party tool
called lumigent log explorer. Do a google search for it. On the otherhand if
the question is regarding performance monitoring, then read BOL on the topics
like SQL profiler and windows performance moniter. The DBA is required to
baseline the values of the performance counters when the SQL is functioning
normally. This base line will help you to compare the trace logs at the time
of bad performance and see what is the problem in event of performance
degradation.
Thanks
Chinna.
"Kalyan" wrote:

> Is there anyway pull logs and statistical information regarding performance
> and Transaction database ?
>
> Thanks
> Kalyan

reg. performance

Is there anyway pull logs and statistical information regarding performance
and Transaction database ?
Thanks
KalyanIf you are talking about reading tran. log then there is 3rd party tool
called lumigent log explorer. Do a google search for it. On the otherhand if
the question is regarding performance monitoring, then read BOL on the topics
like SQL profiler and windows performance moniter. The DBA is required to
baseline the values of the performance counters when the SQL is functioning
normally. This base line will help you to compare the trace logs at the time
of bad performance and see what is the problem in event of performance
degradation.
Thanks
Chinna.
"Kalyan" wrote:
> Is there anyway pull logs and statistical information regarding performance
> and Transaction database ?
>
> Thanks
> Kalyan

Referencing Textbox Values

Is there a way to reference a value from a textbox in a matrix? In other words I want to pull the value in the textbox that is the column header into a cell in the matrix under certain conditions.

You can try this:

=ReportItems!textbox3.value

or

You should be able to share a value in a hidden textbox using code.

Create a hidden textbox. Add the expression =Code.SetValue(mytextboxcontent) to the textbox.

Add the expression =Code.GetValue() to the matrix.

Create 2 functions

public myval as object

function setValue(value as object) as object

myval = value

return value

end function

function getValue() as object
return myval
end function

|||Thanks. You just helped me solve a bigger problem I've been working on for a week now.