Link to home
Start Free TrialLog in
Avatar of MDSS
MDSS

asked on

Linked Server Issue with SQL2012

I have an application that executes the following commands to create a Linked Server .... it works fine with SQL2005 and SQL2008 but not with SQL 2012.  What needs to change?

EXEC sp_addlinkedserver 'Job_t1', 'Jet 4.0','Microsoft.Jet.OLEDB.4.0','C:\rt2\Job_t1.xls ',NULL,'Excel 5.0'

EXEC sp_addlinkedsrvlogin 'Job_t1', 'false', 'sa', 'Admin', NULL

SELECT * FROM [Job_t1]...[mmtemp]

I get the following message:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Job_t1" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Job_t1".
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

This happens in another machine?
You might not using the correct architecture version of the Microsoft.Jet.OLEDB.4. Make sure that you installed the 64bit version.
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MDSS
MDSS

ASKER

Thank you so much