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:\r t2\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".
EXEC sp_addlinkedserver 'Job_t1', 'Jet 4.0','Microsoft.Jet.OLEDB.
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".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much
You might not using the correct architecture version of the Microsoft.Jet.OLEDB.4. Make sure that you installed the 64bit version.