No DSN access database (continued)

zhaozj2021-02-11  187

No DSN access database

Any ASP script to access the database must first turn on the database on the server, we have two ways: Establish a connection via DSN. No DSN is established

A DSN connection requires a server-based system administrator to set a DSN with an ODBC tool in the control panel, or use a third-party server component, let your ASP script establish a DSN by modifying the registry when needed. I will provide A DSN build component for download.

A DSN connection typically requires: DSN name, user name, password, for example we use user name "student", password "magic", establish a connection via DSN "Student":

1. SET CONNTEMP = Server.createObject ("adoDb.connection") 2. ConnTemp.open "DSN = student; uid = student; PWD = MAGIC" 3. Set Rstemp = ConnTemp.execute ("Select * from authors")

If we don't have DSN, what should we do? But we know that the file name (for example, Access, Paradox, FoxPro database) or data source name (for example, SQLServer database). There is a method, we don't want DSN to access the database Note that you must know the actual file path! For example: "c: /tsserver/account17/nwind.mdb". Fortunately, method server.mappath can return the address on the server.

1. SET CONNTEMP = Server.createObject ("AdoDb.Connection") 2. Cnpath = "DBQ =" & Server.mappath ("YourTable.mdb") 3. ConnTemp.Open "Driver = {Microsoft Access Driver (* .mdb )}; "& cnpath4. set RSTEMP = ConnTemp.execute (" Select * from authors ")

nwind.asp </ title> <body bgcolor = "# ffffff"> </ head> <% set convenTemp = Server.createObject ("adodb.connection")</p> <p>'No DSN is established to connect DSNTEMP = "driver = {Microsoft Access Driver (* .mdb)};" DSNTEMP = DSNTEMP & "DBQ =" & Server.MAppath ("nwind.mdb") Conntemp.Open DSNTemp' does not have to establish a connection with DSN</p> <p>SET RSTEMP = ConnTemp.execute ("Select * from customer '") HOWMANYFIELDS = RSTEMP.FIELDS.COUNT -1%> <table border = 1> <tr> <%' Put Headings on The Table of FIELD Namesfor i = 0 to hoWMANYFIELDS%> <TD> <b> <% = RSTEMP (i) .name%> </ b> </ td> <% next%> </ tr> <% 'now lets grab all the Recordsdo While Not Rstemp.eof%> <TR> <% for i = 0 to hoWMANYFIELDS%> <TD Valign = TOP> <% = rTemp (i)%> </ td> <% next%> </ tr> < % rstemp.movenextlooprstemp.closeset rTemp = NothingConntemp.closset ConnTemp = Nothing%> </ Table> </ body> </ html> The following is a typical Driver parameter value:</p> <p>{Microsoft Access Driver (* .mdb)} Driver = SQL Server; Server = 127.0.0.1 & nbs</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-4158.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="4158" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: <b>0.097</b>, SQL: <b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'UFU1E1JYfKDewWwAc9hb6PDoKzLKiVdtF5XPReOa94XoQa1vfL6b7uppVo0_2F2I_2B6GmGAZ09tIR5PS2dD4ZFG9Q_3D_3D'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>