July 7, 2009 at 11:20 pm
Hai guys
I am trying to create a linked server for an excel sheet,but the following error occurs
cannot initialize data source object of eledb provider microsoft.ace.oledb 12.0 for linked server
what may be the reason ??
for this excel sheet no need to map any login rt.as it is in the same systm
pls help
July 7, 2009 at 11:53 pm
July 7, 2009 at 11:55 pm
You should use
Provider : Microsoft.Jet.OLEDB.4.0
Provider String : excel 8.0
Tanx 😀
July 8, 2009 at 12:20 am
the problem has been solved.but the linked server created in one login canot seen on another login.why this is hapening
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply