For anyone encountering the error:

'Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified '

I have found that under W98 with VFP6 and running PWS the following ASP code works fine:

strConn='myConnection'
set conn=server.CreateObject ('ADODB.connection')
conn.open strconn
set rst=server.CreateObject ('ADODB.recordset')
rst.open 'select * from cust',strConn,3

But having loaded VFP7 and the Windows OLEDB updates that are automatically put on at the same time, the above code breaks with the aforementioned error.

I have found that the first line must be replaced by:

>strConn='DNS=myConnection'

when everything works again!

Unfortunately when I upload this revised code to my ISP I find it does *not* work and I have to revert back again to the old code. Presumably my ISP has not (yet) had the same oledb updates thrust upon them like we poor mortals. Which makes maintaining files on my ISP's system a pain as I have to keep 2 versions of the ASP files - each with the different strConn variable.

Unless of course someone out there can advise how to get round the problem???

Thanks
Barry.