myhosting.com Knowledge Base - Database http://myhosting.com/kb/index.php?/category/59 en-us KnowlageBase RSS Generator Microsoft SQL http://myhosting.com/kb/index.php?/article/AA-00227 What is MS SQL Server?

MS SQL Server, also known as Microsoft® SQL, is a relational database management system (RDBMS) used to manage transactions between a client and a database. It receives SQL queries from a client, executes those queries against the database, and then returns the requested…]]> Wed, 19 Sep 2012 17:49:57 +0000 http://myhosting.com/kb/index.php?/article/AA-00227 DSN http://myhosting.com/kb/index.php?/article/AA-00226 How can I use my DSN?

You have to put the following two lines of code in your script to create a database connection using DSN.

Set myconn = Server.CreateObject("ADODB.Connection") myconn.open "dsn_name","",""

NOTES:

  1. DSN should be registered.
  2. dsn_name = U]]> Wed, 19 Sep 2012 17:49:49 +0000 http://myhosting.com/kb/index.php?/article/AA-00226 Access Database http://myhosting.com/kb/index.php?/article/AA-00225 How do I upload my Access database to the server?
    1. Create your files and save locally.
    2. Use our File Manager (located in Control Panel) or get a good FTP client, like FileZilla.
    3. Connect to your server using:
      • Host Name: ftp.domain_name.com or 168.144.xxx.xxx…]]> Wed, 19 Sep 2012 17:49:35 +0000 http://myhosting.com/kb/index.php?/article/AA-00225