Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

SQL Server 2008 - how to convert directory to a URL

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:127   Vote Up (0)   Vote Down (0)    
I am using SQL Server 2008 Enterprise. 

1)  What would be the URL for a file named "test.asp" that is stored in this directory - "C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/test.asp".  Assume the servername is "ServerJoe".  I have tried "http://ServerJoe/MSSQL/test.asp" and many other combinations without success (I get "HTTP request error", "Server.Error.RequestError: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032: Stream Error. URL: http://JWHPC/Reports/Pages/fas_mssql_connector.asp?irand=0.5500319339334965"]".  (Noticed I also tried storing the asp file in /Reports.)

2) What is the root directory for SQL Server 2008?

3) When asked for "userid" is it   domain\userid   or just   userid?

4) In which directory should the crossdomain.xml file be stored?

Thanks much.

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Caputurig Back Button Event & Force The Page To Load From Server:

  
I think in many time developer need this event, which is not provided by any browser and it is not captured by any javascript event.In this Article you see how you capture this event and how you force the browser to load the page from server.

PleaseWaitButton ASP.NET Server Control

  
An approach to displaying a "please wait" message/animated gif following a button click using encapsulated client-side JavaScript.

It is often useful upon a form submission in a web application to display a "please wait" message, or animated .gif image, particularly if the submission process lasts a few seconds or more. I recently developed a survey submission application in which internal users upload excel spreadsheets through a web page. The application inserts the uploaded data from the spreadsheets into a database. The upload/insert process may only take a few seconds, but even a few seconds on the web is a noticeable wait. When testing, some users clicked the upload button repeatedly; it was useful to provide a visual clue that the upload was underway. For that matter, it was useful to hide the upload button altogether, preventing multiple clicks. The control presented here, a subclass of the Button control, demonstrates how client-side JavaScript code encapsulated in an ASP.NET server control can provide such functionality conveniently.

IIS Issues - Unable to start debugging on the web server. The underlying connection was closed. The connection was closed unexpectedly.

  

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:
"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"
If I try to start debugging on my local website project I get the following error:
"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."
Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:

"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"

If I try to start debugging on my local website project I get the following error:

"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."

Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.


IIS Issues - Unable to start debugging on the web server. The underlying connection was closed. The connection was closed unexpectedly.

  

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:
"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"
If I try to start debugging on my local website project I get the following error:
"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."
Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:

"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"

If I try to start debugging on my local website project I get the following error:

"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."

Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.


Creating a Test server - Certain links getting redirected to live server.

  

Hi.

We had a website deployed on IIS server remotely say www.liveserver.com.

We recently decided to make a copy of the website internal to the organisation so we brought a server and copied all the code from live server and configured it and say it is http//archives-testserver.com


Everything seems to work fine but while navigating and clicking on certain module  links within  http//archives-testserver.com......the domain name is getting rewritten to www.liveserver.com and user is made to navigate on the live site. I wonder where this configuration is with in IIS...

I looked under properties under website identification and everything is referring it as http://arhives-testserver.com.  also thr is a file called securityRedirect.inc and ifor handling errors and all the references have been changed and couldn't find anything in web.config.


I would really appreciate if anyone can guide in right direction, where else to look for probable reference to live site?










Calling javascript funtion: Trying to convert a simple example from html to asp.net

  

 I have this javascript function in a javascript file called Bing.js

function onGeocodeClick() {
    myMap.Clear();
    address = document.getElementById("txtWhere").value;
    StartGeocoding(address);
}

function StartGeocoding(address) {
    myMap.Find(null,    // what
              address, // where
              null,    // VEFindType (always VEFindType.Businesses)
              null,    // VEShapeLayer (base by default)
              null,    // start index for results (0 by default)
              null,    // max number of results (default is 10)
              null,    // show results? (default is true)
              null,    // create pushpin for what results? (ignored since what is null)
              null,    // use default disambiguation? (default is true)
              null,    // set best map view? (default is true)
              GeocodeCallback);  // call back function
}

I have this line in my masterpage referencing my javascript file called Bing.js

