A page on ActivexDataObject and SqlServer that is of concern to VbClassic developers.
Introduction and beginner Material
- Using SqlServer Data Transformation Services (DTS) at http://support.hosting.verio.com/verioknowbase/root/public/ves30066.htm
Following two links moved from ActivexDataObject and unfortunately no longer work
I tried WaybackMachine and not found there as well. Links were working in Feb2004. Anyone able to help to provide a new link, or an equivalent good quality replacement? -- dl [The second link below seems to work still. For the first, try http://web.archive.org/web/20021221151514/http://msdn.microsoft.com/archive/en-us/dnarextvb/html/msdn_intro.asp.]
A Microsoft archived article on using VbClassic and ADO to build midtier components is located at http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarextvb/html/msdn_intro.asp?frame=true
A book excerpt kept on Microsoft site on UniversalDataAccess, at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbegvb/html/universaldataaccess.asp, gave an example of ADO usage from within VbClassic
Wiki data access and database pages to be checked out
- SqlServer, in particular the section on XmlEnabled
Material related to Data access concerns, including but not limited to ADO
- Migrating from ADO to ADO.Net by BillVaughn at http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnadonet/html/adocnet4.asp
- Use Disconnected recordsets to pass data around for changes at http://www.devx.com/getHelpOn/10MinuteSolution/20407/1954?pf=true
Anyone got good references to resources that help with thick client application scalability, interoperability and performance please add to above list -- dl