Showing posts with label specified. Show all posts
Showing posts with label specified. Show all posts

Wednesday, March 7, 2012

Errorlog File The system cannot find the path specified

I have a cluster SQL Server 2000 database with Windows 2003 server operating
system. Periodically I receive the error listed below. The database is
functioning properly when I received this error message.
Please help me determine why this error occurs periodically.
Thanks,
initerrlog: Could not open error log file 'F=:\LOG\ERRORLOG'. Operating
system error = 3(The system cannot find the path specified.).
Hi,
just go that path and see is there any error log file or not
if not then create a error logfile.
U did not mentioned from where does this error occurs.
thanx
from
killer

Errorlog File The system cannot find the path specified

I have a cluster SQL Server 2000 database with Windows 2003 server operating
system. Periodically I receive the error listed below. The database is
functioning properly when I received this error message.
Please help me determine why this error occurs periodically.
Thanks,
initerrlog: Could not open error log file 'F=:\LOG\ERRORLOG'. Operating
system error = 3(The system cannot find the path specified.).Hi,
just go that path and see is there any error log file or not
if not then create a error logfile.
U did not mentioned from where does this error occurs.
thanx
from
killer

Errorlog File The system cannot find the path specified

I have a cluster SQL Server 2000 database with Windows 2003 server operating
system. Periodically I receive the error listed below. The database is
functioning properly when I received this error message.
Please help me determine why this error occurs periodically.
Thanks,
initerrlog: Could not open error log file 'F=:\LOG\ERRORLOG'. Operating
system error = 3(The system cannot find the path specified.).Hi,
just go that path and see is there any error log file or not
if not then create a error logfile.
U did not mentioned from where does this error occurs.
thanx
from
killer

Sunday, February 26, 2012

Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
--
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Crdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in messag
e
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> rights.
>

Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
--
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Eric Cárdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> >
> > I did rename my server and followed the steps.
> > sp_dropserver sp_addserver etc
> >
> > But cannot make this server a target server
> >
> > Error-14262 The specified msx does not exist 'any ideas
> > great people?.The other servers see the master server Ok
> >
> >
> > Thanks Michael
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Cárdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Cárdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> > >
> > > I did rename my server and followed the steps.
> > > sp_dropserver sp_addserver etc
> > >
> > > But cannot make this server a target server
> > >
> > > Error-14262 The specified msx does not exist 'any ideas
> > > great people?.The other servers see the master server Ok
> > >
> > >
> > > Thanks Michael
> > --
> > This could be a permissions problem. Start the SQL Server service on the
> > target server using a domain administrator account and see how you go.
> >
> > Hope this helps,
> >
> > --
> > Eric Cárdenas
> > Senior support professional
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
>

Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael
>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
|||"Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Crdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> rights.
>

Error:Procedure or function CatalogJSummary has too many arguments specified

hello, all

I am using a Stored procedure and calling this in my code in C#.

Here is my procedure:

CatalogJSummary

(

@.SeriesId INT

)

AS

SELECT Games.GameName, Games.Id AS GameId

FROM GameCodes INNER JOIN

Games ON GameCodes.GameId = Games.Id INNER JOIN

MobileSeries ON GameCodes.SeriesId = MobileSeries.Id INNER JOIN

Mobiles ON MobileSeries.Id = Mobiles.SeriesId

GROUP BY Games.GameName, Games.Id, MobileSeries.Id

HAVING (MobileSeries.Id = @.SeriesId)

RETURN

and here is the calling C# code::

public DataSet CatalogJSummary(int sid)

{

SqlConnection cnUnique=new SqlConnection();

cnUnique.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["jconnection"];

//con.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["jconnection"];

com.CommandText="CatalogJSummary";

com.CommandType=CommandType.StoredProcedure;

com.Parameters.Add("@.SeriesId",SqlDbType.Int);

com.Parameters["@.SeriesId"].Value=sid;

com.Connection=cnUnique;

// con.Open();

cnUnique.Open();

adp=new SqlDataAdapter();

adp.SelectCommand=com;

DataSet ds1=new DataSet();

adp.Fill(ds1);

cnUnique.Close();

return ds1;

}

but when this code execute,with the parameter passed to stored procedure using this code at runtime, i get the following error::

Procedure or function CatalogJSummary has too many arguments specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function CatalogJSummary has too many arguments specified.

Source Error:

Line 243:adp.SelectCommand=com; Line 244:DataSet ds1=new DataSet(); Line 245:adp.Fill(ds1); Line 246:cnUnique.Close(); Line 247:return ds1;


