-
February 1st, 2012, 11:44 AM
#1
Error: Could not find installable ISAM creating MS Access database
I get the error that the installable ISAM is not found trying to create an MS Access 2007 database. The connection string is:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Databases\Test.accdb;Jet OLEDB;Persist Security Info=false
I am using VS 2010 and .NET 4
Thanks in advance.
Hal
up·grade (up'gräd'),
to take out old bugs
and put in new ones.
-
February 23rd, 2012, 07:51 PM
#2
Re: Error: Could not find installable ISAM creating MS Access database
if you want to use that connection string, you must ensure clients have at least the Microsoft Access Database Engine 2010 Redistributable
which is downlodable for free at microsoft.com. You should take care to ensure you will install on client machine the correct engine for the target machine (x64 or x32). avoiding to try to install both - and your software too should be compiled x32 or x64 depending on target machine. AS you could not predict always what client machines (and if in case any engine is already there, might be even incompatible with your) usually we make a bootstrap that will take care of prerequisite and in case install it from web...
In any case, Microsoft Access Database Engine 2010 Redistributable is here
http://www.microsoft.com/download/en....aspx?id=13255
But before install the redistributable, look if it might be you are on a x64 machine and have the x32 engine (in which case you should try first compiling x32).
...at present time, using mainly Net 4.0, Vs 2010
Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
-
February 23rd, 2012, 08:22 PM
#3
Re: Error: Could not find installable ISAM creating MS Access database
Thank you for replying. The project was compiled using the default of any CPU. I changed it to x86 and it is now working fine.
Regards,
Hal
up·grade (up'gräd'),
to take out old bugs
and put in new ones.
-
February 23rd, 2012, 09:15 PM
#4
Re: Error: Could not find installable ISAM creating MS Access database
that is because on target machine you have the x32bit of the engine. Thanks for feedback.
Cimpy
...at present time, using mainly Net 4.0, Vs 2010
Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|