Execution Plan: error

Showing posts with label error. Show all posts

Thursday, March 29, 2012

export excel fail

Hi All:
I create a report and it works perfectly when i export repor to PDF, CVS etc
except Excel.
The error i got is: Subreports within table/mastrix cells are ignored.
any hepl are appreciated.
Thanks
NickHello Nick,
This is a limitation of the Excel render engine:
http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx
"Excel does not support nested containers other than lists."
and:
http://msdn2.microsoft.com/en-us/library/ms155976.aspx
"Any data region nested inside of a table or matrix data region is not
supported. An error is displayed in Excel if this layout is encountered. "
You can look at:
http://msdn2.microsoft.com/en-us/library/ms156268.aspx
and find tips on designing your report to look good when rendered in
different formats. Modify your report to use lists rather than tables and
you should be able to overcome this issue.
Good luck!
Larry
"Nick" wrote:
> Hi All:
> I create a report and it works perfectly when i export repor to PDF, CVS etc
> except Excel.
> The error i got is: Subreports within table/mastrix cells are ignored.
> any hepl are appreciated.
> Thanks
> Nick|||Thanks mate.
Just wonder that is that any way i can remove excel export from the report
view as i don't really need this export function.
Cheers
Nick
"lsmithmier" wrote:
> Hello Nick,
> This is a limitation of the Excel render engine:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx
> "Excel does not support nested containers other than lists."
> and:
> http://msdn2.microsoft.com/en-us/library/ms155976.aspx
> "Any data region nested inside of a table or matrix data region is not
> supported. An error is displayed in Excel if this layout is encountered. "
> You can look at:
> http://msdn2.microsoft.com/en-us/library/ms156268.aspx
> and find tips on designing your report to look good when rendered in
> different formats. Modify your report to use lists rather than tables and
> you should be able to overcome this issue.
> Good luck!
> Larry
>
> "Nick" wrote:
> > Hi All:
> >
> > I create a report and it works perfectly when i export repor to PDF, CVS etc
> > except Excel.
> > The error i got is: Subreports within table/mastrix cells are ignored.
> >
> > any hepl are appreciated.
> >
> > Thanks
> > Nick|||Just for the one report? I don't think so. For the whole server? Sure, I
think. :-) Try removing the \Configuration\Extensions\Render\Extension for
the Excel renderer from RSReportServer.config. I believe that will disable
it. There may be an easier way, but that is the first one that comes to mind.
Larry
"Nick" wrote:
> Thanks mate.
> Just wonder that is that any way i can remove excel export from the report
> view as i don't really need this export function.
> Cheers
> Nick
> "lsmithmier" wrote:
> > Hello Nick,
> >
> > This is a limitation of the Excel render engine:
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx
> > "Excel does not support nested containers other than lists."
> >
> > and:
> > http://msdn2.microsoft.com/en-us/library/ms155976.aspx
> > "Any data region nested inside of a table or matrix data region is not
> > supported. An error is displayed in Excel if this layout is encountered. "
> >
> > You can look at:
> > http://msdn2.microsoft.com/en-us/library/ms156268.aspx
> > and find tips on designing your report to look good when rendered in
> > different formats. Modify your report to use lists rather than tables and
> > you should be able to overcome this issue.
> >
> > Good luck!
> >
> > Larry
> >
> >
> > "Nick" wrote:
> >
> > > Hi All:
> > >
> > > I create a report and it works perfectly when i export repor to PDF, CVS etc
> > > except Excel.
> > > The error i got is: Subreports within table/mastrix cells are ignored.
> > >
> > > any hepl are appreciated.
> > >
> > > Thanks
> > > Nicksql

Export Error

Some users are getting the following error message when they attempt to
export to any of the avialable file formats.
"Internet Explorer cannot download Format=EXCEL from sqlreports.cnf.com.
"Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later?
Other users are able to download just fine.Does anyone have an answer? I'd like to get his resolved.
"yrmeyer" wrote:
> Some users are getting the following error message when they attempt to
> export to any of the avialable file formats.
> "Internet Explorer cannot download Format=EXCEL from sqlreports.cnf.com.
> "Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later?
> Other users are able to download just fine.

Thursday, March 22, 2012

Export a table to excel sheet with data converting error

Hi,
I an using the following bcp utility to export a sql2000 table to an excel
sheet, there is only one filed data like this 00004563254666,
0000786653636....
The datatype is char(16), After I exported to excel it looks like this now
2.75E+11
Any ideas?
Thanks
select @.sql = 'bcp "' + @.dbName + ' select * from ##Testtable" queryout
"' + @.fullFileName + '" -c -CRAW'
On Jul 26, 9:18 pm, "mecn" <mecn2...@.yahoo.com> wrote:
> Hi,
> I an using the following bcp utility to export a sql2000 table to an excel
> sheet, there is only one filed data like this 00004563254666,
> 0000786653636....
> The datatype is char(16), After I exported to excel it looks like this now
> 2.75E+11
> Any ideas?
> Thanks
> select @.sql = 'bcp "' + @.dbName + ' select * from ##Testtable" queryout
> "' + @.fullFileName + '" -c -CRAW'
Hi, you may try something like this:
select @.sql = 'bcp "' + @.dbName + ' select
convert(varchar(16),field) from ##Testtable" queryout
"' + @.fullFileName + '" -c -CRAW'
sql

Export a table to excel sheet with data converting error

Hi,
I an using the following bcp utility to export a sql2000 table to an excel
sheet, there is only one filed data like this 00004563254666,
0000786653636....
The datatype is char(16), After I exported to excel it looks like this now
2.75E+11
Any ideas?
Thanks
select @.sql = 'bcp "' + @.dbName + ' select * from ##Testtable" queryout
"' + @.fullFileName + '" -c -CRAW'On Jul 26, 9:18 pm, "mecn" <mecn2...@.yahoo.com> wrote:
> Hi,
> I an using the following bcp utility to export a sql2000 table to an excel
> sheet, there is only one filed data like this 00004563254666,
> 0000786653636....
> The datatype is char(16), After I exported to excel it looks like this now
> 2.75E+11
> Any ideas?
> Thanks
> select @.sql = 'bcp "' + @.dbName + ' select * from ##Testtable" queryout
> "' + @.fullFileName + '" -c -CRAW'
Hi, you may try something like this:
select @.sql = 'bcp "' + @.dbName + ' select
convert(varchar(16),field) from ##Testtable" queryout
"' + @.fullFileName + '" -c -CRAW'

Export a table to excel sheet with data converting error

Hi,
I an using the following bcp utility to export a sql2000 table to an excel
sheet, there is only one filed data like this 00004563254666,
0000786653636....
The datatype is char(16), After I exported to excel it looks like this now
2.75E+11
Any ideas?
Thanks
select @.sql = 'bcp "' + @.dbName + ' select * from ##Testtable" queryout
"' + @.fullFileName + '" -c -CRAW'On Jul 26, 9:18 pm, "mecn" <mecn2...@.yahoo.com> wrote:
> Hi,
> I an using the following bcp utility to export a sql2000 table to an excel
> sheet, there is only one filed data like this 00004563254666,
> 0000786653636....
> The datatype is char(16), After I exported to excel it looks like this now
> 2.75E+11
> Any ideas?
> Thanks
> select @.sql = 'bcp "' + @.dbName + ' select * from ##Testtable" queryout
> "' + @.fullFileName + '" -c -CRAW'
Hi, you may try something like this:
select @.sql = 'bcp "' + @.dbName + ' select
convert(varchar(16),field) from ##Testtable" queryout
"' + @.fullFileName + '" -c -CRAW'

Wednesday, March 21, 2012

export a table

I tried to write a package for transferring SQL 2005 table to a flat file in
Visual Studio. However I got the unicode error message at the destination
even though I only use English. Does anyone has idea? Thanks.
The message is as following :
Error: Column "Status" cannot convert between unicode and non-unicode
string data types.
Error: ... ( The same message with all the column in the source table)
Please help. Thanks." 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
news:ekXwbLCcHHA.2552@.TK2MSFTNGP06.phx.gbl...
>I tried to write a package for transferring SQL 2005 table to a flat file
>in
> Visual Studio. However I got the unicode error message at the destination
> even though I only use English. Does anyone has idea? Thanks.
> The message is as following :
> Error: Column "Status" cannot convert between unicode and non-unicode
> string data types.
> Error: ... ( The same message with all the column in the source table)
> Please help. Thanks.
>|||" 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
news:ekXwbLCcHHA.2552@.TK2MSFTNGP06.phx.gbl...
>I tried to write a package for transferring SQL 2005 table to a flat file
>in
> Visual Studio. However I got the unicode error message at the destination
> even though I only use English. Does anyone has idea? Thanks.
>
Sounds like source database may be using nvarchar for its columns?
Probably need to cast them (and possibly lose unicode data, but sounds like
you have none) before you export them.
> The message is as following :
> Error: Column "Status" cannot convert between unicode and non-unicode
> string data types.
> Error: ... ( The same message with all the column in the source table)
> Please help. Thanks.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||I solved the problem by adding data conversion task between source and
destination. But this does only for append. How can I do it for overwrite?
Thanks.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:OVMWf4OcHHA.4260@.TK2MSFTNGP02.phx.gbl...
>" 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
>news:ekXwbLCcHHA.2552@.TK2MSFTNGP06.phx.gbl...
>>I tried to write a package for transferring SQL 2005 table to a flat file
>>in
>> Visual Studio. However I got the unicode error message at the destination
>> even though I only use English. Does anyone has idea? Thanks.
> Sounds like source database may be using nvarchar for its columns?
> Probably need to cast them (and possibly lose unicode data, but sounds
> like you have none) before you export them.
>
>> The message is as following :
>> Error: Column "Status" cannot convert between unicode and non-unicode
>> string data types.
>> Error: ... ( The same message with all the column in the source table)
>> Please help. Thanks.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||Can anyone please help? Is this the correct group I post this kind of
question? Thanks.
" 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
news:OgwAMpQcHHA.588@.TK2MSFTNGP06.phx.gbl...
>I solved the problem by adding data conversion task between source and
>destination. But this does only for append. How can I do it for overwrite?
>Thanks.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:OVMWf4OcHHA.4260@.TK2MSFTNGP02.phx.gbl...
>>" 00ScarlettJohnson" <EE@.yahoo.com> wrote in message
>>news:ekXwbLCcHHA.2552@.TK2MSFTNGP06.phx.gbl...
>>I tried to write a package for transferring SQL 2005 table to a flat file
>>in
>> Visual Studio. However I got the unicode error message at the
>> destination
>> even though I only use English. Does anyone has idea? Thanks.
>>
>> Sounds like source database may be using nvarchar for its columns?
>> Probably need to cast them (and possibly lose unicode data, but sounds
>> like you have none) before you export them.
>>
>> The message is as following :
>> Error: Column "Status" cannot convert between unicode and non-unicode
>> string data types.
>> Error: ... ( The same message with all the column in the source table)
>> Please help. Thanks.
>>
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>

