 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / April 2005DAO 3.6 in Multi-user Env via COM+ server
I have a VB 6.0 component that uses DAO 3.6 library to read MS Access 2000 db/table (just for ReadOnly operation). I created a standard exe that calls this VB component in a 5 second interval. Say for instance this VB component takes 10 seconds to complete a task when deployed out of COM+ server, that means, I used regsvr32 to register the vb component. But, it takes anywhere between 30 seconds to an hour to do the same job when deployed in COM+ server. I am wondering how the performance gets this big hit for a VB component when deployed in a COM+ server. Any help would be appreciated. I would like to add few more things:Opening of access db/table, seek operation is very slow when the vb component is deployed in com+ server. Locking of db is a problem as well, although I open the db in shared mode and not in exclusive mode. > I have a VB 6.0 component that uses DAO 3.6 library to read MS Access 2000 > db/table (just for ReadOnly operation). I created a standard exe that calls [quoted text clipped - 6 lines] > I am wondering how the performance gets this big hit for a VB component when > deployed in a COM+ server. Any help would be appreciated. I think you should ask this question again in a VB group and a COM+ group. Unless by accident, there won't be anyone here familiar with COM+ (david) >I have a VB 6.0 component that uses DAO 3.6 library to read MS Access 2000 > db/table (just for ReadOnly operation). I created a standard exe that [quoted text clipped - 10 lines] > when > deployed in a COM+ server. Any help would be appreciated. Thanks David. (I asked here because the issue was accessing the data in MS Access) > I think you should ask this question again in a VB group and a COM+ group. > [quoted text clipped - 16 lines] > > when > > deployed in a COM+ server. Any help would be appreciated. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.