Scalable SQL cannot create the external index file.

<i><b>Originally posted by : mike ricard (michelricard@hotmail.com)</b></i><br />Here is the message that I receive from sql after multiple openings of a connection<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br />[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]Scalable SQL cannot create the external index file. <br /><br />I can open and execute the code from the sql string 95 % of the time, but somehow, sometime, ireceived this message.<br /><br />Does anyone know what's going on, am I missing something?<br /><br />Please Help, my site goes live this coming tuesday !!!!<br />michelricard@hotmail.com<br /><br /> sqlItemsList = "SELECT DND_Garment_Master.LOGISTIK_NUMBER,DND_Garment_Mas ter.GENERIC_NSN, DND_Garment_Master.PTS_VALUE, DND_Inventory_Header.SPECIFIC_NSN, DND_Garment_Master.NAME_ENGLISH, DND_Garment_Master.NAME_FRENCH, DND_Inventory_Header.SIZE FROM DND_Garment_Master, DND_Inventory_Header WHERE DND_Garment_Master.GENERIC_NSN = DND_Inventory_Header.GENERIC_NSN AND (((DND_Garment_Master.ITEM_Type) = "&OrderFlag&")) AND ((DND_Inventory_Header.Special_Size) = 0) ORDER BY DND_Garment_Master.GENERIC_NSN, DND_Inventory_Header.SPECIFIC_NSN" <br /><br /><br /><br />