Could not find installable ISAM when connect the access database from visual basic 6.0

Question

0.00/5 (No votes)

See more:

Hi,

I do have visual basic program and i am using windows XP operating system.
I have created one Data control and combobox.
the combobox datasource is setted as data control.

when i refresh the data control, its says "Could not find the installable ISAM".

please refer the attached code.

dtcApplication.DatabaseName = strServerPath + "\" + strDatabasNamn

SQL = "SELECT DISTINCTROW " 
   SQL = SQL + "tblApplication.Application "
   SQL = SQL + "FROM tblApplication;"
   dtcApplication.RecordSource = SQL
   
   dtcApplication.Refresh

What I have tried:

dont have right directions for find out the solution

Posted 2-Jul-24 22:06pm

Dhanasekaran Murugesan

Add a Solution

Comments

Richard Deeming 3-Jul-24 4:27am

NB: VB6 has been dead for over 20 years. Windows XP has been dead for over 10 years. If you insist on starting new development in a long-dead technology on a long-dead OS, you're going to increasingly struggle to find solutions to the problems you encounter.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pete O'Hanlon · Answer 1 · 2024-07-02T23:40:00

So, the error is telling you that it cannot find an appropriate ISAM provider. What you normally need to do is provide a set of extended properties. Suppose you were trying to read from Access, your connection string might look something like this:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<<path to db>>;Extended Properties='Microsoft.ACE.OLEDB.12.0;HDR=YES;IMEX=1;';

The really important part of the proerties is the IMEX entry.

OriginalGriff · Answer 2 · 2024-07-02T23:26:00

VB 6 was superseded in 2001 and entered end of support in 2008.
Win XP was superseded in 2008 and entered end of support in 2014.

Creating new development based on either is a poor idea; both is positively dangerous.

Add to that your query is overcomplicated

ALL, DISTINCT, DISTINCTROW, TOP Predicates - Microsoft Support[^]:
DISTINCTROW has an effect only when you select fields from some, but not all, of the tables used in the query. DISTINCTROW is ignored if your query includes only one table, or if you output fields from all tables.

And you end up with something we can't duplicate - you probably need to have a good close look at the connection string and identify which engine you are using and compare that against the system itself - if you are referencing a 64 bit DB engine in a VB6 project it's not going to work because VB6 only supports 32 bit processes.

I know we've told you this before, but ... move to a more modern OS and IDE, move to a more modern language - the level of support you can get for the ancient setup you are trying to work with is just going to cause you more and more problems as you go on.!

Could not find installable ISAM when connect the access database from visual basic 6.0

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0