Cheap Domains, $1 .COM Websites! - Free .COM (or $1.99) on Many Products!
 
Only Minimal Purchase Req'd on Many Free/$1.99 .COM Offers.    And Our Sale Domains are Often Under $2 or $3/year with No Further Purchase Req'd.
 
Plus, almost ALWAYS 15% OFF Everything Not Already Discounted.    15% OFF Most Renewals too!      New: Business-Growth Website-Builders and Hosting!
 

 *ICANN fee adds 18¢ many domains; tas applies some areas.  Our $1 Website Builder with Free .COM is based on 12 months at $1/mo.   Multipile or "Stacked" discounts in same purchase often disallowed (may require separate transactions).  Click for details.

 
Cheap Domains Cheap Domain Names

  
Use Promo HDX for at least
Cheap .com
that's not already On Sale!*
 

Cheap Domains     $1 Websites     Free USA-based Sales/Support:  (800) 655-5512
 

.COM $7.64 (Promo: HDX) |  .NET $10.19  |  .SITE $2.99  |  .ORG $9.99  |  .INFO $4.99  |  .UK $7.64  |  .EU $6.79

Cheap Domains include FREE:  100 Email Addresses & Account, Full DNS Control, Domain Forwarding, Masking, Registrant-Change/Transfer, Monitoring/Alerts, Locking, Expiration Protection, More!

Cheap Domains - Find Yours Now:    
 
Most prices shown
use Promo Code: HDX.  This search function, and most product pages, display higher prices at first, but don't worry,  Discounts appear in Shopping Cart when Promo Code Entered    details

Free .COM Domains!   ...with many products...  

 $1 Website Instantly     Business Website Builder

 Most cPanel & Plesk Hosting    Some WordPress Packages

$1.99 .COM Domains   ...on much else, often including:

Many Email, Calendar, Storage Plans Powerful SSL Certificates, more!

 
Terms & Conditions Here.  Add a .COM to Cart to verify price if product description not specific.

 

 
 

 Cheap Website       Cheap WordPress Hosting        Cheap Website Builder - Easy, Instant!    
Cheap Dedicated Servers       Cheap Virtual Private Servers      
Blogcast and Podcast 

 
Cheap Domains | Availability Check:
 
  

Frequently Asked Questions

Help Center Search

Connecting to a Microsoft SQL Server Database Using ASP/ADO

Print this Article
Cheapest .COM
Last Updated: January 11, 2017 10:48 AM

This example describes using ASP/ADO to connect to a Microsoft SQL Server Database.

<%

'Sample Database Connection Syntax for ASP and SQL Server.

Dim oConn, oRs
Dim qry, connectstr
Dim db_name, db_username, db_userpassword
Dim db_server

db_server = "whsql01.mesa1.secureserver.net"
db_name = "your_dbname"
db_username = "your_dbusername"
db_userpassword = "your_dbpassword"
fieldname = "your_field"
tablename = "your_table"

connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr

qry = "SELECT * FROM " & tablename

Set oRS = oConn.Execute(qry)

Do until oRs.EOF
   Response.Write ucase(fieldname) & ": " & oRs.Fields(fieldname)
   oRS.MoveNext
Loop
oRs.Close


Set oRs = nothing
Set oConn = nothing

%>
Cheap Domain Names
 


Toll Free Technical Support from a USA Call Center, 24 hours a day, 365 days a year:    (800) 655-5512
 
Call us with any sales or support question.     Place Orders by Phone.    Our USA-based Help Desk speaks your language.
 

Call Centers located in the Greater Phoenix metro area and Central Iowa, USA.     Technical Support also available in Spanish   New to Us?  Get a free account in 60 seconds.


 

 

 $1 Cheap Domains   |   $1 Websites   |   Product Catalog   |   Sale Price FAQ   |   Help Pages   |   FAQ   |   Free Phone Support   |   Free WHOIS Lookup   |   My Cart   |   Login

 
ICANN fee of 18 cents [$0.18] may apply on some domain names.    Notice for .eu and some other registering inbound
domain transfers: WHOIS may show domain held under registry
Weiled Weast Domains and/or HostingDude.com.   Legal Agreements.

(https://legacy.hostingdude.com)
 

 


 

Copyright © 2003 - 2019  HostingDude, Inc.  All Rights Reserved.  No reprint or re-use without written authorization.