Difference between revisions of "Main Page"

From Hostek.com Wiki
Jump to: navigation, search
(Start Here)
Line 1: Line 1:
__NOTOC__
+
This wiki article will show how to Manage the DSN's for your domains using WCP.
== About This Site ==
+
<br /><br />
  
Welcome to the Hostek.com wiki based knowledge base for Hostek.com customers. 
+
=What is a Data Source Name (DSN)?=
  
Keeping with the nature of a great wiki, anyone can read articles and comments and any Hostek.com customer can create new articles and update existing ones. NOTE:  This is not the place to ask a question.  Since a customer can create/edit, some of the articles may be incomplete or incorrect; but that doesn't mean that it will stay that way very long. So if you are a customer and find a mistake, feel free to correct the mistake.
+
'''DSN''' - The '''Data Source Name''' is a data structure that contains information about a specific database that an ODBC, JDBC and OLE driver can use in order to connect to it.  
  
== Start Here ==
+
This is an alternative option for those that don't want to specify the Database connection information to pass through their code.
 +
<br /><br />
  
Get some help by browsing the categories here:
+
=Navigating to DSN settings=
  
<!--div style="column-count:4;-webkit-column-count:4;-moz-column-count:4;"-->
+
<ol style="list-style-type: decimal;">
{| width="100%" align="left" style="background: #fdfdfd; border: 1px solid #eee; padding: 1em;"
+
<li>First login to your WCP control panel for the account the domain is under: https://wcp.hostek.com
|-
+
<br />
| '''General'''
+
[[file:wcp_url_secure.png]]
| '''Shared Hosting'''
+
<br /><br />
| '''Email'''
+
<p>If you have any issues with logging into WCP then please see our tutorials on [[Forgot_WCP_Password|recovering your password]] if necessary</p></li>
| '''Databases'''
+
| '''VPS / Virtual Servers'''
+
|-
+
| &bull; [[:Category:Getting Started|Getting Started]]
+
| &bull; [[:Category:ColdFusion|ColdFusion]]
+
| &bull; [[:Category:SmarterMail|SmarterMail]]
+
| &bull; [[:Category:Databases-MySQL|MySQL]]
+
| &bull; [[:Category:VPS|VPS]]
+
|-
+
| &bull; [[:Category:Tutorials|Tutorials]]
+
| &bull; [[:Category:Linux|Linux]]
+
| &bull; [[:Category:Configuring-Email-Clients|Configuring Email Clients]]
+
| &bull; [[:Category:Databases-MSSQL|MS SQL]]
+
| &bull; [[:Category:ColdFusion-VPS|ColdFusion VPS]]
+
|-
+
| &bull; [[:Category:Control-Panels|Control Panels]]
+
| &bull; [[:Category:Railo|Railo]]
+
| &bull; [[:Category:Databases-Access|MS Access]]
+
| &bull; [[:Category:Linux-VPS|Linux VPS]]
+
|-
+
| &bull; [[:Category:Domain-Names|Domain Names]]
+
| &bull; [[:Category:Windows|Windows]]
+
| &bull; [[Dedicated-Email-Server|Dedicated Email Server]]
+
|
+
| &bull; [[:Category:Railo-VPS|Railo VPS]]
+
|-
+
| &bull; [[:Category:Sales|Sales]]
+
| &bull; [[:Category:Resellers|Resellers]]
+
| &bull; [[:Category:Misc-Email|Misc Email Items]]
+
|
+
| &bull; [[:Category:Windows-VPS|Windows VPS]]
+
|-
+
| &bull; [[:Category:Billing|Billing]]
+
|
+
| &bull; [[:Category:cPanel-Mail|cPanel Mail]]
+
|
+
| &bull; [[:Category:Email-VPS|SmarterMail VPS]]
+
|-
+
| &bull; [[:Category:Infrastructure|Infrastructure]]
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|}
+
  
== Contribute ==
+
<br />
  
If you would like to contribute to this wiki, please first search and make sure the content does not already exist.
+
<li>Once logged into WCP if you have multiple domains you may need to select the appropriate domain to manage using the ''''Hosted Domains'''' drop-down in the top-right of the page as shown in the screenshot below:
 +
<br />
 +
[[file:wcp_change_domain.png]]
 +
<br /><br />
 +
</li>
  