Export - Excel Error

Hi All,
i am not able to export the report as excel. it showing the below
error:
i am using the MSRS2000. i have installed microsoft office excel 2003.
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and
Settings\vinod_banagani\Desktop\AppointmentLog.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted.
is RS2000 supports Excel 2000 only?
if anyone have faced this problem earlier, please tell me the solution.
Thanks in advance for your help...Thanks for your response Bruce.
i have upgraded SP2.
When I select the export to excel file format, I get the following in
the
excel file: "Data Regions within table/matrix cells are
ignored".
i am using tables and rectangles inside the table... and texboxes
inside the rectangle in my report. the report is showing perfectly but
when i select the export to excel file, it is throwing an error.
Is this a known bug in RS..
Any info will be appreciated.
Thanks,
Vinod
vinodsh_82@.hotmail.com wrote:
> Hi All,
>
> i am not able to export the report as excel. it showing the below
> error:
>
> i am using the MSRS2000. i have installed microsoft office excel 2003.
>
> Microsoft Office Excel File Repair Log
>
> Errors were detected in file 'C:\Documents and
> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
> The following is a list of repairs:
>
> Damage to the file was so extensive that repairs were not possible.
> Excel attempted to recover your formulas and values, but some data may
> have been lost or corrupted.
>
> is RS2000 supports Excel 2000 only?
>
> if anyone have faced this problem earlier, please tell me the solution.
>
> Thanks in advance for your help...|||Well, at least you got a better error message. It sounds like whatever
combination of tables, rectangles, tables within tables etc causes a
problem.
I don't know if 2005 would work better or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vinodsh_82@.hotmail.com> wrote in message
news:1147799266.536977.43720@.v46g2000cwv.googlegroups.com...
> Thanks for your response Bruce.
> i have upgraded SP2.
> When I select the export to excel file format, I get the following in
> the
> excel file: "Data Regions within table/matrix cells are
> ignored".
> i am using tables and rectangles inside the table... and texboxes
> inside the rectangle in my report. the report is showing perfectly but
> when i select the export to excel file, it is throwing an error.
> Is this a known bug in RS..
> Any info will be appreciated.
> Thanks,
> Vinod
>
> vinodsh_82@.hotmail.com wrote:
>> Hi All,
>>
>> i am not able to export the report as excel. it showing the below
>> error:
>>
>> i am using the MSRS2000. i have installed microsoft office excel 2003.
>>
>> Microsoft Office Excel File Repair Log
>>
>> Errors were detected in file 'C:\Documents and
>> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
>> The following is a list of repairs:
>>
>> Damage to the file was so extensive that repairs were not possible.
>> Excel attempted to recover your formulas and values, but some data may
>> have been lost or corrupted.
>>
>> is RS2000 supports Excel 2000 only?
>>
>> if anyone have faced this problem earlier, please tell me the solution.
>>
>> Thanks in advance for your help...
>|||Hi Vinod. It sounds like you are using a sub-report. Sub-reports are not
exported in the Excel rendering extension in RS2000 or RS2005. MHTML and
PDF rendering extensions do support sub-reports.
-Tim
<vinodsh_82@.hotmail.com> wrote in message
news:1147799266.536977.43720@.v46g2000cwv.googlegroups.com...
> Thanks for your response Bruce.
> i have upgraded SP2.
> When I select the export to excel file format, I get the following in
> the
> excel file: "Data Regions within table/matrix cells are
> ignored".
> i am using tables and rectangles inside the table... and texboxes
> inside the rectangle in my report. the report is showing perfectly but
> when i select the export to excel file, it is throwing an error.
> Is this a known bug in RS..
> Any info will be appreciated.
> Thanks,
> Vinod
>
> vinodsh_82@.hotmail.com wrote:
>> Hi All,
>>
>> i am not able to export the report as excel. it showing the below
>> error:
>>
>> i am using the MSRS2000. i have installed microsoft office excel 2003.
>>
>> Microsoft Office Excel File Repair Log
>>
>> Errors were detected in file 'C:\Documents and
>> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
>> The following is a list of repairs:
>>
>> Damage to the file was so extensive that repairs were not possible.
>> Excel attempted to recover your formulas and values, but some data may
>> have been lost or corrupted.
>>
>> is RS2000 supports Excel 2000 only?
>>
>> if anyone have faced this problem earlier, please tell me the solution.
>>
>> Thanks in advance for your help...
>

