Browse by Tags

• asp.net
• c#
• solution
• sql

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: solution, asp.net, c#, .net, access

 

02 May 2009
Solution to the “Format of the initialization string does not conform to specification starting at index 0.” Exception

You are probably using the wrong DbConnection class. If you are using Access then make sure you use OleDbConnection, not SqlConnection…and vice versa. Alternatively you could be referencing your MDB file wrong. Here’s the proper way: <connectionStrings> Read More...

2 Comments

Filed under: solution, c#, .net, sql, access