Is It possible to pass an ADODB.Connection as parameter?

Question

Is It possible to pass an ADODB.Connection as parameter?

Apinedo (Programmer)

(OP)

22 Sep 00 20:14

Hi.
I'm new working with MTS and I have a problem.
I wrote the next code for a method of my MTS component in VB 6.0:
Public Function Validate_User(cn1 As Object) As Boolean
Validate_User = False
gsSqlStm = "Select * from table1"
Set mrsValidaUsuario = New ADODB.Recordset
mrsValidaUsuario.CursorType = adOpenForwardOnly
mrsValidaUsuario.Open gsSqlStm, cn1
....
....
Then, I tried to use its method on client-side writing the next lines of code:
Dim cn as new ADODB.Connection
cn.ConnectionTimeout = 100
cn.Provider = "sqloledb"
cn.Properties("Data Source").Value = "SERVERNAME"
cn.Properties("Initial Catalog").Value = "DBNAME"
cn.Properties("User ID").Value = "sa"
cn.Properties("Password").Value = ""
cn.Open
Dim a As Object
Set a = CreateObject("SBCOMUserMTS.clsUsuario")
Dim b As Boolean
b = a.Validate_User(cn)<<<<<<HERE FAILS
I got a message "authentication service is unknown"
Is It possible to pass as an argument an ADODB.connection?
I know the component fails when it tries to open the ADODB.recordser mrsValidaUsuario
Thanks

zallen (Programmer) · Answer 1 · 2000-09-24 20:20:25

Sir,
  You must call SafeRef to pass a MTS object. But I cannot test ADO.ADOConnection.
  I think it is not necessary to pass ADO.ADOConection as parameter.Because ADO should stay with your MTS components not with client side (thin client ^_^).

  I hope you should understand it!

Regards!

VB400 (Programmer) · Answer 2 · 2000-09-25 11:39:17

You can pass a disconnected recordset back to client and that's a common strategy; however, I'm not so sure about passing connections!

If the idea is to have your MTS component read a set of records and pass them back to the client (as a recordset) then a disconnected recordset is what you're looking for.

**Guest** (visitor) · Answer 3 · 2000-10-09 17:04:25

im a new mts user, but i pas my connection to the object by setting a property i created in the object on the client to the connection string then using that property with an open in the component method, i used let and get. I think that is what you mean.

cvm (Programmer) · Answer 4 · 2000-10-16 08:15:40

Hi.
Yes, it is ok to pass ADODB.Connection as parameter
Try to change your function to Validate_User(cn1 as ADODB.Connection). Notice: without "New".

**Guest** (visitor) · Answer 5 · 2000-10-17 10:23:50

In our development we have used a connection string to pass into the client and found that it is simple to use and pass around.

CVM, does passing the ADODB.Connection to the object as a parameter allow the MTS / COM+ services to use the Database connection pooling? Or does the connection just get passed inactive and recreated on the server?
The connection pooling is a great way of tubo-charging your app if it uses DB connections.

J.

VB400 (Programmer) · Answer 6 · 2000-10-17 10:41:00

Please make the distinction between a connection object and a connection string.

Tarek

The more I learn, the more I need to learn!

Come Join Us!

Posting Guidelines

Is It possible to pass an ADODB.Connection as parameter?