Databases Archives - Nitesh Kejriwal

01/03/2016 by Nitesh

Solution: The certificate chain was issued by an authority that is not trusted

Friends, Recently, I migrated a website hosted on Azure to a shared hosting server and started getting connectivity error for SQL server. The error was – The certificate chain was issued by an authority that is not trusted After some research, I found that the error occurs when we do not have a CA signed…

02/02/2015 by Nitesh

Connect Access 2007-2010 Database In C#

Friends, In this post, we will see how can we connect Access 2007-2010 database in C#. As we know Microsoft introduced new Access format from Access 2007 onwards (.accdb extension), we cannot use the default JET.OLEDB provider that we used to use before. With the new database, Microsoft also launched a new provider namely ACE.OLEDB…

14/01/2015 by Nitesh

How To INSERT Values Explicitly in Identity Column in SQL

Friends, In this post, we will see how can we insert explicit values in an Identity column in a table in SQL Server. Normally, the data in IDENTITY column should not be entered manually, but there are certain circumstances where you want to insert custom data in the IDENTITY column. If you try entering data…

14/01/2015 by Nitesh

Solution: ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine

Friends, While working with Access, many times you may get the famous exception “Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine“. This normally happens that your code runs fine on your development machine and when you try the run it on production server, this error comes. IN this post, we will see a solution…

09/01/2015 by Nitesh

Solution : Oledb Exception – No value given for one or more required parameters

Friends, In this post, we will see solution to an error that occurs when using OleDbConnection classes to connect with Access database. The exception says – “No value given for one or more required parameters”. This can occur while inserting, selecting, updating or deleting data in Access database. The common problems to this error are…