Page 1 of 1

Could not find installable ISAM.

Posted: Mon Jan 15, 2007 10:19 pm
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();
}

Posted: Mon Jan 15, 2007 11:00 pm
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?)

Posted: Tue Jan 16, 2007 1:21 am
by daedalus__
I've tried most things on the first 5 pages.

Posted: Tue Jan 16, 2007 11:55 am
by daedalus__
I'm sorry, I just realised that code is completely wrong. I am retarded when I am tired.