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. ReportService2005.asmx.

I am new to Reporting Service, I got the sample code, there is a method used
to connect reporting service,
http://servername/reports/ReportService2005.asmx,
But i don't find ReportService2005.asmx.
I chekced http://servername/reports/ folder ts is not there, how to get this
file? Is there any separate installtion/configuration needed?
I searched web, i don't find any information regarding this.
pl. any help
thanks
KalYou need to use http://servername/ReportServer/ReportService2005.asmx
/Reports is the web interface for Reporting Services whereas /ReportServer
is the Web Service interface.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: reg. ReportService2005.asmx.
> From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> Subject: reg. ReportService2005.asmx.
> Date: Mon, 8 Oct 2007 06:02:17 -0700
> I am new to Reporting Service, I got the sample code, there is a method
used
> to connect reporting service,
> http://servername/reports/ReportService2005.asmx,
> But i don't find ReportService2005.asmx.
> I chekced http://servername/reports/ folder ts is not there, how to get
this
> file? Is there any separate installtion/configuration needed?
> I searched web, i don't find any information regarding this.
>
> pl. any help
>
> thanks
> Kal
>|||Thanks Chris,
"Chris Alton [MSFT]" wrote:
> You need to use http://servername/ReportServer/ReportService2005.asmx
> /Reports is the web interface for Reporting Services whereas /ReportServer
> is the Web Service interface.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: reg. ReportService2005.asmx.
> > From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> > Subject: reg. ReportService2005.asmx.
> > Date: Mon, 8 Oct 2007 06:02:17 -0700
> >
> > I am new to Reporting Service, I got the sample code, there is a method
> used
> > to connect reporting service,
> >
> > http://servername/reports/ReportService2005.asmx,
> >
> > But i don't find ReportService2005.asmx.
> >
> > I chekced http://servername/reports/ folder ts is not there, how to get
> this
> > file? Is there any separate installtion/configuration needed?
> >
> > I searched web, i don't find any information regarding this.
> >
> >
> > pl. any help
> >
> >
> > thanks
> > Kal
> >
>|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: reg. ReportService2005.asmx.
> From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> References: <5D2E4DAA-6C21-4138-89A1-4109357A14BA@.microsoft.com>
<7snSqEbCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: reg. ReportService2005.asmx.
> Date: Mon, 8 Oct 2007 06:54:01 -0700
> Thanks Chris,
>
> "Chris Alton [MSFT]" wrote:
> > You need to use http://servername/ReportServer/ReportService2005.asmx
> >
> > /Reports is the web interface for Reporting Services whereas
/ReportServer
> > is the Web Service interface.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: reg. ReportService2005.asmx.
> > > From: =?Utf-8?B?S2FseWFu?= <Kalyan@.discussions.microsoft.com>
> > > Subject: reg. ReportService2005.asmx.
> > > Date: Mon, 8 Oct 2007 06:02:17 -0700
> > >
> > > I am new to Reporting Service, I got the sample code, there is a
method
> > used
> > > to connect reporting service,
> > >
> > > http://servername/reports/ReportService2005.asmx,
> > >
> > > But i don't find ReportService2005.asmx.
> > >
> > > I chekced http://servername/reports/ folder ts is not there, how to
get
> > this
> > > file? Is there any separate installtion/configuration needed?
> > >
> > > I searched web, i don't find any information regarding this.
> > >
> > >
> > > pl. any help
> > >
> > >
> > > thanks
> > > Kal
> > >
> >
> >
>

refreshRow not working

Hi
Can someone confirm that the refreshRow method on a ResultSet class does not
work and that it is a bug in the driver. I've tested the same code with
different drivers and it works ok... unless Microsoft has implemented the
functionallity different, can someone tell me what that is.....
Thanks
Carel
| Thread-Topic: refreshRow not working
| thread-index: AcUqLYcVVyNsCTdOQQKygCm51b/9Fg==
| X-WBNR-Posting-Host: 195.212.29.75
| From: "=?Utf-8?B?Q2FyZWwgZHUgdG9pdA==?="
<Careldutoit@.discussions.microsoft.com>
| Subject: refreshRow not working
| Date: Wed, 16 Mar 2005 05:39:07 -0800
| Lines: 8
| Message-ID: <D1611FB1-186E-45AD-B1F0-7F4B39D2178A@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.jdbcdriver:6758
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi
| Can someone confirm that the refreshRow method on a ResultSet class does
not
| work and that it is a bug in the driver. I've tested the same code with
| different drivers and it works ok... unless Microsoft has implemented
the
| functionallity different, can someone tell me what that is.....
|
| Thanks
| Carel
|
Hello,
The JDBC spec says that ResultSet.refreshRow() is not supported for
ResultSet objects that are type TYPE_FORWARD_ONLY, and does nothing for
those that are type TYPE_SCROLL_INSENSITIVE. This means that it can only
be used with TYPE_SCROLL_SENSITIVE. Since the Microsoft JDBC driver does
not support scroll sensitive ResultSets, the refreshRow() method is
behaving as expected.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
sql

