Hi all,
I'm having a problem with accessing a report.
When I test it on my machine (2000 & reporting services installed on same
machine) there's no problem. As soon as I try to access it vie the internet
(I route through no-ip.org) then a window pops up wanting authentication. I
want to do away with this please.
How do I do this so no prompting occurs?
Regards
John.The authentication for a data source can be different for the dev env than
the production env... Go to the data source in the Prod env, and ensure
that something OTHER than prompt for credentials is set for the data
source...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <a@.b.c> wrote in message
news:%23iJ6eE7XFHA.2768@.tk2msftngp13.phx.gbl...
> Hi all,
> I'm having a problem with accessing a report.
> When I test it on my machine (2000 & reporting services installed on same
> machine) there's no problem. As soon as I try to access it vie the
> internet (I route through no-ip.org) then a window pops up wanting
> authentication. I want to do away with this please.
> How do I do this so no prompting occurs?
> Regards
> John.
>
Showing posts with label net. Show all posts
Showing posts with label net. Show all posts
Monday, March 26, 2012
problem with aspnet_wp.exe
Hi! Just deployed an asp.net application.But we are
experiencing slowdown due to aspnet+wp.exe eating up more
than 50% cpu. What should I do?! Please help! Thanks!
Is the 50% constant? Or does it just occasionally spike to 50%?
What operations are going on when it hits 50%?
Have you checked .NET code to ensure that you don't have problems there?
How are you accessing SQL Server? How much data are you pulling back from
SQL Server?
etc. etc.
Rick Sawtell
MCT, MCSD, MCDBA
"miranda" <anonymous@.discussions.microsoft.com> wrote in message
news:a3e001c4878b$a2530450$a501280a@.phx.gbl...
> Hi! Just deployed an asp.net application.But we are
> experiencing slowdown due to aspnet+wp.exe eating up more
> than 50% cpu. What should I do?! Please help! Thanks!
experiencing slowdown due to aspnet+wp.exe eating up more
than 50% cpu. What should I do?! Please help! Thanks!
Is the 50% constant? Or does it just occasionally spike to 50%?
What operations are going on when it hits 50%?
Have you checked .NET code to ensure that you don't have problems there?
How are you accessing SQL Server? How much data are you pulling back from
SQL Server?
etc. etc.
Rick Sawtell
MCT, MCSD, MCDBA
"miranda" <anonymous@.discussions.microsoft.com> wrote in message
news:a3e001c4878b$a2530450$a501280a@.phx.gbl...
> Hi! Just deployed an asp.net application.But we are
> experiencing slowdown due to aspnet+wp.exe eating up more
> than 50% cpu. What should I do?! Please help! Thanks!
problem with aspnet_wp.exe
Hi! Just deployed an asp.net application.But we are
experiencing slowdown due to aspnet+wp.exe eating up more
than 50% cpu. What should I do?! Please help! Thanks!Is the 50% constant? Or does it just occasionally spike to 50%?
What operations are going on when it hits 50%?
Have you checked .NET code to ensure that you don't have problems there?
How are you accessing SQL Server? How much data are you pulling back from
SQL Server?
etc. etc.
Rick Sawtell
MCT, MCSD, MCDBA
"miranda" <anonymous@.discussions.microsoft.com> wrote in message
news:a3e001c4878b$a2530450$a501280a@.phx.gbl...
> Hi! Just deployed an asp.net application.But we are
> experiencing slowdown due to aspnet+wp.exe eating up more
> than 50% cpu. What should I do?! Please help! Thanks!
experiencing slowdown due to aspnet+wp.exe eating up more
than 50% cpu. What should I do?! Please help! Thanks!Is the 50% constant? Or does it just occasionally spike to 50%?
What operations are going on when it hits 50%?
Have you checked .NET code to ensure that you don't have problems there?
How are you accessing SQL Server? How much data are you pulling back from
SQL Server?
etc. etc.
Rick Sawtell
MCT, MCSD, MCDBA
"miranda" <anonymous@.discussions.microsoft.com> wrote in message
news:a3e001c4878b$a2530450$a501280a@.phx.gbl...
> Hi! Just deployed an asp.net application.But we are
> experiencing slowdown due to aspnet+wp.exe eating up more
> than 50% cpu. What should I do?! Please help! Thanks!
problem with aspnet_wp.exe
Hi! Just deployed an asp.net application.But we are
experiencing slowdown due to aspnet+wp.exe eating up more
than 50% cpu. What should I do?! Please help! Thanks!Is the 50% constant? Or does it just occasionally spike to 50%?
What operations are going on when it hits 50%?
Have you checked .NET code to ensure that you don't have problems there?
How are you accessing SQL Server? How much data are you pulling back from
SQL Server?
etc. etc.
Rick Sawtell
MCT, MCSD, MCDBA
"miranda" <anonymous@.discussions.microsoft.com> wrote in message
news:a3e001c4878b$a2530450$a501280a@.phx.gbl...
> Hi! Just deployed an asp.net application.But we are
> experiencing slowdown due to aspnet+wp.exe eating up more
> than 50% cpu. What should I do?! Please help! Thanks!
experiencing slowdown due to aspnet+wp.exe eating up more
than 50% cpu. What should I do?! Please help! Thanks!Is the 50% constant? Or does it just occasionally spike to 50%?
What operations are going on when it hits 50%?
Have you checked .NET code to ensure that you don't have problems there?
How are you accessing SQL Server? How much data are you pulling back from
SQL Server?
etc. etc.
Rick Sawtell
MCT, MCSD, MCDBA
"miranda" <anonymous@.discussions.microsoft.com> wrote in message
news:a3e001c4878b$a2530450$a501280a@.phx.gbl...
> Hi! Just deployed an asp.net application.But we are
> experiencing slowdown due to aspnet+wp.exe eating up more
> than 50% cpu. What should I do?! Please help! Thanks!
problem with aspnet_ "Could not find stored procedure"
I have developed an asp.net 2.0 web application that uses sql2000 and with storded procedures.
Everything has been working great untill i yesterday found that someone have put in new stored procedures
in the database. The procedures starts with "dbo.aspnet_" like dbo.aspnet_CheckSchemaVersion.
Because i din't create them and i surtenly not call them from the application, i deleted them all.
Now when i try to use my web application nothing works. The app, somehow calls the procedure and becuase they are deleted
an error message is thrown like: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
But the strange thing is that the problem only accure when i publish the site on the web server.
if i would publish it to a local folder on my desktop ore just run in debug mode against the database there are no problems.
I don't want to use the aspnet procedures that probebly comes from aspnet_regsql.exe and that im not calling from the code but reacts somehow,
I just want it to tun as it was designed to do.
And if i need them, can someone explain why?
please help :)
Dude, the "aspnet_" stuff is from Microsoft... it's the Membership provider. To get it back run "aspnet_regsql' in c:\windows\microsoft.net\framework\v2.blah (or wherever your windows files are).
|||Yo Dude :) I did what you said and of course it worked. But i don't know why aspnet_regsql.exe is suddenly needed and all of those procedures that comes along. It worked without it before.
thx :)
sqlFriday, March 23, 2012
Problem With Adding a Date Field to a Database When It is Null
I am having problems adding a date field to a SQL Server Database from a form in ASP.Net. When I leave the date field blank, it automatically inserts Monday, January 01, 1900. I want it to be null when the expiration date is left blank. Can someone please help me with this?
Here's my code for adding information from the table to the database:
'--------------
' name: Button_Click()
'--------------
Sub Button_Click( s As Object, e As EventArgs )
Dim strConnect As String
Dim objConnect As SQLConnection
Dim strInsert As String
Dim cmdInsert As SqlCommand
'Get connection string from Web.Config
strConnect = ConfigurationSettings.AppSettings("ConnectionString")
objConnect = New SqlConnection(strConnect)
strInsert = "Insert DomainName (ClientID, DomainName, Registrar, ExpirationDate ) Values ( @.ClientID, @.DomainName, @.Registrar, @.ExpirationDate )"
cmdInsert = New SqlCommand( strInsert, objConnect)
cmdInsert.Parameters.Add( "@.ClientID", dropClient.SelectedItem.Value )
cmdInsert.Parameters.Add( "@.DomainName", txtDomainName.Text )
cmdInsert.Parameters.Add( "@.Registrar", txtRegistrar.Text )
cmdInsert.Parameters.Add( "@.ExpirationDate", txtExpirationDate.Text )
objConnect.Open()
cmdINsert.ExecuteNonQuery()
objConnect.Close()
'Display the results "page"
DisplayResults()
End Sub
Here's the code for the form:
<form id="frmDomainNames" method="post" runat="server" onSubmit="return InputIsValid()">
<div align="center">
<table border="0" cellpadding="2" cellspacing="2" width="50%" bgcolor="#330099">
<tr>
<td height="37" colspan="2" align="center" valign="middle" bgcolor="#330099"><font color="white" size="5">Domain Name Information</font></td>
<td> </td>
</tr>
<tr>
<td height="42" align="right" valign="top" bgcolor="#e8e8e8"><font face="MS Sans Serif, Arial" size="2" color="#000000"><strong><nobr>
Client's Name:</nobr></strong></font></td>
<td colspan="2" valign="top" bgcolor="#e8e8e8">
<p>
<asp:dropdownlist id="dropClient" runat="server" />
</p>
</td>
</tr>
<tr>
<td height="42" align="right" valign="top" bgcolor="#e8e8e8"><font face="MS Sans Serif, Arial" size="2" color="#000000"><strong><nobr>
Domain Name:</nobr></strong></font></td>
<td colspan="2" valign="top" bgcolor="#e8e8e8">
<p>
<ASP:TextBox id="txtDomainName" runat="server" TextMode="SingleLine" Columns="30" />
</p>
</td>
<tr>
<td height="42" align="right" valign="top" bgcolor="#e8e8e8"><font face="MS Sans Serif, Arial" size="2" color="#000000"><strong><nobr>
Registrar:</nobr></strong></font></td>
<td colspan="2" valign="top" bgcolor="#e8e8e8">
<p>
<ASP:TextBox id="txtRegistrar" runat="server" TextMode="SingleLine" Columns="30" />
</p>
</td>
</tr>
<tr>
<td height="42" align="right" valign="top" bgcolor="#e8e8e8"><font face="MS Sans Serif, Arial" size="2" color="#000000"><strong><nobr>
Expiration Date:</nobr></strong></font></td>
<td colspan="2" valign="top" bgcolor="#e8e8e8">
<p>
<ASP:TextBox id="txtExpirationDate" runat="server" TextMode="SingleLine" Columns="10" />
</p>
</td>
</tr>
<TR>
<TD>
</TD>
<TD align="center">
<asp:Button
Text="Submit"
OnClick="Button_Click"
Runat="Server" />
</TD>
</TR>
</table>
</form>
</div>
cmdInsert.Parameters.Add( "@.ExpirationDate", txtExpirationDate.Text )
to
cmdInsert.Parameters.Add( "@.ExpirationDate", iif(txtExpirationDate.Text="",dbNull.value,txtExpirationDate.text))
Nick
Wednesday, March 21, 2012
Problem with 64-bit ODBC code and SQLConnect and SQLWCHAR
Hi all,
I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
problem. First, my configuration.
Windows XP x64
VS.Net 2005 Beta 2
SQL Server 2005 CTP
So, I have built and tested other 64 bit apps so I know that things are all
working, but now I'm trying to test ODBC and I'm running into a problem. I
have the following code :
SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
SQLCHAR User[MAXBUFLEN]; // = "fred";
SQLCHAR Pass[MAXBUFLEN]; // = "me";
sprintf ((char *)Database, "%s", "Cloud");
sprintf ((char *)User, "%s", "fred");
sprintf ((char *)Pass, "%s", "me");
retcode = SQLConnect(hdbc1, Database, SQL_NTS,
User, SQL_NTS, Pass, SQL_NTS);
If I execute this code as part of a little test program on my 32 bit box, it
connects just fine. Now, to get this code to compile on the 64-bit box, I
have to cast the string variable with (SQLWCHAR *) like this.
retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
(SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
So it compiles, but when I run it, I get an error back. If I take a look
at what (SQLWCHAR *)Database produces, its some unreadable junk. If I turn
on ODBC logging and then after the SQLConnect call take a look at the log,
where I should see the database for instance, I see just random characters.
So, what gives ? Do I have to do something special when working with
SQLWCHAR ?
Thanks for any help anyone can give me.
Nick
Hi
SQL Server 2005 CTP questions to the community newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nick Palmer" <nick@.kcicorp.com> wrote in message
news:11i480ff7qiikf9@.corp.supernews.com...
> Hi all,
> I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
> problem. First, my configuration.
> Windows XP x64
> VS.Net 2005 Beta 2
> SQL Server 2005 CTP
> So, I have built and tested other 64 bit apps so I know that things are
> all
> working, but now I'm trying to test ODBC and I'm running into a problem.
> I
> have the following code :
> SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
> SQLCHAR User[MAXBUFLEN]; // = "fred";
> SQLCHAR Pass[MAXBUFLEN]; // = "me";
> sprintf ((char *)Database, "%s", "Cloud");
> sprintf ((char *)User, "%s", "fred");
> sprintf ((char *)Pass, "%s", "me");
> retcode = SQLConnect(hdbc1, Database, SQL_NTS,
> User, SQL_NTS, Pass, SQL_NTS);
> If I execute this code as part of a little test program on my 32 bit box,
> it
> connects just fine. Now, to get this code to compile on the 64-bit box, I
> have to cast the string variable with (SQLWCHAR *) like this.
> retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
> (SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
> So it compiles, but when I run it, I get an error back. If I take a look
> at what (SQLWCHAR *)Database produces, its some unreadable junk. If I
> turn
> on ODBC logging and then after the SQLConnect call take a look at the log,
> where I should see the database for instance, I see just random
> characters.
> So, what gives ? Do I have to do something special when working with
> SQLWCHAR ?
> Thanks for any help anyone can give me.
> Nick
>
I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
problem. First, my configuration.
Windows XP x64
VS.Net 2005 Beta 2
SQL Server 2005 CTP
So, I have built and tested other 64 bit apps so I know that things are all
working, but now I'm trying to test ODBC and I'm running into a problem. I
have the following code :
SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
SQLCHAR User[MAXBUFLEN]; // = "fred";
SQLCHAR Pass[MAXBUFLEN]; // = "me";
sprintf ((char *)Database, "%s", "Cloud");
sprintf ((char *)User, "%s", "fred");
sprintf ((char *)Pass, "%s", "me");
retcode = SQLConnect(hdbc1, Database, SQL_NTS,
User, SQL_NTS, Pass, SQL_NTS);
If I execute this code as part of a little test program on my 32 bit box, it
connects just fine. Now, to get this code to compile on the 64-bit box, I
have to cast the string variable with (SQLWCHAR *) like this.
retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
(SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
So it compiles, but when I run it, I get an error back. If I take a look
at what (SQLWCHAR *)Database produces, its some unreadable junk. If I turn
on ODBC logging and then after the SQLConnect call take a look at the log,
where I should see the database for instance, I see just random characters.
So, what gives ? Do I have to do something special when working with
SQLWCHAR ?
Thanks for any help anyone can give me.
Nick
Hi
SQL Server 2005 CTP questions to the community newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nick Palmer" <nick@.kcicorp.com> wrote in message
news:11i480ff7qiikf9@.corp.supernews.com...
> Hi all,
> I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
> problem. First, my configuration.
> Windows XP x64
> VS.Net 2005 Beta 2
> SQL Server 2005 CTP
> So, I have built and tested other 64 bit apps so I know that things are
> all
> working, but now I'm trying to test ODBC and I'm running into a problem.
> I
> have the following code :
> SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
> SQLCHAR User[MAXBUFLEN]; // = "fred";
> SQLCHAR Pass[MAXBUFLEN]; // = "me";
> sprintf ((char *)Database, "%s", "Cloud");
> sprintf ((char *)User, "%s", "fred");
> sprintf ((char *)Pass, "%s", "me");
> retcode = SQLConnect(hdbc1, Database, SQL_NTS,
> User, SQL_NTS, Pass, SQL_NTS);
> If I execute this code as part of a little test program on my 32 bit box,
> it
> connects just fine. Now, to get this code to compile on the 64-bit box, I
> have to cast the string variable with (SQLWCHAR *) like this.
> retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
> (SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
> So it compiles, but when I run it, I get an error back. If I take a look
> at what (SQLWCHAR *)Database produces, its some unreadable junk. If I
> turn
> on ODBC logging and then after the SQLConnect call take a look at the log,
> where I should see the database for instance, I see just random
> characters.
> So, what gives ? Do I have to do something special when working with
> SQLWCHAR ?
> Thanks for any help anyone can give me.
> Nick
>
Problem with 64-bit ODBC code and SQLConnect and SQLWCHAR
Hi all,
I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
problem. First, my configuration.
Windows XP x64
VS.Net 2005 Beta 2
SQL Server 2005 CTP
So, I have built and tested other 64 bit apps so I know that things are all
working, but now I'm trying to test ODBC and I'm running into a problem. I
have the following code :
SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
SQLCHAR User[MAXBUFLEN]; // = "fred";
SQLCHAR Pass[MAXBUFLEN]; // = "me";
sprintf ((char *)Database, "%s", "Cloud");
sprintf ((char *)User, "%s", "fred");
sprintf ((char *)Pass, "%s", "me");
retcode = SQLConnect(hdbc1, Database, SQL_NTS,
User, SQL_NTS, Pass, SQL_NTS);
If I execute this code as part of a little test program on my 32 bit box, it
connects just fine. Now, to get this code to compile on the 64-bit box, I
have to cast the string variable with (SQLWCHAR *) like this.
retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
(SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
So it compiles, but when I run it, I get an error back. If I take a look
at what (SQLWCHAR *)Database produces, its some unreadable junk. If I turn
on ODBC logging and then after the SQLConnect call take a look at the log,
where I should see the database for instance, I see just random characters.
So, what gives ? Do I have to do something special when working with
SQLWCHAR ?
Thanks for any help anyone can give me.
NickHi
SQL Server 2005 CTP questions to the community newsgroups:
http://communities.microsoft.com/ne...lcid=us
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nick Palmer" <nick@.kcicorp.com> wrote in message
news:11i480ff7qiikf9@.corp.supernews.com...
> Hi all,
> I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
> problem. First, my configuration.
> Windows XP x64
> VS.Net 2005 Beta 2
> SQL Server 2005 CTP
> So, I have built and tested other 64 bit apps so I know that things are
> all
> working, but now I'm trying to test ODBC and I'm running into a problem.
> I
> have the following code :
> SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
> SQLCHAR User[MAXBUFLEN]; // = "fred";
> SQLCHAR Pass[MAXBUFLEN]; // = "me";
> sprintf ((char *)Database, "%s", "Cloud");
> sprintf ((char *)User, "%s", "fred");
> sprintf ((char *)Pass, "%s", "me");
> retcode = SQLConnect(hdbc1, Database, SQL_NTS,
> User, SQL_NTS, Pass, SQL_NTS);
> If I execute this code as part of a little test program on my 32 bit box,
> it
> connects just fine. Now, to get this code to compile on the 64-bit box, I
> have to cast the string variable with (SQLWCHAR *) like this.
> retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
> (SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
> So it compiles, but when I run it, I get an error back. If I take a look
> at what (SQLWCHAR *)Database produces, its some unreadable junk. If I
> turn
> on ODBC logging and then after the SQLConnect call take a look at the log,
> where I should see the database for instance, I see just random
> characters.
> So, what gives ? Do I have to do something special when working with
> SQLWCHAR ?
> Thanks for any help anyone can give me.
> Nick
>
I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
problem. First, my configuration.
Windows XP x64
VS.Net 2005 Beta 2
SQL Server 2005 CTP
So, I have built and tested other 64 bit apps so I know that things are all
working, but now I'm trying to test ODBC and I'm running into a problem. I
have the following code :
SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
SQLCHAR User[MAXBUFLEN]; // = "fred";
SQLCHAR Pass[MAXBUFLEN]; // = "me";
sprintf ((char *)Database, "%s", "Cloud");
sprintf ((char *)User, "%s", "fred");
sprintf ((char *)Pass, "%s", "me");
retcode = SQLConnect(hdbc1, Database, SQL_NTS,
User, SQL_NTS, Pass, SQL_NTS);
If I execute this code as part of a little test program on my 32 bit box, it
connects just fine. Now, to get this code to compile on the 64-bit box, I
have to cast the string variable with (SQLWCHAR *) like this.
retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
(SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
So it compiles, but when I run it, I get an error back. If I take a look
at what (SQLWCHAR *)Database produces, its some unreadable junk. If I turn
on ODBC logging and then after the SQLConnect call take a look at the log,
where I should see the database for instance, I see just random characters.
So, what gives ? Do I have to do something special when working with
SQLWCHAR ?
Thanks for any help anyone can give me.
NickHi
SQL Server 2005 CTP questions to the community newsgroups:
http://communities.microsoft.com/ne...lcid=us
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nick Palmer" <nick@.kcicorp.com> wrote in message
news:11i480ff7qiikf9@.corp.supernews.com...
> Hi all,
> I'm trying to test some 64-bit ODBC stuff and I'm running into a slight
> problem. First, my configuration.
> Windows XP x64
> VS.Net 2005 Beta 2
> SQL Server 2005 CTP
> So, I have built and tested other 64 bit apps so I know that things are
> all
> working, but now I'm trying to test ODBC and I'm running into a problem.
> I
> have the following code :
> SQLCHAR Database[MAXBUFLEN]; // = "Cloud";
> SQLCHAR User[MAXBUFLEN]; // = "fred";
> SQLCHAR Pass[MAXBUFLEN]; // = "me";
> sprintf ((char *)Database, "%s", "Cloud");
> sprintf ((char *)User, "%s", "fred");
> sprintf ((char *)Pass, "%s", "me");
> retcode = SQLConnect(hdbc1, Database, SQL_NTS,
> User, SQL_NTS, Pass, SQL_NTS);
> If I execute this code as part of a little test program on my 32 bit box,
> it
> connects just fine. Now, to get this code to compile on the 64-bit box, I
> have to cast the string variable with (SQLWCHAR *) like this.
> retcode = SQLConnect(hdbc1, (SQLWCHAR *)Database, SQL_NTS,
> (SQLWCHAR *)User, SQL_NTS, (SQLWCHAR *)Pass, SQL_NTS);
> So it compiles, but when I run it, I get an error back. If I take a look
> at what (SQLWCHAR *)Database produces, its some unreadable junk. If I
> turn
> on ODBC logging and then after the SQLConnect call take a look at the log,
> where I should see the database for instance, I see just random
> characters.
> So, what gives ? Do I have to do something special when working with
> SQLWCHAR ?
> Thanks for any help anyone can give me.
> Nick
>
Problem with &
Hai
Iam using asp.net 2.0 with sql server 2005 as back end..
i need to pass the data to stored procedure via parameter containg (&) symbol
for ex:
If i pass string like "sample&ss"
it gives the error xml parsing how to avoid this..welcome for your suggestion.
Regards
Senthil
hi,
ampersand doesn't seems to cause an error on Sql server as the statement below
executes succesfully
select 'sample&ss'
I think the error happens in dot net since
where & is an operator such as
a$='xxx'&'yyy'
regards,
joey
|||If the error is in parsing XML try this: "sample&ss"
'&' is a special character in XML, and if you catually want to use it you need to represent it as &
|||Or...use ASCII...it works all the time
sql
Monday, March 12, 2012
Problem while connecting to a remote SQL Server through VS.NET1.1
Hi All..
I am having a problem while connecting to a remote sql server through VS.NET 1.1 , an asp.net application. It says :"SQL Server does not exist or access denied".
I have connected to the same server from my home using the same connection string through an asp.net 1.1 app.. So it cant b a prob with Server permissions. I can connect to the same server frm my office through asp.net2.0 app.. So its got nothing to do with office permissions.
I need this connection from my office from asp.net1.1 app 2 debug n find solution for a bug as im unable to simulate it here.
Will this be smth to do with .net installation, some security enabled in vs.net.. I have no idea.. Please help me at the earliest..
Thanks in advance..
aLLEN
Hi Allen,
First, please try to ping the server to see if you can connect to it. Then check if the SQL Server is the default instance. If not, you will need to add instance name after server name in your connection string.
You can try to use SQL Authentication to connect again. If that still doesn't work, please post your connection string here.
problem while configuring RS using rsconfih utility.
i installed reporting services on the same machine where i insatalled SQl
server. i did some sample reports in visual studio.net 2003. initally when i
try to deploy it,iam getting 'cannot connect to http://localhost/report
server.' one more insteresting thing is when i browse to
http://localhost/reports or reportserver is an stating that ' connot find to
directory /not having permissions.' then i gave some permission set to both
these virtual directory.
and later i try to browse i got a different error --'The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
command its giving an error that 'No Reporting Services instance found on
localhost.'. What to do Next i don't have any choice,can any one susject me
some thing.
----
--
pammiDid your installation succeed? This seems to look like you didn't actually
have a successful installation.
In your SQL Server, do you have a database named reportserver and another
called reportservertempdb?
In your filesystem, do you have files under c:\program files\sql
server\mssql\reporting services?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>i installed reporting services on the same machine where i insatalled SQl
> server. i did some sample reports in visual studio.net 2003. initally when
> i
> try to deploy it,iam getting 'cannot connect to http://localhost/report
> server.' one more insteresting thing is when i browse to
> http://localhost/reports or reportserver is an stating that ' connot find
> to
> directory /not having permissions.' then i gave some permission set to
> both
> these virtual directory.
> and later i try to browse i got a different error --'The report server
> cannot open a connection to the report server database. A connection to
> the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> command its giving an error that 'No Reporting Services instance found on
> localhost.'. What to do Next i don't have any choice,can any one susject
> me
> some thing.
> ----
> --
> pammi|||Lukasz, while installation i don't have problems but when i check it now i
don't have those two databases(reportserver and reportservertempdb) and i
have files under c:\program files\sql
> server\mssql\reporting services. Now what to do i have to reinstall it again. And one more thing i forgot to say is my reporting services is an Evaluation Edition which i down loaded from microsoft site.
"Lukasz Pawlowski [MSFT]" wrote:
> Did your installation succeed? This seems to look like you didn't actually
> have a successful installation.
> In your SQL Server, do you have a database named reportserver and another
> called reportservertempdb?
> In your filesystem, do you have files under c:\program files\sql
> server\mssql\reporting services?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >i installed reporting services on the same machine where i insatalled SQl
> > server. i did some sample reports in visual studio.net 2003. initally when
> > i
> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> > server.' one more insteresting thing is when i browse to
> > http://localhost/reports or reportserver is an stating that ' connot find
> > to
> > directory /not having permissions.' then i gave some permission set to
> > both
> > these virtual directory.
> > and later i try to browse i got a different error --'The report server
> > cannot open a connection to the report server database. A connection to
> > the
> > database is required for all requests and processing.
> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> > command its giving an error that 'No Reporting Services instance found on
> > localhost.'. What to do Next i don't have any choice,can any one susject
> > me
> > some thing.
> >
> > ----
> >
> > --
> > pammi
>
>|||If you do not have the databases, then the report server will not work.
You will need to reinstall reporting services. Ensure that after setup, the
reportserver service is running in the service control manager. Also ensure
you can access the report server on the virtual directory you specified
during setup,e.g. http://localhost/reportserver (default).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> Lukasz, while installation i don't have problems but when i check it now i
> don't have those two databases(reportserver and reportservertempdb) and i
> have files under c:\program files\sql
>> server\mssql\reporting services. Now what to do i have to reinstall it
>> again. And one more thing i forgot to say is my reporting services is an
>> Evaluation Edition which i down loaded from microsoft site.
>
> "Lukasz Pawlowski [MSFT]" wrote:
>> Did your installation succeed? This seems to look like you didn't
>> actually
>> have a successful installation.
>> In your SQL Server, do you have a database named reportserver and another
>> called reportservertempdb?
>> In your filesystem, do you have files under c:\program files\sql
>> server\mssql\reporting services?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
>> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>> >i installed reporting services on the same machine where i insatalled
>> >SQl
>> > server. i did some sample reports in visual studio.net 2003. initally
>> > when
>> > i
>> > try to deploy it,iam getting 'cannot connect to http://localhost/report
>> > server.' one more insteresting thing is when i browse to
>> > http://localhost/reports or reportserver is an stating that ' connot
>> > find
>> > to
>> > directory /not having permissions.' then i gave some permission set to
>> > both
>> > these virtual directory.
>> > and later i try to browse i got a different error --'The report server
>> > cannot open a connection to the report server database. A connection to
>> > the
>> > database is required for all requests and processing.
>> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
>> > user
>> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
>> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
>> > command its giving an error that 'No Reporting Services instance found
>> > on
>> > localhost.'. What to do Next i don't have any choice,can any one
>> > susject
>> > me
>> > some thing.
>> >
>> > ----
>> >
>> > --
>> > pammi
>>|||Thanks Lukasz,
i reistalled it and now its working...
pavan
"Lukasz Pawlowski [MSFT]" wrote:
> If you do not have the databases, then the report server will not work.
> You will need to reinstall reporting services. Ensure that after setup, the
> reportserver service is running in the service control manager. Also ensure
> you can access the report server on the virtual directory you specified
> during setup,e.g. http://localhost/reportserver (default).
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> > Lukasz, while installation i don't have problems but when i check it now i
> > don't have those two databases(reportserver and reportservertempdb) and i
> > have files under c:\program files\sql
> >> server\mssql\reporting services. Now what to do i have to reinstall it
> >> again. And one more thing i forgot to say is my reporting services is an
> >> Evaluation Edition which i down loaded from microsoft site.
> >
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> >> Did your installation succeed? This seems to look like you didn't
> >> actually
> >> have a successful installation.
> >>
> >> In your SQL Server, do you have a database named reportserver and another
> >> called reportservertempdb?
> >>
> >> In your filesystem, do you have files under c:\program files\sql
> >> server\mssql\reporting services?
> >>
> >> -Lukasz
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> >> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >> >i installed reporting services on the same machine where i insatalled
> >> >SQl
> >> > server. i did some sample reports in visual studio.net 2003. initally
> >> > when
> >> > i
> >> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> >> > server.' one more insteresting thing is when i browse to
> >> > http://localhost/reports or reportserver is an stating that ' connot
> >> > find
> >> > to
> >> > directory /not having permissions.' then i gave some permission set to
> >> > both
> >> > these virtual directory.
> >> > and later i try to browse i got a different error --'The report server
> >> > cannot open a connection to the report server database. A connection to
> >> > the
> >> > database is required for all requests and processing.
> >> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
> >> > user
> >> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> >> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> >> > command its giving an error that 'No Reporting Services instance found
> >> > on
> >> > localhost.'. What to do Next i don't have any choice,can any one
> >> > susject
> >> > me
> >> > some thing.
> >> >
> >> > ----
> >> >
> >> > --
> >> > pammi
> >>
> >>
> >>
>
>
server. i did some sample reports in visual studio.net 2003. initally when i
try to deploy it,iam getting 'cannot connect to http://localhost/report
server.' one more insteresting thing is when i browse to
http://localhost/reports or reportserver is an stating that ' connot find to
directory /not having permissions.' then i gave some permission set to both
these virtual directory.
and later i try to browse i got a different error --'The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
command its giving an error that 'No Reporting Services instance found on
localhost.'. What to do Next i don't have any choice,can any one susject me
some thing.
----
--
pammiDid your installation succeed? This seems to look like you didn't actually
have a successful installation.
In your SQL Server, do you have a database named reportserver and another
called reportservertempdb?
In your filesystem, do you have files under c:\program files\sql
server\mssql\reporting services?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>i installed reporting services on the same machine where i insatalled SQl
> server. i did some sample reports in visual studio.net 2003. initally when
> i
> try to deploy it,iam getting 'cannot connect to http://localhost/report
> server.' one more insteresting thing is when i browse to
> http://localhost/reports or reportserver is an stating that ' connot find
> to
> directory /not having permissions.' then i gave some permission set to
> both
> these virtual directory.
> and later i try to browse i got a different error --'The report server
> cannot open a connection to the report server database. A connection to
> the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> command its giving an error that 'No Reporting Services instance found on
> localhost.'. What to do Next i don't have any choice,can any one susject
> me
> some thing.
> ----
> --
> pammi|||Lukasz, while installation i don't have problems but when i check it now i
don't have those two databases(reportserver and reportservertempdb) and i
have files under c:\program files\sql
> server\mssql\reporting services. Now what to do i have to reinstall it again. And one more thing i forgot to say is my reporting services is an Evaluation Edition which i down loaded from microsoft site.
"Lukasz Pawlowski [MSFT]" wrote:
> Did your installation succeed? This seems to look like you didn't actually
> have a successful installation.
> In your SQL Server, do you have a database named reportserver and another
> called reportservertempdb?
> In your filesystem, do you have files under c:\program files\sql
> server\mssql\reporting services?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >i installed reporting services on the same machine where i insatalled SQl
> > server. i did some sample reports in visual studio.net 2003. initally when
> > i
> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> > server.' one more insteresting thing is when i browse to
> > http://localhost/reports or reportserver is an stating that ' connot find
> > to
> > directory /not having permissions.' then i gave some permission set to
> > both
> > these virtual directory.
> > and later i try to browse i got a different error --'The report server
> > cannot open a connection to the report server database. A connection to
> > the
> > database is required for all requests and processing.
> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> > command its giving an error that 'No Reporting Services instance found on
> > localhost.'. What to do Next i don't have any choice,can any one susject
> > me
> > some thing.
> >
> > ----
> >
> > --
> > pammi
>
>|||If you do not have the databases, then the report server will not work.
You will need to reinstall reporting services. Ensure that after setup, the
reportserver service is running in the service control manager. Also ensure
you can access the report server on the virtual directory you specified
during setup,e.g. http://localhost/reportserver (default).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> Lukasz, while installation i don't have problems but when i check it now i
> don't have those two databases(reportserver and reportservertempdb) and i
> have files under c:\program files\sql
>> server\mssql\reporting services. Now what to do i have to reinstall it
>> again. And one more thing i forgot to say is my reporting services is an
>> Evaluation Edition which i down loaded from microsoft site.
>
> "Lukasz Pawlowski [MSFT]" wrote:
>> Did your installation succeed? This seems to look like you didn't
>> actually
>> have a successful installation.
>> In your SQL Server, do you have a database named reportserver and another
>> called reportservertempdb?
>> In your filesystem, do you have files under c:\program files\sql
>> server\mssql\reporting services?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
>> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>> >i installed reporting services on the same machine where i insatalled
>> >SQl
>> > server. i did some sample reports in visual studio.net 2003. initally
>> > when
>> > i
>> > try to deploy it,iam getting 'cannot connect to http://localhost/report
>> > server.' one more insteresting thing is when i browse to
>> > http://localhost/reports or reportserver is an stating that ' connot
>> > find
>> > to
>> > directory /not having permissions.' then i gave some permission set to
>> > both
>> > these virtual directory.
>> > and later i try to browse i got a different error --'The report server
>> > cannot open a connection to the report server database. A connection to
>> > the
>> > database is required for all requests and processing.
>> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
>> > user
>> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
>> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
>> > command its giving an error that 'No Reporting Services instance found
>> > on
>> > localhost.'. What to do Next i don't have any choice,can any one
>> > susject
>> > me
>> > some thing.
>> >
>> > ----
>> >
>> > --
>> > pammi
>>|||Thanks Lukasz,
i reistalled it and now its working...
pavan
"Lukasz Pawlowski [MSFT]" wrote:
> If you do not have the databases, then the report server will not work.
> You will need to reinstall reporting services. Ensure that after setup, the
> reportserver service is running in the service control manager. Also ensure
> you can access the report server on the virtual directory you specified
> during setup,e.g. http://localhost/reportserver (default).
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> > Lukasz, while installation i don't have problems but when i check it now i
> > don't have those two databases(reportserver and reportservertempdb) and i
> > have files under c:\program files\sql
> >> server\mssql\reporting services. Now what to do i have to reinstall it
> >> again. And one more thing i forgot to say is my reporting services is an
> >> Evaluation Edition which i down loaded from microsoft site.
> >
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> >> Did your installation succeed? This seems to look like you didn't
> >> actually
> >> have a successful installation.
> >>
> >> In your SQL Server, do you have a database named reportserver and another
> >> called reportservertempdb?
> >>
> >> In your filesystem, do you have files under c:\program files\sql
> >> server\mssql\reporting services?
> >>
> >> -Lukasz
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> >> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >> >i installed reporting services on the same machine where i insatalled
> >> >SQl
> >> > server. i did some sample reports in visual studio.net 2003. initally
> >> > when
> >> > i
> >> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> >> > server.' one more insteresting thing is when i browse to
> >> > http://localhost/reports or reportserver is an stating that ' connot
> >> > find
> >> > to
> >> > directory /not having permissions.' then i gave some permission set to
> >> > both
> >> > these virtual directory.
> >> > and later i try to browse i got a different error --'The report server
> >> > cannot open a connection to the report server database. A connection to
> >> > the
> >> > database is required for all requests and processing.
> >> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
> >> > user
> >> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> >> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> >> > command its giving an error that 'No Reporting Services instance found
> >> > on
> >> > localhost.'. What to do Next i don't have any choice,can any one
> >> > susject
> >> > me
> >> > some thing.
> >> >
> >> > ----
> >> >
> >> > --
> >> > pammi
> >>
> >>
> >>
>
>
Problem when trying to deploy a web site built with asp.net 2.0 and using SQL EXPRESS
Hi,
Plz help!
I built a web site using IIS and ASP.NET 2.0.
My web site has a log on screen and I only configured it with one user without any roles. This web site uses the SQL EXPRESS.(I Have 2 databases: 1 for the security required by the application and the other for my application. for the connectionstring I used a windows authentication security with an instance = true.)
Everything went well on my PC.
When I tried to deploy the web site on another PC, there was a big problem.
When I tried to login with the same user I created, then I have a problem.
The password is incorrect(Why? I don't know).
Maybe there is a problem with the IIS or with the SQL SERVER.
pLZ HELP!!
You should take a look at the forum at http://forums.asp.net/54/ShowForum.aspx, which covers Visual Web Designer. They will have a better idea how to address this.
Mike
Problem when passing parameters to Reporting services
Hello,
Am new to reporting services and having problems passing parameters.
I am using ASP.Net with .NetFramework 1.1 and am trying out reporting
services 2005.
I am using an object of the ReportExecutionService along with the render
method.
I have tried a few differnet examples and none have worked. Does anyone have
any working piece of code that i can try?
Thanks in advance
Regards
IshanJust to add to the question...
There are at least two Render methods specified in the documentation.
One is a call with 12 parameters one of which is the Report parameters.
The other Render method comes from the ReportExecution service and takes
just 5 parameters and the Report Parameters are set using a call to a separate
SetReportExecutionParameters.
Which of these methods has anyone used successfully ? Getting very strange
errors regarding Parameters from both of these Render routines.
Am new to reporting services and having problems passing parameters.
I am using ASP.Net with .NetFramework 1.1 and am trying out reporting
services 2005.
I am using an object of the ReportExecutionService along with the render
method.
I have tried a few differnet examples and none have worked. Does anyone have
any working piece of code that i can try?
Thanks in advance
Regards
IshanJust to add to the question...
There are at least two Render methods specified in the documentation.
One is a call with 12 parameters one of which is the Report parameters.
The other Render method comes from the ReportExecution service and takes
just 5 parameters and the Report Parameters are set using a call to a separate
SetReportExecutionParameters.
Which of these methods has anyone used successfully ? Getting very strange
errors regarding Parameters from both of these Render routines.
Friday, March 9, 2012
Problem when installing MS SQL Reporting Service
Hi,
I need help.
I am trying to install the Reporting Service.
When the screen was in "System Prerequisites Check", it tell me that
visual Studio.NET 2003 is not installed.
After clicking next in "System Prerequisites Check"
It jump to a page called "Welcome to ...SQL Reporting Service SETUP"
and then it automatically jump to a page called "Installing Reporting
Services"
But I haven't selected anything.
Then wait a few minutes, a general error message appears and and tell
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Could anyone get the solution? Thank you very much.I am facing similar problem while installing Reporting Services.
At the "System Prerequisites Check" all checks are OK but at the
"Welcome to Ms SQL Server 2000 Reporting Services Setup" screen I
waited for 10-15 minutes for the NEXT button that never appeared.
Finally, a general error message appears and telling
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Can someone help?|||I have resolved the problem by doing a windows update, shut down all
the active applications. Then proceed with the installation.
Your installer may be corrupted if this doesn't help.
I need help.
I am trying to install the Reporting Service.
When the screen was in "System Prerequisites Check", it tell me that
visual Studio.NET 2003 is not installed.
After clicking next in "System Prerequisites Check"
It jump to a page called "Welcome to ...SQL Reporting Service SETUP"
and then it automatically jump to a page called "Installing Reporting
Services"
But I haven't selected anything.
Then wait a few minutes, a general error message appears and and tell
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Could anyone get the solution? Thank you very much.I am facing similar problem while installing Reporting Services.
At the "System Prerequisites Check" all checks are OK but at the
"Welcome to Ms SQL Server 2000 Reporting Services Setup" screen I
waited for 10-15 minutes for the NEXT button that never appeared.
Finally, a general error message appears and telling
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Can someone help?|||I have resolved the problem by doing a windows update, shut down all
the active applications. Then proceed with the installation.
Your installer may be corrupted if this doesn't help.
Wednesday, March 7, 2012
Problem w/SqlDataAdapter in VB 2003 using SQLExpress
I am going through ADO.NET step-by-step and I tried the first project making a simple SqlDataAdapter and I get errors generating Update, Insert, and Delete statements. Any ideas? Should I just go back to MSDE using VB 2003?
Uriel
Dread Judge Forgive me!What errors are you getting?|||First, I should note that I am using the Northwinds DB that came with the book I am using. I add the SqlDataAdapter and the Wizard pops up. I added my connection. Choose Use SQL statements. I use the query builder to select several fields from one table, then click next. On the final page of the Wizard . I get the following:
The wizard detected the following errors when configuring the data adapter "SqlDataAdapter1".
"Symbol" - this is the symbol before the statements
"Check" Generated SELECT Statement
"Check" Generated Mappings
"Warning" Generated INSERT Statement
There were errors configuring the data adapter
"Warning" Generated UPDATE Statement
There were errors configuring the data adapter
"Warning" Generated DELETE Statement
There were errors configuring the data adapter
To apply these setting click finish.
There is no explanation of the errors and nothing that I can find to get an explanation. It allows you to go back and make changes, but I don't even know what's wrong.
Uriel
Dread Judge Forgive me!|||Any success? I'm getting the same thing, but for me it errors out creating the Select statement and doesn't even attempt the rest.
Problem w/SqlDataAdapter in VB 2003 using SQLExpress
I am going through ADO.NET step-by-step and I tried the first project making a simple SqlDataAdapter and I get errors generating Update, Insert, and Delete statements. Any ideas? Should I just go back to MSDE using VB 2003?
Uriel
Dread Judge Forgive me!What errors are you getting?|||First, I should note that I am using the Northwinds DB that came with the book I am using. I add the SqlDataAdapter and the Wizard pops up. I added my connection. Choose Use SQL statements. I use the query builder to select several fields from one table, then click next. On the final page of the Wizard . I get the following:
The wizard detected the following errors when configuring the data adapter "SqlDataAdapter1".
"Symbol" - this is the symbol before the statements
"Check" Generated SELECT Statement
"Check" Generated Mappings
"Warning" Generated INSERT Statement
There were errors configuring the data adapter
"Warning" Generated UPDATE Statement
There were errors configuring the data adapter
"Warning" Generated DELETE Statement
There were errors configuring the data adapter
To apply these setting click finish.
There is no explanation of the errors and nothing that I can find to get an explanation. It allows you to go back and make changes, but I don't even know what's wrong.
Uriel
Dread Judge Forgive me!
|||Any success? I'm getting the same thing, but for me it errors out creating the Select statement and doesn't even attempt the rest.
Problem w/ SQL Server Database Wizard
I'm relatively new to VB.NET and Database programming, so I don't know a WHOLE lot about both, but I've recently purchased Wrox's "Beginning Visual Basic .NET Databases" and I've run into a snag on page 48.
The text says to fill in the Login ID and Password ("sa" and blank) on the first screen of the Microsoft SQL Server Database Wizard in Access, but when I do, I get an Overflow error. I get the same error if I try to Use Trusted Connection. I can't get past this screen.
I'm running Access 2000, and the SQL Desktop Engine 2000, and I don't have Enterprise Manager. Anyone know how to help me?
Please!!! Help me!!!Do you have latest service packs on SQL SErver and OFfice tools?|||No, I don't. Would I get those from Microsoft's site? (Damn, I hate navigating that website.)|||Hey, Satya, service pack 3 did the trick.
Thanks for the help.
Sean
The text says to fill in the Login ID and Password ("sa" and blank) on the first screen of the Microsoft SQL Server Database Wizard in Access, but when I do, I get an Overflow error. I get the same error if I try to Use Trusted Connection. I can't get past this screen.
I'm running Access 2000, and the SQL Desktop Engine 2000, and I don't have Enterprise Manager. Anyone know how to help me?
Please!!! Help me!!!Do you have latest service packs on SQL SErver and OFfice tools?|||No, I don't. Would I get those from Microsoft's site? (Damn, I hate navigating that website.)|||Hey, Satya, service pack 3 did the trick.
Thanks for the help.
Sean
Subscribe to:
Posts (Atom)