Distributing Application: Netsetup wouldn't work, Disk144 does  
Author Message
VAB





PostPosted: Sat Feb 12 04:44:58 CST 2005 Top

Exchange Servers >> Distributing Application: Netsetup wouldn't work, Disk144 does

I have spent over 6 hours today trying to make my distributed program work
using Netsetup in step 3 of the Setup Wizard in VFP 6.0.

With the Netsetup, the application installs fine and some options even work.
However, I have two databases that are distibuted with the application named
wwdata and wwtables. Database wwdata has its dbf files stored in
\\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
application tried to open a table in wwtables, I keep getting the message
"Error instantiating cursor object. File City not found in
\\....\wwtables.dbc" or something like that. I tried numerous times by
cleaning up the project and making sure that dbc file is not corrupted or
something, but couldn't get rid of the error.

Finally, I reluctantly selected the 1.44 MB option (I want to distribute the
application on a CD in stead of floppies), and BOOM, it work the first time
installation. However, it created six subdirectories DISK1 to DISK6 in the
main directory named DISK144.

Does anyone know the cause of this behaviour and is there any other way I
can create Distribution files under one directory.

Thanks in advance for heliping out......

Exchange Server45  
 
 
Jan





PostPosted: Sat Feb 12 04:44:58 CST 2005 Top

Exchange Servers >> Distributing Application: Netsetup wouldn't work, Disk144 does Subhash,

When you copy the files to your distribution folder, the databases should be
stored in the appropriate subfolders and that should work. Alternatively,
you can create DML code to create your data (using gendbc for each database)
and then in a post executable you can run the generated code to create the
databases.

If the databases need to be populated you can use the post executable to do
this also, either by:-
- including the data in a CSV file where the first field indicates the
database name, the second field indicates the table name and the remaining
fields
contain the data
- or by providing the data in specific files that you include in your
install

HTH
Jan



>I have spent over 6 hours today trying to make my distributed program work
> using Netsetup in step 3 of the Setup Wizard in VFP 6.0.
>
> With the Netsetup, the application installs fine and some options even
> work.
> However, I have two databases that are distibuted with the application
> named
> wwdata and wwtables. Database wwdata has its dbf files stored in
> \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
> application tried to open a table in wwtables, I keep getting the message
> "Error instantiating cursor object. File City not found in
> \\....\wwtables.dbc" or something like that. I tried numerous times by
> cleaning up the project and making sure that dbc file is not corrupted or
> something, but couldn't get rid of the error.
>
> Finally, I reluctantly selected the 1.44 MB option (I want to distribute
> the
> application on a CD in stead of floppies), and BOOM, it work the first
> time
> installation. However, it created six subdirectories DISK1 to DISK6 in the
> main directory named DISK144.
>
> Does anyone know the cause of this behaviour and is there any other way I
> can create Distribution files under one directory.
>
> Thanks in advance for heliping out......


 
 
Subhash





PostPosted: Sat Feb 12 13:57:03 CST 2005 Top

Exchange Servers >> Distributing Application: Netsetup wouldn't work, Disk144 does Jan,

I do have databases in the same subfolder in distribution folder as they are
in the development folder. I simply copy the subfolder from development
folder to the distribution folder. As I said, when I use Netsetup on the same
distribution folder, it doesn't work but when I use 1.44 MB option, then it
works fine.

Thanks.



> Subhash,
>
> When you copy the files to your distribution folder, the databases should be
> stored in the appropriate subfolders and that should work. Alternatively,
> you can create DML code to create your data (using gendbc for each database)
> and then in a post executable you can run the generated code to create the
> databases.
>
> If the databases need to be populated you can use the post executable to do
> this also, either by:-
> - including the data in a CSV file where the first field indicates the
> database name, the second field indicates the table name and the remaining
> fields
> contain the data
> - or by providing the data in specific files that you include in your
> install
>
> HTH
> Jan
>


