![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 10 total |
![]() |
Tue, Aug 4 2009 1:29 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 PM | Permanent 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 PM | Permanent 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 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 AM | Permanent 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 PM | Permanent 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 > |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |