hey im 2006 passed out.,im a trainee in asp platform.,
ive been provided windows authentication and i have a code showing error. could u please help me and i got this code from net only else u giv me a correct code to connect asp and sql2005
my code
<%
set con=server.CreateObject("ADODB.connection")
con.Open dsn="dsn_uma"
set rs=server.CreateObject("ADODB.recordset")
rs.Open "select * from xxtable",con,1,3
while(not rs.EOF)
for i=0 to rs.RecordCount
Response.Write rs(i) & ":"
next
Response.Write "<br>"
rs.MoveNext()
wend
%>
Please check this link http://www.frontpages-web-hosting.net/support/asp.access.database.connection.htm
Make sure your DSN is configured correctly and tell us the exact error msg if you still see errors.
No comments:
Post a Comment