|
Hi...
thanks for the response...
I have same project in two machines. one has sql server 2005 and the other has sql server express.
It works fine where i have Sql server 2005 but not in other.
what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me.
i could connect to database by doing some changes like...
identity impersonate=true,
IIS virtual directory -> security -> windows authentication ...
etc... etc...
so it works fine in that particular machine, and the other has the same settings...
the difference is only the edition of sqlserver/ express....
so why it gives me the prompt for login...
plz help me out
thanks,
hemant
By:
Hemant Thaker
|
|
|
|
|
Just add a new User for
HEM-BE419D4FB41\ASPNET
on the database db1.
If there is no Login created for ASPNET user in your current database instance, you need to create a login account as well.
|
|
|
|
|
Hi...
thanks for the response...
I have same project in two machines. one has sql server 2005 and the other has sql server express.
It works fine where i have Sql server 2005 but not in other.
what happens is.. when i browse my website from IIS it prompts me to auto generated login screen with heading "connect to XPW(machine_name)" with username and pwd...so whats going on can u tell me.
i could connect to database by doing some changes like...
identity impersonate=true,
IIS virtual directory -> security -> windows authentication ...
etc... etc...
so it works fine in that particular machine, and the other has the same settings...
the difference is only the edition of sqlserver/ express....
so why it gives me the prompt for login...
plz help me out
thanks,
hemant
By:
Hemant Thaker
|
|
|
|
|
Hi...
As u said, was right but was not getting my way out creating users and logins.I did search something and its like as follows
Enabling SQL Authentication
STEP1:
You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG.
-------------COPY BELOW---------------------------------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"LoginMode"=dword:00000002
-------------COPY TILL THIS---------------------------------
STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication.
STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect.
Next, you need to add a user with SQLLogin. To do this: Login to SQLExpress using Express Manager and run the script below:
-------------------------------------------
USE MASTER
sp_addLogin 'aspuser', 'aspuser@123'
GO
sp_addsrvrolemember 'aspuser', 'sysadmin'
GO
USE Cartridge
EXEC sp_adduser 'aspuser'
-------------------------------------------
In case you want to reduce the privilege for the user then you can specify something other than sysadmin, but we can think of that once this works.
Now change your connection string as follows:
connectionString = "server=.\\SQLExpress;uid=aspuser;pwd=aspuser@123;database=cartridge;";
////////////////////////////////////////
U may need to change connectionstring probably remove one '\' from server name
May be this can help someone...
thanks for ur support
Hemant
By:
Hemant Thaker
|
|
|
|
|
i want to call server side asp.net(vb) function from java script
how is that possible?
i really need it
|
|
|
|
|
Javascript runs client side - so I don't think that's possible. However, you can use ajax to run the asp page that runs the vb function. If you are new to ajax, I suggest using jQuery (It makes the whole process a lot simpler).
|
|
|
|
|
ICallbackEventHandler would do that.
|
|
|
|
|
i want to change gridview into edit mode using javascript
requirnment is
code to chage mode of asp grid veiw
how is that possible?
|
|
|
|
|
Make the gridview yourself using Repeater and html Table.
then you will be having better grip on the html it renders and place the javascript calls appropriately.
|
|
|
|
|
Hi all ,
I'm using asp.net and crystal report
I'd like to view all pages of the crystal report in the web page without using crystal toolbar to navigate the pages ..
can I do that ?
jooooo
|
|
|
|
|
I hope this is the correct forumn for this.
I need to have the following functionality in my application.
The application is running as an NT service.
It was written using C# with .NET 3.5.
The application will read a record from a SQL Server database.
The record will provide a Method name, a return type and a list of parametes and their types.
The application will then generate a WebService with a WebMethod which matches the database record.
Now, any user can call the WebMethod.
Does this make sense?
I know how to create WebServices using Visual Studio and several other languages.
I need to create the Web Service on the fly.
In fact, I need to create one or more Web Services. Depending on how many records are in the database.
Any help would be greately appreciated.
Thanks
Ben Clark
|
|
|
|
|
Hey Ben,
You got to understand that Web Services are specialiazed Web Application than needs to be hosted ans should have an address to be called by the client in order to get access of the Web Methods.
|
|
|
|
|
I am trying to add an accordion control to one of my pages.
Following is the code:
<asp:scriptmanager id="ScriptManager1" runat="server">
<cc1:accordion id="Accordion1" runat="server">
<panes>
<cc1:accordionpane id="AccordionPane1" runat="server">
but I am getting this error:
An unhandled exeception has occurred.
Collection was modified; enumeration operation may not execute
Searched on this error but no results seemed to pertain to my problem. Can someone tell me what I have done wrong?
Thanks
Lonnie
Lonnie R Thomas
|
|
|
|
|
|
thank you very much for your answer
Lonnie R Thomas
|
|
|
|
|
<iframe>
This in an HTML Code.How to write this code in php ?
|
|
|
|
|
you use php to write html. so it's no different. you can however enclose it in quotes. so:
<iframe frameborder=0 src="http://www.gmodules.com/ig/ifr?url=http://raja.com/ig/ab.xml&up_k1=&&up_k2=&up_k3=&up_k4=&up_k5=&up_k6=&up_k7=&up_k8=&up_k9=&up_k10=&up_interval=60&synd=open&w=400&h=50&title=&border=%23ffffff%7C3px%2C1px+solid+%23999999&" width=412 height=60;><iframe>
is the same as:
<?php
echo "<iframe frameborder=0 src=\"http://www.gmodules.com/ig/ifr?url=http://raja.com/ig/ab.xml&up_k1=&&up_k2=&up_k3=&up_k4=&up_k5=&up_k6=&up_k7=&up_k8=&up_k9=&up_k10=&up_interval=60&synd=open&w=400&h=50&title=&border=%23ffffff%7C3px%2C1px+solid+%23999999&\" width=412 height=60;><iframe>";
?>
note the escape character "\" before quotes within the statement.
|
|
|
|
|
oh and there is a php forum on this site
|
|
|
|
|
In a developer thread on SVG the topic of high lighting text came up. I offered the YUV luminosity transform method. What is the best approach?
JavaScript Hight Light Test[^]
|
|
|
|
|
How to create .txt file in web server. I want to read text file form other website and write it in my web server which can also update data after some time.In which programing language i can make this i don't want to use php.Please help me you all can.
Thank You
|
|
|
|
|
udch wrote: I want to read text file form other website and write it in my web server which can also update data after some time.
You want to read content from some other site and want to save it in your web server as text file. Am I correcct?
|
|
|
|
|
php asp with c# or vb. perl. lots of possiblities - depends what you like best.
|
|
|
|
|
I have 3 pages
1.personal.html
2.work.html
3.others.html
In this 3 pages i want to collect all informations(like the data in the textboxes, etc ) and want to display all the information @ 4th page which is called tota1.html
so can you help me with that?
|
|
|
|
|
yeah you can put the data in forms
Your 3 webpages will have something like:
<form1 method="post" action="tota1.php">
<input type="text" name="mytextbox" />
<inout type="submit" />
To retrieve the posted data you need to use a server side language (PHP or ASP).
To do this in PHP:
Tota1.php: <---------- (note php -you can make php interpret html, but for now this is easier)
<?php
$myvar = $_POST['mytextbox'];
echo $myvar;
?>
That should display posted data.
You may also want to research the following:
PHP and MySQL or ASP and MSSQL
or if you dont have a Database:
Writing to "Flat Files"
|
|
|
|
|
hey dude ... i will try that ...... but as you said if there are 2 text boxes which has the same name in different html pages .... how can you work with that??
any ways I will reply tomorrow ....
Thank you
|
|
|
|