How to close SQL Server connection created by CDaoTableDef

E

Eli Pearlmuter

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Connection Question 1
Unable to update/add records in connected SQL Server tables 4
DSN Less Connection 2
DoCmd.TransferDatabase acExport to SQL server 2005 2
How do you code to get SQL Server data from ODBC Connection? 0
Access to remote SQL server 14
How to use SQL Server connection string 0
Creating a querydef of a stored proc on Sql Server 8

Top