ODBC session

[flori]

sHello, everyone
My question is: How or what do I have to set for ODBC driver to open only
one session?
I'm working in Visual C++ with ODBC driver. The problem is that for each
table opened in the application it creates a new session in database. So, for
one .exe they are at least 6 sessions. I do need to open those tables. After
filtering the tables the application sends a message and waits for an answer,
and in this time those six sessions are inactive. A solution could be to
close the database after filtering but then I have to open it again.
--
flori vucu

[Ralph]

"flori" <fl...@discussions.microsoft.com> wrote in message
news:8904CB4F-5200-4B88...@microsoft.com...

1) You posted this message to the wrong group. This newsgroup is for users
of 'classic' VB (VB6 and lower) with ODBC issues. You need to post to a VC++
newsgroup, perhaps "microsoft.public.vc.database".

2) You should be able to control Sessions through the ODBC Session facility.

3) However, ODBC can't carry a single session across different schemas. And
support varies across drivers, databases, and libraries.

4) You are not providing enough information. When you do repost to the
appropriate newsgroup, also state the database, the ODBC library you are
using, and provide some code snippet for how you connecting and querying
those tables.

hth
-ralph

[flori]

Thanks,
I've posted the question on microsoft.public.vc.database and I'm still
waiting for a suggestion. I hope I do not have to change the whole project.
--
flori vucu