ASP ODBC Connection

In classic ASP we had the option to use odbc for connecting to the database. I had to use this in one of my project. I did not find any useful article on this.

Establishing ODBC connection for classic ASP

We can specify the odbc connection in ASP as shown below


cnn.ConnectionString = "DSN=OL-DSSL;UID=test;PASSWORD=test;"

This is how we can establish ODBC connection in the server where we are hosting the application


Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Test the connection