Re: .mdf file - ASP.NET Discussion Boards

First Prev Next

Re: How to get ipaddtes of system in asp

rahul.net113-Sep-07 1:09

rahul.net11

3-Sep-07 1:09

Hi i tried the code it gives following error.Can u tell me why this
error was coming.

Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/add.asp, line 10, column 73
Set LNCs = WMI.ExecQuery("SELECT * FROM Win32_NetworkAdapterConfiguration

Thanks.

Rahul

Re: How to get ipaddtes of system in asp [modified]

VenkataRamana.Gali3-Sep-07 1:18

VenkataRamana.Gali

3-Sep-07 1:18

try with this

Set objFarm = CreateObject("MetaFrameCOM.MetaFrameFarm")<br />
objFarm.Initialize(1)<br />
<br />
For Each objSession In objFarm.Sessions<br />
WScript.Echo "User name : " & objSession.UserName<br />
WScript.Echo "IP Address: " & objSession.ClientAddress<br />
Next

ipaddress = Request.ServerVariables("HTTP_X_FORWARDED_FOR")<br />
if ipaddress = "" then<br />
    ipaddress = Request.ServerVariables("REMOTE_ADDR")<br />
end if

GV Ramana

Re: How to get ipaddtes of system in asp

rahul.net113-Sep-07 1:24

rahul.net11

3-Sep-07 1:24

Hi Thanks for your reply but it also giving following error.

Error Type:
Microsoft VBScript runtime (0x800A01AD)
ActiveX component can't create object: 'MetaFrameCOM.MetaFrameFarm'
/add.asp, line 9

Thanks.

Rahul

Re: How to get ipaddtes of system in asp

VenkataRamana.Gali3-Sep-07 1:27

VenkataRamana.Gali

3-Sep-07 1:27

http://www.thepcspy.com/articles/programming/getting_the_real_ip_of_your_users[^]

GV Ramana

Re: How to get ipaddtes of system in asp

rahul.net113-Sep-07 1:59

rahul.net11

3-Sep-07 1:59

Hi Thanks for your lot of help i tried all those but i don't know
why i am getting default ip address.127.0.0.1

Thanks.

Rahul

Re: How to get ipaddtes of system in asp

rahul.net113-Sep-07 2:32

rahul.net11

3-Sep-07 2:32

Hi Thanks i got the solution.

Rahul.

.mdf file

Mri1a3-Sep-07 0:44

Mri1a

3-Sep-07 0:44

How to use .mdf file in asp.

Actually i am having a project which is already using some other source and now i want to use .mdf file and bring about the changes but i dont know how to do

plz do hlp me out

Martand

Re: .mdf file

_mubashir3-Sep-07 1:25

_mubashir

3-Sep-07 1:25

Mri1a wrote:
How to use .mdf file in asp.

Do you want to use ASP with SQL Server ? Bcoz MDF is a SQL Server Database file.
If yes, then try google it, I believe there are thousands of articles available. If you have any problem using them...we are here to help you out. But atleast take an initiative Wink | ;)

Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.

How to use Microsoft Excel 11.0 Object in IIS 6.0

Bapi Ray3-Sep-07 0:13

Bapi Ray

3-Sep-07 0:13

I am developing a small application using ASP.NET 2.0. I have used Microsoft Excel 11.0 Object Library to create a excel chart. The OS is Windows XP and I have installed Microsoft Office 2003 SP2 in my system.This is running fine in my system when i am running the project in debug and release mode. But when i deployed in local server it threw me an error saying

"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error:
80080005.
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. "

I did some changes by adding the following line in web.config

"<identity impersonate="true" username="username" password="password">

After adding this i am not getting the above error, but the application is not instanciating excel application.

Please give me the solution, how i will be able to instanciate the excel application from IIS 6.0

TextBox in DataGrid

nandhububbly3-Sep-07 0:11

nandhububbly

3-Sep-07 0:11

Hi i am using textbox in datagrid ,so i need to add that textbox value in that datagrid and put in to label , so these working fine in IE 6 but if i run this in IE 7 and mozila the values are not adding ..

