Browse by Tags

02 May 2009
Solution to the “You tried to assign the Null value to a variable that is not a Variant data type.” Exception
By default the DataSource wizard passes parameters for AutoNumber primary keys. If you are getting this error: You tried to assign the Null value to a variable that is not a Variant data type. Then you need to remove that default parameter. This is what Read More...
1 Comments
Filed under: , , , ,
 
06 April 2009
Solution to “Operation must use an updateable query” Exception when writing to an Access Database from ASP.NET
Could be a couple of things: The file is marked as read-only. Right click on file, uncheck “read only”. The application pool identity doesn’t have write permissions to the folder that contains the MDB. Find the identity of the application pool (using Read More...
03 March 2009
The simplest DataSet to Excel solution
Tim Mackey has a very simple method for converting DataSets to Excel spreadsheets. http://tim.mackey.ie/HowtoExportADatasetToExcelCAspnet.aspx Thanks Tim! Read More...
1 Comments
Filed under: , , ,
 
06 March 2007
Solution to "is null or not an object" error with ScriptService
I just spent the last few hours trying to track down why I kept getting an "is null or not an object" error when setting up a service with a ScriptService attribute. I started my coding with a PageMethods implementation, but moved to a ScriptReference Read More...
Page view tracker