SnowTweet
Xe Dap Oi !If your windows is 64 bits or 32 bits, you will need to download and install “Microsoft Access Database Engine 2010 Redistributable”
Instructions
To install this download:
1.Download the file by clicking the Download button and saving the file to your hard disk.
2.Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
3.Follow the instructions on the screen to complete the installation.
To use this download:
1.If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
2.If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
◦If you are connecting to Microsoft Office Excel data, add “Excel 14.0” to the Extended Properties of the OLEDB connection string.
3.If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
4.If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
To remove this download:
To remove the download file itself, delete the file AccessDatabaseEngine.exe
1.On the Start menu, point to Settings and then click Control Panel.
2.Double-click Add/Remove Programs.
3.In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
4.Click Yes or OK to confirm that you want to remove the program.
Downloads
For 32 bits
AccessDatabaseEngine.exe
For 64 bits
AccessDatabaseEngine_x64.exe
Check MSSQL Version:
exec xp_msver
source 2: http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/4887d91f-6ac7-40c0-9fc8-5cdd0634e603
