SoapXlm0,
Thanks for the reply.
Why do you tell me to "do the registration twice, i.e delete component from the pacakge and add again"?
How does this differ from what I do now? I compile the DLL with Project compatibility selected, then delete the components from MTS and re-drop...
Palbano,
ADO is NOT an MTS component and therefore should NOT be instantiated with CreateInstance. Use
Dim x as ADODB.Connection
Set x = CreateObject("ADODB.Connection")
or
Dim x as ADODB.Connection
Set x = New ADODB.Connection
Both of which will instantiate the connection...
That's because the DLL is not registered as an MTS component. You have to shut down the IIS Administrator service, which keeps the DLL open indefinitely once an ASP page references it. Those who responded assumed the DLL was registered with MTS because, well, this is an MTS forum. If your...
You need to supply even more detail.
Which version of Oracle? On which OS? Same PC?
Of SQL*Net or Net 8?
Whose OLEDB Provider?
Which version?
There are two possible transaction managers - XA.DLL from Microsoft and Oracle Services for MTS from Oracle. It sounds like neither is properly...
When you write "I can see the record being changed but it does not update the database after the program ends.", do you mean that the first and last of the debug statements shown below print different values, yet a subsequent query of this record does not show the change?
debug.print...
Actually, I am very confident in the statement that MTS wraps your in-process server (ActiveX DLL), effectively changing it into an out-of-process server. However, I am not sure whether MTS wraps each DLL separately or uses MTX.EXE as a common wrapper for all DLLs, and I not sure whether my...
I think the trick to understanding this is to understand that, when a DLL is registered as a component, MTS subtitutes it's own Class ID for the class IDs that were put into the registry by VB when the project was compiled.
When an program uses CreateObject or CreateInstance, the class-ID is...
I cannot get interactive debugging to work properly and would appreciate any help you can offer.
I complile the ActiveX DLL in Project compatibility mode, then use the MTS console to stop the MTS processes, delete the components that form the package, and re-drop the DLL into the package...
"as NEW" should be avoided when referring to MTS objects. I avoid it entirely. I dimension objects to a specific type during the editing (it's nice to have the auto-help features when you are editing), but comment-out the types before compiling.
"CreateObject" should be used...
If this is used within an NT security context, you can get the user's ID as described above. If you have a separate security context that provides site membership services and uses a proxy account to represent the users (such as Site Server) you will have to pass the user's authorized login ID...
A few points that might help (NT4SP3):
The CR8 engine is a single-threading DLL. I am not sure what the impact of that is, but the developer help makes a point of stating it.
The Oracle client-side products do something to MDAC that can trigger errors ( don't recall if the out of memory error...
Use the OLEDB Providor for Microsoft Jet (search the MS knowledgebase for connectinString examples). This will avoid threading problems that are in the ODBC driver.
If you have security defined to the databse, there is a file in System32 that holds the security info for all MDB files on that...
ASP is superior to JSP because it has a simpler syntax and is not case sensitive in variable and procedure names. Those differences alone allow the coder to focus more on the logic than the syntax details of the language, which in my experience eliminates up to 90% of the non-productive...
Use the SELECT statement. The following should help, butI am not 100% about the "is <" and "X to Y" syntax. It may only be supported in VB. The colon allows a single instruction to be put on the same line as the test. You can always put statements on subsequent lines...
Use the MS OLEDB provider for Oracle or the Oracle OLEDB provider for Oracle. Neither of these use an ODBC driver. The first is twice as fast as the MS OLEDB Provider for ODBC and the second is four times as fast (but only works with Oracle 8i). Use the ADO Add and Update methods to maintain...
There are a lot of different APIs that you can call. I was able to create a VB ActiveX class and standard EXE that use the Crystal Reports Engine (an ActiveX DLL) and the PDF Writer software (a print driver to generate PDF files) to generate batches of reports in both XLS and PDF formats.
It...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.