March 4, 2012 at 10:26 pm
hi
Please solve this error ?
I want to read the mdb file and push the data to tables in Sql Server 2005
i am using the code like:
exec sp_linkedserver 'linkedadvisor','Acess','Microsoft.jet.oledb.4.0',@mdbfilepath
or
select * from opendatasource('Microsoft.jet.oledb.4.0','datasource='path')...tbl_name
I am getting an error like "Msg 7303 Level 16, State 1
Cannot initialize the datasoure oblect ole db provider 'Microsoft.jet.oledb.4.0' for linked server "null"
but its working in Sql Server 2008
Tanks & Regards
Narayanan
March 5, 2012 at 12:27 pm
Are you sure that the JET driver is installed on the server running SQL Server 2005? Are you running 64-bit or 32-bit? There isn't a 64-bit JET driver.
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
March 5, 2012 at 11:43 pm
Hi Jack Corbett,
yes correct ,its working only in 32 bit and its not working in 64 bit...
How to run this in 64 bit machine.Is there any way to solve this problem?
please help me
Thanks & regards
Narayanan
March 6, 2012 at 7:24 am
I think this, https://connect.microsoft.com/SQLServer/feedback/details/587897/connecting-via-a-linked-server-to-an-access-2010-database-file, might address your issue. Be sure to read all the comments and workarounds.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply