January 23, 2009 at 5:00 am
hi,
actually i am fetching data from accessfile and take that into one table i am using openrowset method as below
it's runing in my one server successfully but in another server when i am trying to execute following query it's showing me error as described below ...... can anyone help me out from this
i am runing this query on os win server 2003 with sp1 and on sql server 2005
on this microsoft office not installed
and try to run same query with another server with same os version and also there is no office installed then also query run successfully but don't know why on another server it's showing me error like this
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','\\servername\testingdata\LOG.MDB';'admin';'',tablename)
i am getting following error
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" 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 "(null)".
Raj Acharya
January 23, 2009 at 8:47 am
Please don't duplicate posts. Answers here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply