How to connect Mysql Database Mingshui Xuanxuan in ASP CCTV.NET 2004-3-7, 2004-4-2 Correction
Take a while, finally complete the ASP and MySQL connections, feel, close-by this article to share with you.
There are two ways to find a lot of information, and there are currently two ways to connect: one is the use of components, more name is Mysqlx, but unfortunately $ 99. Second, use myodbc to connect, let's take a look at the second way.
Test platform:
Mysql 4.0 for radhat Linux (you can also use for Windows)
Windows 2003 Standard Edition Windows XP ENGLISH
First, install myodbc
1. Visit the website www.mysql.com and download myodbc, we use version 3.51.
2. Install myodbc to Windows running the downloaded myodbc-3.51.06.exe (file name varies from version varies), establish an ODBC connection entry: Control Panel - "ODBC Data Source, we can see it in user DSN There is already an item: myodbc3-test, pay attention to the right Driver {mysql ODBC 3.51 Driver} This parameter will be a connection word that is unable to connect as an ASP and database connections (CONECTION STRING). Add a "System DSN" selection dialog box, press the "Add" button on the right. At this time, you will let you choose a data source. Select MySQL ODBC 3.51 Driver. Press "End". At this time, a configuration dialog box will pop up: Data Source Name Data Source Name: The identifier of the DSN used in the program can be named casually. Host / Server Name (or IP) Host / Server Name (or IP address), if you fill in the localhost database name database name: You want to use the library name used in the program. User User: Log in to MySQL Username, especially note, root users can log in to this machine due to security issues, of course, users can remove this function by modifying the user table. Password key: Login password port port: Using the default value, it is best not to change unless you are grasp. After all set it, press the "Test Data Source" will see the screen display successfully. The configuration is all set! ^ _ ^ II, the connection of the ASP and database is the source code I have tested, connected to MySQL, the library name is mm, the table name is MY, and there are two fields Name and SEX.
mysql connection test </ title> <meta http-equiv = "content-type" content = "text / html; charSet = GB2312> </ head> <body> <% strconnection = "DSN = mysqltest; driver = {mysql odbc 3.51 driver}; server = fill in server address; UID = username; PWD = password; database = mm" connection string, DSN is the data source identifier we set Driver we just mentioned when setting the system DSN. The test found that DSN = mysqltest; it is already possible to connect the database normally, the reason is very simple to have worked in the ODBC to complete the connection between MySQL.</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-24956.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="24956" 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.057</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 = 'lgmamtOv3Ym0sE0ap8GY7qJdOGU6EYTJzNgHJ_2BvBmGVB44qoSDaRpaTd9i4nr3y6EtVbdrctVNnGirWc2ppibg_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>
