|
|
try this if you are using dotnet framework 3.5
http://weblogs.asp.net/scottgu/archive/2008/11/24/new-asp-net-charting-control-lt-asp-chart-runat-quot-server-quot-gt.aspx[^]">link
|
|
|
|
|
Hi All,
Is there any way to trace an Ip address that has tried to access a our SQL database remotely?
Thanks
|
|
|
|
|
Who's SQL are you using? What firewall do you have? (if you have one)?
Not trying to be a jerk, just trying to figure out what tools you have available.
|
|
|
|
|
Thanks.IS there any way to track an IP address that LOgs in to SQL2005 database.
I have tried:- netstat -n
Many thanks
|
|
|
|
|
With the MS SQL 2005 Enterprise manager; There is a 'Management' entry on the treeview pane. Expand that out and then the SQL server logs. Under there is an entry named 'Activity Monitor'. Double click on that and it will denote all of your connections to the database. Toward the end of the list of columns on the page is a 'Host' column. It should either give you the resolved host name if it is a local address (and you have a DNS server), or the TCP/IP address of the connected machine otherwise.
If the person is not actually connecting, you can see the connection attempts in the Windows Security Event log. If you don't you need to change the local policies on the machine, but by default they are set to record that activity.
|
|
|
|
|
Hi
I am getting problem in IE 7 when i am running asp.net 2.0 project in local machine if u set any aspx page set as default and run it automatically taking dot(.) at the end of Url for example http://localhost/mysite/sigin.aspx. Why That Url Taking Dot at the end of the Url. Please Help me as early as possible.
D.V.Mallikarjuna Guptha
|
|
|
|
|
|
All your Url are belong to us.
We are the Dot of B0rg.
We take Dot at the end of Url.
var question = (_2b || !(_2b));
|
|
|
|
|
Hi All
I am facing SQL Server Timeout exception.
try
{
SetStoredProcCommand(SPRetrieveIntSchedReport, DatabaseConfigKey);
AddInParameter("@FromDate", DbType.DateTime, schedule.FromDate);
AddInParameter("@ToDate", DbType.DateTime, schedule.ToDate);
AddInParameter("@ApplnType", DbType.String, schedule.ApplnType);
IDataReader dataReader = ExecuteReader();
while (dataReader.Read())
{ .....}
}
When the control reaches the data reader its taking much time to enter the WHILE loop, and some times its getting in and its done fine,but sme times facing this SQL SERVER TIMEOUT EXCEPTION.
please help.
Thanks in advance.
Reagrds
Pavan
|
|
|
|
|
You can increase the timeout on your connection/command, or better still optimise your proc as you may be doing a table scan or something similar - no way to tell from your code.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi
i have increased the timeout duration, and optimized the query as simple as i can.
Any settings to be changed in the IIS ?
Thanks
pavan
|
|
|
|
|
pavan.kumar,sai wrote: i have increased the timeout duration,
Set it to 0 to run the query indefinately .ie until you get the result.
When you fail to plan, you are planning to fail.
|
|
|
|
|
where to do that and how to do that ??
|
|
|
|
|
use the sqlcommand CommandTimeOut property....
ie
your_cmd_obj.CommandTimeOut=0
When you fail to plan, you are planning to fail.
|
|
|
|
|
I am using a datareader ...and not using it through commands, so we cant set it ...
|
|
|
|
|
In which case I suggest you consider some of the followng:
- do you need to return all the data at once?
- could the underlying data be denormailised into reporting tables?
- could some of the data be cached?
- could the indexing be improved?
I am fairly certain that if the query times out, and you are displaying the data on a web page it will be pointless, as nobody wants to wait ages for a page to load.
Hopefully this may guide you to a solution
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi
it is something like report grnearion,based on the user input a report is generated.
yes i am trying to display in the format of tables only.
But sometimes i can get it perfectly, and sometimes it throws the timeout exception ?
any case related to IIS ?
Thanks
Pavan
|
|
|
|
|
What about load on the sql server? Any locking causing problems, that sort of thing? Without actually being there its difficult to pinpoint where the problem is.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
How to display text in status bar in all browers using javascript
Am using window.status="text message" to display the in status bar, its working fine in IE6, but its not working in IE7 and in other browers.
Anyone please help me out to solve this problem.
beula
CMOTS INFOTECH
|
|
|
|
|
antony beula wrote: Am using window.status="text message" to display the in status bar, its working fine in IE6, but its not working in IE7 and in other browers.
Here you Go.
How To Enable window.status in Firefox[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Thanks a lot for your reply.
Its not possible for me to enable window.status in client machine.
Is there any other solution to display text in status bar using asp.net or javascript
beula
CMOTS Infotech
|
|
|
|
|
Hi all,
I am generating drop down list boxes for every row of the gridview using the itemTemplate in template Field, i want to give different ID's for each drop down list, how can i do it???
Please help.........
scarface
|
|
|
|
|
Hi,
if you placed dropdown list inside the item templage, i think it is not possible to give the different ids for each dropdownlist.
|
|
|
|
|
Hi,
I want to know wheather a Repeator Control:
1. can accept data from the database instead of XML files?
2. can hold an image control?
If yes plz get me some sampples.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
