开发者

ODBC Connection to Access 2007 on WinXP

开发者 https://www.devze.com 2023-01-11 10:47 出处:网络
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?

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

0

精彩评论

暂无评论...
验证码 换一张
取 消