RefCount dismatch on Row Count components

Has anyone seen this error?

messageText:
A call to the ProcessInput method for input 507 on component "CNT RowsInput"

(505) unexpectedly kept a reference to the buffer it was passed. The refcount on

that buffer was 4 before the call, and 5 after the call returned.

dataCode: -2147192599
dataBytes:

The CNT RowsInput transformation is right between the oledb source and the derive transformation. It is the 2nd transformation in the data flow.

I use all defaults for the Data flow task and provide a valid BufferTempStoragePath.

The closest/detailed explaination I found

A call to the ProcessInput

method for input %1!d! on %2!s! unexpectedly kept a reference to the

buffer it was passed. The refcount on that buffer was %3!d! before the

call, and %4!d! after the call returned. The component is keeping

references to buffers it shouldn't. If it needs to keep the buffer, it

should make a copy of the buffer for itself by calling the Clone method.

from
http://wiki.sqlis.com/default.aspx/SQLISWiki/0x800470E9.html

Hi Tianyu

Did you find an answer on this?

I am getting exactly the same problem with a custom row count component I have written - I'm keen to find out the cause.

Thanks . . . Ed

|||

Hi, Allen

We don't have any answer to this yet. Last time I researched still nothing on it :(

Tianyu

|||I randomly get that same warning on different components... and its on fairly "simple" standard components (multicast is the most common one to get that error for me, followed by rowcount)|||

Tianyu / Chris

See this thread - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=705702&SiteID=1

Regards . . . Ed

|||

Yeah, I saw that... I figured it didn't really matter - but it doesn't help me much when I have a script in my Master package that looks for any warnings from any of the many packages the Master runs, compiles all the warnings and sends it to me and my boss. He of course in turn asks what is wrong and when I say not to worry about the buffer error he wants to know why he gets emails on it then.... LOL I haven't actually found an instance where the rowcount was wrong after one of those warnings.

Mailing all the warnings and errors has saved our butts - for example when someone changed a table that is used for lookups it caused the lookup to match multiple records we got a warning. So I highly recommend the practice but its kinda lame becuase people have started to ignore the warnings when about 50% of the time at least one of the daily packages will get that error about the buffers.

|||I found this warning too. Do I need to do something or just leave it?|||Tom, I'd say to just ignore it after spot checking your results a few times. In my package which emails warnings and errors I added code to explicitly ignore that error. In the hundreds of packages run everyday we've never had this warning result in incorrect data.

RefCount dismatch on Row Count components

Has anyone seen this error?

messageText:
A call to the ProcessInput method for input 507 on component "CNT RowsInput"

(505) unexpectedly kept a reference to the buffer it was passed. The refcount on

that buffer was 4 before the call, and 5 after the call returned.

dataCode: -2147192599
dataBytes:

The CNT RowsInput transformation is right between the oledb source and the derive transformation. It is the 2nd transformation in the data flow.

I use all defaults for the Data flow task and provide a valid BufferTempStoragePath.

The closest/detailed explaination I found

A call to the ProcessInput

method for input %1!d! on %2!s! unexpectedly kept a reference to the

buffer it was passed. The refcount on that buffer was %3!d! before the

call, and %4!d! after the call returned. The component is keeping

references to buffers it shouldn't. If it needs to keep the buffer, it

should make a copy of the buffer for itself by calling the Clone method.

from
http://wiki.sqlis.com/default.aspx/SQLISWiki/0x800470E9.html

Hi Tianyu

Did you find an answer on this?

