hi all.
 I am a new user to asp.I am having problem in making a connection to the access file and its showing the following error:-

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" at line number 19

and i have written the connection code as follows i am not able to sort out the problem
<%
Option Explicit

    Dim objConn
    Dim strConn
    Dim objRS
    Dim strSQL
    Dim intTotalColumns
    Dim intCounter

    Const adOpenStatic = 3
    Const adLockReadOnly = 1

    Set objConn = Server.CreateObject("ADODB.Connection")
    Set objRS = Server.CreateObject("ADODB.Recordset")

    strConn = "DBQ=" & Server.MapPath("product.mdb")
    strConn = "DRIVER={Microsoft Access Driver(*.mdb)};" & strConn
    objConn.Open strConn

    strSQL = "SELECT * FROM prodtable"

    objRS.open strSql, objConn, adOpenStatic, adLockReadOnly


    intTotalColumns = objRS.Fields.Count - 1
%>

This is the wrong forum for this question since you are asking a classic ASP question but the answer is quite simple. Your connection string is invalid. You are missing a semicolon in this line and I have bolded where you need to add it:

strConn = "DBQ=" & Server.MapPath("product.mdb");

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========