Export - Excel Error

Monday, March 19, 2012

Explorer Script Error

Ever time I open Enterprise Manager and select the database to work on, I
recieve an Internet Script Error
LINE: 307
Char: 2
Error: Unspecified
Code: 0
URL:
res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\10
33\sqlmmc.rll/Tabs.htmlFor that error, Change the view for the database in
Enterprise Manager to something other than task pad. Then
close Enterprise Manager. The reopen Enterprise Manager and
change the view back to task pad. You should be able to
proceed from there without errors.
-Sue
On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
<rrowe68@.hotmail.com> wrote:
>Ever time I open Enterprise Manager and select the database to work on, I
>recieve an Internet Script Error
>
>LINE: 307
>Char: 2
>Error: Unspecified
>Code: 0
>URL:
>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\10
>33\sqlmmc.rll/Tabs.html
>|||Thanks - but if I want to view the task pad - do you know of a fix?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h6g0qv499idhe0iq9vebftffiuaquuepfh@.4ax.com...
> For that error, Change the view for the database in
> Enterprise Manager to something other than task pad. Then
> close Enterprise Manager. The reopen Enterprise Manager and
> change the view back to task pad. You should be able to
> proceed from there without errors.
> -Sue
> On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
> <rrowe68@.hotmail.com> wrote:
> >Ever time I open Enterprise Manager and select the database to work on, I
> >recieve an Internet Script Error
> >
> >
> >LINE: 307
> >Char: 2
> >Error: Unspecified
> >Code: 0
> >URL:
>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1
0
> >33\sqlmmc.rll/Tabs.html
> >
>|||After changing it to something else other than task pad,
closing Enterprise Manager, you can reopen and then change
the view back to task pad.
I don't think there is any fix other than going through this
routine when you get the error.
-Sue
On Wed, 29 Oct 2003 16:01:43 -0800, "Bob"
<rrowe68@.hotmail.com> wrote:
>Thanks - but if I want to view the task pad - do you know of a fix?
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:h6g0qv499idhe0iq9vebftffiuaquuepfh@.4ax.com...
>> For that error, Change the view for the database in
>> Enterprise Manager to something other than task pad. Then
>> close Enterprise Manager. The reopen Enterprise Manager and
>> change the view back to task pad. You should be able to
>> proceed from there without errors.
>> -Sue
>> On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
>> <rrowe68@.hotmail.com> wrote:
>> >Ever time I open Enterprise Manager and select the database to work on, I
>> >recieve an Internet Script Error
>> >
>> >
>> >LINE: 307
>> >Char: 2
>> >Error: Unspecified
>> >Code: 0
>> >URL:
>>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1
>0
>> >33\sqlmmc.rll/Tabs.html
>> >
>|||That did it -- Thanks.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:rsl0qvk2midqee2rms1rmj8kse0egf232t@.4ax.com...
> After changing it to something else other than task pad,
> closing Enterprise Manager, you can reopen and then change
> the view back to task pad.
> I don't think there is any fix other than going through this
> routine when you get the error.
> -Sue
> On Wed, 29 Oct 2003 16:01:43 -0800, "Bob"
> <rrowe68@.hotmail.com> wrote:
> >Thanks - but if I want to view the task pad - do you know of a fix?
> >
> >
> >
> >"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> >news:h6g0qv499idhe0iq9vebftffiuaquuepfh@.4ax.com...
> >> For that error, Change the view for the database in
> >> Enterprise Manager to something other than task pad. Then
> >> close Enterprise Manager. The reopen Enterprise Manager and
> >> change the view back to task pad. You should be able to
> >> proceed from there without errors.
> >>
> >> -Sue
> >>
> >> On Wed, 29 Oct 2003 14:26:04 -0800, "Bob"
> >> <rrowe68@.hotmail.com> wrote:
> >>
> >> >Ever time I open Enterprise Manager and select the database to work
on, I
> >> >recieve an Internet Script Error
> >> >
> >> >
> >> >LINE: 307
> >> >Char: 2
> >> >Error: Unspecified
> >> >Code: 0
> >> >URL:
> >>
>>res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\
1
> >0
> >> >33\sqlmmc.rll/Tabs.html
> >> >
> >>
> >
>

