Could not find installable ISAM.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Could not find installable ISAM.

Post by daedalus__ »

I have no idea why I get this error but I do and I'm about ready to slam my head through a brick wall.

Source: Microsoft JET Database Engine
Description: Could not find installable ISAM.

I am trying to access tables from Navision 4.0 running their native Database Engine. I set up a DSN that the Database uses to access the linked tables. It all works fine on the system but as soon as I use PHP I get all kinds and manner of stupid errors.

I was going to try to go through an Access database but that didn't work either.

Server is Windows 2000 running IIS whatever crappy version comes with it.

I've been here for 13 hours, I'm done. See ya guys tomorrow.

Code: Select all

try
{
	$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');
	
	// Two ways to connect. Choose one.
	$conn->Open('Provider=Microsoft.Jet.OLEDB.4.0; Data Source="Navision 4.0"; UID=edited; PWD=;');
	
	$sql = 'SELECT [Entry No_] FROM [G/L Entry]';
	$rs = $conn->Execute($sql);
}
catch (Exception $e)
{
	echo $e->getMessage();
}
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

I guess it's the Data Source="Navision 4.0"; UID=edited; PWD=; (might also be only UID=edited; PWD=;) part of the connect string as described at http://support.microsoft.com/kb/318161 (second hit on a google search for Could not find installable ISAM. You didn't do that, did you?)
User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Post by daedalus__ »

I've tried most things on the first 5 pages.
User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Post by daedalus__ »

I'm sorry, I just realised that code is completely wrong. I am retarded when I am tired.
Post Reply