varru Posted May 21, 2012 Share Posted May 21, 2012 Hi allI'm new to this forum.I am working on an application which will try to retrieve data from MS Access database (*.accdb) file.I am unable to open a connection to the database.Kindly help meHere's the code i used.$dbname = "C:\Project\Routers.accdb"$tblname = "db"$query = "SELECT * FROM " & $tblname & " WHERE Loopback=218.248.254.111"Local $title$adoCon = ObjCreate("ADODB.Connection")$adoCon.open("Provider=Microsoft.ACE.OLEDB.4.0; Data Source=" & $dbname)$adoRs = ObjCreate ("ADODB.Recordset")$adoRs.CursorType = 1$adoRs.LockType = 3$adoRs.Open ($query, $adoCon)$title = $adoRs.Fields("Router_Name").value$adoCon.CloseMsgBox(0,"testing",$title)I am getting error at that point and could not proceed further.What is the provider that to be used for Access 2010 database?Also any declarations required at the beginning of the code????Thanks in advance Link to comment Share on other sites More sharing options...
water Posted May 21, 2012 Share Posted May 21, 2012 Please search the forum for the MSAccess UDF. This will make things a lot easier. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Zedna Posted May 21, 2012 Share Posted May 21, 2012 Also use COM error handler to see detailed error description, examples are in AutoIt's helpfile and on the forum. Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now