There are about a million [ OK, slight exaggeration 
] settings that must be just right for your Clarion For Windows compiled program to successfully connect to a running MS-SQL 2005 database.
I have posted some things to check that should help you get configured and connected at…
As I get more time, I will add to the page. Getting all the settings and configurations correct can be a task.
Enjoy.