Source File: c:\inetpub\wwwroot\mobmasti.catalog\classes\truetonescls.cs Line: 245

Anyone please help me to resolve this error

thanks in advance

There are many options you can try:

1. From SQL Server books online:
If the first three characters of the procedure name are sp_, SQL Server
searches the master database for the procedure. If no qualified procedure name is provided, SQL Server searches for the procedure as if the owner name is dbo. To resolve the stored procedure name as a user-defined stored procedure with the same name as a system stored procedure, provide the fully qualified procedure name.

2. Make sure the field names between your calls and the procedure are the same

3. Make sure you attached the database with the user it was intended to be used with. Otherwise you may not have sufficient rights and this message will show up.

error:no report server found on the specified machine while setting up reporting services config

Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

Hello Nirupa,

Can you make sure you have IIS installed and running? If so, make sure you have /Reports and /ReportServer showing in IIS management.

Then, check to see if you have the following three folders in the C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services directory (where x is the component number for RS). LogFiles, ReportManager, & ReportServer

Hope this helps.

Jarret

|||

Hi Jarret,

Thanks for your suggestions first,

yes I installed IIS and it is running,

and

I couldn't find any folder C:\Program Files\Microsoft SQL Server\MSSQL.1\ Reporting Services directory

...LogFiles, ReportManager, & ReportServer

I could see only path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ Backup

'' \Bin

'' \Install

'' \LOG

'' \repldata

'' \TemplateData

can you suggest me what might had happen.... or what shall be done

Thanks

Nirupa

|||

Do you have a MSSQL.2, MSSQL.3, or MSSQL.4 folder? If so, look in each for the 3 folders I listed in my last post. If you don't have these folders, you probably should reinstall Reporting Services.

Jarret

|||

Hello Jarret

I do not have the folders that you have mentioned....As you have mentioned will probably need reinstallation

Thank you

Nirupa

|||

That is correct, if you don't have these folders, you don't have RS installed. Try to re-install and see if that fixes your problem.

Jarret

|||

Hi Jarret,

Thanks for your suggestions.As you mentioned, I reinstalled SQL reporting services and got the above mention folders(MSSQL.1,MSSQL.2,MSSQL.3) and also I successfully configured reporting services.While trying to deploy my reporting services application in to localhost , I got the below mentioned error : " The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) "

can you please sugguest me work around for this issue.

Friday, February 24, 2012

error:26 Error Locating Server/Instance Specified

I am having trouble connecting to Sql Server 2005 Express from asp.net
2.0 app on Windows Server 2003. I am using Sql Server Authentication,
and I tried the below article's suggestions a number of times. When I
login to to the machine, and login, I am able to get authenticated.
However, when I debug my application, I get the error below. Do I have
to give the sql server authenticaed account I created certain
permissions? Whould I set a port, and use the ipaddress rather than
the server name? Any suggestions would be greatly appreciated.
http://support.microsoft.com/kb/914277
My Error:
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: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)
My Connection String:
<add key="ConnectionString"
value="server=MyServerName;uid=MyUserName;pwd=MyPasswd;database=MyDB"/>On Feb 1, 5:20=A0pm, carlos <carlosubu...@.gmail.com> wrote:
> I am having trouble connecting to Sql Server 2005 Express from asp.net
> 2.0 app on Windows Server 2003. I am using Sql Server Authentication,
> and I tried the below article's suggestions a number of times. When I
> login to to the machine, and login, I am able to get authenticated.
> However, when I debug my application, I get the error below. Do I have
> to give the sql server authenticaed account I created certain
> permissions? Whould I set a port, and use the ipaddress rather than
> the server name? Any suggestions would be greatly appreciated.
> http://support.microsoft.com/kb/914277
> My Error:
> 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: SQL Network Interfaces, error: 26 - Error
> Locating Server/Instance Specified)
> My Connection String:
> =A0<add key=3D"ConnectionString"
> value=3D"server=3DMyServerName;uid=3DMyUserName;pwd=3DMyPasswd;database=3D=MyDB"/>
Update:
I changed the connection string to use the ipaddress, and a port that
I set in the TCPIP settings, and now i'm getting the below message:
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: TCP Provider, error: 0 - No connection could
be made because the target machine actively refused it.)
I'm thinking this may be a permission problem'|||Hi Carlos,
By default, SQL Server 2005 Express, Evaluation, and Developer editions
allow local client connections only. Enterprise, Standard, and Workgroup
editions also listen for remote client connections over TCP/IP.
you ned to enable Remote Connections option using
Surface Area Configuration for Services and Connections (Remote Connections)
- Database Engine
You must restart the Database Engine instance's service to apply changes.
Regards,
Amol R. Lembhe
"carlos" wrote:
> On Feb 1, 5:20 pm, carlos <carlosubu...@.gmail.com> wrote:
> > I am having trouble connecting to Sql Server 2005 Express from asp.net
> > 2.0 app on Windows Server 2003. I am using Sql Server Authentication,
> > and I tried the below article's suggestions a number of times. When I
> > login to to the machine, and login, I am able to get authenticated.
> > However, when I debug my application, I get the error below. Do I have
> > to give the sql server authenticaed account I created certain
> > permissions? Whould I set a port, and use the ipaddress rather than
> > the server name? Any suggestions would be greatly appreciated.
> >
> > http://support.microsoft.com/kb/914277
> >
> > My Error:
> >
> > 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: SQL Network Interfaces, error: 26 - Error
> > Locating Server/Instance Specified)
> >
> > My Connection String:
> > <add key="ConnectionString"
> > value="server=MyServerName;uid=MyUserName;pwd=MyPasswd;database=MyDB"/>
> Update:
> I changed the connection string to use the ipaddress, and a port that
> I set in the TCPIP settings, and now i'm getting the below message:
> 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: TCP Provider, error: 0 - No connection could
> be made because the target machine actively refused it.)
> I'm thinking this may be a permission problem'
>

