In this article, we learn, how to create DSN Connection in Dreamweaver.
Step.1
The first step in this is to create a system DSN. To create DSN you have to go to (Windows)
system’s control panel and then you have to go to “Administrative Tools” then “Data Sources
(ODBC)” then go to the “System DSN” TAB.
Then click ADD button and then choose the driver (Driver Do Microsoft Access) then click
finish. Now give a name for your DSN and then browse and select the “*.mdb” file (database
file) you want to use as the database to which the particular DSN name has to connect.
You need to define the DSN by clicking Define button on the DSN wizard window that appears
when you click to add “Data Source Name(DSN)” in Dreamweaver.
(If your new DSN does not appear in the list items, open the “Data Source Name(DSN)” wizard
once again from the database tab from the Application panel. you can find your new dsn
appearing in the list. (Forget not to define your DSN in the System DSN tab).
Step2.
Now, we need to link the newly created DSN in dreamweaver for our application devlopment.
For this, go to “Application” Panel and choose the Database tab. Click PLUS icon and choose
“Data Source Name (DSN)“.Select the “using Local DSN” Radio button. choose from the list of
System DSNs available on your system ( in this list you can find your newly defined DSN
too) then give a name for that connection. Now click “Test” (if there is password fill it
and the username).
If the DSN is connected Successfully, we get the message saying “Connection was made
Successfully“. Now you can make use of this DSN and create applications.
If the Test is not Success, it means there are some errors. We need to cross review each
steps we’ve done.
Learn how to create a DSN-less database connection in dreamweaver
No comments:
Post a Comment