ODBC Connection to Access 2007 on WinXP
Is it possible to have an ODBC connection to a MS Access 2007 database on Windows XP without having any other database engine (i.e. Microsoft.ACE.OLEDB.12.0) installed?
I am using the following connection string which works on Windows 7 but not on Windows XP. (There is only *.mdb option in Data Sources (ODBC) control panel in Windows XP and no *.accdb option is there but both exist on Windows 7.):
connectionString = "Driver开发者_运维百科={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=|DataDirectory|Database1.accdb"
You can download drivers: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en
精彩评论