Hi

I am experiencing a problem that I cant seem to work around. We are moving from a linux server to w2k advanced server. We have installed MySQL and MyODBC and set up a DSN.

The web site pages have been posted and the database has been setup and populated with data. In theory this should have worked at this point, and yet when the site is visited an asp is returned as follows:

Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /Menu.asp, line 683

Line 683 reads: <% If Not Recordset1.EOF Or Not Recordset1.BOF Then %><% if isnull((Recordset1.Fields.Item("ImageName").Value)) or (Recordset1.Fields.Item("ImageName").Value) ="" then%>

Recordset1 is coded as follows: set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_connRL_STRING Recordset1.Source = "SELECT * FROM tblMajorStory WHERE MakeArchive =0" Recordset1.CursorType = 3 Recordset1.CursorLocation = 2 Recordset1.LockType = 3 Recordset1.Open() Recordset1_numRows = 0

Executing the SQL query from the MySQL command prompt returns data.

This is where I am unsure where else to look. Therefore any help is greatly appreciated.

Thanks in advance

Graham