Delphi & MS SQL Server 6.0

We are developing an application that will access data on MS SQL server 6.0. I
have set up the ODBC and BDE.

Delphi has no problems connecting in design mode -- with a TDatabase and/or
TTable objects. However when I run the application it frezes completely as
soon as I set Connect = True for TDatabase and/or Active = True for TTable.

I am sure that in time I will find the problem. But if someone has an answer
it will be well appreciated.