Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 10 total
Thread First baby steps with dbsrvr
Tue, Aug 4 2009 1:29 PMPermanent Link

"John Taylor"
Hi guys,

Just getting my feet wet with the database server and a simple project.

I created a simple table with dbsys named test.sfdata  and added the
database with
the server admin utility named it TESTDB.

I created a form, dropped the following components on it:

TDBIsamSession - set the type to stRemote, session name = 'Remote'
TDBIsamDatabase - set the RemoteDatabase to TESTDB, it sees it, set
the sessionname to 'Remote'
TDBIsamEngine - set enginetype to etClient and changed the data and index
extensions to .sfdata and .sfidx to match the file extensions

Dropped a TDBIsamTable component on the form, set the databasename and
sessionname properties.

Form has 1 button onclick handler code is DBIsamTAble1.active := true;

I notice that the table component is not 'aware' of the table test.sfdata in
the
drop down box in the object inspector, but I type in the table name 'test'
anyway.

I compile, run -  an exception is immediately thrown 'Class TDBIsamEngine
not found'.

If I delete the Engine component from the form and change the filenames to
use .dat and .idx then the exception goes away and now the table
component can see the table in design mode (shows in drop down box)
and can be opened in the button's onclick handler.

So... how is it possible to use other than the default .dat, .idx, .blb file
extentions without an Engine component ?  Why am I getting 'Class.. not
found' ?

I'm obviously missing something very basic.

Thanks in advance.
JT
Tue, Aug 4 2009 1:37 PMPermanent Link

"John Taylor"
I found the post about the 'class not found' error and have resolved that
but
I still cannot use tables with extensions different than .dat, get 'table
not found'
error when trying to set active to true and cannot see it in design mode.

JT


"John Taylor" <jcta@snappysoftware.com> wrote in message
news:B855064C-C776-4DE1-A75C-B7683C603B65@news.elevatesoft.com...
> Hi guys,
>
> Just getting my feet wet with the database server and a simple project.
>
> I created a simple table with dbsys named test.sfdata  and added the
> database with
> the server admin utility named it TESTDB.
>
> I created a form, dropped the following components on it:
>
> TDBIsamSession - set the type to stRemote, session name = 'Remote'
> TDBIsamDatabase - set the RemoteDatabase to TESTDB, it sees it, set
> the sessionname to 'Remote'
> TDBIsamEngine - set enginetype to etClient and changed the data and index
> extensions to .sfdata and .sfidx to match the file extensions
>
> Dropped a TDBIsamTable component on the form, set the databasename and
> sessionname properties.
>
> Form has 1 button onclick handler code is DBIsamTAble1.active := true;
>
> I notice that the table component is not 'aware' of the table test.sfdata
> in the
> drop down box in the object inspector, but I type in the table name 'test'
> anyway.
>
> I compile, run -  an exception is immediately thrown 'Class TDBIsamEngine
> not found'.
>
> If I delete the Engine component from the form and change the filenames to
> use .dat and .idx then the exception goes away and now the table
> component can see the table in design mode (shows in drop down box)
> and can be opened in the button's onclick handler.
>
> So... how is it possible to use other than the default .dat, .idx, .blb
> file
> extentions without an Engine component ?  Why am I getting 'Class.. not
> found' ?
>
> I'm obviously missing something very basic.
>
> Thanks in advance.
> JT
Tue, Aug 4 2009 2:14 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< I found the post about the 'class not found' error and have resolved that
but I still cannot use tables with extensions different than .dat, get
'table not found' error when trying to set active to true and cannot see it
in design mode. >>

Which TDBISAMEngine properties did you modify for the file extensions ?
Also, what version of Delphi are you using ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Aug 4 2009 2:34 PMPermanent Link

"John Taylor"
Modified as follows in the property inspector:
TableBlobBackupExtension = .sfbbk
TableBlobExtention = .sfblb
TableBlobUpgradeExtension = .sfblb
TableBlobTempExtension = .sfblb
TableDataBackupExtension = .sfdat
TableDataExtension = .sfdat
TAbleDataTempExtension = .sfdat
TableDataUpgradeExtension = .sfdup
TableIndexBackupExtension = .sfibk
TableIndexExtension = .sfidx
TableIndexTempExtension = .sfidx
TableIndexUpgradeExtension = .sfiup

Do I need to do anything with the server ?  I looked
in the admin utility, didn't see anything there related.

JT


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:190E2965-D45A-47BE-B4F3-011C24F3D4C2@news.elevatesoft.com...
> John,
>
> << I found the post about the 'class not found' error and have resolved
> that but I still cannot use tables with extensions different than .dat,
> get 'table not found' error when trying to set active to true and cannot
> see it in design mode. >>
>
> Which TDBISAMEngine properties did you modify for the file extensions ?
> Also, what version of Delphi are you using ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Tue, Aug 4 2009 3:17 PMPermanent Link

"Rita"

"John Taylor" <jcta@snappysoftware.com> wrote in message
news:DB11E767-DA5E-407E-869C-1D4486E6A061@news.elevatesoft.com...
> Modified as follows in the property inspector:
> TableBlobBackupExtension = .sfbbk
> TableBlobExtention = .sfblb
> TableBlobUpgradeExtension = .sfblb
> TableBlobTempExtension = .sfblb
> TableDataBackupExtension = .sfdat
> TableDataExtension = .sfdat
> TAbleDataTempExtension = .sfdat
> TableDataUpgradeExtension = .sfdup
> TableIndexBackupExtension = .sfibk
> TableIndexExtension = .sfidx
> TableIndexTempExtension = .sfidx
> TableIndexUpgradeExtension = .sfiup
>
> Do I need to do anything with the server ?  I looked
> in the admin utility, didn't see anything there related.
>

