>Hi Naomi,
>If i use CA (CursorAdapters) and ADODB, then in CA.Init Method, i have some like ():
>
>
>....
>loConnDataSource = createobject('ADODB.Connection')
>***<DataSource>
>loConnDataSource.ConnectionString = [Provider=SQLOLEDB;Integrated Security=SSPI;
>Initial Catalog=Northwind;Data] + [ Source=(local);]
>***</DataSource>
>
>loConnDataSource.Open()
>this.DataSource = createobject('ADODB.RecordSet')
>...
>
>
>But, if i use CA, ADODB and 3-Tier model (User Interface, Business Logic and Data Layer), in this case where is there ADODB commands like oConn.Open(),oConn.BeginTrans(), oRS.ActiveConnection = oConn, oRS.UpdateBatch(), oConn.RollbackTrans(), oRS.CancelBatch(), oConn.CommitTrans()... my question: which layer?).
>
>In this case (with ADO commands) is unnecessary CA ?
>
>Please, example.
>
>Thanks,
>Best regards
>Vojislav
Hi Vojislav,
I believe all these commands should go to the Data Layer. I'm not sure what kind of example do you want, I don't have an example myself, I don't know where you can get this example.
You may check this discussion on MSDN
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1767382&SiteID=1 though I'm not sure it is really helpful to the problem. But it has some links.
If it's not broken, fix it until it is.
My Blog