Which driver to use

Hi All, I am working on a project where we need to update Navision database(SQL Server option) say from VB or ASP Pages. My question is which driver I can use/should be using among ODBC, C/FRONT and OLE DB Provider for SQL SERVER. I have tried to make connection to Navision Database (SQL SERVER) through OLE DB Provider for SQL SERVER. I was also able to retrieve and update data. Please suggest pros and cons of using different drivers or what driver I should be using. Regards, Devinder