I am getting exactly the same problem with a custom row count component I have written - I'm keen to find out the cause.

Thanks . . . Ed

|||

Hi, Allen

We don't have any answer to this yet. Last time I researched still nothing on it :(

Tianyu

|||I randomly get that same warning on different components... and its on fairly "simple" standard components (multicast is the most common one to get that error for me, followed by rowcount)|||

Tianyu / Chris

See this thread - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=705702&SiteID=1

Regards . . . Ed

|||

Yeah, I saw that... I figured it didn't really matter - but it doesn't help me much when I have a script in my Master package that looks for any warnings from any of the many packages the Master runs, compiles all the warnings and sends it to me and my boss. He of course in turn asks what is wrong and when I say not to worry about the buffer error he wants to know why he gets emails on it then.... LOL I haven't actually found an instance where the rowcount was wrong after one of those warnings.

Mailing all the warnings and errors has saved our butts - for example when someone changed a table that is used for lookups it caused the lookup to match multiple records we got a warning. So I highly recommend the practice but its kinda lame becuase people have started to ignore the warnings when about 50% of the time at least one of the daily packages will get that error about the buffers.

|||I found this warning too. Do I need to do something or just leave it?|||Tom, I'd say to just ignore it after spot checking your results a few times. In my package which emails warnings and errors I added code to explicitly ignore that error. In the hundreds of packages run everyday we've never had this warning result in incorrect data.

RefCount dismatch on Row Count components

Has anyone seen this error?

messageText:
A call to the ProcessInput method for input 507 on component "CNT RowsInput"

(505) unexpectedly kept a reference to the buffer it was passed. The refcount on

that buffer was 4 before the call, and 5 after the call returned.

dataCode: -2147192599
dataBytes:

The CNT RowsInput transformation is right between the oledb source and the derive transformation. It is the 2nd transformation in the data flow.

I use all defaults for the Data flow task and provide a valid BufferTempStoragePath.

The closest/detailed explaination I found

A call to the ProcessInput

method for input %1!d! on %2!s! unexpectedly kept a reference to the

buffer it was passed. The refcount on that buffer was %3!d! before the

call, and %4!d! after the call returned. The component is keeping

references to buffers it shouldn't. If it needs to keep the buffer, it

should make a copy of the buffer for itself by calling the Clone method.

from
http://wiki.sqlis.com/default.aspx/SQLISWiki/0x800470E9.html

Hi Tianyu

Did you find an answer on this?

I am getting exactly the same problem with a custom row count component I have written - I'm keen to find out the cause.

Thanks . . . Ed

|||

Hi, Allen

We don't have any answer to this yet. Last time I researched still nothing on it :(

Tianyu

|||I randomly get that same warning on different components... and its on fairly "simple" standard components (multicast is the most common one to get that error for me, followed by rowcount)|||

Tianyu / Chris

See this thread - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=705702&SiteID=1

Regards . . . Ed

|||

Yeah, I saw that... I figured it didn't really matter - but it doesn't help me much when I have a script in my Master package that looks for any warnings from any of the many packages the Master runs, compiles all the warnings and sends it to me and my boss. He of course in turn asks what is wrong and when I say not to worry about the buffer error he wants to know why he gets emails on it then.... LOL I haven't actually found an instance where the rowcount was wrong after one of those warnings.

Mailing all the warnings and errors has saved our butts - for example when someone changed a table that is used for lookups it caused the lookup to match multiple records we got a warning. So I highly recommend the practice but its kinda lame becuase people have started to ignore the warnings when about 50% of the time at least one of the daily packages will get that error about the buffers.

|||I found this warning too. Do I need to do something or just leave it?|||Tom, I'd say to just ignore it after spot checking your results a few times. In my package which emails warnings and errors I added code to explicitly ignore that error. In the hundreds of packages run everyday we've never had this warning result in incorrect data.

RefCount dismatch on Row Count components

Has anyone seen this error?

messageText:
A call to the ProcessInput method for input 507 on component "CNT RowsInput" (505) unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was 4 before the call, and 5 after the call returned.

dataCode: -2147192599
dataBytes:

The CNT RowsInput transformation is right between the oledb source and the derive transformation. It is the 2nd transformation in the data flow.

I use all defaults for the Data flow task and provide a valid BufferTempStoragePath.

