Category: Scripting

Scripting

CDONTS with ASP Part 3

Below is the code used in the cdontsmailreply.asp file and is really what makes all of this work. <!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN”> <html> <head> <title>Email Sent …
Scripting

CDONTS with ASP Part 2

A Sample User Interface for Sending Email Using CDONTS NewMail Object Note, however, that our sample user interface does not provide a means for the client to specify an …
Scripting

CDONTS with ASP Part 1

In this tutorial, we will learn how to send email from an Active Server Page using CDONTS (Microsoft Collaboration Data Objects for Windows NT Server). Although there are other …
Scripting

Microsoft SQL database connection strings

With DSN <% dbconn=”Provider=SQLOLEDB.1;UID=user;Password=password;Initial Catalog=DSNname;Data Source=IPaddressoftheSQLserver,PortNumber” %> OLE DB <% Set cnn = Server.CreateObject(“ADODB.Connection”) cnn.open “PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=mydatabasename ” %> With DSN <% Set Conn = Server.CreateObject(“ADODB.Connection”) Conn.open “DSN=DSNname;UID=user;PWD=password;DATABASE=mydatabasename” %> …
Scripting

Microsoft Access database connection strings

With DSN and no User ID/Password <% Set connectionToDatabase=Server.CreateObject(“ADODB.Connection”) connectionToDatabase.ConnectionTimeout=60 connectionToDatabase.Open”DSN=DSNname” %> VERY IMPORTANT! Make sure to insert the following line where you want to close the connection] <% …