|
Actually I want to attach my database (named KoorasDatabase.mdf) in the server to host. I need to the procedure.
I am confused if all all my tables are needed to create again.
|
|
|
|
|
To attach a database use this script.
USE [master]
GO
CREATE DATABASE [KoorasDatabase] ON
( FILENAME = N’C:\Data\KoorasDatabase_Data.mdf’ ),
( FILENAME = N’C:\Data\KoorasDatabase_Log.ldf’ )
FOR ATTACH
GO
IF EXISTS ( SELECT name
FROM master.sys.databases sd
WHERE name = N’KoorasDatabase’
AND SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() )
EXEC [KoorasDatabase].dbo.sp_changedbowner @loginame=N’sa’,
@map=false
GO
Just replace the Filepath with appropriate one. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hello 
I'm currently designing an intranet web project that will need to plot graphs (not charts)
Something like mxGraph, more precisely in this port sample or in database sample.
I'm not allowed to has a local copy of their script, so I can't use them.
Are there any good similar libraries out there, which is not too low level, and are allowed to be hosted locally?
Thanks in advanced
|
|
|
|
|
|
Thx
But it wasn't really what I looked for
Not charts, but more like a database diagram where you connect an entity with the others
Thanks
|
|
|
|
|
Member 3369662 wrote: will need to plot graphs (not charts)
Member 3369662 wrote: more like a database diagram where you connect an entity with the others
Then you really need to be more clear in what you are asking for. These requests are completely different
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
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
|
|
|
|
|
i m displaying records from one table and while displaying
i m passing the id field of project.asp to scheme.asp
now my problem is that when scheme.asp does not contain the scheme for the
project.asp then it should not show the hyperlink viewscheme on project.asp file.
here is my code.....below
| <%
opendatabase conn
id=request("id")
sql="select * from projectdescription where id="& id
set obj=server.createobject("adodb.recordset")
obj.open sql,conn,1,1
sql2="select * from schemedescription where projectid="& obj("id")
set obj2=server.CreateObject("adodb.recordset")
obj2.open sql,conn,1,1
if obj2("projectid")=obj("id") then
response.Write("View Project ")
response.Write("View Scheme ")
response.Write("View Team
")
%>
|
| <%
response.Write(obj("description"))
%>
| " height="150" width="200" alt="Central Home Images" >
<%
else
response.Write("View Project ")
response.End()
end if
%>
|
|
|
|
|
|
I think you need to omit this
response.Write("scheme.asp?id=%22%20&%20obj(%22id%22)%20&%20%22")
Use an IF statement then.. .whats the problem ?? 
|
|
|
|
|
Please consider the following web page:
<br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.or<br />
g/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head><br />
<title>Untitled Page</title><br />
</head><br />
<br />
<body><br />
<script type="text/javascript"><br />
<br />
document.getElementById("I1").href = "http://www.google.com";<br />
<br />
</script><br />
<br />
<a href = "http://www.yahoo.com" id = "I1" name = "N1" >click here</a><br />
<br />
<br />
</body><br />
<br />
</html><br />
<br />
When this JavaScript runs, I would expect the getElementById call to return a reference to the href tag. Instead it returns null. I would like to know what I am doing wrong.
Thanks
Bob
|
|
|
|
|
I think you need to call this in your page loaded event, I thnk it's running before the control exists.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hello...
Forgive if this has been asked before... what tools or techniques do any of you recommend to "protect" the content of web page from a malicous user (hidden textboxes, links, etc)?
Thank you for your time.
Nathan
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Of course Code injection should be protected first. Javascript/SQL injection are the primary concern as Data is the most essential part of any application.
Other than that use solid security software for your server.
|
|
|
|
|
How to communicate the javaServlet to .net webserver. How to implement the Webserver in my project ? Ple anybody help me.
|
|
|
|
|
you can use screen scraping or SOAP protocol 
=============
NITIN SAWANT
=============
|
|
|
|
|
|
I have no idea.. Tell me which one is best
|
|
|
|
|
i believe SOAP is best if u want to communicate between java and .net websites
=============
NITIN SAWANT
=============
|
|
|
|
|
SOAP(Simple Object Access Protocol) means Web service that communicates using XML soap request and response objects. 
|
|
|
|
|
boopathiduraisamy wrote: Tell me which one is best
Hiring someone who knows what they are doing is probably best.
|
|
|
|
|
Hello,
I want to know whether API functions can be used in JavaScript.If possible then say any example.In JavaScript what is window.scheduler?.
Thank you
Sanuji
|
|
|
|
|
What do you mean by API functions ? If you mean the functions that, for example, C# or VB.NET would do in ASP.NET then the answer is definitely not ( and further, that if you did not know this, you should buy a basic book on your chosen platform and read it ).
You can use AJAX to make server calls with javascript.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks for your information.
|
|
|
|
|
I would not say "definitely not".
Its possible to develop an activex control that calls the API functions for you (on client side).
But I agree with you, that this possibilty should not be used on normal websites (user has to install that control, security issues,...).
In a "kiosk"-like webpage (running on a terminal) there I use this possiblity to
establish a phone connection with this javascript/activex combo.
Greetings
Covean
|
|
|
|
|
Check this out. I find it to be extremely peculiar and very frustrating. I've downloaded a few scripts to check all of the checkboxes in a form. All of them have had the same issue. When I have one value for a checkbox, the function to check all no longer works. When I have more than one value for the checkbox, it works. Take the code below as an example. If you click the "Check All" button, it's not working. Yet, take the line of HTML that has the checkbox, copy it to the line after, reload and click the button again. It will work! What kind of crazy voodoo is this? One checkbox value isn't valid or something?
<HTML>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
<!-- Begin
function checkAll(field)
{
for (i = 0; i < field.length; i++)
field[i].checked = true ;
}
function uncheckAll(field)
{
for (i = 0; i < field.length; i++)
field[i].checked = false ;
}
</script>
</head>
<body>
Here is the HTML:
<form name="myform" action="checkboxes.asp" method="post">
<b>Your Favorite Scripts & Languages</b><br>
<input type="checkbox" name="list" value="1">Java<br>
<input type="button" name="CheckAll" value="Check All" onClick="checkAll(document.myform.list)">
<input type="button" name="UnCheckAll" value="Uncheck All" onClick="uncheckAll(document.myform.list)">
<br>
</form>
</body>
</html>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