Error: Too many backup devices specified

I am new to SQL Server 2005.
I am trying to restore a database on my computer using SQL Server 2005.
In SQL 2000, I could create the database and then restore a backup over it.
I tried doing this in SQL 2005 and I get the Error:
Too many backup devices specified for backup or restore; only 64 allowed.
Error: 3205.
In the 'Restore Database' window, I select the database and I select, 'From
Device' and point to the backup file to restore. From the 'Specify Backup'
window, I select the backup file, I get the above error.
What am I doing wrong?
ThanksGloria,
It seems that most of the people who run into this are trying to restore a
2005 database to a 2000 server.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
The description of your problem does not sound like you are doing this (or
at least not intentionally) but you might check it out.
Do you backup to multiple files or do you use single file backups? SQL
Server 2000 had a problem restoring multi-file backups, but that was fixed
in 2000 and should be working fine in SQL Server 2005.
RLF
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:E51D26A7-88C0-4580-9722-40D84E17B6E9@.microsoft.com...
>I am new to SQL Server 2005.
> I am trying to restore a database on my computer using SQL Server 2005.
> In SQL 2000, I could create the database and then restore a backup over
> it.
> I tried doing this in SQL 2005 and I get the Error:
> Too many backup devices specified for backup or restore; only 64 allowed.
> Error: 3205.
> In the 'Restore Database' window, I select the database and I select,
> 'From
> Device' and point to the backup file to restore. From the 'Specify
> Backup'
> window, I select the backup file, I get the above error.
> What am I doing wrong?
> Thanks|||We use single file backups.
The file is from SQL 2005 and I am trying to restore it in SQL 2005 BUT, I
do have SQL 2000 on my computer also and the other databases that I see in
the database list (Object Explorer are SQL 2000 ).
I will check out the links you sent and will continue troubleshooting.
Thanks,
"Russell Fields" wrote:
> Gloria,
> It seems that most of the people who run into this are trying to restore a
> 2005 database to a 2000 server.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
> The description of your problem does not sound like you are doing this (or
> at least not intentionally) but you might check it out.
> Do you backup to multiple files or do you use single file backups? SQL
> Server 2000 had a problem restoring multi-file backups, but that was fixed
> in 2000 and should be working fine in SQL Server 2005.
> RLF
> "Gloria" <Gloria@.discussions.microsoft.com> wrote in message
> news:E51D26A7-88C0-4580-9722-40D84E17B6E9@.microsoft.com...
> >I am new to SQL Server 2005.
> > I am trying to restore a database on my computer using SQL Server 2005.
> > In SQL 2000, I could create the database and then restore a backup over
> > it.
> >
> > I tried doing this in SQL 2005 and I get the Error:
> > Too many backup devices specified for backup or restore; only 64 allowed.
> > Error: 3205.
> >
> > In the 'Restore Database' window, I select the database and I select,
> > 'From
> > Device' and point to the backup file to restore. From the 'Specify
> > Backup'
> > window, I select the backup file, I get the above error.
> >
> > What am I doing wrong?
> >
> > Thanks
>
>|||I noticed when I opened SQL Server 2005 that my server was listed as a SQL
Server 2000 type. It looks like this:
Server Name (SQL Server 8.0......)
The '8.0' I believe means that it is SQL Server 2000 and not 2005.
When it is 2005, it is SQL Server 9.0.3042
When you start SQL 2005, the dialog box lists the server names. In my case,
my server group is on my machine so I added '\SQLEXPRESS' to the name of my
machine and it identified it as Server 9.0.3042.
"William" wrote:
> Hi, I would like to know if you could find the solution to this problem because it's happening to me too.
> I'm traying to restore a backup from sql 2005 to a database in sql 2005 too. The message is the same that yours.
> I appreciate your answer.
> Thanks!!!
>

Error: Too many backup devices specified

I am new to SQL Server 2005.
I am trying to restore a database on my computer using SQL Server 2005.
In SQL 2000, I could create the database and then restore a backup over it.
I tried doing this in SQL 2005 and I get the Error:
Too many backup devices specified for backup or restore; only 64 allowed.
Error: 3205.
In the 'Restore Database' window, I select the database and I select, 'From
Device' and point to the backup file to restore. From the 'Specify Backup'
window, I select the backup file, I get the above error.
What am I doing wrong?
Thanks
Gloria,
It seems that most of the people who run into this are trying to restore a
2005 database to a 2000 server.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
The description of your problem does not sound like you are doing this (or
at least not intentionally) but you might check it out.
Do you backup to multiple files or do you use single file backups? SQL
Server 2000 had a problem restoring multi-file backups, but that was fixed
in 2000 and should be working fine in SQL Server 2005.
RLF
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:E51D26A7-88C0-4580-9722-40D84E17B6E9@.microsoft.com...
>I am new to SQL Server 2005.
> I am trying to restore a database on my computer using SQL Server 2005.
> In SQL 2000, I could create the database and then restore a backup over
> it.
> I tried doing this in SQL 2005 and I get the Error:
> Too many backup devices specified for backup or restore; only 64 allowed.
> Error: 3205.
> In the 'Restore Database' window, I select the database and I select,
> 'From
> Device' and point to the backup file to restore. From the 'Specify
> Backup'
> window, I select the backup file, I get the above error.
> What am I doing wrong?
> Thanks
|||We use single file backups.
The file is from SQL 2005 and I am trying to restore it in SQL 2005 BUT, I
do have SQL 2000 on my computer also and the other databases that I see in
the database list (Object Explorer are SQL 2000 ).
I will check out the links you sent and will continue troubleshooting.
Thanks,
"Russell Fields" wrote:

> Gloria,
> It seems that most of the people who run into this are trying to restore a
> 2005 database to a 2000 server.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
> The description of your problem does not sound like you are doing this (or
> at least not intentionally) but you might check it out.
> Do you backup to multiple files or do you use single file backups? SQL
> Server 2000 had a problem restoring multi-file backups, but that was fixed
> in 2000 and should be working fine in SQL Server 2005.
> RLF
> "Gloria" <Gloria@.discussions.microsoft.com> wrote in message
> news:E51D26A7-88C0-4580-9722-40D84E17B6E9@.microsoft.com...
>
>

error: Too many arguments specified

Error:Too Many Arguments Specified
Posted: 03-03-2005 05:03 AM
Hi,
I'm pretty new to ASP.NET so I'm having some problems
I'm trying to insert a users registration info into the DB using a Stored
Proc but for some reason it won't work
When i run the Sproc in query analyser it seems to be ok with it but when i
run the asp pages it lets me enter the info then when i submit it gives me
the Too many Arguments Specified error
here's the code for the proc
CREATE PROCEDURE [dbo].[Toregister]
(
@.firstname varchar(20),
@.lastname varchar(20),
@.address varchar(20),
@.town varchar(20),
@.county varchar(20),
@.postcode varchar(10),
@.telno varchar(10),
@.email varchar(20),
@.username varchar(20),
@.password varchar(20)
)
AS
insert into t_user
(firstname,lastname,address,town,county,
postcode,telno,email,username,passwo
rd)
values
(@.firstname,@.lastname,@.address,@.town,@.co
unty,@.postcode,@.telno,@.email,@.userna
me,@.password)
GO
and here's the code in my aspx file for adding the parameters
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Save.Click
SqlCommand1.Parameters.Add("@.firstname", txtFirstname.Text)
SqlCommand1.Parameters.Add("@.lastname", txtSurname.Text)
SqlCommand1.Parameters.Add("@.address", txtAddress.Text)
SqlCommand1.Parameters.Add("@.town", txtTown.Text)
SqlCommand1.Parameters.Add("@.county", txtCounty.Text)
SqlCommand1.Parameters.Add("@.postcode", txtPostcode.Text)
SqlCommand1.Parameters.Add("@.telno", txtTelno.Text)
SqlCommand1.Parameters.Add("@.email", txtEmail.Text)
SqlCommand1.Parameters.Add("@.username", txtUsername.Text)
SqlCommand1.Parameters.Add("@.password", txtPassword.Text)
SqlConnection1.Open()
SqlCommand1.ExecuteNonQuery()
End Sub
and just for good measure here's the result from the DB profiler when I run
the asp
exec [Toregister] @.firstname = default, @.lastname = default, @.address =
default, @.town = default, @.county = default, @.postcode = default, @.telno =
default, @.email = default, @.username = default, @.password = default,
@.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street, @.town
= N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd', @.telno =
N'01234567890, @.email = N'neil_pat@.email.com', @.username = N'neilpat',
@.password = N'neil'
I really can't see where this is going wrong
Anny suggestions welcomeMaybe the parameters already exist in the SqlParameterCollection (Look at
where SqlCommand1 is created).
Have you tried... (Warning I am not a .net programmer so my syntax may be
off).
SqlCommand1.Parameters("@.firstname").Value = txtFirstname.Text
SqlCommand1.Parameters("@.lastname").Value = txtSurname.Text
SqlCommand1.Parameters("@.address").Value = txtAddress.Text
SqlCommand1.Parameters("@.town").Value = txtTown.Text
SqlCommand1.Parameters("@.county").Value = txtCounty.Text
SqlCommand1.Parameters("@.postcode").Value = txtPostcode.Text
SqlCommand1.Parameters("@.telno").Value = txtTelno.Text
SqlCommand1.Parameters("@.email").Value = txtEmail.Text
SqlCommand1.Parameters("@.username").Value = txtUsername.Text
SqlCommand1.Parameters("@.password").Value = txtPassword.Text
"neil_pat" wrote:

> Error:Too Many Arguments Specified
> Posted: 03-03-2005 05:03 AM
> Hi,
> I'm pretty new to ASP.NET so I'm having some problems
> I'm trying to insert a users registration info into the DB using a Stored
> Proc but for some reason it won't work
> When i run the Sproc in query analyser it seems to be ok with it but when
i
> run the asp pages it lets me enter the info then when i submit it gives me
> the Too many Arguments Specified error
> here's the code for the proc
> CREATE PROCEDURE [dbo].[Toregister]
> (
> @.firstname varchar(20),
> @.lastname varchar(20),
> @.address varchar(20),
> @.town varchar(20),
> @.county varchar(20),
> @.postcode varchar(10),
> @.telno varchar(10),
> @.email varchar(20),
> @.username varchar(20),
> @.password varchar(20)
> )
> AS
> insert into t_user
> (firstname,lastname,address,town,county,
postcode,telno,email,username,pass
word)
> values
> (@.firstname,@.lastname,@.address,@.town,@.co
unty,@.postcode,@.telno,@.email,@.user
name,@.password)
> GO
> and here's the code in my aspx file for adding the parameters
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Save.Click
>
> SqlCommand1.Parameters.Add("@.firstname", txtFirstname.Text)
> SqlCommand1.Parameters.Add("@.lastname", txtSurname.Text)
> SqlCommand1.Parameters.Add("@.address", txtAddress.Text)
> SqlCommand1.Parameters.Add("@.town", txtTown.Text)
> SqlCommand1.Parameters.Add("@.county", txtCounty.Text)
> SqlCommand1.Parameters.Add("@.postcode", txtPostcode.Text)
> SqlCommand1.Parameters.Add("@.telno", txtTelno.Text)
> SqlCommand1.Parameters.Add("@.email", txtEmail.Text)
> SqlCommand1.Parameters.Add("@.username", txtUsername.Text)
> SqlCommand1.Parameters.Add("@.password", txtPassword.Text)
> SqlConnection1.Open()
> SqlCommand1.ExecuteNonQuery()
> End Sub
>
> and just for good measure here's the result from the DB profiler when I ru
n
> the asp
> exec [Toregister] @.firstname = default, @.lastname = default, @.address =
> default, @.town = default, @.county = default, @.postcode = default, @.telno =
> default, @.email = default, @.username = default, @.password = default,
> @.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street, @.to
wn
> = N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd', @.telno =
> N'01234567890, @.email = N'neil_pat@.email.com', @.username = N'neilpat',
> @.password = N'neil'
> I really can't see where this is going wrong
> Anny suggestions welcome
>

error: too many arguments specified

Error:Too Many Arguments Specified
Posted: 03-03-2005 05:03 AM
Hi,
I'm pretty new to ASP.NET so I'm having some problems
I'm trying to insert a users registration info into the DB using a Stored
Proc but for some reason it won't work
When i run the Sproc in query analyser it seems to be ok with it but when i
run the asp pages it lets me enter the info then when i submit it gives me
the Too many Arguments Specified error
here's the code for the proc
CREATE PROCEDURE [dbo].[Toregister]
(
@.firstname varchar(20),
@.lastname varchar(20),
@.address varchar(20),
@.town varchar(20),
@.county varchar(20),
@.postcode varchar(10),
@.telno varchar(10),
@.email varchar(20),
@.username varchar(20),
@.password varchar(20)
)
AS
insert into t_user
(firstname,lastname,address,town,county,
postcode,telno,email,username,passwo
rd)
values
(@.firstname,@.lastname,@.address,@.town,@.co
unty,@.postcode,@.telno,@.email,@.userna
me,@.password)
GO
and here's the code in my aspx file for adding the parameters
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Save.Click
SqlCommand1.Parameters.Add("@.firstname", txtFirstname.Text)
SqlCommand1.Parameters.Add("@.lastname", txtSurname.Text)
SqlCommand1.Parameters.Add("@.address", txtAddress.Text)
SqlCommand1.Parameters.Add("@.town", txtTown.Text)
SqlCommand1.Parameters.Add("@.county", txtCounty.Text)
SqlCommand1.Parameters.Add("@.postcode", txtPostcode.Text)
SqlCommand1.Parameters.Add("@.telno", txtTelno.Text)
SqlCommand1.Parameters.Add("@.email", txtEmail.Text)
SqlCommand1.Parameters.Add("@.username", txtUsername.Text)
SqlCommand1.Parameters.Add("@.password", txtPassword.Text)
SqlConnection1.Open()
SqlCommand1.ExecuteNonQuery()
End Sub
and just for good measure here's the result from the DB profiler when I run
the asp
exec [Toregister] @.firstname = default, @.lastname = default, @.address =
default, @.town = default, @.county = default, @.postcode = default, @.telno =
default, @.email = default, @.username = default, @.password = default,
@.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street, @.town
= N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd', @.telno =
N'01234567890, @.email = N'neil_pat@.email.com', @.username = N'neilpat',
@.password = N'neil'
I really can't see where this is going wrong
Anny suggestions welcomeActually there are only 10 parameters to be passed.
exec [Toregister] @.firstname = default, @.lastname = default, @.address =
default, @.town = default, @.county = default, @.postcode = default,
@.telno
= default, @.email = default, @.username = default, @.password = default,
@.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street,
@.town = N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd',
@.telno = N'01234567890, @.email = N'neil_...@.email.com', @.username =
N'neilpat', @.password = N'neil'
You passed more than 10
Madhivanan|||Look at the profiler trace. It is passing all the parameters as default
folowed by all the parameters with values - hence 20 parameters instead of 1
0.
I suspect when you build the command you are getting the parameters for the
sp then adding them again.
"neil_pat" wrote:

> Error:Too Many Arguments Specified
> Posted: 03-03-2005 05:03 AM
> Hi,
> I'm pretty new to ASP.NET so I'm having some problems
> I'm trying to insert a users registration info into the DB using a Stored
> Proc but for some reason it won't work
> When i run the Sproc in query analyser it seems to be ok with it but when
i
> run the asp pages it lets me enter the info then when i submit it gives me
> the Too many Arguments Specified error
> here's the code for the proc
> CREATE PROCEDURE [dbo].[Toregister]
> (
> @.firstname varchar(20),
> @.lastname varchar(20),
> @.address varchar(20),
> @.town varchar(20),
> @.county varchar(20),
> @.postcode varchar(10),
> @.telno varchar(10),
> @.email varchar(20),
> @.username varchar(20),
> @.password varchar(20)
> )
> AS
> insert into t_user
> (firstname,lastname,address,town,county,
postcode,telno,email,username,pass
word)
> values
> (@.firstname,@.lastname,@.address,@.town,@.co
unty,@.postcode,@.telno,@.email,@.user
name,@.password)
> GO
> and here's the code in my aspx file for adding the parameters
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Save.Click
>
> SqlCommand1.Parameters.Add("@.firstname", txtFirstname.Text)
> SqlCommand1.Parameters.Add("@.lastname", txtSurname.Text)
> SqlCommand1.Parameters.Add("@.address", txtAddress.Text)
> SqlCommand1.Parameters.Add("@.town", txtTown.Text)
> SqlCommand1.Parameters.Add("@.county", txtCounty.Text)
> SqlCommand1.Parameters.Add("@.postcode", txtPostcode.Text)
> SqlCommand1.Parameters.Add("@.telno", txtTelno.Text)
> SqlCommand1.Parameters.Add("@.email", txtEmail.Text)
> SqlCommand1.Parameters.Add("@.username", txtUsername.Text)
> SqlCommand1.Parameters.Add("@.password", txtPassword.Text)
> SqlConnection1.Open()
> SqlCommand1.ExecuteNonQuery()
> End Sub
>
> and just for good measure here's the result from the DB profiler when I ru
n
> the asp
> exec [Toregister] @.firstname = default, @.lastname = default, @.address =
> default, @.town = default, @.county = default, @.postcode = default, @.telno =
> default, @.email = default, @.username = default, @.password = default,
> @.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street, @.to
wn
> = N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd', @.telno =
> N'01234567890, @.email = N'neil_pat@.email.com', @.username = N'neilpat',
> @.password = N'neil'
> I really can't see where this is going wrong
> Anny suggestions welcome
>|||Could you just explain that? iDo you mean that its counting each one
seprately i.e. 20 instead of 10?
How do i rectify this?
"Madhivanan" wrote:

> Actually there are only 10 parameters to be passed.
> exec [Toregister] @.firstname = default, @.lastname = default, @.address =
> default, @.town = default, @.county = default, @.postcode = default,
> @.telno
> = default, @.email = default, @.username = default, @.password = default,
> @.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street,
> @.town = N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd',
> @.telno = N'01234567890, @.email = N'neil_...@.email.com', @.username =
> N'neilpat', @.password = N'neil'
> You passed more than 10
> Madhivanan
>|||Sorry I'm a bit of a beginer.
Which bit of my code do i need to edit to stop this?
"Nigel Rivett" wrote:
> Look at the profiler trace. It is passing all the parameters as default
> folowed by all the parameters with values - hence 20 parameters instead of
10.
> I suspect when you build the command you are getting the parameters for th
e
> sp then adding them again.
> "neil_pat" wrote:
>|||Have a look at
http://www.mindsdoor.net/DOTNET/DotNetDBAccess.html
It gives a database access layer and includes creation of all the objects.
I suspect you are binding sqlcommand1 to the sp before adding the parameters
.
"neil_pat" wrote:
> Sorry I'm a bit of a beginer.
> Which bit of my code do i need to edit to stop this?
> "Nigel Rivett" wrote:
>|||Remove all the fields with default values
Madhivanan|||I managed to sort it out now.
VS.net was adding default parameters automatically which i removed and it
works fine now
Thanks
"neil_pat" wrote:

> Error:Too Many Arguments Specified
> Posted: 03-03-2005 05:03 AM
> Hi,
> I'm pretty new to ASP.NET so I'm having some problems
> I'm trying to insert a users registration info into the DB using a Stored
> Proc but for some reason it won't work
> When i run the Sproc in query analyser it seems to be ok with it but when
i
> run the asp pages it lets me enter the info then when i submit it gives me
> the Too many Arguments Specified error
> here's the code for the proc
> CREATE PROCEDURE [dbo].[Toregister]
> (
> @.firstname varchar(20),
> @.lastname varchar(20),
> @.address varchar(20),
> @.town varchar(20),
> @.county varchar(20),
> @.postcode varchar(10),
> @.telno varchar(10),
> @.email varchar(20),
> @.username varchar(20),
> @.password varchar(20)
> )
> AS
> insert into t_user
> (firstname,lastname,address,town,county,
postcode,telno,email,username,pass
word)
> values
> (@.firstname,@.lastname,@.address,@.town,@.co
unty,@.postcode,@.telno,@.email,@.user
name,@.password)
> GO
> and here's the code in my aspx file for adding the parameters
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Save.Click
>
> SqlCommand1.Parameters.Add("@.firstname", txtFirstname.Text)
> SqlCommand1.Parameters.Add("@.lastname", txtSurname.Text)
> SqlCommand1.Parameters.Add("@.address", txtAddress.Text)
> SqlCommand1.Parameters.Add("@.town", txtTown.Text)
> SqlCommand1.Parameters.Add("@.county", txtCounty.Text)
> SqlCommand1.Parameters.Add("@.postcode", txtPostcode.Text)
> SqlCommand1.Parameters.Add("@.telno", txtTelno.Text)
> SqlCommand1.Parameters.Add("@.email", txtEmail.Text)
> SqlCommand1.Parameters.Add("@.username", txtUsername.Text)
> SqlCommand1.Parameters.Add("@.password", txtPassword.Text)
> SqlConnection1.Open()
> SqlCommand1.ExecuteNonQuery()
> End Sub
>
> and just for good measure here's the result from the DB profiler when I ru
n
> the asp
> exec [Toregister] @.firstname = default, @.lastname = default, @.address =
> default, @.town = default, @.county = default, @.postcode = default, @.telno =
> default, @.email = default, @.username = default, @.password = default,
> @.firstname = N'Neil', @.lastname = N'Patel', @.address = N'28 my street, @.to
wn
> = N'mytown', @.county = N'mycounty', @.postcode = N'mypostcd', @.telno =
> N'01234567890, @.email = N'neil_pat@.email.com', @.username = N'neilpat',
> @.password = N'neil'
> I really can't see where this is going wrong
> Anny suggestions welcome
>|||I've sorted it now
VS.Net was adding default parameters automatically. I've removed them and it
works fine now
"Nigel Rivett" wrote:
> Have a look at
> http://www.mindsdoor.net/DOTNET/DotNetDBAccess.html
> It gives a database access layer and includes creation of all the objects.
> I suspect you are binding sqlcommand1 to the sp before adding the paramete
rs.
> "neil_pat" wrote:
>

Error: The sort order specified for distinct count records is incorrect

When processing a measure group with a distinct count measure in it, i get the following error:

"The sort order specified for distinct count records is incorrect."

I have no idea what this means - any ideas?

whoops - looks like there's some info here:

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

Wednesday, February 15, 2012

ERROR: Subreport cannot be shown

Hi,

I have a report (rdlc) which has a subreport. I have specified which report to use as my subreport. I created a dataset to pull all data from two tables. One table goes with the main report, the other goes with the subreport. I then created two sqldatasources and configured the first one to pull the data using parameter to fill the main report then configured the other to do the same for the subreport. I then configured my report to work in those two datasource instances. Then when I run my report I get ERROR: Subreport cannot be shown. But my main report section works fine. Also, if I change the report to just use my report that is the subreport, it works fine. I just can't get it to work as a subreport! PLEASE HELP! I am going insane!

I had the same problem, and found a solution. It appears that even if the parameters are named the same, the subreport will not get its parameter value set unless you connect it to the parameter that the main report is using.

Open the main report|||

I had the same problem, and found a solution. It appears that even if the parameters are named the same, the subreport will not get its parameter value set unless you connect it to the parameter that the main report is using.

Open the main report|||Thanks!|||

Hi Billy,

I have done the same thing as mentioned by you. But I am still not able to view the report. The main report goes in some loop. If I run main report & subreport separately then it is running perfectly fine. I have the same list of parameters for the main report as well as for the subreport.

Do I need to do something else besides this? Appreciate your help.

Thanks

Hitesh

|||

Hi, there

I got the same error with you. Just wonder did u solve your problem? I just sent your an email.

contact me atste_chen@.yahoo.com

thanks a lot !

steven

|||

Having the same parameter names will not cause the data to flow from the parent report to the sub report. Did you go through the bullet points above and map the parameter values from the parent report to the child report?

|||

You may need to handle the OnSubreportProcessing event in your code. Build a dataset of the table you want to use and add it to the SubreportProcessingEventArgs of the local report.

Private Sub ReportViewer_SubreportProcessing(ByVal senderAs Object,ByVal eAs SubreportProcessingEventArgs)Dim SubRptConnAs New SqlConnection("Connection string")Dim SubRptSqlCmdTextAs String ="SELECT * FROM Table;"Dim SubRptSqlCmdAs New SqlCommand(SubRptSqlCmdText, SubRptConn)Dim SubRptSqlDAAs New SqlDataAdapter(SubRptSqlCmd)Dim SubRptSqlDSAs New DataSet SubRptConn.Open()SubRptSqlDA.Fill(SubRptSqlDS)SubRptConn.Close()Dim SubRptDSAs New ReportDataSource("Activities_V_LINCS_ItenEventsDetail", SubRptSqlDS.Tables(0))e.DataSources.Add(SubRptDS)End Sub
|||

Has anyone figured this out?

I have my main report and my subreport with a parameter called X. Then on my sub report viewer control thing you place on the main report I have set the parameter to the same name and set the value to be the main report parameters (parameters!x.value).

This last post had a code regarding ReportViewer_SubreportProcessing, where does this go? My sub report is already bound to a table adapter.
Please help this is driving me nuts. I get the report could not be shown error.
Thanks.
-S

|||

I Have The Same Errot The SubreportProcessingEventHandler is fired up and the query Runs O.K. But The Sub Report Isn't Shown up ,

i Think It's Because in The local Report Mode the main report page doesnt refresh it self