tag:blogger.com,1999:blog-5472436831307966815.post6651711223104633493..comments2024-03-20T00:30:07.883-06:00Comments on Daniel Cai's Blog: Solution: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machineDaniel Caihttp://www.blogger.com/profile/05461949321689249420noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-5472436831307966815.post-23527813605792251172014-07-28T02:36:37.246-06:002014-07-28T02:36:37.246-06:00Thanks for sharing this informative blog..Keep pos...Thanks for sharing this informative blog..Keep posting..<br /><br /><a href="http://www.dotnettrainingchennai.net/" rel="nofollow">Dot Net Course in Chennai</a> Anonymoushttps://www.blogger.com/profile/01882839630037611834noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-3197425566252510192013-03-04T13:08:18.865-07:002013-03-04T13:08:18.865-07:00Daniel Cai
Here is a LINQ Provider for MS Access:...Daniel Cai<br /><br />Here is a LINQ Provider for MS Access:<br />https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx<br />darichkidhttps://www.blogger.com/profile/11427384867993481295noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-66392283180032637912013-02-12T08:05:28.386-07:002013-02-12T08:05:28.386-07:00Thank you so much for posting this. I've been...Thank you so much for posting this. I've been beating my head against this problem for days and this finally fixed it for me. Switching the provider to the ACE version cleared up the Excel import issue I had been having when the package was deployed (switching to Run64BitRuntime = "False" worked fine in dev, but did nothing once deployed).Anonymoushttps://www.blogger.com/profile/13644153957205188818noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-5680258875865245612012-09-27T01:14:54.580-06:002012-09-27T01:14:54.580-06:00Hi,
I have created an application to import Tags i...Hi,<br />I have created an application to import Tags into oracle db from Excel file and its working fine in windows XP but when i tries to import in Windows Server 2008 R2(64 bit OS),Iam getting error as 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine'. Can anyone please help me on this issue.<br /><br />Thanks,<br />RajuAnonymoushttps://www.blogger.com/profile/07060212821949165425noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-5843225369294990942012-08-21T05:51:32.873-06:002012-08-21T05:51:32.873-06:00If you are trying to read an excel file using oled...If you are trying to read an excel file using oledb in Web appln( win 2008 R2, VS 2010), then there is one more thing that need to be done.<br /><br />make following changes to IIS:<br /> App pool--> Advance Setting -->Enable 32-bit applications = true<br /><br />This worked for me.Unknownhttps://www.blogger.com/profile/14466478854824892775noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-82999950037598590922012-05-30T01:48:29.021-06:002012-05-30T01:48:29.021-06:00Hi Everybody,
I just backed here to add my solutio...Hi Everybody,<br />I just backed here to add my solution that really worked for me:<br />My project had been setup to works with DotNet Framework 2.0,<br />So I changed form DotNet framework 2.0 ---> Dotnet framework 4.0<br />and then I changed from Dotnet frmaework 4.0 ---> DotNet framework 2.0<br />This solution works great to me,<br />Regards,karamihttps://www.blogger.com/profile/09115114144764907410noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-52152645660293824322011-06-29T12:50:02.270-06:002011-06-29T12:50:02.270-06:00Hi sainath, you can use any text editing tool to c...Hi sainath, you can use any text editing tool to change the connection string in your application's config file. The file name of the config file is different from application to application. For web application, it's web.config. For Windows form application, it's (YourAppName).exe.config. They are basically xml files.Daniel Caihttps://www.blogger.com/profile/05461949321689249420noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-37472652074909735612011-06-29T12:44:42.207-06:002011-06-29T12:44:42.207-06:00plz can any one tell me how to change the string.....plz can any one tell me how to change the string......... ???sainathnoreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-45657693473133907722011-05-19T07:29:24.296-06:002011-05-19T07:29:24.296-06:00thanks, i change my strig and it´s working!!!
The ...thanks, i change my strig and it´s working!!!<br />The conection into the vb will be change too.<br />This option exist.<br />You dont need install "Microsoft Access Database Engine 2010"<br />Thanks<br />Fananfananhttp://www.pcglobo.comnoreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-54549213685870680952011-04-09T22:02:43.386-06:002011-04-09T22:02:43.386-06:00@DS, there is no reason that you should receive th...@DS, there is no reason that you should receive the error if your code worked previously. Maybe you can post your connection string here so I can have a look. Also I would check the file system permission in your case.Daniel Caihttps://www.blogger.com/profile/05461949321689249420noreply@blogger.comtag:blogger.com,1999:blog-5472436831307966815.post-20044051120736888862011-04-06T02:56:07.873-06:002011-04-06T02:56:07.873-06:00Hi,
I use MS Access as a backend for my applicatio...Hi,<br />I use MS Access as a backend for my application which works in 32 bit and not in 64bit OS.<br /><br />I had the same problem "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." and i have changed the connection string as you have changed. <br /><br />I have installed the Microsoft Access Database Engine 2010 too. <br /><br />It works fine when i use select statements but throws error while i use insert, update and delete statements.<br /><br />Please help me on this to get it done for Insert, Update and delete statements too.<br /><br />Thanks in Advance<br /><br />DSVictor DShttps://www.blogger.com/profile/07211807066170926898noreply@blogger.com