|
|
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;
|
|
|
|
|
hifiger2004 wrote: What's wrong with it?
Everything 
Google for ado, check connectionstrings.com for connection details
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
still doesn't work 
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
|
|
|
|
|
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
|
|
|
|
|
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()
|
|
|
|
|
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.
|
|
|
|
|
I created a new application pool with identity local system, but am getting some other error. Error is as follows.
Unable to validate data
|
|
|
|
|
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.
|
|
|
|
|
could i change the culture of any server control in asp.net 3.5
From en to es
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
I am creating menu tab using multiview . it works fine in firefox and IE but in safari browser
menu tab not clicked
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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);
}
}
|
|
|
|
|
|
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,"+");
|
|
|
|
|
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.
|
|
|
|
|
I want to retrieve the text from the search text box to the new browser window which is google.com.
I tried "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" &gt;&lt;="" asp:textbox="" &gt;
="" &amp;nbsp;&lt;asp:button="" text="SEARCH" borderstyle="None"
="" font-bold="True" onclick="Button1_Click">
Understand and reply back
|
|
|
|
|
Hi all,
After being binded, my datagridview is so long, because the there is so much data in the table related, so I want to limit the height of my gridview. Maybe it has a certain height and to see more data, we should use a scroll bar.
Would you give me any suggestion?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