function TotalBudgetAmount()
{
var intCount=2;
var txtBudgetAmount= document.getElementById("dgridBudgetAllocationDetails__ctl"+intCount+"_txtCurrentBudgetAmount");//here txtBudgetAmount come as null in IE 7 but in IE6 its working so problem in this line

var TotalAmount=0;

while (txtBudgetAmount != null)
{

if (parseFloat(txtBudgetAmount.value))
TotalAmount = TotalAmount + parseFloat(txtBudgetAmount.value)

intCount += 1;
var txtBudgetAmount=document.getElementById("dgridBudgetAllocationDetails__ctl"+intCount+"_txtCurrentBudgetAmount");

}

these are that lines please c this code and reply thank u

Reg
nantha

Timer problem in Javascript..

Balagurunathan S2-Sep-07 23:51

Balagurunathan S

2-Sep-07 23:51

Hi Friends.

I am using javascript to display timer in my .aspx page..I also use javascript to do validations in that page.when i alert the user with a message.i.e when alert function is called,the timer stops and becomes idle.Again when i click the ok button of the message box that occured as a result of alert function ,the timer starts ticking again from where it had left earlier..Time deviation occurs due to this..How to solve it? Someone help in this regard as early as possible..

Thanks & Regards,

Balaguru

Re: Timer problem in Javascript..

Guffa3-Sep-07 0:46

Guffa

3-Sep-07 0:46

Time deviation always occurs when you use a timer, as the timer is triggered at the first possible moment after the time elapsed. If you want correct timing, you have to store the current time when the script starts, and calculate the difference between the start time and current time later on.

---
single minded; short sighted; long gone;

Re: Timer problem in Javascript..

Balagurunathan S3-Sep-07 0:51

Balagurunathan S

3-Sep-07 0:51

Thanks Guffa. for the informati0n given.

But i could i do it..I have no idea..Do u have any sample javascript coding..?Can u provide me with some sample..?

Regards,

Balaguru

Re: Timer problem in Javascript..

VenkataRamana.Gali3-Sep-07 0:51

VenkataRamana.Gali

3-Sep-07 0:51

see this

http://www.javascript-page.com/clock.html[^]

GV Ramana

Sending RDLC report as mail attachment.

M LN Rao2-Sep-07 23:16

M LN Rao

2-Sep-07 23:16

Please help me in sending rdlc report as an email attachment.

Intelligence is measured by common sense not by how many scholarly books you read.

plz help me

ManiMughal2-Sep-07 23:04

ManiMughal

2-Sep-07 23:04

i made a project but when i run it i face the following error mentioned in bold text when trying to login.plz tell me how to resolve it.

Server Error in '/Courier' Application.
--------------------------------------------------------------------------------

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 43: dsUsers = New DataSet
Line 44:
Line 45: Dataadapter.Fill(dsUsers, "users")
Line 46:
Line 47: If dsUsers.Tables(0).Rows.Count = 0 Then

here is the code of this page

Imports System.Configuration
Imports System.Data.SqlClient

Namespace Courier

Partial Class Login
Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<system.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent()

End Sub

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region

Dim dsUsers As DataSet
Dim Dataadapter As SqlDataAdapter
Dim strConnection As String

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

strConnection = ConfigurationSettings.AppSettings("ConnectionString") (this line also gives error)

End Sub

Private Sub cmdLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdLogin.Click

Dim roleName As String

Dataadapter = New SqlDataAdapter("SELECT * FROM users where users_login='" + txtID.Text + "' AND users_password='" + txtPassword.Text + "'", strConnection)
dsUsers = New DataSet

Dataadapter.Fill(dsUsers, "users")

If dsUsers.Tables(0).Rows.Count = 0 Then
lblError.Visible = True
Else
lblError.Visible = False

roleName = dsUsers.Tables(0).Rows(0)("users_role")
Session.Add("loggedIn", roleName)

If roleName = "administrator" Then
Response.Redirect("officemain.aspx")
End If

If roleName = "branchadmin" Then
Response.Redirect("officemain.aspx")
End If
End If
End Sub

Private Sub cmdCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCancel.Click
txtID.Text = ""
txtPassword.Text = ""
End Sub
End Class

End Namespace

Re: plz help me

Sandeep Akhare2-Sep-07 23:10

Sandeep Akhare

2-Sep-07 23:10

I got this error in my application also
This error occurs due to many reasons one of it is your Windows FireWall is not allowing to connect remote server .
Off your and Server fire wall and check once again

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: plz help me

Ahmad Adnan2-Sep-07 23:18

Ahmad Adnan

2-Sep-07 23:18

maybe it the sqlserver2005 service is turned off
try to turn it on
regards

Re: plz help me

Ahmad Adnan3-Sep-07 1:57

Ahmad Adnan

3-Sep-07 1:57