> >I have spent over 6 hours today trying to make my distributed program work
> > using Netsetup in step 3 of the Setup Wizard in VFP 6.0.
> >
> > With the Netsetup, the application installs fine and some options even
> > work.
> > However, I have two databases that are distibuted with the application
> > named
> > wwdata and wwtables. Database wwdata has its dbf files stored in
> > \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
> > application tried to open a table in wwtables, I keep getting the message
> > "Error instantiating cursor object. File City not found in
> > \\....\wwtables.dbc" or something like that. I tried numerous times by
> > cleaning up the project and making sure that dbc file is not corrupted or
> > something, but couldn't get rid of the error.
> >
> > Finally, I reluctantly selected the 1.44 MB option (I want to distribute
> > the
> > application on a CD in stead of floppies), and BOOM, it work the first
> > time
> > installation. However, it created six subdirectories DISK1 to DISK6 in the
> > main directory named DISK144.
> >
> > Does anyone know the cause of this behaviour and is there any other way I
> > can create Distribution files under one directory.
> >
> > Thanks in advance for heliping out......
>
>
>
 
 
Jan





PostPosted: Sun Feb 13 16:26:38 CST 2005 Top

Exchange Servers >> Distributing Application: Netsetup wouldn't work, Disk144 does Subhash,

I use gendbc to generate the code to recreate the database and run this code
in a post install executable. As per my previous answer, this may be the
solution to your problem. Remember that the setup wizard is discontinued
after VFP6 and when you upgrade you will need to use another install maker.
Installshield express is included from VFP7 onwards, but only supports the
post install executable from vfp8 on.

Using a post install executable gives you better control of database
installation. Typically you would copy the contents of the database folder
to a backup folder, destroy the contents of the database folder, recreate
the database programmatically then append the contents of the database in
the backup folder to reinstate the user/customer data. Obviously as you are
in control you can also initiate or derive the contents of new columns in
your tables.

HTH
Jan



> Jan,
>
> I do have databases in the same subfolder in distribution folder as they
> are
> in the development folder. I simply copy the subfolder from development
> folder to the distribution folder. As I said, when I use Netsetup on the
> same
> distribution folder, it doesn't work but when I use 1.44 MB option, then
> it
> works fine.
>
> Thanks.
>

>
>> Subhash,
>>
>> When you copy the files to your distribution folder, the databases should
>> be
>> stored in the appropriate subfolders and that should work. Alternatively,
>> you can create DML code to create your data (using gendbc for each
>> database)
>> and then in a post executable you can run the generated code to create
>> the
>> databases.
>>
>> If the databases need to be populated you can use the post executable to
>> do
>> this also, either by:-
>> - including the data in a CSV file where the first field indicates the
>> database name, the second field indicates the table name and the
>> remaining
>> fields
>> contain the data
>> - or by providing the data in specific files that you include in your
>> install
>>
>> HTH
>> Jan
>>


>> >I have spent over 6 hours today trying to make my distributed program
>> >work
>> > using Netsetup in step 3 of the Setup Wizard in VFP 6.0.
>> >
>> > With the Netsetup, the application installs fine and some options even
>> > work.
>> > However, I have two databases that are distibuted with the application
>> > named
>> > wwdata and wwtables. Database wwdata has its dbf files stored in
>> > \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
>> > application tried to open a table in wwtables, I keep getting the
>> > message
>> > "Error instantiating cursor object. File City not found in
>> > \\....\wwtables.dbc" or something like that. I tried numerous times by
>> > cleaning up the project and making sure that dbc file is not corrupted
>> > or
>> > something, but couldn't get rid of the error.
>> >
>> > Finally, I reluctantly selected the 1.44 MB option (I want to
>> > distribute
>> > the
>> > application on a CD in stead of floppies), and BOOM, it work the first
>> > time
>> > installation. However, it created six subdirectories DISK1 to DISK6 in
>> > the
>> > main directory named DISK144.
>> >
>> > Does anyone know the cause of this behaviour and is there any other way
>> > I
>> > can create Distribution files under one directory.
>> >
>> > Thanks in advance for heliping out......
>>
>>
>>


 
 
