Cannot Find Installable ISAM Exception-VBForums
Results 1 to 7 of 7

Thread: Cannot Find Installable ISAM Exception

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2014
    Posts
    14

    Cannot Find Installable ISAM Exception

    The following code generates the exception on o_DBEngine.CreateDatabase:

    Public Sub New()

    Dim o_DBEngine As New DBEngine
    Dim o_Database As DAO.Database
    Dim o_WorkSpace As DAO.Workspace
    Dim o_TableDef As New TableDef

    ' Create and open the main database
    If (Dir(Application.StartupPath + "\" + modUtilities.DATABASE_NAME) = "") Then
    Try
    InitializeComponent()

    o_DBEngine.CreateDatabase(modUtilities.DATABASE_NAME, "General") <-------- EXCEPTION ON THIS LINE
    o_WorkSpace = o_DBEngine.CreateWorkspace(MAINWS, "admin", "")
    o_Database = o_DBEngine.Workspaces(MAINWS).OpenDatabase(modUtilities.DATABASE_NAME)
    o_TableDef.Name = "Person"
    o_TableDef.CreateField("PersonID", DAO.DataTypeEnum.dbLong)
    o_TableDef.Fields("PersonID").Attributes = DAO.FieldAttributeEnum.dbAutoIncrField
    o_TableDef.CreateField("FirstName", DAO.DataTypeEnum.dbText, 255)
    o_TableDef.CreateField("LastName", DAO.DataTypeEnum.dbText, 255)
    Catch o_Exception As Exception
    MsgBox("Exception: " + o_Exception.Message)
    End Try
    End If
    End Sub

    Has anybody over come this? I have re-installed MDAC 2.8 to no avail. I'd really appreciate some help. Thank you.

  2. #2
    PowerPoster
    Join Date
    Oct 2013
    Posts
    2,846

    Re: Cannot Find Installable ISAM Exception

    I think you use incorrect parameters in CreateDatabase:

    http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

    But I never used DAO, it's obsolete for a long time

  3. #3
    Frenzied Member
    Join Date
    May 2014
    Location
    Central Europe
    Posts
    1,197

    Re: Cannot Find Installable ISAM Exception

    i remember this error coming from some broken installation. There is a MS tool somewhere out there that checks all DAO components and compatibility. I remember beeing able to resolve this error some 10 years ago using this tool.

  4. #4
    PowerPoster kaliman79912's Avatar
    Join Date
    Jan 2009
    Location
    Ciudad Juarez, Chihuahua. Mexico
    Posts
    2,592

    Re: Cannot Find Installable ISAM Exception

    If I was you, I would start changing to a more current Database system. Sorry I can't help you with this.
    More important than the will to succeed, is the will to prepare for success.

    Please rate the posts, your comments are the fuel to keep helping people

  5. #5
    Super Moderator Joacim Andersson's Avatar
    Join Date
    Jan 1999
    Location
    Sweden
    Posts
    14,649

    Re: Cannot Find Installable ISAM Exception

    It would be more informative if you could name the exception you're getting, but I suspect that you're running this on a 64-bit machine. DAO is 32-bit so you must change the Target CPU setting. In VS click Project > Project Name Properties and on the Compile tab change the Target CPU to x86.
    Joacim Andersson
    If anyone's answer has helped you, please show your appreciation by rating that answer.
    I'd rather run ScriptBrix...
    Joacim's view on stuff.

    MVP

  6. #6
    PowerPoster Nightwalker83's Avatar
    Join Date
    Dec 2001
    Location
    Adelaide, Australia
    Posts
    13,346

    Re: Cannot Find Installable ISAM Exception

    I would check that the database was saved in the correct file format for the version of the DB.Engine you are using.
    when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
    If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
    Please consider giving me some rep points if I help you a lot.
    Please rate my post if you find it helpful!
    Technology is a dangerous thing in the hands of an idiot! I am that idiot.

  7. #7
    Super Moderator Joacim Andersson's Avatar
    Join Date
    Jan 1999
    Location
    Sweden
    Posts
    14,649

    Re: Cannot Find Installable ISAM Exception

    Quote Originally Posted by Nightwalker83 View Post
    I would check that the database was saved in the correct file format for the version of the DB.Engine you are using.
    He gets the exception when he tries to create the database. So the database doesn't exist yet.
    Joacim Andersson
    If anyone's answer has helped you, please show your appreciation by rating that answer.
    I'd rather run ScriptBrix...
    Joacim's view on stuff.

    MVP

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.