This example is for an Access database located at 'C:\Temp\Test.accdb' and the creditials being pass are the some ones that you use to connect to SQL Server. Here is a script how to create a connection to an Access 2010 database once OLEDB v12 shows up. To know) It is best to use SSMS to verify. (Readers do please comment on this - I would like I do not know of a query that will return all the Providers that are installed for SQL Server - I believe that is a registry call that SSMS makes. The same can be said for the second query as well. The query does not return all the providers that are installed. The information being returned for your query is likely for that SQL Server instance. The query to sys.servers returns current information about current linked servers. On any server you want to use this link you must have the software installed and you must register a linked server for every database you want to access, no pun. Here is the same server with the Microsoft Access Database Engine 圆4 installed - see how it shows up. Here is a SQL Server 圆4 server with the Microsoft Access Database Engine x32 installed - see it does not show up. Once it is installed and you have checked for updates, there is a SP, make sure SQL Server show's it registered. Please note that only one version 圆4 -OR- x86 can be installed, not both. Please double check to make sure you did install the 圆4 version of Microsoft Access Database Engine here.
0 kommentar(er)
