Ciao a tutti
ho sempre usato access.
Ora sto cercando di passare a MSSQL.
Ed ecco il primo problema:

Cerco di estrapolare un semplice dato

dim objconn as new oledbconnection ("Provider=Microsoft.Jet.OLEDB.4.0;Server=localhos t;Database=***;uid=***;pwd=***")
sub page_load (obj as object, e as eventargs)



dim objcmd_ver34dsmitnstcabe_anno_in_corso as new oledbcommand (" select * from elenco ", objconn)


dim read34dsmitnstcabe_anno_in_corso as oledbdatareader

objconn.open
read34dsmitnstcabe_anno_in_corso=objcmd_ver34dsmit nstcabe_anno_in_corso.executereader


dim eccotot_anno_in_corso as string


while read34dsmitnstcabe_anno_in_corso.read

If Not read34dsmitnstcabe_anno_in_corso("nome") Is System.DBNull.Value Then
eccotot_anno_in_corso = read34dsmitnstcabe_anno_in_corso("nome")
end if


response.Write(eccotot_anno_in_corso)
end while
read34dsmitnstcabe_anno_in_corso.close
objcmd_ver34dsmitnstcabe_anno_in_corso.connection. close()



end sub




</script>
ma mi da questo errore

Server Error in '/' Application.


Could not find installable ISAM.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM.

Source Error:

Line 18: dim read34dsmitnstcabe_anno_in_corso as oledbdatareader
Line 19:
Line 20: objconn.open
Line 21: read34dsmitnstcabe_anno_in_corso=objcmd_ver34dsmit nstcabe_anno_in_corso.executereader
Line 22:
mi date una mano?
grazie