Sangeetha

Question
Im using dreamweaver and my host is goddady
How I connect an Access Database Using File DSN and ASP/ADO?

Goddady help file said:
The purpose of the Windows file DSN (data source name) is to centrally store your database connection information. If you have many Web pages that require database access, this feature enables you to simply reference the path of the file DSN instead of having to provide the database connection details on every page.

For security reasons, the file DSN is kept in a sub-directory of your hosting content directory that cannot be viewed by anonymous Web users. The file DSN works with ASP and uses ADO to access a database. This directory is named "_dsn" and you can find it at the root of your hosting account.
What is a File DSN? - Help Center—Knowledge Base and FAQ

I have a database with two tables ( the name is listados.mdb and the tables are usuarios and propiedades)


The help center of goddady the following asp script but I need your help.

1.What i need to change in this script?
2.I need to put this script exactly in a asp page?
3. What more I need to do? Can you expline to me More Specific?

<%
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim db_server, dsn_name

dsn_name = "your_dsn_name"
fieldname = "your_fieldname"
tablename = "your_tablename"

sDSNDir = Server.MapPath("_dsn")

connectstr = "filedsn=" & sDSNDir & "\" & dsn_name

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open connectstr
qry = "SELECT * FROM " & tablename

Set oRS = oConn.Execute(qry)

if not oRS.EOF then
while not oRS.EOF
response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & " "
oRS.movenext
wend
oRS.close
end if

Set oRs = nothing
Set oConn = nothing

%>

Sangeetha

Ahhh, there we go, now we've got a specific question!

In DW, go to the "Applications panel", select the "Database" tab, and then click the + button (if it's greyed out that means you have to have an ASP page already open (and in the Site Definition window, under "testing server", you must have selected "ASP Vbscript")).

There are plugins to give build the connection string for you, but it goes like this, if you use the "custom connection string" option:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<<fullSystemPathToYourMDBFile>>;Mode=ReadWr ite|Share Deny None;Persist Security Info=True

You should be able to click "Test" while in the Custom Connection String dialog to verify that your path is correct.

Tips:
Your database should be in a subfolder of that site so that you can set the read/write permissions for it. Permission problems are the most common errors for database connections.

The first page in any folder should be named "default.asp". This way the server can find it automatically.

To add a recordset to an ASP page, open that page, and then expand the database in the Applications Panel, and the drag and drop it into the wysiwyg area of the page.