Explanation for Error Message

Where can I go to find out what error message 25602 means?
Thanks for your help.
HenryIs that a SQL error? Where/when do you get that?|||Thanks for your response. We got this message when we attempted to load the
enterprise edition of Microsoft Reporting Services on WIN2003 server running
SQL Server 2000. And that killed our installation attempt. It would be most
helpful to know what this means!
Henry
"Bassist695" wrote:
> Is that a SQL error? Where/when do you get that?
>

Monday, March 12, 2012

Expired Subscription Clean Up - REPOST

Running SQL 2k / Win 2k
I am getting an error on Replication Monitor->Agents->Misc
Agents->Expired Subscription Clean up that reads 'Executed as user:
ROUSES.COM\Administrator. Invalid object name 'sysarticles'. [SQLSTATE
42S02] (Error 208) Invalid object name 'sysarticleupdates'. [SQLSTATE
42S02] (Error 208) Associated statement is not prepared [SQLSTATE
HY007] (Error 0). The step failed.'
What dB is this table or tables missing from? How do I recreate
them?
AHIA,
Larry...
Sounds like a publication database. For some reason there seems to be an
bogus entry in distribution.dbo.mspublisher_databases or
distribution.dbo.mspublications.
Its looking at the view in sysextendedarticlesview in a publication
database. I can't tell which one it it. Run profiler and look for the db id.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1140014373.809026.60790@.g47g2000cwa.googlegro ups.com...
> Running SQL 2k / Win 2k
> I am getting an error on Replication Monitor->Agents->Misc
> Agents->Expired Subscription Clean up that reads 'Executed as user:
> ROUSES.COM\Administrator. Invalid object name 'sysarticles'. [SQLSTATE
> 42S02] (Error 208) Invalid object name 'sysarticleupdates'. [SQLSTATE
> 42S02] (Error 208) Associated statement is not prepared [SQLSTATE
> HY007] (Error 0). The step failed.'
>
> What dB is this table or tables missing from? How do I recreate
> them?
>
> AHIA,
> Larry...
>

Friday, March 9, 2012

expects parameter......parameterized query

Hi all,

I am using the below parameterized query and get an error while executing it...can anyone please spot the error. Any help will be appreciated. I have gone cross-eyed now looking at it all day. The error I get it is

