Category: HotDocs Database Connections

SQL Adventures – Navigating PCLaw Billing Preferences From HotDocs

The answer to the question is “MatterInfoSpareLong2″.  After several hours of searching, calls to former PCLaw product managers and tech support directors, I got the answer I was searching for.  My odyssey had started with a simple request: “Produce a report that combines File details in Amicus Attorney with billing and receivables details in PCLaw.  Having presented a seminar on integrating Amicus Attorney and HotDocs, I thought it a simple matter to integrate HotDocs and PCLaw.

On the surface, it was easy.  In PCLaw there is a MattInf table that stores the Matter information.  You can use the MatterID from within HotDocs to query the SQL database and get file information.  On the MattInf table there is a ClientID that links to information on the primary client, allowing you to pull in client data. For current statistics, there is a MattBal that contains data on each file regarding account balance, receivables, billings etc.

Learn more ...

Database Connection – Vista64 and Windows7

Have you ever tried to add an Access database as a new “datasource” in Vista64 and Windows7? In most cases, you will go WINDOWS START -> Control Panel -> Administrative Tools -> Data Sources (ODBC).  When you click ADD, you will get SQL Native Client and SQL Server.  There will be NO opportunity to add Access or any of the OLDER data types.  These 32-bit datatypes are effectively banished from the system.  Quelle disaster!!!  Well we have a solution, one that is REAL EASY

The Source of the Problem

The problems is that the Data Sources (ODBC) is really limited to 64-bit drivers.  MS Access uses a 32-bit driver and so DOES not show up in the Administrative Tool.  Lucky for us, Windows stores all the old tools in a special legacy folder:  C:\Windows\SysWOW64.  Yes, WOW!!!!!  That could stand for “where is my OLD Windows” Who knows.  Here is how you get to the key file.

  1. Create Shortcut

    - Name: ODBC 32bit Admin

    - Path: c:\WINDOWS\SysWOW64\odbcad32.exe

  2. Launch shortcut and ADD Access database as a data source just as you would in the past.

Basha Search

Loading

Basha Network

Basha Product Sites