c/odbc again...

Just wondering… just tested the (NL) 2.60G version of odbc on our 2.60G database, but sometimes my ASP pages do not show any data at all. My simple code just reads some tables en displays this data. (not using any fancy stuff or dates … just plain and simple. but i’m just new to c/odbc :slight_smile: It uses 2 connections from my database… where i can have 1000 so that does not seem to be the problem… no error messages … the database just gives me no data at all… when i try do display data using a ‘do while recordset.eof’ it keeps running in a loop. all fields returned are blank. when i refresh the asp page it works again, but i get this every 2 / 3 refreshes… is this due to the unstable c/odbc or is it something else? the simple asp page : Set connection = Server.CreateObject(“ADODB.Connection”) connection.open “naviweb”,"","" Set Session(“NAVISION”) = connection sql = “SELECT * FROM Employee” Set rs = Server.CreateObject(“ADODB.Recordset”) rs.Open sql, connection Set Session(“NAVITEST”) = rs do while Not rs.eof response.write(rs.fields(1)) rs.Movenext loop rs.close set connection = nothing

Hi Willem, Please specify required field name instead of * in the query and then check it.