Parameterized Query '(@.Re_UK_Eligible nvarchar(4000),@.Re_Aus_Eligible nvarchar(33),@.R' expects parameter @.Re_JobType_Temp, which was not supplied.

 sqlStmt ="UPDATE Re_Users SET Re_UK_Eligible=@.Re_UK_Eligible,Re_Aus_Eligible=@.Re_Aus_Eligible,Re_Can_Eligible=@.Re_Can_Eligible,Re_USA_Eligible=@.Re_USA_Eligible,Re_Address1=@.Re_Address1,Re_Address2=@.Re_Address2,Re_Address3=@.Re_Address3,Re_City=@.Re_City,Re_Postcode=@.Re_Postcode,Re_Country=@.Re_Country,Re_Homephone=@.Re_Homephone,Re_Mobile=@.Re_Mobile,Re_JobType_Per=@.Re_JobType_Per,Re_JobType_Temp=@.Re_JobType_Temp,Re_JobType_Con=@.Re_JobType_Con,Re_Hours_Full=@.Re_Hours_Full,Re_Hours_Part=@.Re_Hours_Part,Re_Sector=@.Re_Sector,Re_StepTwoDone=1 WHERE Re_UserCount=" + Session["ReUserIdentity"]; cn =new SqlConnection(ConfigurationManager.ConnectionStrings["ReConnectionString"].ConnectionString); cmd =new SqlCommand(sqlStmt, cn); cmd.CommandType = CommandType.Text;//Insert UKif (chkUK.Checked ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_UK_Eligible", DBNull.Value)); }if ((chkUK.Checked ==true) && (UKRadioButtonList.SelectedIndex > -1)) { cmd.Parameters.Add(new SqlParameter("@.Re_UK_Eligible", UKRadioButtonList.SelectedItem.Text)); }//Insert AUSif (chkAUS.Checked ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_Aus_Eligible", DBNull.Value)); }if ((chkAUS.Checked ==true) && (AUSRadioButtonList.SelectedIndex > -1)) { cmd.Parameters.Add(new SqlParameter("@.Re_Aus_Eligible", AUSRadioButtonList.SelectedItem.Text)); }//Insert CANif ((chkCAN.Checked ==false)) { cmd.Parameters.Add(new SqlParameter("@.Re_Can_Eligible", DBNull.Value)); }if ((chkCAN.Checked ==true) && (CANRadioButtonList.SelectedIndex > -1)) { cmd.Parameters.Add(new SqlParameter("@.Re_Can_Eligible", CANRadioButtonList.SelectedItem.Text)); }//Insert USAif (chkUSA.Checked ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_USA_Eligible", DBNull.Value)); }if ((chkUSA.Checked ==true) && (USARadioButtonList.SelectedIndex > -1)) { cmd.Parameters.Add(new SqlParameter("@.Re_USA_Eligible", USARadioButtonList.SelectedItem.Text)); }//Contact Details cmd.Parameters.Add(new SqlParameter("@.Re_Address1", Address1TextBox.Text));if (Address2TextBox.Text =="") { cmd.Parameters.Add(new SqlParameter("@.Re_Address2", DBNull.Value)); }else { cmd.Parameters.Add(new SqlParameter("@.Re_Address2", Address2TextBox.Text)); }if (Address3TextBox.Text =="") { cmd.Parameters.Add(new SqlParameter("@.Re_Address3", DBNull.Value)); }else { cmd.Parameters.Add(new SqlParameter("@.Re_Address3", Address3TextBox.Text)); } cmd.Parameters.Add(new SqlParameter("@.Re_City", CityTextBox.Text)); cmd.Parameters.Add(new SqlParameter("@.Re_Postcode", PostcodeTextBox.Text)); cmd.Parameters.Add(new SqlParameter("@.Re_Country", CountryDropDownList.SelectedItem.Text));if (HomeTelephoneTextBox.Text =="") { cmd.Parameters.Add(new SqlParameter("@.Re_Homephone", DBNull.Value)); }else { cmd.Parameters.Add(new SqlParameter("@.Re_Homephone", HomeTelephoneTextBox.Text)); }if (MobileTelephoneTextBox.Text =="") { cmd.Parameters.Add(new SqlParameter("@.Re_Mobile", DBNull.Value)); }else { cmd.Parameters.Add(new SqlParameter("@.Re_Mobile", MobileTelephoneTextBox.Text)); }//Job Preferencesfor (int i = 0; i < JobTypeCheckBoxList.Items.Count; i++) {if (JobTypeCheckBoxList.Items[i].Text =="Permanent" && JobTypeCheckBoxList.Items[i].Selected ==true) { cmd.Parameters.Add(new SqlParameter("@.Re_JobType_Per", 1)); }else if (JobTypeCheckBoxList.Items[i].Text =="Permanent" && JobTypeCheckBoxList.Items[i].Selected ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_JobType_Per", 0)); }if (JobTypeCheckBoxList.Items[i].Text =="Temporary" && JobTypeCheckBoxList.Items[i].Selected ==true) { cmd.Parameters.Add(new SqlParameter("@.Re_JobType_Temp", 1)); }else if (JobTypeCheckBoxList.Items[i].Text =="Temporary" && JobTypeCheckBoxList.Items[i].Selected ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_JobType_Temp", 0)); }if (JobTypeCheckBoxList.Items[i].Text =="Contract" && JobTypeCheckBoxList.Items[i].Selected ==true) { cmd.Parameters.Add(new SqlParameter("@.Re_JobType_Con", 1)); }else if (JobTypeCheckBoxList.Items[i].Text =="Contract" && JobTypeCheckBoxList.Items[i].Selected ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_JobType_Con", 0)); } }//Hours and Sectorfor (int i = 0; i < HoursCheckBoxList.Items.Count; i++) {if (HoursCheckBoxList.Items[i].Text =="FullTime" && HoursCheckBoxList.Items[i].Selected ==true) { cmd.Parameters.Add(new SqlParameter("@.Re_Hours_Full", 1)); }else if (HoursCheckBoxList.Items[i].Text =="FullTime" && HoursCheckBoxList.Items[i].Selected ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_Hours_Full", 0)); }if (HoursCheckBoxList.Items[i].Text =="PartTime" && HoursCheckBoxList.Items[i].Selected ==true) { cmd.Parameters.Add(new SqlParameter("@.Re_Hours_Part", 1)); }else if (HoursCheckBoxList.Items[i].Text =="PartTime" && HoursCheckBoxList.Items[i].Selected ==false) { cmd.Parameters.Add(new SqlParameter("@.Re_Hours_Part", 0)); } } cmd.Parameters.Add(new SqlParameter("@.Re_Sector", SectorDropDownList.SelectedItem.Text)); cn.Open(); cmd.ExecuteNonQuery();

thanks,

vijay

I would add the parameters to the collection first and set the value in the IF loops. Sometimes there are other conditions that you might not have accounted for.

Example:

myCommand.Parameters.Add(New SqlParameter("@.userid",SqlDbType.int));if txtbox1.text ==""{myCommand.Parameters("@.userid").Value = 0}else{myCommand.Parameters("@.userid").Value = userid}

