Manage DSN - Revision history

WikiSysop at 15:03, 29 March 2012

2012-03-29T15:03:11Z

WikiSysop at 13:07, 21 September 2011

2011-09-21T13:07:49Z

WikiSysop at 13:07, 21 September 2011

2011-09-21T13:07:22Z

WikiSysop at 13:05, 21 September 2011

2011-09-21T13:05:00Z

WikiSysop at 13:17, 20 September 2011

2011-09-20T13:17:38Z

WikiSysop at 13:15, 20 September 2011

2011-09-20T13:15:29Z

WikiSysop: Created page with 'Data Source Names are textual strings used by application programs to reference data sources. ODBC data sources store information about how to connect to the indicated data provi…'

2011-03-15T17:52:50Z

Created page with 'Data Source Names are textual strings used by application programs to reference data sources. ODBC data sources store information about how to connect to the indicated data provi…'

New page

Data Source Names are textual strings used by application programs to reference data sources. ODBC data sources store information about how to connect to the indicated data provider (i.e. Microsoft SQL database).

'''NOTE:''' You must provide a unique identifier for each data source. In other words, the name that you select for your DSN (Data Source Name) must be unique. It may take up to one hour for changes to take effect.

 

'''Here’s how to create a DSN using the  Manage DSN Records application:''' 

 

You can create MSSQL, MySQL or MS Access Data Source Names using this tool however, before doing so you will need to upload the MS Access file to the server.

 

      i.  Click on the "Add" button. A Create popup window will become active on the right hand side. 

     ii.  Enter your Data Source Prefix (required). 

    iii.  Choose a database type from the drop-down menu.

    iv.  Choose a langauge: ASP or ASP.NET. form the drop-down menu.

    v.  Select an .mdb file from the databse drop-down menu (required). 

    vi. Click "Apply" to create new data source name

        Click" Cancel" to dismiss all chnages.

 

'''To Upload a database:'''

1. Click "Browse" in order to locate your file tat you wish to upload. 

2. Click "Upload" to upload the file. 

 

'''Here’s how to delete a DSN : '''

1. From the Available Data Source Names list, select the DSN you wish to delete. 2. Click the Remove button. 

[[Category:Setup]]

@@ Line 1: / Line 1: @@
 Data Source Names are textual strings used by application programs to reference data sources. ODBC data sources store information about how to connect to the indicated data provider (i.e. Microsoft SQL database).
@@ Line 5: / Line 6: @@
 <br>
-'''Here’s how to create a DSN using the "Manage DSN Records" application:'''<br>
+=Create a DSN Record=
 You can create MSSQL, MySQL or MS Access Data Source Names using this tool however, before doing so you will need to upload the MS Access file to the server.
-<br>
+#Click on the '''Add''' button. A Create popup window will become active on the right hand side.
 #Enter your Data Source Prefix (required).
 #Select a database type from the drop-down menu.
 #Select a language:ASP or ASP.NET. from the drop-down menu.
 #Select an .mdb file from the database drop-down menu (required).
-#Click on the "Apply" button to create new data source name.
+#Click on the '''Apply''' button to create new data source name.
-#Click on the "Cancel" button to dismiss all changes.
+#Click on the '''Cancel''' button to dismiss all changes.
 <br>
-'''To Upload a database:'''
+=To Upload a Database=
-#Click on the "Browse" button in order to locate your file that you wish to upload.<br>
+#Click on the '''Browse''' button in order to locate your file that you wish to upload.<br>
-#Click on the "Upload" button to upload the file.<br>
+#Click on the '''Upload''' button to upload the file.<br>
-'''Here’s how to delete a DSN: '''
+=Delete a DSN=
 #From the Available Data Source Names list, select the DSN you wish to delete.<br>
-#Click on the "Remove" button.
+#Click on the '''Remove''' button.
 [[Category:Setup]]

@@ Line 5: / Line 5: @@
 <br>
-'''Here’s how to create a DSN using the "Manage DSN Records application":'''<br>
+'''Here’s how to create a DSN using the "Manage DSN Records" application:'''<br>
 <br>

@@ Line 5: / Line 5: @@
 <br>
-'''Here’s how to create a DSN using the&nbsp; Manage DSN Records application:'''<br>
+'''Here’s how to create a DSN using the "Manage DSN Records application":'''<br>
 <br>
@@ Line 13: / Line 13: @@
 <br>
