dBase-III with ASP 2

[jcbr]

Hello, I am trying to set up an asp site using dBase-III. Any ideas on how to do this? This is what I currently have...

Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.Open "DSN=Custmast"
Set rsCustmast=Server.CreateObject("ADODB.Recordset&quot
lsQuery="SELECT CUST_NAME FROM Custmast.dbf"
Set rsCustmast=objConn.Execute(lsQuery)


Also, does anyone know how many users can access the web page. I know that Access only lets ~64 users on before it crashes.
Thanks!

 

[foxbox]

you're almost there:

your recordset rsCustmast has the result of the IsQuery. Now you need a loop:


while not rsCustmast.eof
response.write rs(0) & &quot;<br>&quot; ' = CUST_NAME
rsCustmast.movenext
wend

BTW: i had major troubles UPDATING a dBASE file (the famous updateable query error). INSERTING was no trouble (so nothing wrong with my permissions).

br
Gerard
(-:

Better a known bug then a new release.