400 points - Please help!!


I've submitted this question before and I haven't received any answers.  I've also submitted this in the database-general category, and between the three questions there's 400 points at stake.  Answer my question and I'll credit you the points for all three questions.  I suspect that it is not very difficult but I'm not very experienced with databases.  

I'm learning sql thru the SAMS text Database Progamming with Visual C++ in 21 days.  I'm going thru the example in day 4, which is to load the database engine into an list control.  Instead of loading properly, an exception is thrown, with the following information:

 Code Meaning = Unspecified error
 Source = Microsoft JET Database Engine
 Description = Couldn't find installable ISAM.

I take it this means something necessary isn't installed on my system.  Can anybody help me on what I need to get to fix it?

koziscoolAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
KangaRooConnect With a Mentor Commented:
Make sure:
that a proper DSN is used (check that the driver is an access .mdb driver).
the ODBC connection works, use a tool like WinSQL (http://www.imranweb.com/) or iSQL.
Your code connects with the Database through ODBC. Use DSN's to specify the database.

0
 
KangaRooCommented:
If SQL is what you want to learn, use MS Acces ans SQL view if you are creating queries.

Anyway, the Jet help gives:
==================================================================================
Couldn't find installable ISAM. (Error 3170)

The DLL for an installable ISAM file couldn't be found. This file is required for linking external tables (other than ODBC or Microsoft Jet database tables). The locations for all ISAM drivers are maintained in the Windows Registry. These entries are created automatically when you install your application. If you change the location of these drivers, you need to correct your application Setup program to reflect this change and make the correct entries in the Registry.

Possible causes:

·      An entry in the Registry isn't valid. For example, this error occurs if you're using a Paradox external database, and the Paradox entry points to a nonexistent directory or driver. Exit the application, correct the Windows Registry, and try the operation again.
·      One of the entries in the Registry points to a network drive and that network isn't connected. Make sure the network is available, and then try the operation again.
==================================================================================

Check with the ODBC administartor if the tekstdriver is installed at all. Also look in the registry, the keyname is (on my system) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM Formats\Text
You may have to run the MS Access or Office Setup again if it is missing.

Also note that you can do very little with a tekst database, an MS Access db gives you a much better SQL support and doesn't suffer from the ISAM syndrome.
0
 
koziscoolAuthor Commented:

First of all, big-picturewise, I'm trying to learn SQL and to be able to embed SQl and I/O thru c++ stored procedures.  Thus the text that I'm using.  If you have any suggestions for this, let me know.

As far as the problem itself is concerned, I think we might be getting somewhere here.  I was wondering why I'm getting this ISAM error when my data source is an *.mdb file.  Somehow Jet(?) thinks its looking for an ISAM file instead.  There's only a couple of things I can think of.  1.  There's a registry entry that points to somewhere bad.  2.  I need to reinstall some drivers from VC6.0 setup.  They might not even be mutually exclusive.  If you can help, please do.  I'm increasing the points again.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
KangaRooCommented:
I think I understood your goal wrong; I thought you were trying to access data in an ODBC source from C++. Now it seems you are using C++ to implement stored procedures?
0
 
koziscoolAuthor Commented:

Right.  The I have access to the original data through 3rd party apps like Bloomberg and XL.  I do some calculations on the original data in my own c++ code.  Now I need a way to store and retrieve my own output data.  Flat files would work except that I'll want to be able to do queries and joins as well.  Thus, I'm learning SQL and the ado c++ api in the text I mentioned before.
0
 
koziscoolAuthor Commented:

This question is still live, but I wanted to credit Roo for the comments he's made so far.
0
 
KangaRooCommented:
Thank you
0
All Courses

From novice to tech pro — start learning today.