Subhash





PostPosted: Wed Feb 16 13:35:08 CST 2005 Top

Exchange Servers >> Distributing Application: Netsetup wouldn't work, Disk144 does Thanks Jan for your reply. I can't find documentation on GENDBC. Can you tell
where I can find it. Also, as I am new to VFP, I am not familiar with DML
code. What is it and where I can learn about it.

Could you also elaborate a little on why I need to adopt this approach and
why the Setup wouldn't work in Netsetup option although it works fine when I
use 1.44 MB option.

Thanks.



> Subhash,
>
> I use gendbc to generate the code to recreate the database and run this code
> in a post install executable. As per my previous answer, this may be the
> solution to your problem. Remember that the setup wizard is discontinued
> after VFP6 and when you upgrade you will need to use another install maker.
> Installshield express is included from VFP7 onwards, but only supports the
> post install executable from vfp8 on.
>
> Using a post install executable gives you better control of database
> installation. Typically you would copy the contents of the database folder
> to a backup folder, destroy the contents of the database folder, recreate
> the database programmatically then append the contents of the database in
> the backup folder to reinstate the user/customer data. Obviously as you are
> in control you can also initiate or derive the contents of new columns in
> your tables.
>
> HTH
> Jan
>


> > Jan,
> >
> > I do have databases in the same subfolder in distribution folder as they
> > are
> > in the development folder. I simply copy the subfolder from development
> > folder to the distribution folder. As I said, when I use Netsetup on the
> > same
> > distribution folder, it doesn't work but when I use 1.44 MB option, then
> > it
> > works fine.
> >
> > Thanks.
> >

> >
> >> Subhash,
> >>
> >> When you copy the files to your distribution folder, the databases should
> >> be
> >> stored in the appropriate subfolders and that should work. Alternatively,
> >> you can create DML code to create your data (using gendbc for each
> >> database)
> >> and then in a post executable you can run the generated code to create
> >> the
> >> databases.
> >>
> >> If the databases need to be populated you can use the post executable to
> >> do
> >> this also, either by:-
> >> - including the data in a CSV file where the first field indicates the
> >> database name, the second field indicates the table name and the
> >> remaining
> >> fields
> >> contain the data
> >> - or by providing the data in specific files that you include in your
> >> install
> >>
> >> HTH
> >> Jan
> >>


> >> >I have spent over 6 hours today trying to make my distributed program
> >> >work
> >> > using Netsetup in step 3 of the Setup Wizard in VFP 6.0.
> >> >
> >> > With the Netsetup, the application installs fine and some options even
> >> > work.
> >> > However, I have two databases that are distibuted with the application
> >> > named
> >> > wwdata and wwtables. Database wwdata has its dbf files stored in
> >> > \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
> >> > application tried to open a table in wwtables, I keep getting the
> >> > message
> >> > "Error instantiating cursor object. File City not found in
> >> > \\....\wwtables.dbc" or something like that. I tried numerous times by
> >> > cleaning up the project and making sure that dbc file is not corrupted
> >> > or
> >> > something, but couldn't get rid of the error.
> >> >
> >> > Finally, I reluctantly selected the 1.44 MB option (I want to
> >> > distribute
> >> > the
> >> > application on a CD in stead of floppies), and BOOM, it work the first
> >> > time
> >> > installation. However, it created six subdirectories DISK1 to DISK6 in
> >> > the
> >> > main directory named DISK144.
> >> >
> >> > Does anyone know the cause of this behaviour and is there any other way
> >> > I
> >> > can create Distribution files under one directory.
> >> >
> >> > Thanks in advance for heliping out......
> >>
> >>
> >>
>
>
>