how can i link msSQL server with JSP? please send source code?
485440
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"\n"http://www.w3.org/TR/html4/loose.dtd">\n<html>\n<head>\n<title>Mr.Duke Is Back</title>\n<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\n</head>\n<body>\n<%\npublic void baglan(){\ntry {\nClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");\nconn=DriverManager.getConnection("jdbc:odbc:pass","pass","pass");\n }\n catch (Exception ex) {%><%\n \n out.print("alert()");\n %><%}\nString name=request.getParameter("name");\nString pass=request.getParameter("password");\nString sql="INSERT INTO pass (marka, tip, seri, fiyat, ekran)";\nsql +=" VALUES (N'"+name+"', N'"+pass+"')";\n%>\n<p align="center"><a href="register.htm" >Registration</a>   <a href="login.htm">Log In</a>   <a href="">Contact Us</a></p>\n<p align="center"> </p>\n<p align="center"><img src="duke_kahve_fincani.gif" width="96" height="112"></p>\n<p align="center"><font size="+3" color="#009933"><b>Disributor Network System</b></font> </p>\n<p align="center"><font size="+2" color="#009933"><b>Log In</b></font> </p>\n<form action="index2.htm">\n<table>\n<tr>\n<td>Name:</td>\n<td><input name="name" type="text" size="25"></td>\n</tr>\n<tr>\n<td>Password:</td>\n<td><input name="password" type="password" size="25"></td>\n</tr>\n</table>\n<p align="center">\n<input type="submit" name="Submit" value="Submit">   \n<input type="reset" name="Submit2" value="Reset">\n</p>\n</form>\n<a href="register.htm">New members click here!</a>\n<p align="center" > <img src="computerbanner.gif" width="400" height="70"></p>\n<p > </p>\n</body>\n</html>\n \n \n--------------------------------------------------------------------------------
109333
Hi, the link below may help. I sent an email to my actual programmer who can help for sure. I have not personally made the leap to how we actually serve our websites but its xhtml 1.1 and css served as an xml file. It may not require visual basic to do it but please don't quote me on that.
17938
Find a webhost with cPanel. or\n\nhttp://www.webmastertoolscentral.com/
438237
if you're dealing with ASP then i suggest you look out for sites giving you free source codes on that...\nwww.google.com and search for Free+ASP+Source+Code
1088795
Use SQLDMO and SQLDTS both are references for the SQL Server. But they should also work with Oracle. But it's a crazy thing. I just do it on an SQL Server and you get mad by solving all the errors you can get.\n\nHelmut\n\nP.S.: A good source to get a idea about it, download the SQL Samples and look for the Bulk Insert Task
482611
YEAH! Your question is easy because it's done all the time.\n\nI'll assume you have the database.\n\nFirst thing is your email template.  You can do this in the program or a better practice is to keep your emails either in a library or in separate files.  This males finding an email and changing it easier down the road.\n\nNext you write a program you bring the database and the email together like a maillist merge in wordprocessing.\n\nYou program will open the db, grab all the records you want to send the email to and for each one you\nll send the email message.\n\nNow the above is the logic to use no matter what type of server you are own.\n\nIf you are Apache with MySQL and PHP or a combo close then you'd use the MySQL connection your webhost setup as to how to acces it and Apache server email programs is usually SendMail.\n\nA combo of html and SendMail will be the email "code" part of your project.  The SendMail allows you to insert fields, the ones you'll pull from the database into the email.\n\nSo you can send mail with Dear John, etc...\n\nSendMail has greeting, salutaion, body sections which you can write as html or use scripting.  The trick is the receivers email must understand html and not block it and any scripting commands like Yahoo does.\n\nIf you're .NET the email namspace to learn more is System.Net.Mail, same logic applies, only thins has more stuff built in for you to play with.  The database or datasource can be Access, MSSQL, Oracle or MySQL and other dbs, it's Microsoft so more db makers are out there for the environment.\n\nNow, after you'd picked up the quick info on the command, you'll use save you fingers some headaches and go to a code site like CodeProject or DevSource and grab some free code doing emailing for the language and server you're using.  You may have to tweek the fields they'll use and of course your email not will be different.
1117893
The MSSQL server is a database, and if you didn't install it yourself it might have been installed as a requirement for some other software you installed. Has anything changed on the system - new installation or removal of software? Its probably not a problem, and it might cause more issues trying to remove it.
470920
I am assuming that the code - \nstrSQL = "SELECT * FROM tbl_Hardware WHERE Hardware_ID = 2" \n\nis in a <script language=vbscript> block....\n\nIf I am correct, then that part of the code will be available on the client side, whereas the code that you have in the <%%> block is a sever side code available on the server side.\n\nIf the value of strSql does not change on the client side then one way of doing this is\n\n<%\ndim sql\nsql = "SELECT * FROM tbl_Hardware WHERE Hardware_ID = 2" \n%>\n<script language=vbscript>\nstrSQL = <%=sql%>\n </script>\n<%\nSet rs = cnnLogin.Execute(sql)\n%>\n\nIf the Value of the strSQL changes on the client side, then you need to pass it back to the server on submit using some sort of hidden fields.\n\n-jainnys\nMind Experts Inc\nhttp://www.mindexp.com
1161694
If you are doing .NET work, have you looked in the machine.config to see what your connection string(s) is(are)?\n\nTake a look at this example:\n\n  <connectionStrings>\n    <remove name="LocalSqlServer"/>\n    <add name="MyDatabase" connectionString="data source=sql2k503.datamain.net;Initial Catalog=SQL20005_DB;User ID=Meuser; Password=abcdef" providerName="System.Data.SqlClient" />\n  </connectionStrings\n\nHope this helps, or at least points you in the right direction.
306322
Hi\n\nTOMCAT_HOME=C:&#92;tomcat\n\nTOMCAT_HOME&#92;webapps&#92;<CreateUrFolder>&#92;Put Your Jsp here\n\nExecute\n\nhttp://localhost:8080/CreateUrFolder/JSPName.jsp
1068037
Hi, that is kinda a weak answer :) \n\nUsually it is like this from JSP you produce HTML, and when you navigate to a LINK link like http://localhost /MyApp/MyMainServlet\nThe WEB.XML file will tell it where to navigate. For example:\n======================================\n<servlet>\n<display-name> MainControllerServlet </display-name>\n<servlet-name> MainControllerServlet </servlet-name><servlet-class> bankapp.web.MainControllerServlet </servlet-class>\n</servlet>\n<servlet-mapping>\n<servlet-name> MainControllerServlet </servlet-name>\n<url-pattern> /MainController.do </url-pattern>\n</servlet-mapping>\n======================================\n\nWhat the above xml descriptor does is that whenever I visit http://localhost/BankApp/MainContoller.do It will goto the ServletName called MainControllerServlet which points to the servlet class: bankapp.web.MainControllerServlet\n\nNotice that is inside the package bankapp.web, Now inside that servlet you have your doGet and doPost and your computational within the beans and other yummy stuff :)\n\nTO RUN!\nNow If your using Eclipse IDE as your main IDE, you could download JBOSS from www.jboss.org, and download the server and the eclipse addon. It is pretty straight forward and you just right click on the project and make a package xml and deploy it. What is does is that it will automatically deploy it to the webserver. And you access it by doing http://localhost:8080/BankApp/\n\nBUT if your not using that, you need to download Apache Tomcat\nhttp://tomcat.apache.org/\nWhat that does, it is a EJB/JavaBeans/JSP webserver. When you package your Servlet it will produce either .war or .ear dpending if its a EJB or a JavaBeans. In your case if it is JSP and Servlets, then it is only WAR. You place that War in htdocs within Tomcat and you navigate to http://localhost:8080/BankApp/\n\nBut now you tell me how do you package the whole thing to a war. That requires some practice, you need to read up on that \n\nIf you need more help let me know.\nTake care
1090052
http://www.java.com/en/download/manual.jsp
218597
http://www.jsptut.com/
725618
Hai Ritu,\n   Here you mentioned that you are connected to *.mdb, so it is not to a single database, like db1.mdb ?\n\nYou cannot  access lot of mdb's through a single dsn.\n\nIf this is not the  case, then you need to verify that the dsn you created is existing ? and it is the same as that you have mentioned in the programming.\n\nOne more thing is that you said you are working in an application, \nIs that a Web Application, later you said you are using JSP ?\n\nWhere did you receive these error messages ? \nIs it in the console(command prompt) or in the IE ?\n(This error may be also due to missing of library file also).\n\nIf you wish you can contact me\nfor more clarifications, send me a detailed description of what you need to know and if possible send me the code segment\nI will correct the necessary parts.\n\nemail: ananthasivanvk@gmail.com\ncell: +919995403653
354889
JSP best practices: Update your JSP pages with JSTL\nStandardized JSTL tags bring even more functionality to your Web pages\n  \n \n  Document options \n  Print this page\n \n  E-mail this page\n \n \n\nFree software for rapid results \n  Kick-start your Java apps \n \n \n\nRate this page \n  Help us improve this content\n \n \n\n \nLevel: Introductory\n\nBrett McLaughlin (brett@oreilly.com), Author, O'Reilly and Associates\n\n\n27 May 2003\n\nThe JSP Standard Tag Library (JSTL) is a collection of custom tags that enable many common Web site functions in a standardized format. In this installment of JSP best practices, Brett McLaughlin introduces JSTL and shows you how to convert your JSP pages to use its highly functional tags.\nOne of the strengths of JSP technology is its custom tag library facility. In addition to the core JSP tags such as jsp:include, the custom tag library facility lets you create unique tags to describe behavior that is specific to your site or application. Once you've created a custom tag library (taglib for short) you can reuse the tags as you extend your project or move on to other projects. You can also pass on your taglib to other developers for use on their sites or on different parts of your Web application. In a future installment of this series, I'll show you how to create your own custom tag library, but for now we'll focus on the JSP Standard Tag Library, or JSTL. \n\nJSTL is actually a collection of custom tag libraries that have been standardized for JSP 1.2. Many of the JSTL tags are analogous to the core JSP tags, although they do much more. For example, the c:import tag is very similar to the include and jsp:include directives we've worked with in the previous installments of this series (see Resources). Like includes, c:import helps you populate the pages of your Web site or Web application, but its functionality extends beyond what the core JSP tags can do. \n\nIn this installment of JSP best practices, we'll use the c:import tag to learn about converting a Web page from JSP to JSTL. Before we can begin working with the new tag, however, we need to load JSTL onto your Web container.\n\nJSTL setup\n\nWhile JSTL is expected to be bundled into the next wave of Web containers, you currently have to set it up for yourself. Follow these step-by-step directions to load JSTL onto your Web container:\n\nDownload jakarta-taglibs-standard-current.tar.gz from apache.org.\n\n\nExpand the downloaded archive.\n\n\nCopy jakarta-taglibs/standard-1.0.3/tld/c.tld to your WEB/INF/tlds directory. \n\n\nCopy all the JAR files in jakarta-taglibs/standard-1.0.3/lib to your WEB-INF/lib directory.\n\n\nAdd the entry shown below to your WEB-INF/web.xml deployment descriptor. \n     <taglib>\n       <taglib-uri>http://java.sun.com/jstl/core</taglib-uri>\n       <taglib-location>/WEB-INF/tlds/c.tld</taglib-location>\n     </taglib>\n \n\n\n\n\nRestart your Web container. \nThat's the crash-course version of the current JSTL setup, but in most cases it should be sufficient. See the Resources section if you need more detailed instructions.\n\n\n \n\n Back to top \n \n\n\n\nIncorporating JSTL tags\n\nIf you want to use any of the JSTL tags on a JSP page, you'll first have to declare the tag library prefix and URI on that page. We're using the core JSTL library, so the standard prefix to use is c (for core). Listing 1 shows a Web site index file with the taglib directive added to it:\n\n\nListing 1. The taglib directive for an index file\n\n<%@ page language="java" contentType="text/html" %>\n<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>\n<html>\n<head>\n     <title>newInstance.com</title>\n     <meta http-equiv="Content-Type" content="text/html; \n       charset=iso-8859-1" />\n     <link href="/styles/default.css" rel
971270
try these link baby..hope it work\nhttp://www.dizzay.com/dizzaymysql/index.asp
564243
How this even comes down to a dead heat is beyond me.\n\nIf you are going to code in ASP.NET 2.0, use Visual Web Developer Express. Otherwise, there's no contest: Dreamweaver is the vastly superior tool.