Is the server really remote and have u setup the username
and password to the Database ?
Try the default *.dat and *.idx 1st set the IP for your remote
server everything u have said so far seems ok to me.
My remote server works fine session got me 1st try.  I
love the whole shebang keep trying u will get there.
Rita

Wed, Aug 5 2009 6:40 AMPermanent Link

"John Taylor"
Sorry, I forgot

Delphi 2007, DBIsam 4.27


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:190E2965-D45A-47BE-B4F3-011C24F3D4C2@news.elevatesoft.com...
> John,
>
> << I found the post about the 'class not found' error and have resolved
> that but I still cannot use tables with extensions different than .dat,
> get 'table not found' error when trying to set active to true and cannot
> see it in design mode. >>
>
> Which TDBISAMEngine properties did you modify for the file extensions ?
> Also, what version of Delphi are you using ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Wed, Aug 5 2009 6:43 AMPermanent Link

"John Taylor"
The server is not really remote, it is local at 127.0.0.1
I am using the default password and user name

I have tried the default file extensions, .dat and .idx, I renamed
my files with those extensions and everything works just fine,
it's when I try to drop an engine component on the form and
change the extensions there (after renaming the files) that things
get screwy.

"Rita" <nospam@nospam> wrote in message
news:FE4E64A9-56ED-46E3-A7E8-83C95E2612A3@news.elevatesoft.com...
>
> "John Taylor" <jcta@snappysoftware.com> wrote in message
> news:DB11E767-DA5E-407E-869C-1D4486E6A061@news.elevatesoft.com...
>> Modified as follows in the property inspector:
>> TableBlobBackupExtension = .sfbbk
>> TableBlobExtention = .sfblb
>> TableBlobUpgradeExtension = .sfblb
>> TableBlobTempExtension = .sfblb
>> TableDataBackupExtension = .sfdat
>> TableDataExtension = .sfdat
>> TAbleDataTempExtension = .sfdat
>> TableDataUpgradeExtension = .sfdup
>> TableIndexBackupExtension = .sfibk
>> TableIndexExtension = .sfidx
>> TableIndexTempExtension = .sfidx
>> TableIndexUpgradeExtension = .sfiup
>>
>> Do I need to do anything with the server ?  I looked
>> in the admin utility, didn't see anything there related.
>>
>
> Is the server really remote and have u setup the username
> and password to the Database ?
> Try the default *.dat and *.idx 1st set the IP for your remote
> server everything u have said so far seems ok to me.
> My remote server works fine session got me 1st try.  I
> love the whole shebang keep trying u will get there.
> Rita
>
Wed, Aug 5 2009 11:35 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< Do I need to do anything with the server ?  I looked in the admin
utility, didn't see anything there related. >>

My apologies, I completely missed that you were running the server in your
tests.  You need to add these settings in a dbsrvr.ini file:

[Server Parameters]
Table Data Extension=
Table Index Extension=
Table Blob Extension=
Backup Table Data Extension=
Backup Table Index Extension=
Backup Table Blob Extension=
Upgrade Table Data Extension=
Upgrade Table Index Extension=
Upgrade Table Blob Extension=
Temp Table Data Extension=
Temp Table Index Extension=
Temp Table Blob Extension=

(just fill in the desired extensions, and leave out any settings that you
want to leave as-is)

and make sure that the dbsrvr.ini file is in the same directory as the
dbsrvr.exe file.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Aug 5 2009 11:58 AMPermanent Link

"John Taylor"
Thank you Tim, I was just opening this back up to give it another go.


John

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:0E9067CA-EED4-48CF-A3F9-977044DFC1E8@news.elevatesoft.com...
> John,
>
> << Do I need to do anything with the server ?  I looked in the admin
> utility, didn't see anything there related. >>
>
> My apologies, I completely missed that you were running the server in your
> tests.  You need to add these settings in a dbsrvr.ini file:
>
> [Server Parameters]
> Table Data Extension=
> Table Index Extension=
> Table Blob Extension=
> Backup Table Data Extension=
> Backup Table Index Extension=
> Backup Table Blob Extension=
> Upgrade Table Data Extension=
> Upgrade Table Index Extension=
> Upgrade Table Blob Extension=
> Temp Table Data Extension=
> Temp Table Index Extension=
> Temp Table Blob Extension=
>
> (just fill in the desired extensions, and leave out any settings that you
> want to leave as-is)
>
> and make sure that the dbsrvr.ini file is in the same directory as the
> dbsrvr.exe file.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Wed, Aug 5 2009 12:13 PMPermanent Link

"John Taylor"
Of course that was it, Tim.  Thanks, I wondered if something had to
be done with the server, I'm certain I did not read the manual thoroughly
enough.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:0E9067CA-EED4-48CF-A3F9-977044DFC1E8@news.elevatesoft.com...
> John,
>
> << Do I need to do anything with the server ?  I looked in the admin
> utility, didn't see anything there related. >>
>
> My apologies, I completely missed that you were running the server in your
> tests.  You need to add these settings in a dbsrvr.ini file:
>
> [Server Parameters]
> Table Data Extension=
> Table Index Extension=
> Table Blob Extension=
> Backup Table Data Extension=
> Backup Table Index Extension=
> Backup Table Blob Extension=
> Upgrade Table Data Extension=
> Upgrade Table Index Extension=
> Upgrade Table Blob Extension=
> Temp Table Data Extension=
> Temp Table Index Extension=
> Temp Table Blob Extension=
>
> (just fill in the desired extensions, and leave out any settings that you
> want to leave as-is)
>
> and make sure that the dbsrvr.ini file is in the same directory as the
> dbsrvr.exe file.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Image