ado.Connection error

[nigz]

Hi - I have developed a simple comm object which is running on complus
service on a win 2000 server. The comm suppllies an adodb connection object
- the comm appears to work fine but when I try to assign the connection
object to the active connection of an adodb command object I get an error
(3001) 'artguments are of the wrong type, are out of range, or are in
conflict with one another'. I fully tested the dll on the development
machine before deploying it - does anyone have any suggestions? TIA

- Nigz

 

[v0520]

Its because you are running under COM+. Since you are calling the dll from asp, its treated as separate process space...

Try changing your code to do something like...

set objrs = objconn.Execute("your sql string)

rather than

set objrs.activeconnection = objconn
objrs.open("your sql string&quot
Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov

 

[nigz]

Thanks Gilbert - although what I was trying to do was make a generic connection object which could be used by a number of other components to connect to various databases, but I guess that cannot be done ... also I was hoping to have a single connection per user via COM .. does this mean I should create the connection on the client & then pass it each time to the various commands? or do I have to create a new connection every time I wish to interact with the database?