-#Click on the "Add" button. A Create popup window will become active on the right hand side.<br>
+#Click on the "Add" button. A Create popup window will become active on the right hand side.
-#Enter your Data Source Prefix (required).<br>
+#Enter your Data Source Prefix (required).
-#Choose a database type from the drop-down menu.
+#Select a database type from the drop-down menu.
-#Choose a language:ASP or ASP.NET. from the drop-down menu.
+#Select a language:ASP or ASP.NET. from the drop-down menu.
-#Select an .mdb file from the database drop-down menu (required).<br>
+#Select an .mdb file from the database drop-down menu (required).
-#Click the "Apply" button to create new data source name.
+#Click on the "Apply" button to create new data source name.
-#Click the "Cancel" button to dismiss all changes.
+#Click on the "Cancel" button to dismiss all changes.
 <br>
@@ Line 25: / Line 25: @@
 '''To Upload a database:'''
-#Click the "Browse" button in order to locate your file that you wish to upload.<br>
+#Click on the "Browse" button in order to locate your file that you wish to upload.<br>
-#Click the "Upload" button to upload the file.<br>
+#Click on the "Upload" button to upload the file.<br>
 <br>
-'''Here’s how to delete a DSN&nbsp;: '''
+'''Here’s how to delete a DSN: '''
 #From the Available Data Source Names list, select the DSN you wish to delete.<br>
-#Click the "Remove" button.<br> <br>
+#Click on the "Remove" button.
 [[Category:Setup]]

@@ Line 13: / Line 13: @@
 <br>
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i.&nbsp; Click on the "Add" button. A Create popup window will become active on the right hand side.<br>
+#Click on the "Add" button. A Create popup window will become active on the right hand side.<br>
+#Enter your Data Source Prefix (required).<br>
-&nbsp;&nbsp;&nbsp;&nbsp; ii.&nbsp; Enter your Data Source Prefix (required).<br>
+#Choose a database type from the drop-down menu.
+#Choose a language:ASP or ASP.NET. from the drop-down menu.
-&nbsp;&nbsp;&nbsp; iii.&nbsp; Choose a database type from the drop-down menu.
+#Select an .mdb file from the database drop-down menu (required).<br>
+#Click the "Apply" button to create new data source name.
-&nbsp;&nbsp;&nbsp; iv.&nbsp; Choose a language:&nbsp;ASP or ASP.NET. from the drop-down menu.
+#Click the "Cancel" button to dismiss all changes.
 <br>
@@ Line 31: / Line 25: @@
 '''To Upload a database:'''
-. Click "Browse" in order to locate your file that you wish to upload.<br>
+#Click the "Browse" button in order to locate your file that you wish to upload.<br>
+#Click the "Upload" button to upload the file.<br>
 <br>
@@ Line 39: / Line 32: @@
 '''Here’s how to delete a DSN&nbsp;: '''
-. From the Available Data Source Names list, select the DSN you wish to delete.<br> 2. Click the Remove button.<br> <br>
+#From the Available Data Source Names list, select the DSN you wish to delete.<br>
 [[Category:Setup]]

@@ Line 19: / Line 19: @@
 &nbsp;&nbsp;&nbsp; iii.&nbsp; Choose a database type from the drop-down menu.
-&nbsp;&nbsp;&nbsp; iv.&nbsp; Choose a langauge:&nbsp;ASP or ASP.NET. form the drop-down menu.
+&nbsp;&nbsp;&nbsp; iv.&nbsp; Choose a language:&nbsp;ASP or ASP.NET. from the drop-down menu.
 &nbsp;&nbsp;&nbsp; v.&nbsp; Select an .mdb file from the database drop-down menu (required).<br>

@@ Line 21: / Line 21: @@
 &nbsp;&nbsp;&nbsp; iv.&nbsp; Choose a langauge:&nbsp;ASP or ASP.NET. form the drop-down menu.
-&nbsp;&nbsp;&nbsp; v.&nbsp; Select an .mdb file from the databse drop-down menu (required).<br>
+&nbsp;&nbsp;&nbsp; v.&nbsp; Select an .mdb file from the database drop-down menu (required).<br>
 &nbsp;&nbsp;&nbsp; vi. Click "Apply" to create new data source name
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click" Cancel" to dismiss all chnages.
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click" Cancel" to dismiss all changes.
 <br>
@@ Line 31: / Line 31: @@
 '''To Upload a database:'''
-. Click "Browse" in order to locate your file tat you wish to upload.<br>
+. Click "Browse" in order to locate your file that you wish to upload.<br>
 . Click "Upload" to upload the file.<br>