I am setting up hotdocs 2006 with microsoft sql server 2000 to connect to my tm7e system. In the database editor, you can specify connection properties defined by an ado connection string or an ODBC data source, and further specify simple command type or a user definded setting.
Which would be the recommended settings? From the hotdocs book it appears that the ado connection string is preferred but it does work both ways.
You will want to use an ADO connection string as it is much more reliable, is the latest Microsoft technology and offers you the greatest control over the connections. It is also controlled at the component file level as opposed to at the machine level so it is much easier to maintain.
Mark Deal (CIC/Moderator)Document & Data Solutions, LLCTMTools, LLCAtlanta, Georgiahttp://firstname.lastname@example.org(770) 888-1940Time Matters | HotDocs | PCLaw | TMTools | DDSLink | Worldox