hi
i am tryting to open an asp fie....coinencted with microsoft access...i have conected through control pannel...odbc shortcut.....but reciving following error...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/file19_2.asp, line 17
the code for asp file 19_2 is
<html>
<head>
<title>Active Server Pages</title>
</head>
<body >
<img src="logo.gif" height="50" width="500">
<center>
<%
Name = Request.Form("txtBookName")
Price = Request.Form("txtPrice")
Pages = Request.Form("txtPages")
Category = Request.Form("txtCategory")
Set objConn= Server.CreateObject("ADODB.Connection")
objConn.Open "ch19DSN"
thesql="insert into Books(Name,Price,Pages,Category)" &_
"values('" & Name & " ',' " & Price& " ', " &_
"'" & Pages& " ',' " & Category& " ')"
objConn.Execute(thesql)
%>
<font font="Arial" size="+2" color="magenta" >
<b><i>Your Book has been added <br>
List Of Books</b></i>
</font>
<%
Set objRs =Server.CreateObject("ADODB.Recordset")
objRs.Open "Books",objConn
Response.Write "<table border=1> "
Response.Write "<tr><td><b>BookCode</b><td><b>Name</b>" &_
"<td><b>Price</b></tr><td><b>Pages</b>" &_
"<td><b>Category</b>"
while not objRs.eof
Response.Write "<tr> "
Response.Write "<td>" & objRs.fields(0) &"<td>" & objRs.fields(1)&_
"<td>" & objRs.fields(2) &"<td>" & objRs.fields(3)&_
"<td>" & objRs.fields(4)
objRs.MoveNext
Response.Write "</tr> "
wend
Response.Write "</table> "
objRs.Close
objConn.Close
Set objRs= nothing
Set objConn = Nothing
%>
</center>
</body>
</html>
i am using IIS...asp files r working fine....
can anyone solve this problem....
by doing this ,u will really contribute in some good .....(smileeeeeee)
thanx a alot