Also, I would do a response.write of JobTypeCheckBoxList.Items.Count to see what the count is.

|||

Gave my sore eyes some rest and changed the code as recommended and guess what it did do the trick!!!

thanks

vijay

Expects parameter which was not supplied....need help....

I wanted to add new record into two different tables. By using one web form...
Not so sure I coded it correctly. And I got this error trying to insert new record

" Procedure 'sp_insert' expects parameter '@.mid', which was not supplied. "

Isn't it i have include @.mid in my code ...??

<STORED PROCEDURES>
sp_insert

(
@.mid char(10),
@.status char(10),
@.name char(20),
@.dj char(20),
@.rank char(20),
@.nric char(14),
@.dob char(20),
@.age char(10),
@.add char(80),
@.school char(50),
@.hp char(10),
@.mp char(10),
@.email char(30),
@.pgname char(20),
@.relationship char(20),
@.contact char(10)

)
AS
insert into Table1(mid,status,name,date_joined,rank,nric,dob,age,address,school,house_phone,Mobile_phone,email,[P/G_name],[P/G_relationship],[P/G_contacts])
values (@.mid,@.status,@.name,@.dj,@.rank,@.nric,@.dob,@.age,@.add,@.school,@.hp,@.mp,@.email,@.pgname,@.relationship,@.contact)

insert into Table2 (name) values (@.name)

RETURN

<WEB FORM>
mycommand = New SqlCommand("sp_insert", mycon)
mycommand.CommandType = CommandType.StoredProcedure

Dim midpar As New SqlParameter("@.mid", SqlDbType.Char, 10)
midpar.Direction = ParameterDirection.Input
midpar.Value = Tb1.Text

Dim statuspar As New SqlParameter("@.status", SqlDbType.Char, 10)
statuspar.Direction = ParameterDirection.Input
statuspar.Value = ddl1.SelectedItem.Text

---
---
---Your webform code is wrong, needs to be something like this:

Dim sqlPar As SqlParameter= myCommand.Parameter.Add("@.mid", SqlDbType.Char, 10)
sqlPar.Direction = ParameterDirection.Input
sqlPar.Value = Tb1.TextsqlPar = myCommand.Parameter.Add("@.status", SqlDbType.Char, 10)
sqlPar.Direction = ParameterDirection.Input
sqlPar.Value = ddl1.SelectedItem.Text

etc.
etc.
etc.

Expected end of statement

i got this kind of error type:

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/wanhe/services/update_succeed.asp, line 80, column 129
sqlStrDB = "update applicant set Name='"&username&"', Gender= '"&gender&"', Age='"&age&"',Marriage='"&maritalstatus&"',HighEdu='"&hEducation&"',EngScore='"&engScore&"',ToeflScore='"&toeflScore&"',IeltsScore='"&ieltsScore&"',FysmScore='"&fysmScore&"',NcetScore='"&ncetScore&"',Tel='"&coTel&"',Mobile='"&coMobile&"',Email='"&coEmail&"',AppSchool='"&appSchool&"',AppMajor='"&appMajor&"',Comment='"&coComment&"',companyNameCN='"&coNameCN&"',companyNameEN='"&coNameEN&"',CoAddress='"&coAddress&"',CoPostal='"&coPostal&"' where ID = "&userID&""

this is my coding:
<%
dim cnStrDB
dim rcSetDB
dim sqlStrDB

'create connection and recordset objects
Set cnStrDB = Server.CreateObject("ADODB.Connection")
Set rcSetDB = Server.CreateObject("ADODB.Recordset")

' connection string
dim pathDB
dim providerDB

' change this path to your database path
pathDB = "C:\Inetpub\wwwroot\wanhe\services\oApplication.mdb "
providerDB = "Microsoft.Jet.OLEDB.4.0"

' defining database connection (connectionstring.asp)
cnStrDB.ConnectionString = pathDB
cnStrDB.Provider = providerDB
cnStrDB.Mode = 3

cnStrDB.open
dim username
Dim coNameCN
Dim coNameEN
Dim coAddress
Dim coPostal
dim gender
dim age
dim maritalstatus
dim hEducation
dim engScore
dim toeflScore
dim ieltsScore
dim fysmScore
dim ncetScore
dim appSchool
dim appMajor
Dim coTel
Dim userID
Dim coMobile
dim coEmail
dim coComment

username = request.form("userName")
coNameCN = request.form("txtCoNameCN")
coNameEN= request.form("txtCoNameEN")
coAddress= request.form("txtCoAddress")
coPostal= request.form("txtPostal")
coTel= request.form("Tel")
coMobile= request.form("Mobile")
coEmail= request.form("Email")
coComment= request.form("Comment")
gender= request.form("Gender")
age= request.form("Age")
maritalstatus= request.form("Age")
hEducation= request.form("highEdu")
'response.write hEducation
'response.end
engScore= request.form("EngScore")
toeflScore= request.form("ToeflScore")
ieltsScore= request.form("IeltsScore")
fysmScore= request.form("FysmScore")
ncetScore= request.form("NcetScore")
appSchool= request.form("AppSchool")
appMajor= request.form("AppMajor")

userID=Request.cookies("ID")

sqlStrDB = "update applicant set Name= '"&username&"', Gender= '"&gender&"', Age='"&age&"',Marriage='"&maritalstatus&"', HighEdu='"&hEducation&"', EngScore='"&engScore&"',ToeflScore='"&toeflScore&"',IeltsScore='"&ieltsScore&"',FysmScore='"&fysmScore&"',NcetScore='"&ncetScore&"',Tel='"&coTel&"',Mobile='"&coMobile&"',Email='"&coEmail&"',AppSchool='"&appSchool&"',AppMajor='"&appMajor&"',Comment='"&coComment&"',companyNameCN='"&coNameCN&"',companyNameEN='"&coNameEN&"',CoAddress='"&coAddress&"',CoPostal='"&coPostal&"' where ID = "&userID&""

rcSetDB.ActiveConnection = cnStrDB
rcSetDB.cursorType = 3 'for add record into database
rcSetDB.cursorLocation = 3
rcSetDB.open(sqlStrDB)

%>

i know it's somehting wrong with
HighEdu='"&hEducation&"
but i cant find where is wrong

anyone can helps me??
thanks a lot
:()Maybe that "" at the end should have been ";"?

You should really use prepared statements with bind variables. Not only do they improve performance and remove a security loophole, they also make it easier to write your SQL:

sqlStrDB = "update applicant set Name=?, Gender=?, Age=?,Marriage=?, HighEdu=?, ... , CoPostal=? where ID = ?;"|||same error message|||your first line:
sqlStrDB = "Your statement" _ (add the "_" at the end)

your second line:
& "Your statement" (add "&" at the first)

try to manipulate it if error happens again. I think it should work because you have to separate your string to another lines by these characters.

regards.

chris|||the problem is the variable name
i change to another name can liao

by the way thanks for ur help

Sunday, February 26, 2012

Exit DTS Package

Is there a way to exit an executed DTS package using Microsoft TSQL without causing an error or does this need to be in VB?The TSQL executes within the package, and thus I don't think there is a way to directly stop the package using TSQL. I suppose you could call system stored procedures to command shell out and stop the service, or even identify the executing process and kill it, but I would certainly never recommend anything like this.

Your best be may be to have the TSQL return an error code or set an environment variable that your DTS package can respond to.|||Okay thanks. I did raiserror but that makes the package a failure which is what I don't want.|||the handling of return codes inside DTS is a different animal from RAISEERROR|||I ended up writing it in VB but thanks guys.

Sunday, February 19, 2012

Execution 'rgaerh55bisinzr1nlmr13jk' cannot be found (rsExecutionN

I have a SSRS 2005 SP1 running on Windows 2003 SRS. On reports with
parameters we are getting the following error.
Execution 'rgaerh55bisinzr1nlmr13jk' cannot be found (rsExecutionNotFound).
Anyone else seen this? Any suggestions on how to resolve this?
Thanks.Yes, we are seeing the same thing.
In our case, the report runs the first time, with the default parameters --
which says that there's an aweful lot of setup that is functioning just fine.
Then, upon changing a parameter and pressing "View Report", the following
obscure error shows up:
Execution 'qr1hx055hlpkx445xluqd4yv' cannot be found (rsExecutionNotFound)
It also occurs when simply pressing "View Report", with no changes to
parameters.
"rdwill1" wrote:
> I have a SSRS 2005 SP1 running on Windows 2003 SRS. On reports with
> parameters we are getting the following error.
> Execution 'rgaerh55bisinzr1nlmr13jk' cannot be found (rsExecutionNotFound).
> Anyone else seen this? Any suggestions on how to resolve this?
> Thanks.

Thursday, March 29, 2012

export excel fail

Export Error

Thursday, March 22, 2012

Export a table to excel sheet with data converting error

Export a table to excel sheet with data converting error

Export a table to excel sheet with data converting error

Wednesday, March 21, 2012

export a table

export a table

export a table

Export - Excel Error

Export - Excel Error

Monday, March 19, 2012

Explorer Script Error

Explanation for Error Message

Monday, March 12, 2012

Expired Subscription Clean Up - REPOST

Friday, March 9, 2012

expects parameter......parameterized query

Expects parameter which was not supplied....need help....

Expected end of statement

Sunday, February 26, 2012

Exit DTS Package

Sunday, February 19, 2012

Execution 'rgaerh55bisinzr1nlmr13jk' cannot be found (rsExecutionN

Execution Plan

Blog Archive

About Me