a beginner unable to retrieve data from database
-
hello friends, i m fairly new to ASP. i installed PWS thur windows 98 cd on windows 98 OS. now i m tyring this code <% set cn=server.createobject("adodb.connection") cn.open "c:\inetpub\wwwroot\myprog\vbquiz.mdb" set rs=cn.execute "select * from quiz" rs.movefirst do while not rs.eof Response.write rs("quizid") rs.movenext loop %> but nothing is displayed. my PWS is on. but while i installed PWS thr was one error MTS not installed properly. is the problem related to MTS or m i wrong somewhr. please do help me. i ma beginner.
-
hello friends, i m fairly new to ASP. i installed PWS thur windows 98 cd on windows 98 OS. now i m tyring this code <% set cn=server.createobject("adodb.connection") cn.open "c:\inetpub\wwwroot\myprog\vbquiz.mdb" set rs=cn.execute "select * from quiz" rs.movefirst do while not rs.eof Response.write rs("quizid") rs.movenext loop %> but nothing is displayed. my PWS is on. but while i installed PWS thr was one error MTS not installed properly. is the problem related to MTS or m i wrong somewhr. please do help me. i ma beginner.
-
hello friends, i m fairly new to ASP. i installed PWS thur windows 98 cd on windows 98 OS. now i m tyring this code <% set cn=server.createobject("adodb.connection") cn.open "c:\inetpub\wwwroot\myprog\vbquiz.mdb" set rs=cn.execute "select * from quiz" rs.movefirst do while not rs.eof Response.write rs("quizid") rs.movenext loop %> but nothing is displayed. my PWS is on. but while i installed PWS thr was one error MTS not installed properly. is the problem related to MTS or m i wrong somewhr. please do help me. i ma beginner.
Your connection string isn't sufficient - try this: strConnect= "Provider=Microsoft.Jet.4.0;Data Source=c:\inetpub\wwwroot\myprog\vbquiz.mdb" strCmd="SELECT * FROM quiz" Set cn=server.createobject("adodb.connection") Set rs=Server.CreateObject("ADODB.Recordset") cn.Open strConnect Set rs=cn.Execute strCmd While Not rs.EOF Response.Write rs("quizid") & "
" rs.MoveNext Wend Heard in Bullhead City - "You haven't lost your girl -
you've just lost your turn..." [sigh] So true... -
hello friends, i m fairly new to ASP. i installed PWS thur windows 98 cd on windows 98 OS. now i m tyring this code <% set cn=server.createobject("adodb.connection") cn.open "c:\inetpub\wwwroot\myprog\vbquiz.mdb" set rs=cn.execute "select * from quiz" rs.movefirst do while not rs.eof Response.write rs("quizid") rs.movenext loop %> but nothing is displayed. my PWS is on. but while i installed PWS thr was one error MTS not installed properly. is the problem related to MTS or m i wrong somewhr. please do help me. i ma beginner.
<% Set cn = server.createobject("adodb.connection") Set rs = Server.CreateObject("ADODB.RecordSet") cn.open "Provider=Microsoft.Jet.4.0;Data Source= c:\inetpub\wwwroot\myprog\vbquiz.mdb" set rs = cn.execute("select * from quiz") rs.movefirst do while not rs.eof Response.write rs("quizid") rs.movenext loop %> good luck