Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unsolved mistery
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Unsolved mistery
Miscellaneous
Thread ID:
00454314
Message ID:
00454314
Views:
73
I posted these 2 questions a couple weeks ago and still no answer, anybody ?? Actually i figured out (i think) the second question but the first remains an unsolved mistery.

1rst Question
-------------
In COM+, All my properties of a Com DLL Are showing twice, is this normal ? how can i fix it? (Using W2K Server SP1, VFP 6 SP4)


2nd Question
------------
I have an COM Dll which wraps ADO Functions It Does about this:

1- Creates ADO Objects, RS, connection, Command, parameters, etc...
2- Does my process (Query Delete Update, Etc...)
3- Set All ActiveConnection To NULL And Close() the connection

When i look in Sql Server Profiler log, i can see a connect event then my Dll actions but no diconnect !!, it only disconnect when i release the object reference when my Dll Is Not IN MTS. When it is in MTS, it disconnects about one minute after it connects. Does anybody know if this behavior is normal ? If it is, it defeats the purpose of offline work and saving SQL Server licences.

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform