Sql Server Help

[dolly_doll]

[size=5]Hi friends- i have some data loaded to tables in MS access 2010. I am looking to link to those tables and run queries in sql server 2008. I am using the [i]sp_addlinkedserver [/i][i]to add a linked server to SQL server. the sql server is on a remote machine and the access data base is on a local machine. It gives me a datasource unavailable error. please help me if you guys have an idea about this. Thanks in adavance[/i][/size]

[gundugadu]

Try placing the Access file to a network shared Location folder.

and while creating a linked server point the path to the Shared network path.


\\SourceDirectory\AccessFiles\Example.mdf

[cherlapalli_jailer]

help

i don't know much about linking the servers..

just thowing some lite

since MSAccess is in local..

did u properly call (ipaddress./machine name)

form SQLServer SP?

[JUJUBI_JULABI]

As long as you are in the same intranet (company server), you can use fully qualified server name to access the DB , you can add as linked server as well

[littlemoon]

[size=4][font=arial, helvetica, sans-serif]local path mention cheyalii .. try to run this query in sql server

[color=#000000]Exec sp_addlinkedserver @server = 'DBName' [/color][color=#444444][background=rgb(244, 248, 251)]@provider = N'Microsoft.Jet.OLEDB.4.0' @srvproduct = N'OLE DB Provider for Jet',[/background][/color]
[color=#444444][background=rgb(244, 248, 251)]@datasrc = N'C:\MSOffice\Access\Data\Database.mdb'; [/background][/color][/font][/size]

[dolly_doll]

[color=#444444][font=arial, helvetica, sans-serif][background=rgb(244, 248, 251)]Microsoft.Jet.OLEDB.4.0 cannot be used for distributed queries error vastundi[/background][/font][/color]

[dolly_doll]

is there a specificOLE DB provider for distributed queries?