ISAM databases/opening

[Catrina]

Hi,

I am a beginning programmer, and I'm trying to find the code to open an ISAM database in a Visual Basic application. I will eventually be converting a DOS payroll program to Windows. I have just begun the Sams Teach yourself Database Programming with VB6. But was hoping someone could help me out with a quick answer. I have searched the VB online help, but can't find much info on ISAMs. Thanks for any help.

Catrina

[Johnny101]

From what i understand about ISAM (and the error messages I've received), how you open a database greatly depends on what type of database you are using. For example: I've tried to open an Access database with an incorrect connectionstring using ADO and received "Could not find installable ISAM" as the error message. That usually means that the name of the provider/driver is incorrect, or that no driver exists for that db. Do you which type of database you have to open? If you have that information, we can help out a lot more. (FoxPro, Paradox, DB2 etc.)

Good Luck,
John

John Pirkey
MCSD
www.ShallowWaterSystems.com

[Catrina]

Thanks for responding. The database is an old ISAM created with Quick Basic Extended Ver 7.0. It is a record-oriented database that is currently running with a DOS program. The opening code for that program is:

DIM PAYREC AS MasterRecord

OPEN "PAYMAST.DBS" FOR ISAM MasterRecord AS 5

This does not work, I get a syntax error on the Open statement.

Again, I am just learning VB, and I'm in way over my head, but if I can get past this, the rest of the program should be much easier to convert to windows.

Thank you for any help.

Catrina

[Kyle Burns]

ISAM is not one of the modes that you can use when using the Open statement. The available modes for the Open statement are: Append, Binary, Input, Output, and Random.