If the content does not exist, login using your cp.hostek.com login information.
+
<li>Now click on the icon labeled ''''DSN'''' under the '''Databases''' section</li>
 +
<br />
 +
[[file:DSN_button.png]]
 +
<br /><br />
  
Please follow the policies and guidelines when adding or editing an article. Thank you for contributing and sharing your knowledge with the rest of us.  
+
<li>You should now see a list of available DSN Connetions currently configured your the specified domain.</li>
 +
<br />
 +
[[file:DSN_List.png]]
 +
<br /><br />
 +
</ol>
  
NOTE:  This is not a place to add spam or to try to promote your business. Any user doing such will be banned from editing/contributing.
+
==Creating a DSN==
 +
In the above section, we covered how to log in and view your current DSN's. We will now proceed with creating a new DSN.
 +
<br /><br />
  
 +
<ol>
  
==Official Guides==
+
<li>On the DSN panel click on the click on the ''''Add'''' option as shown in the screenshot below:</li>
* [http://en.wikipedia.org/wiki/Wikipedia:How_to_edit_a_page Quick Guide]
+
<br />
* [http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide WikiMedia User's Guide]
+
[[file:DSNoutline.png]]
 +
<br /><br />
 +
 
 +
<li>Now click the Database type you wish to connect to per screenshot below:</li>
 +
<br />
 +
[[file:Databasetypes.png]]
 +
<br /><br />
 +
 
 +
<li>Next click on ''''ADD'''', then proceed to fill out the required information (Database Usernames and Passwords must match the existing user) as shown in the screenshot below:</li>
 +
<br />
 +
[[file:Databaseinformation.png]]
 +
<br /><br />
 +
 
 +
<li>Now you should see a message stating the DSN was successful and the connection was successful.</li>
 +
<br />
 +
[[file:DSNcreated.png]]
 +
<br /><br />
 +
 
 +
</ol>
 +
 
 +
==Editing a DSN==
 +
In the above section, we covered how to create a DSN using WCP. Now we will review how to update your DSN information.
 +
 
 +
<ol>
 +
 
 +
<li>In WCP click on the ''''DSN'''' option as shown in the below screenshot:</li>
 +
<br />
 +
[[file:DSN_button.png]]
 +
<br /><br />
 +
 
 +
<li>Now click on the Pencil Icon located to the left of the DSN you wish to update as shown in the screenshot below:</li>
 +
<br />
 +
[[file:DSNedit.png]]
 +
<br /><br />
 +
 
 +
<li>Update the connection to the new information required for the DSN to connect properly </li>
 +
<br />
 +
[[file:Databaseinformation.png]]
 +
<br /><br />
 +
 
 +
<li>Now that you have made the nessary chages to the DSN click on ''''Save'''' and verify that the Green ''''Data Source Updated'''' bar is dispalyed.</li>
 +
<br />
 +
[[file:DSNupdated.png]]
 +
<br /><br />
 +
 
 +
 
 +
===DSN Common issues===
 +
<br />
 +
 
 +
If you receive a red connection error when setting the DSN information to ensure that the proper user credentials are being set. If the issue persists after verify your information please contact us at [email protected]
 +
 
 +
Additionally, if you are setting up an ACCESS database on a shared  WCP will display a red error with failing to connect to the database. Please ensure that an .LDB file does not  exist in your file structure.
 +
 
 +
 
 +
[[Category:WCP (Windows based Control Panel)]]
 +
ia User's Guide]
 
* [http://meta.wikimedia.org/wiki/Help:Editing MediaWiki editing help]
 
* [http://meta.wikimedia.org/wiki/Help:Editing MediaWiki editing help]

Revision as of 21:34, 24 August 2017

This wiki article will show how to Manage the DSN's for your domains using WCP.

What is a Data Source Name (DSN)?

DSN - The Data Source Name is a data structure that contains information about a specific database that an ODBC, JDBC and OLE driver can use in order to connect to it.

This is an alternative option for those that don't want to specify the Database connection information to pass through their code.

Navigating to DSN settings

  1. First login to your WCP control panel for the account the domain is under: https://wcp.hostek.com
    Wcp url secure.png

    If you have any issues with logging into WCP then please see our tutorials on recovering your password if necessary


  2. Once logged into WCP if you have multiple domains you may need to select the appropriate domain to manage using the 'Hosted Domains' drop-down in the top-right of the page as shown in the screenshot below:
    Wcp change domain.png

  3. Now click on the icon labeled 'DSN' under the Databases section

  4. DSN button.png

  5. You should now see a list of available DSN Connetions currently configured your the specified domain.

  6. DSN List.png

Creating a DSN

In the above section, we covered how to log in and view your current DSN's. We will now proceed with creating a new DSN.

  1. On the DSN panel click on the click on the 'Add' option as shown in the screenshot below:

  2. DSNoutline.png

  3. Now click the Database type you wish to connect to per screenshot below:

  4. Databasetypes.png

  5. Next click on 'ADD', then proceed to fill out the required information (Database Usernames and Passwords must match the existing user) as shown in the screenshot below:

  6. Databaseinformation.png

  7. Now you should see a message stating the DSN was successful and the connection was successful.

  8. DSNcreated.png

Editing a DSN

In the above section, we covered how to create a DSN using WCP. Now we will review how to update your DSN information.

  1. In WCP click on the 'DSN' option as shown in the below screenshot:

  2. DSN button.png

  3. Now click on the Pencil Icon located to the left of the DSN you wish to update as shown in the screenshot below:

  4. DSNedit.png

  5. Update the connection to the new information required for the DSN to connect properly

  6. Databaseinformation.png

  7. Now that you have made the nessary chages to the DSN click on 'Save' and verify that the Green 'Data Source Updated' bar is dispalyed.

  8. DSNupdated.png


    DSN Common issues


    If you receive a red connection error when setting the DSN information to ensure that the proper user credentials are being set. If the issue persists after verify your information please contact us at [email protected]

    Additionally, if you are setting up an ACCESS database on a shared WCP will display a red error with failing to connect to the database. Please ensure that an .LDB file does not exist in your file structure. ia User's Guide]