The closest/detailed explaination I found

A call to the ProcessInput method for input %1!d! on %2!s! unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was %3!d! before the call, and %4!d! after the call returned. The component is keeping references to buffers it shouldn't. If it needs to keep the buffer, it should make a copy of the buffer for itself by calling the Clone method.

from
http://wiki.sqlis.com/default.aspx/SQLISWiki/0x800470E9.html

Hi Tianyu

Did you find an answer on this?

I am getting exactly the same problem with a custom row count component I have written - I'm keen to find out the cause.

Thanks . . . Ed

|||

Hi, Allen

We don't have any answer to this yet. Last time I researched still nothing on it :(

Tianyu

|||I randomly get that same warning on different components... and its on fairly "simple" standard components (multicast is the most common one to get that error for me, followed by rowcount)|||

Tianyu / Chris

See this thread - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=705702&SiteID=1

Regards . . . Ed

|||

Yeah, I saw that... I figured it didn't really matter - but it doesn't help me much when I have a script in my Master package that looks for any warnings from any of the many packages the Master runs, compiles all the warnings and sends it to me and my boss. He of course in turn asks what is wrong and when I say not to worry about the buffer error he wants to know why he gets emails on it then.... LOL I haven't actually found an instance where the rowcount was wrong after one of those warnings.

Mailing all the warnings and errors has saved our butts - for example when someone changed a table that is used for lookups it caused the lookup to match multiple records we got a warning. So I highly recommend the practice but its kinda lame becuase people have started to ignore the warnings when about 50% of the time at least one of the daily packages will get that error about the buffers.

|||I found this warning too. Do I need to do something or just leave it?|||Tom, I'd say to just ignore it after spot checking your results a few times. In my package which emails warnings and errors I added code to explicitly ignore that error. In the hundreds of packages run everyday we've never had this warning result in incorrect data.

RefCount dismatch on Row Count components

Has anyone seen this error?

messageText:
A call to the ProcessInput method for input 507 on component "CNT RowsInput"

(505) unexpectedly kept a reference to the buffer it was passed. The refcount on

that buffer was 4 before the call, and 5 after the call returned.

dataCode: -2147192599
dataBytes:

The CNT RowsInput transformation is right between the oledb source and the derive transformation. It is the 2nd transformation in the data flow.

I use all defaults for the Data flow task and provide a valid BufferTempStoragePath.

The closest/detailed explaination I found

A call to the ProcessInput

method for input %1!d! on %2!s! unexpectedly kept a reference to the

buffer it was passed. The refcount on that buffer was %3!d! before the

call, and %4!d! after the call returned. The component is keeping

references to buffers it shouldn't. If it needs to keep the buffer, it

should make a copy of the buffer for itself by calling the Clone method.

from
http://wiki.sqlis.com/default.aspx/SQLISWiki/0x800470E9.html

Hi Tianyu

Did you find an answer on this?

I am getting exactly the same problem with a custom row count component I have written - I'm keen to find out the cause.

Thanks . . . Ed

|||

Hi, Allen

We don't have any answer to this yet. Last time I researched still nothing on it :(

Tianyu

|||I randomly get that same warning on different components... and its on fairly "simple" standard components (multicast is the most common one to get that error for me, followed by rowcount)|||

Tianyu / Chris

See this thread - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=705702&SiteID=1

Regards . . . Ed

|||

Yeah, I saw that... I figured it didn't really matter - but it doesn't help me much when I have a script in my Master package that looks for any warnings from any of the many packages the Master runs, compiles all the warnings and sends it to me and my boss. He of course in turn asks what is wrong and when I say not to worry about the buffer error he wants to know why he gets emails on it then.... LOL I haven't actually found an instance where the rowcount was wrong after one of those warnings.

Mailing all the warnings and errors has saved our butts - for example when someone changed a table that is used for lookups it caused the lookup to match multiple records we got a warning. So I highly recommend the practice but its kinda lame becuase people have started to ignore the warnings when about 50% of the time at least one of the daily packages will get that error about the buffers.

|||I found this warning too. Do I need to do something or just leave it?|||Tom, I'd say to just ignore it after spot checking your results a few times. In my package which emails warnings and errors I added code to explicitly ignore that error. In the hundreds of packages run everyday we've never had this warning result in incorrect data.