<head runat="server">
    <title>Geocoding in Bing Maps</title>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
      <link href="~/Styles/Site.css" rel="stylesheet" type="text/css" />
      <script type="text/javascript" src="http://ecn.dev.virtualearth.net/mapcontrol/mapcontrol.ashx?v=6.3"></script>
     <script src="Scripts/bingMap.js" type="text/javascript"></script>    <---***bingMap.js        
    <asp:ContentPlaceHolder ID="HeadContent" runat="server">
    </asp:ContentPlaceHolder>
</head>

I have this in my Default.aspx. I have my new asp.net textbox and asp.net button above the htm text and click from the bing example

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <div>
        Address:
        <asp:TextBox ID="txtHere" Width="255px" runat="server" 
            ontextchanged="txtHere_TextChanged"></asp:TextBox>
         
        <asp:Button ID="Button1" runat="server" Text="Button" />
    </div>
    <div style="font-family:Arial; font-size:10pt">
          Address: 
          <input id="txtWhere" type="text" style="width:255px" />
           
          <input type="button" value="Geocode" onclick="onGeocodeClick()" />
       </div>
       <br />
       <div style="position:relative;width:400px;height:400px;" id="mapDiv">
       </div>
       <div id="resultsDiv" style="font-family:Arial;font-size:8pt;position:relative; top:-400px;left:425px;width:400px">
       </div>
</asp:Content>


Then this is my code behind for default.aspx.cs

  
    protected void Button1_Click(object sender, EventArgs e)
    {
        //myMap.Clear();
        //address = document.getElementById("txtWhere").value;
        //StartGeocoding(address);
        string address = txtHere.Text;
        // Get a ClientScriptManager reference from the Page class.
        ClientScriptManager cs = Page.ClientScript;

        // Check to see if the client script is already registered.
        if (!cs.IsClientScriptBlockRegistered(this.GetType(), "StartGeocoding"))
        {
            cs.RegisterClientScriptBlock(this.GetType(), "StartGeocoding", "StartGeocoding(address)");
        }
    }


On Button1_Click(), instead of calling StartGeocoding(address)...it prints the words StartGeocoding(address) at the top of the screen!
Is the ClientScriptBock above suppose to go into Page_Load? How do you make the javaScript call to StartGeocoding(address)?
Thanks, John Feeney



 


Convert MM/DD/YYYY to YYYY/MM/DD

  

hello,

               When the user enter the data in the text field, they are entering as  12/1/2010 4:19:49 PM.

But in database, the date is in this format        2010-12-01 16:19:49.367.


Here I have to change date format and Convert 12 hr format to 24 hr format.


Can any one help me.


TIA


will a 32-bit web application run as WOW64 on a 64-bit server?

  

Hi

I need to know if a web application deployed in a 64-bit server runs as a WOW64 process or a 64-bit process if the web application's pages are compiled as PE 32/x86 ?

I mean I have read a lot about normal console applications or executables with PE 32/x86 run as WOW64 on 64-bit servers. But what about web applications( all i can compile is the pages which are dlls)? The only process I can think of is w3wp.exe for web apps. Please explain. I am confused.

Thanks in advance

Vineeth


The remote server returned an error: (403) Forbidden.

  

Hi All,

i have a program in vb.net..i use the webrequest to post the data to another page (http://localpost/posReceived.aspx), and use the webResponse to get the back the response from the remote page.

When i run this program, it returned error "The remote server returned an error: (403) Forbidden.". I have no idea on this. Coz my aspx page and posReceived.aspx are placed in the same server and same directory. I supposed it should be worked without any security concerns.

Can anyone help me to solve it. Thanks a lot!

 

 

 


Display directory files in descending order

  

I need to retrieve and display directory files in descending order. For example: file-02_01_2010.txt should display before file-01_01_2010. I am using DirectoryInfo.getfile(searchPattern) but that will return files in random order (or maybe ascending order, I am not sure). Is there a way to specify the order in which I need files to be returned? I know I can load them into an array, sort them, etc., etc., but is there any cleaner way?


 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge