Home  Fees/Services  Access Examples  Programming Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
  File DSN Connection String Example
 Database Connection Using File DSN Method







Connect String to Access DSN

Connect String to OLEDB Provider for Jet

Database Connect String to Remote Database

ADO File-DSN Database Connection String

Access DSN-Less Connection String

SQL/Server ODBC Database Connection Method Example

OLE DB UDL Database Connection String Example

Connection Open Method String Example

Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013


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
'---------------
Conn.Open "FileDSN=your_file_DSN;" & _
                   "UID=username;" & _
                   "PWD=password;"

Where:



Are you just starting out on your quest for a database? Need some advice or someone to bounce ideas off of? We are here and will be happy to chat with you on the phone and discuss options to your situation. Visit our contact page and give us a call.

Are you looking for an MS Access template database? We have many for sale in our Access Template and Examples Software section.


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
rst.movefirst
response.write rst!sales_rep

'--------------

Where mysession is any name for the session.

When done with the recordset don't forget to close it:

Conn.close
set conn=nothing

 











A Blue Claw Database Design Article:

Repair Corrupted Access Table
 





Blue Claw Database Design Downloadable Tutorial:
Running Sum Query Method  





A Blue Claw Software Design Template:

Airline Reservations Database Template
 




Contact Information

Copyright 2000-2017 Blue Claw Database Design