ASP.NET

Abhijit Jana2-Dec-09 22:10

2-Dec-09 22:10

hifiger2004 wrote:
I know that this is an ASP.Net forum, but just in case some of you still remember about the classic ASP,

I guess Web Development Forum is the best location where you can ask this.

For you ref. You can check following links. that may help you :

[^]
and
http://forums.digitalpoint.com/showthread.php?t=154140[^]
and
http://www.devarticles.com/c/a/ASP/Two-Ways-To-Connect-To-SQL-Server-2000-Via-ASP/3/[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Appusamy.subbian2-Dec-09 23:26

Appusamy.subbian

2-Dec-09 23:26

I guess ASP uses class ADO for data base connection .You need t provide provider information

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

Ashfield3-Dec-09 0:08

Ashfield

3-Dec-09 0:08

hifiger2004 wrote:
What's wrong with it?

Everything Smile | :)

Google for ado, check connectionstrings.com for connection details

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

hifiger20043-Dec-09 21:46

hifiger2004

3-Dec-09 21:46

still doesn't work Frown | :(

In ASP.Net there's no problem when using this type of connection string inside the web.config

<add name="ConnStr" connectionString="Data Source=PCName\SQLEXPRESS; Initial Catalog=MyDatabase;Integrated Security=True" providerName="System.Data.SqlClient" />

I tried the codes below and placed it inside the global.asa but still doesn't work.
Error: An unhandled exception ('[Microsoft][ODBC Driver Manager] Dta source name not found and no default driver specified') occurred in dllhost.exe [1368].

ConnStr = "Driver={SQL Server};Data Source=PCName\SQLEXPRESS;Initial Catalog=MyDatabase;Trusted_Connection=Yes;"

Or

ConnStr = "Provider=SQLOLEDB; Data Source =PCName\SQLEXPRESS; Initial Catalog = MyDatabase;Integrated Security=SSPI;"

It's really time consuming, I followed everything you told me from connectionstrings.com but still doesn't work at all.

hifiger2004

Error while creating excel file

Ashfield4-Dec-09 1:15

Ashfield

4-Dec-09 1:15

hifiger2004 wrote:
In ASP.Net there's no problem when using this type of connection string inside the web.config

But you are using CLASSIC ASP you said. It knows nothing about web.config, global.asa etc, these are .NET only.

You need to use ADO NOT ADO.NET, create connection objects and so on. Take a look at this:

http://support.microsoft.com/kb/299980[^]

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Robymon2-Dec-09 21:41

Robymon

2-Dec-09 21:41

Hi Guys,

i am getting the following error, creating an excel file dynamically through asp.net application.

The server process could not be started because the configured identity is incorrect. Check the username and password.

Exception Details: System.Runtime.InteropServices.COMException: The server process could not be started because the configured identity is incorrect. Check the username and password

source code as follows

Dim xlApp As New Microsoft.Office.Interop.Excel.ApplicationClass

' Create a new Excel Workbook
Dim excelWorkbook As Microsoft.Office.Interop.Excel.Workbook
excelWorkbook = xlApp.Workbooks.Add(Type.Missing)
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet

Dim misValue As Object = System.Reflection.Missing.Value

excelWorkbook = xlApp.Workbooks.Add(misValue)
xlWorkSheet = excelWorkbook.Sheets("sheet1")
xlWorkSheet.Cells(1, 1) = "http://vb.net-informations.com"
xlWorkSheet.SaveAs("C:\vbexcel.xls")

excelWorkbook.Close()
xlApp.Quit()

Re: Error while creating excel file

Abhijit Jana2-Dec-09 22:16

Re: Error while creating excel file

2-Dec-09 22:16

Robymon wrote:
The server process could not be started because the configured identity is incorrect. Check the username and password.

Exception Details: System.Runtime.InteropServices.COMException: The server process could not be started because the configured identity is incorrect. Check the username and password

Your application ruining from VS IDE or IIS ? If IIS does the user having sufficient permission to write on your system ?

If its from IIS, you can create a new Application pool for your web application with Identity "Local System" . Then you can try.
How to create Application pool and set up all other stuff, please read this article .
Beginner's Guide : Exploring IIS 6.0 With ASP.NET [^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Robymon2-Dec-09 22:33

Robymon

2-Dec-09 22:33

I created a new application pool with identity local system, but am getting some other error. Error is as follows.

Unable to validate data

Re: Error while creating excel file

Abhijit Jana2-Dec-09 22:43

could i change the culture of gridView

2-Dec-09 22:43

That is the different error that you were getting earlier. Check the code or you may enable the Error details from web.config for get the proper details.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

amit sahu202-Dec-09 21:40

amit sahu20

2-Dec-09 21:40

could i change the culture of any server control in asp.net 3.5
From en to es

Re: could i change the culture of gridView

