[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] MS Access Database via RaQ4 & Chilli Soft ASP

Please, replace the \ for / in the DBQ, TYPO replacing the path of an actual
database.
----- Original Message -----
From: "satan" <satan@xxxxxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Friday, May 25, 2001 2:40 PM
Subject: Re: [cobalt-users] MS Access Database via RaQ4 & Chilli Soft ASP


> Try a connection less DSN, i dunnot but it may work out :
> **********************************************************
> <html>
> <body>
> <%
> myDSN="Driver={Microsoft Access Driver
> (*.mdb)};DBQ=/home/Sites\sitemane\database\login.mdb"
> mySQL="select * from users"
>
> set conntemp=server.createobject("adodb.connection")
> conntemp.open myDSN
> set rstemp=conntemp.execute(mySQL)
> howmanyfields=rstemp.fields.count -1
> %>
>
> <table border="1">
> <tr>
> <td valign="top">---</td>
> <% 'Put Headings On The Table of Field Names
> for i=0 to howmanyfields %>
>        <td><b><%=rstemp(i).name %></b></td>
> <% next %>
> </tr>
>
> <tr>
> <% ' Now lets grab all the records
> do  while not rstemp.eof %>
> <td></td>
> <td><%=rstemp(0) %>
> </td>
> <td></td>
> <td></td>
> <td></td><td><%=rstemp(4) %>
>
> </td>
> </tr>
>
>
>    <%
>    rstemp.movenext
> loop
>
> rstemp.close
> set rstemp=nothing
> conntemp.close
> set conntemp=nothing
> %>
> </table></body></html>
> *********************************************
> This was working on my an other box than cobalt, and i think that it may
> work for you on unix if the system handle DSN connection without using the
> administrative server . You can always create the DSN yourself and use the
> same type of code.
>
> Stephen Gilbert
> ssatan@xxxxxxxxxxxxxxxx
>
> ----- Original Message -----
> From: "Gerald Waugh" <gerald@xxxxxxxxx>
> To: <cobalt-users@xxxxxxxxxxxxxxx>
> Sent: Friday, May 25, 2001 10:48 AM
> Subject: Re: [cobalt-users] MS Access Database via RaQ4 & Chilli Soft ASP
>
>
> > > [: Ok .. So I have searched the archives for a how to ..
> > Can't find .. How
> > > : does one use a MS Access Database with ChilliSoft on a
> > RaQ4?? .. Are
> > > : there any how to's? .. HELP! ]
> > >
> > http://pkg.nl.cobalt.com/howto/casp_access_howto.html
> >
> >
> > _______________________________________________
> > cobalt-users mailing list
> > cobalt-users@xxxxxxxxxxxxxxx
> > To Subscribe or Unsubscribe, please go to:
> > http://list.cobalt.com/mailman/listinfo/cobalt-users
> >
>
>
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>