MyTetra Share
Делитесь знаниями!
!Настройка провайдера
25.12.2018
12:05
Раздел: !Закладки - SQL Server

HERE IS THE SOLUTION FOR ALL OF YOU WITH THE SAME PROBLEM:

Тема на sql.ru

 

-On your Server Objects ->

Linked Servers ->

Providers, Righ Click on Microsoft.ACE.OLEDB.12.0 and select Options. Check the option ->

Allow inprocess


HERE IS THE SOLUTION FOR ALL OF YOU WITH THE SAME PROBLEM:

- Install the
2007 Office System Driver: Data Connectivity Components on your server.
here is the link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

- Make shure you have
SQL SERVER 2005 Standard installed. IT DOESN'T WORK'S ON SQL EXPRESS. No mather what you do. It only works on the standard versions...

- Install
SQL SERVER SP2

- On your
Server Objects > Linked Servers > Providers, Righ Click on Microsoft.ACE.OLEDB.12.0 and select Options. Check the option Allow inprocess

-
Use this T-SQL template (replacing by your own values) to create a connecto to the Linked Server:


Code Snippet

-- ==============================================

-- Add Linked Server Access 2007 ACCDB template

-- BY JOSÉ ALVES @ CCG - UMINHO - PORTUGAL

-- ==============================================

 

EXEC sp_addlinkedserver

    @server = N'Your Linked Server Name',

    @provider = N'Microsoft.ACE.OLEDB.12.0',

    @srvproduct = N'Access2007',

    @datasrc = N'C:\path\to\your\db.accdb'

GO

 

-- Set up login mapping using current user's security context

EXEC sp_addlinkedsrvlogin

    @rmtsrvname = N'Your Linked Server Name',

    @useself = N'TRUE',

    @locallogin = NULL,

    @rmtuser = N'Your Linked Server Name',

    @rmtpassword = ''

GO

 

-- List the tables on the linked server

EXEC sp_tables_ex N'Your Linked Server Name'

GO

 

-- Select all the rows from table1

SELECT * FROM [Your Linked Server Name]...table1




I hope this helps you. To me it was a big headache but i figured out after many tries...



Greetings from Portugal

Так же в этом разделе:
 
MyTetra Share v.0.52
Яндекс индекс цитирования