Home  Fees/Services  Access Examples  Programming Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
  UDL Data Link Connection
 ASP UDL DataLink Connection 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


UDL Data Link Tools Microsoft Activex Data Object

This example shows the method for the OLE DB Data Link database connection string.
Dim conn as DB.Connection
Dim rst as DB.Recordset
Dim sql as string
'---------------

Absolute path to the UDL file:
Conn.Open "File Name=UDL_filename.udl;"

Where:



Our Access Programmers work with clients all over the world through the Internet. See why we are the: the best Access programming company.

We also offer Microsoft SQL Server / Azure / Cloud database development through our programmer partnership with Jay McCormick and his team.


UDL_filename = The name of the Universal Data Link file as created below:

To create a Universal Data Link:

Create an empty text file using a text editor, such as notepad.  Save the file with a .udl extension.  Then, right click on the file and select Properties.  Fill in the connection specification fields.  Here is a snapshot of the 'connection' tab of the UDL connection properties editor screen:

UDL Database Connection Strings

'--------------  here we use the database 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:

How To Create Faster Access Databases
 





Blue Claw Database Design Downloadable Tutorial:
How To Perform Inventory Calculations (Multi-User)  





A Blue Claw Software Design Template:

Barcode-Device Inventory Database
 




Contact Information

Copyright 2000-2017 Blue Claw Database Design