OLE DB not only offers a performance benefit over ODBC connections (DSN) but also has some increased functionality. This article shows how to set up an OLE DB connection to an Access database.
http://www.drdev.net/article09.htm
Setting up an OLE DB connection to an Access database
Owen Eastwick
I have over a dozen years experience in the IT industry and in the past 5 I have focussed exclusively on web site design and development. I'm familiar with all aspects of web site design from planning through to launch. I specialise in developing dynamic, ASP/VBScript web sites utilising either a Microsoft Access or a SQL Server database back end. I also create logos, artwork and design web site interfaces so I am able to develop a complete web site from “front-end” through to “back-end” if required.
In addition to developing sites directly for clients I also undertake sub-contract projects developing ASP and database solutions for other web site designers. If you've got a rush job and a fast approaching deadline or you've simply reached a seemingly impassable sticking point within a project, get in touch.
Check out my sites for more information:
http://www.drdev.net/
http://www.tdsf.co.uk/
Comments
Switch ODBC to OLE DB
I posted a tutorial around OLE DB 2 years ago, and more detailed with additional information supplied by Microsoft as well for those that want some more detail you can read it here:
http://www.dmxzone.com/ShowDetail.asp?NewsId=859
You must me logged in to write a comment.