How to close SQL Server connection created by CDaoTableDef

Hi all,

Can some one instruct me of how i will make sure that the SQL Server 2000
connection i have created after call CDaoTableDef::Create and
CDaoTableDef::Append will be closed when i call to CDaoTableDef::Close.

for some reson the SQL connection i have created remain in SQL server.
In my code i create a link table to my SQL server using ODBC.

here are the parameters:
void CDaoTableDef::Create(LPCTSTR lpszName, long lAttributes,
LPCTSTR lpszSrcTable, LPCTSTR lpszConnect)
lpszName = 'Link_Provider'
lAttributes = 0
lpszSrcTable = 'Provider'
lpszConnect=
{"ODBC;APP=BOGUS_CONNECTION;FILEDSN=D:\Views\eli_2.18.7_BUS3\sources\IPR\Patient Record\DEV2005.dsn;DATABASE=siteDB;UID=xx;PWD=xx;WSID=ELIP_WXP"}

when i call to CDaoTableDef::Append the SQL connection is created in the
SQL server and then when i call CDaoTableDef::Close, the connecton remain.

Does any one have any idea what i can do?