?
Solved

OleDbConnection

Posted on 2003-03-28
9
Medium Priority
?
2,278 Views
Last Modified: 2008-02-07
I've a password protected Access db on a remote box.  Using MSAccess to open the DB manually through a UNC works just fine.  However,

OleDbConnection DBConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"
                                          +"Data Source="+DBFullUNC+";"
                                          +"pwd=shhh");
DBConn.Open();

results in "Could not find installable ISAM"

Is this complaining about the box the code is running on or the remote box where the mdb is?  Is there some other provider I could use or a connection string parameter I need to add?
0
Comment
Question by:cookre
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 22

Author Comment

by:cookre
ID: 8227605
I do note that if I remove the password from the mdb, everything works fine.
0
 
LVL 1

Accepted Solution

by:
bibendum95 earned 2000 total points
ID: 8228552
I've connected to secured MDBs, but never any password protected MDBs -- so I may be mistaken, but I thought the database password property was called 'Database Password'. Does it make a difference if you change the last line to read:
       +"Jet OLEDB:Database Password=shhh");
0
 
LVL 22

Author Comment

by:cookre
ID: 8228996
Alas, no joy.
'Database Password=shhh;' gives the same result.
Installing the latest MDAC and .NET SP2 had no effect either.


0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 4

Expert Comment

by:dotthei
ID: 8229340
see
http://www.mvps.org/access/bugs/bugs0017.htm 

Bugs: Couldn't Find Installable ISAM
 Author(s)
Dev Ashish
 
 
  When you try to export/import data from Excel, dBase, Text or some other file type, you might get this error message.  
     A missing file or corrupt registry entry are the usual causes behind this error.  Sometimes, a typical Office Setup does not install these drivers by default.  Re-run the Setup program, and manually select the individual drivers under the Data Access options.  If any of the driver files were missing, they should be copied and registered by the Setup program.

    However, in a few cases, this does not get rid of the error message.   If the driver files are already present on the hard drive,  the registry entries could be corrupt.  

    First try registering the appropriate dll with RegSvr32 (sample steps). If this doesn't work, then try running the setup with some command line arguments:

    Setup /y /r

     If you still experience the same error message, try completely uninstalling Access. Then, search for these files on your hard drive, and rename them.

Msexcl35.dll (Excel) Mstext35.dll (Text)
Msxbse35.dll (dBase) Msxbse35.dll (FoxPro)

Now, re-install Access.
 
 
0
 
LVL 22

Author Comment

by:cookre
ID: 8229395
You'll also find references to a third variant:

"Can't find installable ISAM"

Each of these deal with the inability to access non-MDB databases by a number of different packages for various causes, none of which, unfortunately, apply here (would that they did).

I get the same result with Access 2000 and 2002 under each of NT, 2K, and XP - and all tests were run on different, non-pristine boxes:

An MDB with no password works fine in all cases (with and without indices), but as soon as a password is added, the .NET code fails (although Access itself has no problem (golly, I wonder why))

0
 
LVL 16

Expert Comment

by:GUEEN
ID: 8229426
and this: specify a database password, not
a user password.  The working code reads:

OleDbConnection perConnection =
    new OleDbConnection ( "Provider=Microsoft.Jet.OLEDB.4.0"
                         +";Data Source=" + Server.MapPath
("db\\Data.mdb")
                         +";Jet OLEDB:Database Password=XxxxxYyyyy"
                       
0
 
LVL 22

Author Comment

by:cookre
ID: 8229549
After Ms. Shek's response, I realized I had mis-read your post.  Switching from "pwd=xxx" to "Jet OLEDB..." made it all work.


And for She Who Whacked Me Up Side The Head And Made Me Open My Eyes:
http://www.experts-exchange.com/Databases/MS_Access/Q_20567160.html

Thanks to all, and to all a good night.

0
 
LVL 16

Expert Comment

by:GUEEN
ID: 8230270
I can't take them point scookie - heart!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question