PPCS using guisimpolserver.exe

[Giancarlo Cavadini]

Hello, I’m doing my first experiments with PPCS. With Superbase all OK. Now I’m trying to use guisimpolserver.exe but when I start the program, after setting the *.cfg as described in the readme.txt file, I get the message “Unable to start the program because SMPOL32.DLL is not present”! After copying SMPOL32.DLL in the startup folder of guisimpolserver.exe am no longer receiving any message but apparently nothing happens (the program does not start). Question 1: Someone can tell me how to do? Question 2: with guisimpolserver.exe can I open and manage Superbase database (*.SBF) file? Thanks in advance. Giancarlo

[Giancarlo Cavadini]

I have seen the indications of Jean Vallee of 29.05.2013
http://www.simpol.com/forum/article.php?id=942&group=simpol.programming #
942
(thanks Jean).
Following the suggestions of Jean I added, to what was found in
utilitysimpolservr, the dll's mentioned namely smppcs32.dll, smsbme32.dll,
smslib32.dll, wxbase28u_vc_simpol.dll, wxmsw28u_adv_vc_simpol.dll and
wxmsw28u_core_vc_simpol.dll, but. . .
NOTHING HAPPENS! The program guisimpolserver.exe don’t start.
Someone can give me the correct informations?
I use the trial version of guisimpolserver.exe (3 licenses LAN) provided
with SIMPOL Professional. Could this be the problem? Should I buy a
regular license for 5 users to make my tests?
Thank you for each other relevant information.
Giancarlo

[Giancarlo Cavadini]

> On 10/07/13 17:43:40, Giancarlo wrote:

>> Hello,
>> I'm doing my first experiments with PPCS.
>> With Superbase all OK.
>> Now I'm trying to use guisimpolserver.exe but when I start the program,
>> after setting the *.cfg as described in the readme.txt file, I get the
>> message "Unable to start the program because SMPOL32.DLL is not present"!
>> After copying SMPOL32.DLL in the startup folder of guisimpolserver.exe am
>> no longer receiving any message but apparently nothing happens (the
>> program does not start).

>> Question 1:
>> Someone can tell me how to do?

>> Question 2:
>> with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>> file?

>> Thanks in advance.
>> Giancarlo

On 10/07/13 06:14:08, Giancarlo wrote:

> I have seen the indications of Jean Vallee of 29.05.2013
> http://www.simpol.com/forum/article.php?id=942&group=simpol.programming #
> 942
> (thanks Jean).
> Following the suggestions of Jean I added, to what was found in
> utilitysimpolservr, the dll's mentioned namely smppcs32.dll, smsbme32.dll,
> smslib32.dll, wxbase28u_vc_simpol.dll, wxmsw28u_adv_vc_simpol.dll and
> wxmsw28u_core_vc_simpol.dll, but. . .
> NOTHING HAPPENS! The program guisimpolserver.exe don’t start.
> Someone can give me the correct informations?
> I use the trial version of guisimpolserver.exe (3 licenses LAN) provided
> with SIMPOL Professional. Could this be the problem? Should I buy a
> regular license for 5 users to make my tests?
> Thank you for each other relevant information.
> Giancarlo

For your information: purchased and installed SIMPOL Database Engine
5-User Licence but nothing changes.
Giancarlo

[Ian Macpherson]

Giancarlo hello Pleased to help
This has happened to all of us
The simpolserver dos program works when placed in the
Utilitiessimpolserver folder but the guisimpolserver does NOT
You have to put guisimpolserver.exe & the associated icon in the simpolbin
folder You can leave your cfg file in the other folder but you have to
tell it where to look
C:SIMPOLbinguisimpolserver.exe c:simpolutilitiessimpolserverwhatever.cfg

Neil says he is working on another utility for this that will open
automatically etc etc but not ready yet apparently.
Re opening the sb files I cannot help you but I can say the conversion
utility works very well once the calcs, validations, lookups etc have been
removed.
Ian macpherson

[JD Kromkowski]

On 10/07/13 5:21 AM, Ian Macpherson wrote:
> You have to put guisimpolserver.exe & the associated icon in the simpolbin
> folder

Ian is correct.

I also just create a .bat file like this

rem first server script
cd C:SIMPOLbin
guisimpolserver.exe C:SIMPOLUtilitiessimpolserversample.cfg

And then I don't have to fool around with typing in the cmd window. And
I can create different .bats reference different .cfg s.

JDK

[JD Kromkowski]

On 10/07/13 3:20 AM, Giancarlo wrote:
> Question 2:
>>>with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>>>file?

No. the simpol server works with the .sbm datasources and the table(s)
therein, not with SBFs.

There is a utility to convert an .SBF to a Simpol database. Also
Personal has a utility to import .csv, ascii delimited or xml into a
simpol database.

[Giancarlo Cavadini]

Thanks Neil,
that's what I thought to do after seeing your tutorials and guides.
I hope I can make it.
Giancarlo

On 08/10/2013 12:36, Neil Robinson wrote:

> On 08/10/2013 10:26, Giancarlo wrote:
>> Thank you,
>> now I'm finally able to see guisimpolserver.exe run!
>> Having time would be nice to be able to write a program based on
>> simpolserver.smp. . .
>>
>> I've seen the conversion utilities that are a good thing.
>>
>> For the moment I am converting from Superbase to SIMPOL, and I have to
>> still use database files *.SBF.
>> Since PPCS should be able to allow the sharing of tables *.SBF and *.SBM
>> at the moment I am checking if I can live together Superbase programs
>> (*.SBP) and SIMPOL (*.SMP) that interact both at the same time with the
>> two database systems.

> Hi Giancarlo,

> Sorry not to get back to you sooner, we have been pretty tied up lately
trying to complete the 1.8 release. Still, I see the other
> forum members have put you right. The approach you will need is to convert
to Simpol SBM files, and in your Superbase program
> change the OPEN FILE statements to use PPCS. You can also still take
advantage of the Calc, Con, and Val formulas in your fields,
> if you have any, by using the syntax: OPEN FILE SHARE,0"UDP1:MYFILE" BLANK
USING "MYFILE.SBD". That is the fastest open command
> for Superbase when using PPCS. You cannot use th SER() command however, so
you should consider migrating to a table and a serial
> number function for retrieving one.

> Ciao, Neil

>> Giancarlo
>>
>> kromkowski wrote:
>>
>>> On 10/07/13 3:20 AM, Giancarlo wrote:
>>>> Question 2:
>>>>>> with guisimpolserver.exe can I open and manage Superbase database
(*.SBF)
>>>>>> file?
>>
>>
>>> No. the simpol server works with the .sbm datasources and the table(s)
>>> therein, not with SBFs.
>>
>>> There is a utility to convert an .SBF to a Simpol database. Also
>>> Personal has a utility to import .csv, ascii delimited or xml into a
>>> simpol database.
>>
>>
>>
>>
>>

[Giancarlo Cavadini]

Merci Ian,
maintenant je suis enfin en mesure de voir guisimpolserver.exe au travail
Giancarlo

Ian Macpherson wrote:

> Giancarlo hello Pleased to help
> This has happened to all of us
> The simpolserver dos program works when placed in the
> Utilitiessimpolserver folder but the guisimpolserver does NOT
> You have to put guisimpolserver.exe & the associated icon in the simpolbin
> folder You can leave your cfg file in the other folder but you have to
> tell it where to look
> C:SIMPOLbinguisimpolserver.exe c:simpolutilitiessimpolserverwhatever.cfg

> Neil says he is working on another utility for this that will open
> automatically etc etc but not ready yet apparently.
> Re opening the sb files I cannot help you but I can say the conversion
> utility works very well once the calcs, validations, lookups etc have been
> removed.
> Ian macpherson

[Giancarlo Cavadini]

Thank you,
now I'm finally able to see guisimpolserver.exe run!
Having time would be nice to be able to write a program based on
simpolserver.smp. . .

I've seen the conversion utilities that are a good thing.

For the moment I am converting from Superbase to SIMPOL, and I have to
still use database files *.SBF.
Since PPCS should be able to allow the sharing of tables *.SBF and *.SBM
at the moment I am checking if I can live together Superbase programs
(*.SBP) and SIMPOL (*.SMP) that interact both at the same time with the
two database systems.
Giancarlo

kromkowski wrote:

> On 10/07/13 3:20 AM, Giancarlo wrote:
>> Question 2:
>>>>with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>>>>file?

> No. the simpol server works with the .sbm datasources and the table(s)
> therein, not with SBFs.

> There is a utility to convert an .SBF to a Simpol database. Also
> Personal has a utility to import .csv, ascii delimited or xml into a
> simpol database.

[Michael]

On 08/10/2013 10:26, Giancarlo wrote:
> Thank you,
> now I'm finally able to see guisimpolserver.exe run!
> Having time would be nice to be able to write a program based on
> simpolserver.smp. . .
>
> I've seen the conversion utilities that are a good thing.
>
> For the moment I am converting from Superbase to SIMPOL, and I have to
> still use database files *.SBF.
> Since PPCS should be able to allow the sharing of tables *.SBF and *.SBM
> at the moment I am checking if I can live together Superbase programs
> (*.SBP) and SIMPOL (*.SMP) that interact both at the same time with the
> two database systems.

Hi Giancarlo,

Sorry not to get back to you sooner, we have been pretty tied up lately trying to complete the 1.8 release. Still, I see the other
forum members have put you right. The approach you will need is to convert to Simpol SBM files, and in your Superbase program
change the OPEN FILE statements to use PPCS. You can also still take advantage of the Calc, Con, and Val formulas in your fields,
if you have any, by using the syntax: OPEN FILE SHARE,0"UDP1:MYFILE" BLANK USING "MYFILE.SBD". That is the fastest open command
for Superbase when using PPCS. You cannot use th SER() command however, so you should consider migrating to a table and a serial
number function for retrieving one.

Ciao, Neil

> Giancarlo
>
> kromkowski wrote:
>
>> On 10/07/13 3:20 AM, Giancarlo wrote:
>>> Question 2:
>>>>> with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>>>>> file?
>
>
>> No. the simpol server works with the .sbm datasources and the table(s)
>> therein, not with SBFs.
>
>> There is a utility to convert an .SBF to a Simpol database. Also
>> Personal has a utility to import .csv, ascii delimited or xml into a
>> simpol database.
>
>
>
>
>

[Author]

Posts