ISAM stands for Indexed Sequential Access Method, a method for indexing data for fast retrieval, originally developed by IBM.
Questions tagged [isam]
69 questions
22
votes
10 answers
How to resolve "Could not find installable ISAM." error for OLE DB provider "Microsoft.ACE.OLEDB.12.0"
I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "Microsoft.ACE.OLEDB.12.0" OLE DB provider, and I'm getting a persistent "Could not find installable ISAM" error. All hardware…
Martin_W
- 1,582
- 1
- 19
- 24
8
votes
4 answers
Open an Excel 2003 spreadsheet with C#. Could not find installable ISAM. Exception
I need to pull data from an xls, I also need have the user be able to change the location of the file it will. So an OleDbConnection seemed like a good start, and it was until the first merged cell.
This works for all but the merged…
NitroxDM
- 5,039
- 10
- 44
- 56
6
votes
7 answers
Choosing ISAM rather than SQL
Many developers seem to be either intimidated or a bit overwhelmed when an application design requires both procedural code and a substantial database. In most cases, "database" means an RDBMS with an SQL interface.
Yet it seems to me that many of…
dkretz
- 37,399
- 13
- 80
- 138
5
votes
1 answer
Connect to excel 2007 file using ADOConnection in Delphi7
I want to connect to an excel 2007 file(.xlsx) using delphi 7, so I used a AdoConnection and set its connectionstring property as:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\qm\Results-summary.xlsx;Extended Properties="Excel…
Masoud
- 8,020
- 12
- 62
- 123
5
votes
2 answers
c# Error: “Could Not Find Installable ISAM” in converting Excel file into .CSV file
I'm working on a project that would be able to convert Excel files to .CSV File, I think there are some problems in my C# code that is generating and error message Could Not Find Installable ISAM, please help me to sort out my problem.
Code:
if…
user1863359
- 317
- 1
- 10
- 23
2
votes
2 answers
Legacy dos system with flat file data store (ISAM-Files)
I have a legacy system which used to run on dos. It is an ERP system for retail stores (fashion). It think it stores it's data in flat files.
I have files ending with *.KEY and other files ending with *.D00 (counting up).
I think the key files hold…
server info
- 1,335
- 1
- 14
- 24
2
votes
2 answers
PHP: Extra spaces removed when using substr
I am trying to separating data from Isam files looping it line by line using fgets and with substr to get correct data from correct position of line.
Source data:
000000124325424Productname Type Price Weight Unit …
Roger Wayne
- 419
- 3
- 20
2
votes
2 answers
How to read .DAT and .IDX files using C Tree
I've got a program that I am trying to get data out of. I have been unable to find any sort of Database file to open. In the parent directory of the program there are a bunch of .DAT and .IDX files.
The program also installed the C-Tree GUI…
Fuzzerker
- 249
- 1
- 6
- 15
2
votes
1 answer
Could not find installable ISAM. Server Error in '/' Application
I have a access database in web. This file is being uploaded in the web earlier. When I checked the same in web by file manager I could see the file. But when I am trying to read this file using this statement
con.ConnectionString =…
user1923200
- 59
- 1
- 4
- 10
2
votes
1 answer
Could not find installable ISAM
I want to create a search function in my webpage with first
1
vote
3 answers
Problem with connection string and ISAM
I have the following problem. Have little application which read some data from excel file. Here is my connection string:
@"Provider=Microsoft.ACE.OLEDB.12.0;"+
@"Data Source=" + m_excelFileName + ";" +
@"Extended…
Karol
- 11
- 1
1
vote
2 answers
How to handle special characters to get result as "%{%s}t" using Ansible/yml?
Currently working on Ansible to port config of older system to multiple IBM ISAM 9 systems using ISAM-Ansible-Roles (https://github.com/IBM-Security/isam-ansible-roles) and having issue with a specific string.
The result I need is like…
alwayslearning321
- 21
- 1
- 5
1
vote
1 answer
Importing ISAM table files (ISD, ISM) from one mysql to another
Problem: My db-host suddently switched my mysql db from one server to another. Unfortunately I has 1 table that was running ISAM, all other tables are MyISAM.
After the switch from one server to another the ISAM table is dead!
PHP sends "Lost…
Svenn
- 111
- 2
- 5
1
vote
1 answer
how to tune Mysql when storage engine is MyISAM
MyISAM queries results too slow,What changes should i make,
if
Ram 16GB
DB 500GB
mysql> SHOW STATUS LIKE 'key%'
+------------------------+-------------+
| Variable_name | Value |
+------------------------+-------------+
|…
Syed Daniyal Asif
- 726
- 1
- 5
- 19
1
vote
1 answer
What's this OLD C pointer-math / macro thing doing?
I need help trying to understand what's happening in some old C code.
I'm utilizing an old btree/isam software product (from Softfocus) to write my data to the database. It essentially puts data into a mydb.dt file and the index data into mydb.nx…
csr19us
- 105
- 9