Jul
07
This example describes using File DSN and ASP/ADO to connect to a MySQL Database.
Connecting to a MySQL Database Using File DSN and ASP/ADO
This example describes using File DSN and ASP/ADO to connect to a MySQL Database.
<%
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim db_server, dsn_name
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim db_server, dsn_name
dsn_name = “your_dsn_name”
fieldname = “your_fieldname”
tablename = “your_tablename”
sDSNDir = Server.MapPath(“_dsn”)
connectstr = “filedsn=” & sDSNDir & “” & dsn_name
Set oConn = Server.CreateObject(“ADODB.Connection”)
oConn.Open connectstr
qry = “SELECT * FROM ” & tablename
Set oRS = oConn.Execute(qry)
if not oRS.EOF then
while not oRS.EOF
response.write ucase(fieldname) & “: ” & oRs.Fields(fieldname) & ”
”
oRS.movenext
wend
oRS.close
end if
Set oRs = nothing
Set oConn = nothing
%>
Related posts:
- How do I export a MySQL Database?You have two options when exporting your MySQL database. You can either export the entire database, or export selected tables of a database, to a file. To Export the Complete Database Log in to your Account Manager. In the My Products section, select Hosting. Next to the hosting account you want to modify, click Manage [...]...
- 10 tips in choosing a good ASP hosting company the world of internet application, solutions are greater than products. Individuals and companies are still investing in web technologies, but they are investing in solutions with demonstrated benefits. If you are looking for top-notch ASP hosting solutions that helps you to deliver quick productivity and profitability, you need the necessary hosting foundation and ASP tools [...]...
- ASP.net hosting and SQL hosting providerASP.net hosting and SQL hosting provider, DiscountASP.NET, has deployed SmarterTrack customer service software to deliver customer support Ticketing, and Knowledge Base articles, among other services, to all of its customers. SmarterTrack brings all the functionality of a Help Desk, Ticket system, Live Chat, WhosOn, cost analysis, data mining, reporting, and a Knowledge Base in one application, all delivered through an elegant Web interface. Thanks in part to its unique ability to automate and extend to external databases and applications, SmarterTrack can effectively replace multiple applications and services, such as LivePerson, Bold Chat, Provide Support, Crystal Reports, Kayako, and more - saving money, time, overhead, and integration costs. Jeff Hardy, vice president of business operations at SmarterTools remarked, SmarterTools is very pleased that DiscountASP.NET has adopted SmarterTrack as a customer service solution for its customers. DiscountASP.NET has a well-earned reputation for quality and service and we are proud that they trust the complete SmarterTools lineup to deliver that value to their customers. DiscountASP.NET delivers email via the SmarterMail mail server, Web site statistics via the SmarterStats Web analytics tool, and sales and technical customer support via SmarterTrack customer service software. Takeshi Eto, VP Marketing and Business Development for DiscountASP.NET remarked, We found our previous customer service solution to be very inflexible and limiting in comparison to SmarterTrack. DiscountASP.NET had already migrated to the SmarterMail mail server and SmarterStats Web log analytics packages from SmarterTools and we were very happy with those results. SmarterTools has delivered on all counts and SmarterTrack has exceeded our expectations.Founded in 2003, SmarterTools Inc. is an information technology-management software company based in Phoenix, Arizona. SmarterTools builds a Windows mail server, customer service software, and a Web log analytics reporting tool that simplify and automate the day-to-day IT operations of businesses and hosting environments in over 100 countries. Additional information about SmarterTools Inc. and the SmarterTools product line is available at the company Web site: www.smartertools.com. DiscountASP.NET is a Microsoft Windows-based shared hosting provider, focused on providing the best value in ASP.NET and SQL database hosting. DiscountASP.NET was one of the first hosts to launch Windows 2008 hosting and SQL 2008 hosting. Through strong word-of-mouth and their commitment to ASP.NET and SQL technology, DiscountASP.NET has become the choice for affordable enterprise-class ASP.NET web hosting....
- Top US ASP.NET HostsAre you looking for United States based ASP.NET Hosting or ASP.NET Web Hosting? Your US ASP.NET Hosting search is over! We select some of the Best US Windows hosts specialized in ASP.NET Hosting Services and offering Shared ASP.NET Hosting, VPS ASP.NET Hosting, Dedicated ASP.NET Hosting and Reseller ASP.NET Hosting. We believe that choosing a reliable [...]...
- Top ASP.NET Reseller Hosts Are you looking for ASP.NET Reseller Hosting or Windows Reseller Web Hosting? Your ASP.NET Reseller Hosting search is over! We select some of the Best Windows Reseller Hosts specialized in ASP.NET Reseller Hosting Services. Below are our Top Reseller ASP.NET Hosts recommended list!...
- تحميل برنامج محول الصوتيات Switch Audio File Conversionتحميل برنامج محول الصوتيات Switch Audio File Conversion Operating Systems:Windows Vista, Windows Me, Windows XP, Windows NT, Windows 2000, Windows 98 Additional Requirements: Windows 98/Me/NT/2000/XP/2003...
- Youtube Video File Downloader 1.0.0.7 Download freeYoutube Video File Downloader 1.0.0.7 Download (2.74MB)Last Updated: 2008-11-03License: Freeware Free OS: Windows XP, 2000, NT...
- LimeWire 5.1.2 file-sharing application for all types of computer filesLimeWire is the worlds fastest P2P file-sharing application for all types of computer files, including music, video, pictures, games, and text documents. Other features include dynamic querying, file previews during download, advanced techniques for locating rare files, and an easy, clean user interface....
113 views
