Reading a MS-Access table:

PYee · January 24th, 2005, 09:08 PM

Hello, I have an ASP page and would like to connect to a table in MS-Access and read from it. How do I do that?

Thanks in advance,
Peter

om_prakash · January 24th, 2005, 09:23 PM

Please check the following URL:

http://www.scit.wlv.ac.uk/~jphb/sst/asp/asp3.html

Om Prakash

PYee · January 24th, 2005, 09:41 PM

Thanks for your quick reply. I was actually thinking of using JS to do this. The reason is I have a scroller (in JS code) and would like to get the data from the MS-Access, then display them in the scrolling area.

om_prakash · January 24th, 2005, 10:13 PM

You have to read the data from the database as mentioned in the above example (Link), and then store the contents in a variable from server side script and assign this to a javascript scroller variable, which is used.

Om Prakash

PYee · January 24th, 2005, 11:06 PM

I really appreciated it. I got it to work!!!!!

Thanks again,
Peter

pallone · January 28th, 2005, 10:04 AM

Hi Peter,

I was wondering if you could share your code with us in the forum. You said you got it to work and I think everyone would like to see that.

Cheers,

Claudio

PYee · February 2nd, 2005, 11:08 AM

Pallone, absolutely!! But because of lot's of codes, I'll put a snippet of it.
<HEAD>
<%
    set Conn = Server.CreateObject("ADODB.Connection")
    Conn.ConnectionTimeout = 20
    Conn.Mode = 8
    Conn.Open "MyConnection"
    strSql = "select title1, description1, title2, description2,title3, description3 from specialAnnouncements "
    set Rec = Server.CreateObject("ADODB.RecordSet")
    ... and so on.. bla,blah

    Rec.Open StrSql
    if Not Rec.BOF then
        Do While Not Rec.EOF
%>
<SCRIPT LANGUAGE="JavaScript">

</script>
<%
   Rec.MoveNext
   Loop
   end if
  Rec.Close()
  Set Rec = Nothing
%>
</HEAD>

In my include js file, all it does is display a scrolling text and here are my code snippet that gets it from my ASP object:

var displayText = new Array()
displayText[0]='<div align="Left"><b>[u]<center><%=Rec("title3")%></center></u></b><br><%=Rec("description3")%></div><br>'+
              '<div align="Left"><b>[u]<center><%=Rec("title1")%></center></u></b><br><%=Rec("description1")%></div><br>'+
              '<div align="Left"><b>[u]<center><%=Rec("title2")%></center></u></b><br><%=Rec("description2")%></div>'

There you have it and thanks for Mr. Prakash's help.

pallone · February 2nd, 2005, 03:22 PM

Peter,

Thanks a lot.

I can now see how you are mixing javascript with asp. But what about scrolling the messages?? how do you that?

Cheers,

Claudio

PYee · February 3rd, 2005, 02:10 PM

Claudio,

I got the codes from here. http://javascript.internet.com/scrolls/

Peter

pallone · February 7th, 2005, 08:12 AM

thanks Peter :)