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

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
>