Public Function TestNull() As String Dim SQL As String = "SELECT SET('NULL') from TIP" Dim oConn As New OleDbConnection(ConfigurationManager.ConnectionStrings("TIPWebEdits").ConnectionString) Dim oCommand As New OleDbCommand(SQL, oConn) Dim RetVal As String oConn.Open() RetVal = oCommand.ExecuteScalar oConn.Close() Return RetVal End Functionreports ON. This is my connection string.
<add name="TIPWebEdits" connectionString="Provider=VFPOLEDB.1;Data Source=|DataDirectory|\Tip_WebEdits\tip_webedits.dbc;NULL=NO" providerName="System.Data.OleDb" />