Using Microsoft SQL Server

This discussion assumes that you have basic knowledge of Microsoft SQL Server and the client tools it uses to administer databases. It also assumes that you have a basic knowledge of ODBC scripting.

Through the SQL Administration area of the Control Panel, you are able to import existing SQL Server databases and create new ones, as well as set up a DSN (data source name) to access your database. The data source name will be the main avenue for communicating with our SQL Server when using a scripting language such as ASP or ASP.NET.

You can connect directly to our SQL Servers using Microsoft SQL Server Management Studio (included with SQL Server 2012 & 2014), or any other SQL Server management software that can connect using TCP/IP (including the freely available Microsoft® SQL Server® 2014 Express) to remotely and graphically access your database from your computer.

To connect to a SQL Server database from a Web page, you must use a scripting language such as ASP or ASP.NET. In your scripts, you will need to use a DSN or DSN-less connection string. A DSN connection string requires you to set up a DSN in the SQL Administration area. Once there, click on the "View Sample Connection String" link for a number of sample connection strings.

ColdFusion DSN's

All system data source names (DSNs) added through the DSN Administration or SQL Administration sections of your Control Panel are automatically set up as Windows system DSNs. Once you have added a DSN to your Control Panel it will take about 10 minutes before your DSN will be available for use with your ColdFusion code.

Note: When adding a SQL DSN you must remember that the username and password are not stored in the ColdFusion Administrator. Therefore you will need to supply the database username and password in your DSN connection string.

Was this answer helpful?

 Print this Article

Also Read

Set Up Aliased Nameservers

Aliased name servers allow our resellers to completely hide LFC Hosting from WHOIS lookups on...

Accessing Your Detailed Web Site Access Statistics

LFC Hosting offers nightly Web site statistical traffic analysis for all of your domain names....

Securing Your Site Using SSL

Secure Sockets Layer (SSL) is the standard for data encryption on the World Wide Web, allowing...

Setting up a permanent 301 redirect via .htaccess

A permanent 301 redirect in your .htaccess file lets search engines and others know that an old...

Using .NET Core

LFC Hosting fully supports Microsoft .NET Core 2.To enable .NET Core you need to configuration an...