March 20, 2009 at 3:53 am
Hi friends
I am getting this error while accessing xls file.
ie;
The Jet.OLEDB.4.0' provider is not registered on the local machine I am running a Windows server 2003 EE x64 edition- x64 bit O/S and machine with Visual Studio 2005. I have installed Office 2007 version.
some one advice or guide me...
T.Loganathan
March 21, 2009 at 10:53 am
There is no x64 JET engine because Office is still x86 so you need to install Win2003 SP2 that installs the x86 JET engine which let you use Excel and other Office products and you must remember to access SQL Server x86 directory to compile any code.
Kind regards,
Gift Peddie
March 23, 2009 at 4:21 am
Hi,
I have installed SP2 already, till this err is coming. any other solution..
T.Loganathan
March 23, 2009 at 7:39 am
There is no other solution you need to look for the x86 ODBC in your WOW64 directory so you can use Excel, if your Excel is through SSIS let me know so I could show you the code you need in SQL Server x86 directory.
Kind regards,
Gift Peddie
March 23, 2009 at 11:38 pm
Hi Gift Peddie,
No, Not thro. SSIlL , It is thro .NET Ver 2.0 accessing (View/Upload) the Excell file.
regards,
T.Loganathan
March 24, 2009 at 7:46 am
Then there is x86 ODBC at your point of connection reference it but your code must build x86 in the debug menu, the reason is dependent dll which is Office. Open the .NET application go to your debug menu then configuration manager and change the platform to x86 in any for pay VS2005/8, the options are based of edition.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply