Hi,
I am trying to remove the grad total amount from the pivot table list with asp.net,programing. The data I called from cube, I have rows,columns and data axis values, when I place my measure in to data axis it autometically created sub total and grand totals, I want remove those. I could not found any property or method to remove that.
Please help me on this.
Hi Please help, I still not got any answer.
I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.
Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.
Thanks in advance for reply's
Regards
Matt
Hi,
As you said your machines are not on domain network, so you can not add the windows users to your server, rather you may add sql server login(s) in this case. Add the machine(s) to doamains so that they appears or else you need to create a windows login on your sql server machine with the same user id /password as they are on your workgroup machine. I.E. the name of your machine on workgroup is MachA and it has a user "squser1" and password "squser1", you need to create a windows user on your sql server with same username "squser1" and password "squser1" , But the best bet is to add those machine on your domain and then add/map the users to your sql server.
|||Hi, thanks for your reply.
You have said
Hemantgiri S. Goswami wrote:
Add the machine(s) to doamains so that they appears
This is what I want to know how to do.
In theory should the workgroup computers automatically be added to the listed locations on the add login window or is there a process I must go through to get them on there. As I stated before I can see the other computers in the network places > view workgroup computers.
Regards
Matt
|||I have solved my problem. I was trying to add sql user with windows domain and account details and it was throwing an error at this. This post just illustrates my inexperience with SQL.Thanks anyway for the reply
I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.
Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.
Thanks in advance for reply's
Regards
Matt
Hi,
As you said your machines are not on domain network, so you can not add the windows users to your server, rather you may add sql server login(s) in this case. Add the machine(s) to doamains so that they appears or else you need to create a windows login on your sql server machine with the same user id /password as they are on your workgroup machine. I.E. the name of your machine on workgroup is MachA and it has a user "squser1" and password "squser1", you need to create a windows user on your sql server with same username "squser1" and password "squser1" , But the best bet is to add those machine on your domain and then add/map the users to your sql server.
|||Hi, thanks for your reply.
You have said
Add the machine(s) to doamains so that they appears
This is what I want to know how to do.
In theory should the workgroup computers automatically be added to the listed locations on the add login window or is there a process I must go through to get them on there. As I stated before I can see the other computers in the network places > view workgroup computers.
Regards
Matt
|||I have solved my problem. I was trying to add sql user with windows domain and account details and it was throwing an error at this. This post just illustrates my inexperience with SQL.Thanks anyway for the reply
I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.
Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.
Thanks in advance for reply's
Regards
Matt
Hi,
As you said your machines are not on domain network, so you can not add the windows users to your server, rather you may add sql server login(s) in this case. Add the machine(s) to doamains so that they appears or else you need to create a windows login on your sql server machine with the same user id /password as they are on your workgroup machine. I.E. the name of your machine on workgroup is MachA and it has a user "squser1" and password "squser1", you need to create a windows user on your sql server with same username "squser1" and password "squser1" , But the best bet is to add those machine on your domain and then add/map the users to your sql server.
|||Hi, thanks for your reply.
You have said
Add the machine(s) to doamains so that they appears
This is what I want to know how to do.
In theory should the workgroup computers automatically be added to the listed locations on the add login window or is there a process I must go through to get them on there. As I stated before I can see the other computers in the network places > view workgroup computers.
Regards
Matt
|||I have solved my problem. I was trying to add sql user with windows domain and account details and it was throwing an error at this. This post just illustrates my inexperience with SQL.Thanks anyway for the reply
What is a secure way or accepted method to make database changes,IE: edit tables, add sprocs. ect. on a server being ran by an ASP.NET hosting service across the internet?
Thank you
-heywadeYou should check out theData Access Security section of "Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication" in Microsoft's Patterns & Practices series.
Terri|||Thanks Terri,
That is a great artical. Alot of that is out of My control though. An ASP.NET hosting service said that I would use Enterprize manager to admin My "would be" database across the internet. They didn't mention using SSL, also the use of IPSec wouldn't work on My end with NAT. So I guess I'll have to follow up with them. I didn't know the SSL would work with an SQL server...cool.
Thanks again
-heywade
I am using an asp.net web page (C#) to access a remote Report Server via the reportviewer contol. After solving the credentials issues, all of my test reports seem to run very nicely if there is no parameter input. When a parameter report is executed, the text box for parameter input is displayed. When the parameter is entered and the View Report button is pressed, the report is NOT Returned. If I go directly to the remote Report Manager and run the report (IE no code behind), it runs as it is supposed to. I've also run the report (web page) on my local report server and it displays the report after the parameter has been input. Why is the remote report server not returning the report after the parameter is input?
Thanks,
John
This problem has been resolved. The page will not work if the "ReportViewer1.ServerReport.ReportServerCredentials = new MyReportServerCredentials();" statement is placed in the Page_Load event.
Here are the steps taken to eliminate the problem:
1. Remove the credentials statement from the Page_Load event.
2. Place this code in the Page_Load event
if (!Page.IsPostBack)
{
ReportViewer1.Visible = false;
}
3. Place a button on the page to display the report.
4. Move all report statements to the push button event. Make sure to include "ReportViewer1.Visible = true"
It now works like a champ and I am happy!
Thanks,
John
Any sugession is greately appretiated!
Here is my code:
".net" page:
<%@. page language='vb' debug='true' %>
<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>
<html>
<script runat="server"
Sub Page_Load(Src As Object, E As EventArgs)
Dim MyConnection As SqlConnection
Dim da AS sqlDataAdaptor
Dim ds As DataSet
MyConnection = New SqlConnection("DSN=***;UID=***;PWD=***")
da = new sqlDataAdaptor("select * from city", MyConnection)
Try
MyConnection.open()
Response.write "Connection Success " & MyConnection.Database & "<br>"
catch sx AS sqlException
Response.write "Connection successful: <br>"
End Tryds=new Dataset()
da.Fill(ds, "City")With DataGrid1
.DataSource = ds.Tables("city").DefaultView
.DataBind()
End WithMyConnection.Close()
End Sub
</script
<body
<p>
<ASP:dataGrid id='DataGrid1' runat='server'/>
<p>
</body>
</html>
--------------
Set DB = Server.CreateObject("ADODB.Connection")
DB.Open ConnectionStringSET RSCheckeMail = DB.Execute ("select * from city")
While not RSCheckeMail.eof
Response.write "City: " & RSCheckeMail("Name") & "<br>"
RSCheckeMail.Movenext
Wend
Please check out the connection string suggestions athttp://www.connectionstrings.com. I would think that you would need to connect using an IP address.
Terri|||tmorton,
Thank you for your suggestion. I am trying with SQLClient only or I am missing some thing here.
I tried with all the connection strings explained in the URL: http://www.connectionstrings.com. No luck.
Any more suggestions? please.
KP|||can you post the updated code ?|||Yes, you are using SQLClient, which is good. What I was trying to say but wasn't clear is that if you want to use a DSN you would need to use ODBC instead.
Did you try a connection string in this format?
"Data Source=190.190.200.100;Network Library=DBMSSOCN;Initial Catalog=yourDatabase;User ID=yourSQLUserID;Password=youSQLUserPassword;"
If you could post your attempted connection string and any errors your are receiving this would help to troubleshoot the problem.
Terri|||tmorton,
Thank you for your advice.
I got the solution for my problem.
I think all new .net learners like me has this problem initially. I mistake I did was, not using VS .net to start my development.
All beginners you need to remember to do this when you start for the first time when you start running some sample .net pages: Create an application (vb or c#) depends as per your preference. Then add all the pages to that Application. This will make your test pages will run properly (you won't waste time like me for 3 days to scratch your head to run a simple page!!).
Here is my final code to connect remote server from your IIS:
<%@. page language='vb' %>
<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %
<script runat="server"
Sub Page_Load(Src As Object, E As EventArgs)
Dim MyConnection As SqlConnection
Dim da AS sqlDataAdapter
Dim ds As DataSet
MyConnection = new SqlConnection("server=65.49.254.24;database=aspdotnet;uid=aspdotnetuser;pwd=aspdotnetpassword")da = new sqlDataAdapter("select * from city", MyConnection)
Try
MyConnection.open()
Response.write ("Connection Success <br>")
catch sx AS sqlException
Response.write ("Connection failed: <br>")
End Tryds=new Dataset()
da.fill(ds, "cities")With DataGrid1
.DataSource = ds.Tables("cities").DefaultView
.DataBind()
End With
MyConnection.Close()
End Sub</script>
<html>
<body
<p>
<ASP:dataGrid id='DataGrid1' runat='server'/>
<p>
</body>
</html>
Please correct me if you can improve the connection.
Thanks for your support.
KP|||this is good...works..but if you just want to display a set of results...you can use executereader (for returning multiple columns) which is faster than datasets...am sure you will learn along the journey...
in your case you could have just created an sqlcommand...xample..( off the top of my head)
dim mysqlcommand as sqlcommand
Dim conn As SqlConnection
dim strsql as string
conn="..."
strsql ="Select * from table"
mysqlcommand=new sqlcommand(strsql,conn)
conn.open()
datagrid.datasource=mysqlcommand.executereader()
conn.close()
also remember to open the connection late and close early...
hth|||Dinakar,
Thanks for your suggestions. I will remember them.
You are right! Just now I started long journey...
KP
Hello,
My database stays in a remote site and I have access it through VPN. I would like connect my current Windows based Asp.Net application with this database. What are my options? Can I connect remote database with SqlDataAdaper, will that be slow? Should I sue Web Services to connect database?
If you can Ping the database server from the server running the ASP.NET code, you should be able to connect the exact same way as you can connect to a machine right next to your machine. The speed or slowness depends upon exactly what you are doing. It is likely that using the standard SqlClient classes will be faster and easier than trying to do it using a Web Service.Hi can anybody know how to connect remote database with asp.net application? Actually my database is in different machine (in different server, different location) so i want to connect that server. Every time I'm getting the fallowing message
An error has occured 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.
Thank you,
Nagu
Hi,
Please check the article athttp://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx about this default security configuration and altering this setting
You can use the Surface Area Configuration tool in order to let remote connections.
Eralper
|||
Hi nagsline ,
First of all enable mixed mode authentication for accessing the database. If you are using an sql username and password make sure that user have access to your database.
|||Also make sure your connection string is correct ie. you have mentioned the correct system name or Ip address etc.|||I don't know if this helps but I thought I would point out that you receive this exact error also when your SQL server is stopped and you try connecting to it.How can I connect to a remote database, based on Microsoft sql server? Is there any article that can help? I have read few over the net, but not working for me yet
Try this link
http://plutonium.cs.umanitoba.ca/ntlabs/MSSQLserver/MSSQLserver-home.html
|||
Prashant Kumar:
Try this link
http://plutonium.cs.umanitoba.ca/ntlabs/MSSQLserver/MSSQLserver-home.html
What I really wanted here is connecting to remote server (via IP address). I'm running windows xp. Which should be something that has to be configured in my connection string
|||
Refer to the following
http://connectionstrings.com/?carrier=sqlserver2005
search for "Connect via an IP address"
Hi
I'm having a problem connecting to a remote sql server 2000, A, database using asp.net 2.
Im able to connect to another remote database, B, fine but when i connect A i get the following 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
I figure it might be a server problem. I tried using all sorts of connection strings.
Thanks
Hi,
Did you manage to solve this problem? I have the same problem and I am also finding it hard to find anyone to help me.
Thanks
|||I'm also having this issue, Server is 2003 IIS 6.0. .NET 2.0 I am writing an application hosted on this server that connects to another 2003 server running sqlserver 2005 standard. There is no Firewall enabled on the db server. Remote connections are enabled on the dbserver and allowed through 1433. I've added local service to the security permissions too as well as the username and password that i'm using in the connection string.
I've gone through various posts regarding this error but to no avail. here's the full error as seen in my browser and the connection string i'm using in web.config
Exception Details:System.Data.SqlClient.SqlException: 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.)
web.config
<connectionStrings>
<add name="ConnectionString" connectionString="data source=dbserver;Network=DBMSSOCN;initial catalog=ius_hr;Trusted_Connection=yes;user id=username;password=password;packet size=4096"/>
</connectionStrings>
I had made an application which is using SQL Expresss.
When I deploy that application on a server where only .Net Framework 2.0 is installed then it gives an error of remote connection.
Does that need some prerequisite for SqlExpress or the reason of error is something else.
Dear Rajkumar,
By default Sql Express does not allow remote connections.
Configuring remote connections is shown overhere.
HTH,
Suprotim Agarwal
|||The Given points are written on the article you provided.
But I don''t have any SQLExpress Server or SQLServer2005 installed on my server machine.
I have only .net framework 2005 installed.
|||
Dear rajkumar,
I agree that your application is deployed on the server where only .NET framework is installed. However my question is where is the database installed.
Well if the db is installed in your machine apply the suggestions given in the post to enable remote connections on your database.
HTH,
Suprotim Agarwal
