File Data Source Name String Method
File DSN string code is show below. These
connections can be used for Microsoft Access databases and many others.
Dim conn as DB.Connection
Dim rst as DB.Recordset
Dim sql as string
"UID=username;" & _
Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.
Do you and your clients need access to data on the Internet? We can create a secure system to match your requirements perfectly.
your_file_DSN = The File DSN you have setup using ODBC
connection in your control panel, or a DSN setup by the remote hosting company
who hosts your website, or your in house network support group.
username = the username you have
identified in the database, or the default 'Admin' username.
password = the password you have
setup in the database or nothing "Pwd=;" for no password.
'-------------- here we use the connection
sql = "select sales_rep, dollars from sales_by_rep_chart"
Set rst = Server.CreateObject(" DB.Recordset")
rst.Open sql, conn, 3, 3
Set Session("mysession") = rst
Where mysession is any name
for the session.
When done with the recordset don't forget to close it: