Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

!!! HELP !!! Installable ISAM Error (3170)

28 views
Skip to first unread message

Michael Winsel

unread,
Feb 19, 1996, 3:00:00 AM2/19/96
to
Hey Everyone,

I have a hell of a problem! I have a program that interfaces with
another programs database, which is in dBase III format. When I run
the code within VB3, its fine. However, as soon as I run the
executable file, I get an error (3170) when trying to connect to the
dBase III database....

"Couldn't find installable ISAM"

As you can see from below, I included the [Installable ISAMs] section
in my programs Ini file ... but it still fails. I also cut the
connection code below.

What am I doing?????????????????????????????

I appreciate any help.

MiWi

********************************************************************
********** Source Code *********************************************
' This is part of the routine connecting to the dBase III database
' via the DataControl is called "MST":

' Connect to Database
' ===================
MST.Exclusive = False
MST.Connect = "dBASE III"
MST.DatabaseName = TempStr$
MST.RecordSource = "MSTREQ"
' now the 3170 error occurs


' This is part of the routine connecting to the dBase III database
' via the OpenDatabase statement:

Dim MainDB as Database
Dim MainT as Table

' Connect to Database
' ===================
Set MainDB = OpenDatabase(TempStr$, False, False, "dBASE III")
Set MainT = MainDB.OpenTable("MSTREQ")
' now the 3170 error occurs


********************************************************************
****** Settings in INI File ****************************************

[Installable ISAMs]
dBASE III=C:\WIN\SYSTEM\xbs200.dll

[dBase ISAM]
Deleted=On
PageTimeout=600

[ISAM]
PageTimeOut=5
MaxBufferSize=128
LockRetry=20
CommitLockRetry=20
ReadAheadPages=16


Philip Bush

unread,
Feb 21, 1996, 3:00:00 AM2/21/96
to
Michael Winsel wrote:
> I have a hell of a problem! I have a program that interfaces with
> another programs database, which is in dBase III format. When I run
> the code within VB3, its fine. However, as soon as I run the
> executable file, I get an error (3170) when trying to connect to the
> dBase III database....
> "Couldn't find installable ISAM"

Try the following code in your form_load:
AppPath$ = app.Path
If Right$(AppPath$, 1) <> "\" Then AppPath$ = AppPath$ + "\"
a$ = AppPath$ + "WHATEVER.INI" 'your ini file!!
X = 1
SetDataAccessOption X, a$


I use the following ini information:
[Installable ISAMs]
dBASE III=C:\WINDOWS\SYSTEM\xbs200.dll
dBASE IV=C:\WINDOWS\SYSTEM\xbs200.dll

[dBase ISAM]
Deleted=On


Also see my Vb tip web page: http://pages.prodigy.com/MO/vbsite/

0 new messages