Abhijit Jana2-Dec-09 22:13

Re: Help provider+win Form

2-Dec-09 22:13

amit sahu20 wrote:
could i change the culture of any server control in asp.net 3.5
From en to es

Are you talking about localization of your application ?
Localization in ASP.NET 2.0[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Help provider+win Form

Ramkumar_S2-Dec-09 20:00

Ramkumar_S

2-Dec-09 20:00

Hi All,

I am using help provider control.
my requirement is when i press F1 i should get the .chm file -- I done
but my .chm file should highlight the "Index" part as the default however, I want to highlight the "content" Tab not the "index" Tab.

For example if i am seeing the customer form and when i hit the F1 it should highlight the Customer page which is in the .chm file

Thank in advance

Ramkumar
("When you build bridges you can keep crossing them. ")

http://ramkumarishere.blogspot.com

Abhijit Jana2-Dec-09 20:03

Menu tab not woriking In safari

2-Dec-09 20:03

Ramkumar_S wrote:
Forum: ASP.NET
Subject: Help provider+win Form

Hi Ramkumar,
This is ASP.NET Forum and you are asking question for Win Form. Better if you ask on C# Forum.

Thanks !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Sudhanshu Mani Tripathi2-Dec-09 19:54

Sudhanshu Mani Tripathi

2-Dec-09 19:54

I am creating menu tab using multiview . it works fine in firefox and IE but in safari browser
menu tab not clicked

Re: Menu tab not woriking In safari

sashidhar2-Dec-09 21:36

sashidhar

2-Dec-09 21:36

Sudhanshu Mani Tripathi wrote:
menu tab not clicked

What Problem You Got..?

check my article..![^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

coding for search

Amit Spadez2-Dec-09 19:46

2-Dec-09 19:46

I have search textbox....Now, when I enter some text to search, it must search through google. And text entered in the search textbox of the project, must be appeared in the google search box...
tell me how to do it

Vimalsoft(Pty) Ltd2-Dec-09 19:52

Vimalsoft(Pty) Ltd

2-Dec-09 19:52

look at this

http://aspnet.4guysfromrolla.com/articles/030503-1.2.aspx[^]

Consuming the Windows Live Search Webservice using ASP.NET and AJAX 1.0[^]

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Dinesh Mani2-Dec-09 19:53

Dinesh Mani

2-Dec-09 19:53

You want to open a new browser window and show the google search result or you want to do a google search and display the results in a place holder?

Former can be achieved by opening a new window with url
http://www.google.com/search?hl=en&q=your+search+text+here

To do the latter you need to create a HTTPRequestResponse object and post a request to google server, get the response and display it in the placeholder.

Amit Spadez2-Dec-09 20:09

2-Dec-09 20:09

I want to do the first one i.e. retrieve the text from the search text box to the new browser window which is google.com.
I tried it "www.google.com/search?..." but it doesn't work .is there any alternative or can u understand the code below::

protected void Button1_Click(object sender, EventArgs e)
{
if (tbMainSearch.Text != null || tbMainSearch.Text != "")
{
Response.Redirect("http://www.google.com");
}
else
{
tbMainSearch.Focus();

}
}

The above code is done on clicking the "search" button.

the script is :
<asp:content id="Content2" runat="server"
="" contentplaceholderid="ContentPlaceHolder1">
<asp:textbox id="tbMainSearch" runat="server" style="margin-left: 0px" width="170px" ><="" asp:textbox="" >
="" &nbsp;<asp:button="" text="SEARCH" borderstyle="None"
="" font-bold="True" onclick="Button1_Click">

inderstand and reply back

Dinesh Mani2-Dec-09 20:19

Dinesh Mani

2-Dec-09 20:19

I'm able to achieve what you need with this code!

private void Button1_Click(object sender, System.EventArgs e)
{
	String SearchString = String.Empty;
	if (TextBox1.Text != null || TextBox1.Text != "")
	{
		SearchString = TextBox1.Text.Replace(" ", "+");
		Response.Redirect("http://www.google.com/search?hl=en&q="+SearchString);
	}
}

Amit Spadez2-Dec-09 20:30

2-Dec-09 20:30

thanx man

Dinesh Mani2-Dec-09 20:45

Dinesh Mani

2-Dec-09 20:45

You don't need to post your message to the server to redirect to Google! Use the window.Location.href from javascript to redirect from the browser like so

window.location.href = 'http://www.google.com/search?hl=en&q='+ document.getElementById('TextBox1').value.replace(/ /g,"+");

Abhijit Jana2-Dec-09 20:00

2-Dec-09 20:00

Just Try with this :
<html>
<body>
<form action="http://www.google.com/search" method="get">
<input name="q" type="text">
<input type="submit" value="search">
</form>
</body>
</html>

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Amit Spadez2-Dec-09 20:10