Creating a DSN-less Connection to a Datasource.

--- BEGIN CODE COPY HERE ---->
<%@ Language=VBScript %>
<%
' Dim the Recordset Object
Dim rsADO

' Define the Connection String From Above
ConnectionString = "<%=sConnection%>"

' Create the Object
Set rsADO = Server.CreateObject("ADODB.Recordset")

' Define the SQL Statement
' (REPLACE TABLENAME WITH THE TABLE NAME
' IN YOUR DATABASE)
Source = "SELECT * FROM TABLENAME"
	
' Open the Recordset 
rsADO.Open Source, ConnectionString

' Display the Fields Returned 
' (PUT YOUR FIELD NAMES WHERE FieldName1 and 
' FieldName2 Appear)
if not rsADO.EOF then
	Response.Write rsADO("FieldName1") 
	Response.Write rsADO("FieldName2") 
end if

' DeAllocate the Object to Free Server Memory
set rsADO = nothing
%>
<--- END CODE COPY HERE ----

Creating a DSN-less Connection to a Datasource.

Fields

Choose Your Data Type-This field is for selecting the type of database you are connecting to. Selecting the correct type is imperative.

Your Site's IP Address-Enter the Web IP of the customer's site

Database Location (Not Needed if SQL)-This field is for typing the location of the file on your site.
Be sure to type in the full path name, including sub directories, off your root directory.
Example: d:/IP Address/start database location here
If customer's database is in a databases directory and the database is contacts.mdb, you would type in databases/contacts.mdb in the field box.

SQL Server Name (SQL Only)-Enter the IP Address of the SQL server that the customer's database is on.

Database Name (SQL Only)-Enter the Database Name of the Customer's SQL database that you want to connect to

User Name-Enter the user name for the database that you are connecting to (Not needed if database is not password protected)

Password-Enter the password for the database that you are connecting to (Not needed if database is not password protected)