in Search
 
           
Welcome to SPAN Sign in | Join |
 
 

ACCESS LINKED SERVER IN SQL SERVER 2005

Last post 07-05-2007, 5:31 AM by shannen. 0 replies.
Sort Posts: Previous Next
  •  07-05-2007, 5:31 AM 555

    ACCESS LINKED SERVER IN SQL SERVER 2005

    I have created a Linked Server to an Access DB with SQL 2005 to a cross server mdb 

    EXEC sp_addlinkedserver 
        
       @provider = 'Microsoft.Jet.OLEDB.4.0 DB Provider',
       @product name = 'ACCESS DB',
       @data source = '\\server3\datacenter\data1.mdb'

    I have successfully created the link and queried the mdb and But when I try to browse the table in the linked server, it prompts me the error

     

    TITLE: Microsoft SQL Server Management Studio

    FAiled to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Data1".(Microsoft SQL Server, Error: 7303)

View as RSS news feed in XML
 
SPAN © COPYRIGHTS 2006. |  PRIVACY STATEMENT  |  TERMS OF USE  | FAQ