Click here to Skip to main content
15,899,314 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Is it possible to download a media (video or images) files from server and run it on client machine ! Pin
Abhishek Sur12-Nov-09 8:42
professionalAbhishek Sur12-Nov-09 8:42 
QuestionComprehensive comparison of document.all and document.getElementById? Pin
DigiFaith2-Nov-09 6:51
DigiFaith2-Nov-09 6:51 
AnswerRe: Comprehensive comparison of document.all and document.getElementById? Pin
Oakman3-Nov-09 12:08
Oakman3-Nov-09 12:08 
QuestionHow to change a title of javascript alert Pin
kKamel2-Nov-09 5:56
kKamel2-Nov-09 5:56 
AnswerRe: How to change a title of javascript alert Pin
Abhishek Sur2-Nov-09 6:13
professionalAbhishek Sur2-Nov-09 6:13 
GeneralRe: How to change a title of javascript alert Pin
kKamel2-Nov-09 6:19
kKamel2-Nov-09 6:19 
GeneralRe: How to change a title of javascript alert Pin
Abhishek Sur2-Nov-09 6:20
professionalAbhishek Sur2-Nov-09 6:20 
GeneralRe: How to change a title of javascript alert Pin
kKamel2-Nov-09 6:22
kKamel2-Nov-09 6:22 
GeneralRe: How to change a title of javascript alert Pin
Abhishek Sur2-Nov-09 7:04
professionalAbhishek Sur2-Nov-09 7:04 
QuestionHow to add my database in server Pin
Ariful Islam Sabuz31-Oct-09 21:55
Ariful Islam Sabuz31-Oct-09 21:55 
AnswerRe: How to add my database in server Pin
Abhishek Sur31-Oct-09 22:03
professionalAbhishek Sur31-Oct-09 22:03 
GeneralRe: How to add my database in server Pin
Ariful Islam Sabuz31-Oct-09 22:22
Ariful Islam Sabuz31-Oct-09 22:22 
GeneralRe: How to add my database in server Pin
Abhishek Sur1-Nov-09 1:34
professionalAbhishek Sur1-Nov-09 1:34 
QuestionJavascript Library for Graph Pin
Member 336966231-Oct-09 17:53
Member 336966231-Oct-09 17:53 
AnswerRe: Javascript Library for Graph Pin
Not Active31-Oct-09 18:17
mentorNot Active31-Oct-09 18:17 
GeneralRe: Javascript Library for Graph Pin
Member 33696621-Nov-09 4:49
Member 33696621-Nov-09 4:49 
GeneralRe: Javascript Library for Graph Pin
Not Active1-Nov-09 6:30
mentorNot Active1-Nov-09 6:30 
QuestionCan I use ASP script to connect & open local MS Access database? [modified] Pin
Curious 200931-Oct-09 11:57
Curious 200931-Oct-09 11:57 
I would like to use ASP script to connect and open my local MS Access database, I also have the MS Access database at my c:\inetpub\wwwroot\Name_ID.mdb with have only 1 table List with 2 columns: column "Name"(defined as Text) & column "ID" (defined as Number)

I have my web-page ConnectLocalDatabase.asp at my web-site with the following codes:

<%
    Dim strQuery, rsRequest, conn
	
    set conn = CreateObject("ADODB.Connection") 
    conn.open "Provider=MS Remote;" &_  
        "Remote Server=http://27.33.22.211;" &_ 
        "Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_ 
        "Data Source=c:\inetpub\wwwroot\Name_ID.mdb;" 
			
    set rsRequest = Server.CreateObject("ADODB.Recordset")
    strQuery = "SELECT * From List Where ID = 1"  
	
    '======================================================================
    rsRequest.Open strQuery, conn, adOpenDynamic, adLockOptimistic, CmdText	
    If Not rsRequest.EOF Then
	Response.write(rsRequest("Name"))
	Response.write("OK1")
    End If
    rsRequest.Close
    '======================================================================
	
    conn.Close
			
    Response.write("OK2")
%>


If I comment-out codes between '=== ... '=== then my web-page show OK2 without any error, but when I remove those comment-out I will have web-page error

- If I connect directly with the same Name_ID.mdb on my web-site, then there is no error (sure I have to modify the "Remote Server=<b>http://27.33.22.211;"

Note1: I even use ODBC Data Source Administrator to register the Name_ID.mdb in c:\inetpub\wwwroot\ as recomended

Note2: I did use www.showmyip.com to have my Internet address of my PC: 27.33.22.211

Can anyone help on this?

Thanks in-advanced

modified on Saturday, October 31, 2009 6:03 PM

Questionasp(scripting) Pin
rajiv_kadam30-Oct-09 22:39
rajiv_kadam30-Oct-09 22:39 
AnswerRe: asp(scripting) Pin
Abhishek Sur31-Oct-09 11:29
professionalAbhishek Sur31-Oct-09 11:29 
QuestionThe Link is not being updated Pin
BobInNJ30-Oct-09 10:37
BobInNJ30-Oct-09 10:37 
AnswerRe: The Link is not being updated Pin
Christian Graus30-Oct-09 14:09
protectorChristian Graus30-Oct-09 14:09 
QuestionWeb Page Protection Pin
nlarson1130-Oct-09 4:55
nlarson1130-Oct-09 4:55 
AnswerRe: Web Page Protection Pin
Abhishek Sur30-Oct-09 9:40
professionalAbhishek Sur30-Oct-09 9:40 
QuestionHow to Commnuicate with .net to javaServlat Pin
boopathiduraisamy30-Oct-09 1:37
boopathiduraisamy30-Oct-09 1:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.