How can I setup QODBC in Microsoft Excel, Microsoft Access or Crystal Reports?

Question

I am torn between deploying Microsoft Exchange 2016 and Linux-based SMTP servers like sendmail, postfix, qmail and exim. Relative ease of installation and configuration is an important consideration factor.

Microsoft Exchange 2016, Domain Controller, and Active Directory are relatively easy to install and configure. Linux-based SMTP servers are extremely difficult to install and configure and of course, extremely time-consuming.

One of the features of Microsoft Exchange 2016 is that you can create additional folders on your Inbox in the server (server-side). Can Linux-based SMTP servers do that?

Does Exchange 2016 offer more user-friendly features or Linux-based SMTP servers?

Besides the above considerations, how about security? Traditionally, Linux is far more secure than Windows. Judging by security, Linux-based SMTP servers ought to have a higher percentage of the market share?

Finally, I can only use Windows Server 2016 Standard Evaluation Copy FREE for a period of 3 years MAXIMUM. But I can use Linux servers and Mail Transport Agents (MTA) FREE perpetually.

Please share your opinion?

Answer 1

QODBC.com provides you detailed instructions to set up ODBC access to Microsoft Excel, Microsoft Access or Crystal Reports.

Will give you the details but it is very difficult to explain here so will provide you each:

For Crystal Reports: http://www.qodbc.com/intuit/setup/crystal.htm

For Microsoft Access: http://www.qodbc.com/intuit/setup/msaccess.htm

For Microsoft Excel: http://www.qodbc.com/intuit/setup/msexcel.htm