Author | Topic: using programs with windows SBS 2003 | |
---|---|---|
Ernesto Avedillo | using programs with windows SBS 2003 on Fri, 24 Feb 2006 18:00:27 +0100 Hello to everybody I have developed a program thas was working very well in a windows 2000 server. This last month we decided to buy a new server but this one has a windows small bussines server 2003 . When I try to execute this program with this system nothing happens , no execution, no window opened, absolutely nothing. I also have some problems accesing the datafiles (DBF files). When accesing a file, W2000 needs 1,5 seconds, WSBS2003 needs 35 seconds. This is the code (AreaConc)->( DBGoTop() ) Do While !(AreaConc)->( EOF() ) AADD(aCompOld, {(AreaConc)->Num_Comp , (AreaConc)->P_Peso,(AreaConc)->Lab,(AreaConc)->Fase2}) (AreaConc)->( DBSkip() ) EndDo Very simple Does anybody have an idea why? Thanks | |
Rodd Graham | Re: using programs with windows SBS 2003 on Sat, 25 Feb 2006 03:45:17 -0600 Ernesto, I assume you are trying to run the Xbase++ on the server and the DBF are on the same server. Things to check: XPPFatal.log generated? Windows Event Logs report any problems? Application has same environment as client workstation where it does run? (i.e. drive mappings) Local security policy to restrictive to run the program? (Win2003 defaults to tighter security at console sessions than Win2000) Any chance hardware/software DEP is the culprit? I assume since you cannot run on the server, the performance problems are at a network workstation. Things to check: Is it truly taking 35 seconds in the loop or is it possible that the time is in opening the table? If it is in establishing table access, do you have routing or name resolution configuration errors? Any chance you forgot to disable oplocking when changing or upgrading to the Win2003? Is the SBS server also an internet firewall/gateway using ISA 2000? If so, have you made sure windows file services are disabled on the public nic, that the private nic is primary, and name resolution services (DNS/WINS) for the windows client are not resolving to the public nic. No confusion regarding NetBui, TCP/IP, and NetBios encapsulated in TCP/IP? I can confirm that Xbase++ apps run fine for me on Win2K3 and have also worked with 2K3 SBS, but I also use ADS which eliminates any direct file access of tables. When properly configured, Win2K3 will perform at least as well as Win2K. Win2K3 SBS (premium) is just a bundling of Win2K3, Exchange, Sql Server, and ISA with some minor extra features and scripts to simplify the installation. Buying Win2K3, Exchange, Sql Server and ISA seperately and installing on single computer is esentially same as SBS except more work and more expensive. Hopefully something above points you to a solution. Rodd "Ernesto Avedillo" <eavedillo@iacsl.e.telefonica.net> wrote in message news:4ace1b5d$1211a25a$9c5a1@news.alaska-software.com... > Hello to everybody > > I have developed a program thas was working very well in a windows 2000 > server. This last month we decided to buy a new server but this one has a > windows small bussines server 2003 . When I try to execute this program > with > this system nothing happens , no execution, no window opened, absolutely > nothing. > I also have some problems accesing the datafiles (DBF files). When > accesing > a file, W2000 needs 1,5 seconds, WSBS2003 needs 35 seconds. > This is the code > > (AreaConc)->( DBGoTop() ) > Do While !(AreaConc)->( EOF() ) > AADD(aCompOld, {(AreaConc)->Num_Comp , > (AreaConc)->P_Peso,(AreaConc)->Lab,(AreaConc)->Fase2}) > (AreaConc)->( DBSkip() ) > EndDo > > Very simple > > Does anybody have an idea why? > Thanks > > > > > | |
Volker Thimm | Re: using programs with windows SBS 2003 on Fri, 03 Mar 2006 13:04:56 +0100 Hi Rodd, I'm having nearly the same problem. My programm works perfektly on W2k Server but on a very fast W2k3 server with 2GB memory it takes 3 minutes to built the NTX-Files (50 sec. before). The files and the programm is in the same directory on the server. I heard, that there are problems with other DB-Systems too like FoxPro Volker "Rodd Graham" <rodd@grahamautomation.com> schrieb im Newsbeitrag news:410eac7a$1ecc100c$9d073@news.alaska-software.com... > Ernesto, > > I assume you are trying to run the Xbase++ on the server and the DBF are on > the same server. > > Things to check: > > XPPFatal.log generated? > Windows Event Logs report any problems? > Application has same environment as client workstation where it does run? > (i.e. drive mappings) > Local security policy to restrictive to run the program? (Win2003 defaults > to tighter security at console sessions than Win2000) > Any chance hardware/software DEP is the culprit? > > I assume since you cannot run on the server, the performance problems are at > a network workstation. > > Things to check: > > Is it truly taking 35 seconds in the loop or is it possible that the time is > in opening the table? If it is in establishing table access, do you have > routing or name resolution configuration errors? > Any chance you forgot to disable oplocking when changing or upgrading to the > Win2003? > Is the SBS server also an internet firewall/gateway using ISA 2000? If so, > have you made sure windows file services are disabled on the public nic, > that the private nic is primary, and name resolution services (DNS/WINS) for > the windows client are not resolving to the public nic. > No confusion regarding NetBui, TCP/IP, and NetBios encapsulated in TCP/IP? > > I can confirm that Xbase++ apps run fine for me on Win2K3 and have also > worked with 2K3 SBS, but I also use ADS which eliminates any direct file > access of tables. When properly configured, Win2K3 will perform at least as > well as Win2K. Win2K3 SBS (premium) is just a bundling of Win2K3, Exchange, > Sql Server, and ISA with some minor extra features and scripts to simplify > the installation. Buying Win2K3, Exchange, Sql Server and ISA seperately > and installing on single computer is esentially same as SBS except more work > and more expensive. > > Hopefully something above points you to a solution. > > Rodd > > "Ernesto Avedillo" <eavedillo@iacsl.e.telefonica.net> wrote in message > news:4ace1b5d$1211a25a$9c5a1@news.alaska-software.com... > > Hello to everybody > > > > I have developed a program thas was working very well in a windows 2000 > > server. This last month we decided to buy a new server but this one has a > > windows small bussines server 2003 . When I try to execute this program > > with > > this system nothing happens , no execution, no window opened, absolutely > > nothing. > > I also have some problems accesing the datafiles (DBF files). When > > accesing > > a file, W2000 needs 1,5 seconds, WSBS2003 needs 35 seconds. > > This is the code > > > > (AreaConc)->( DBGoTop() ) > > Do While !(AreaConc)->( EOF() ) > > AADD(aCompOld, {(AreaConc)->Num_Comp , > > (AreaConc)->P_Peso,(AreaConc)->Lab,(AreaConc)->Fase2}) > > (AreaConc)->( DBSkip() ) > > EndDo > > > > Very simple > > > > Does anybody have an idea why? > > Thanks > > > > > > > > > > > > | |
Volker Thimm | Re: using programs with windows SBS 2003 on Fri, 03 Mar 2006 13:05:54 +0100 Hi Rodd, I'm having nearly the same problem. My programm works perfektly on W2k Server but on a very fast W2k3 server with 2GB memory it takes 3 minutes to built the NTX-Files (50 sec. before). The files and the programm is in the same directory on the server. I heard, that there are problems with other DB-Systems too like FoxPro Volker "Rodd Graham" <rodd@grahamautomation.com> schrieb im Newsbeitrag news:410eac7a$1ecc100c$9d073@news.alaska-software.com... > Ernesto, > > I assume you are trying to run the Xbase++ on the server and the DBF are on > the same server. > > Things to check: > > XPPFatal.log generated? > Windows Event Logs report any problems? > Application has same environment as client workstation where it does run? > (i.e. drive mappings) > Local security policy to restrictive to run the program? (Win2003 defaults > to tighter security at console sessions than Win2000) > Any chance hardware/software DEP is the culprit? > > I assume since you cannot run on the server, the performance problems are at > a network workstation. > > Things to check: > > Is it truly taking 35 seconds in the loop or is it possible that the time is > in opening the table? If it is in establishing table access, do you have > routing or name resolution configuration errors? > Any chance you forgot to disable oplocking when changing or upgrading to the > Win2003? > Is the SBS server also an internet firewall/gateway using ISA 2000? If so, > have you made sure windows file services are disabled on the public nic, > that the private nic is primary, and name resolution services (DNS/WINS) for > the windows client are not resolving to the public nic. > No confusion regarding NetBui, TCP/IP, and NetBios encapsulated in TCP/IP? > > I can confirm that Xbase++ apps run fine for me on Win2K3 and have also > worked with 2K3 SBS, but I also use ADS which eliminates any direct file > access of tables. When properly configured, Win2K3 will perform at least as > well as Win2K. Win2K3 SBS (premium) is just a bundling of Win2K3, Exchange, > Sql Server, and ISA with some minor extra features and scripts to simplify > the installation. Buying Win2K3, Exchange, Sql Server and ISA seperately > and installing on single computer is esentially same as SBS except more work > and more expensive. > > Hopefully something above points you to a solution. > > Rodd > > "Ernesto Avedillo" <eavedillo@iacsl.e.telefonica.net> wrote in message > news:4ace1b5d$1211a25a$9c5a1@news.alaska-software.com... > > Hello to everybody > > > > I have developed a program thas was working very well in a windows 2000 > > server. This last month we decided to buy a new server but this one has a > > windows small bussines server 2003 . When I try to execute this program > > with > > this system nothing happens , no execution, no window opened, absolutely > > nothing. > > I also have some problems accesing the datafiles (DBF files). When > > accesing > > a file, W2000 needs 1,5 seconds, WSBS2003 needs 35 seconds. > > This is the code > > > > (AreaConc)->( DBGoTop() ) > > Do While !(AreaConc)->( EOF() ) > > AADD(aCompOld, {(AreaConc)->Num_Comp , > > (AreaConc)->P_Peso,(AreaConc)->Lab,(AreaConc)->Fase2}) > > (AreaConc)->( DBSkip() ) > > EndDo > > > > Very simple > > > > Does anybody have an idea why? > > Thanks > > > > > > > > > > > > | |
James Loughner | Re: using programs with windows SBS 2003 on Fri, 03 Mar 2006 10:12:54 -0500 This is just M$ trying to get you to buy MSSQL. Has all the Caching been tuned off?? Jim Volker Thimm wrote: > Hi Rodd, > I'm having nearly the same problem. My programm works perfektly on W2k > Server but on a very fast W2k3 server with 2GB memory it takes 3 minutes to > built the NTX-Files (50 sec. before). The files and the programm is in the > same directory on the server. I heard, that there are problems with other > DB-Systems too like FoxPro > > Volker > "Rodd Graham" <rodd@grahamautomation.com> schrieb im Newsbeitrag > news:410eac7a$1ecc100c$9d073@news.alaska-software.com... > >>Ernesto, >> >>I assume you are trying to run the Xbase++ on the server and the DBF are > > on > >>the same server. >> >>Things to check: >> >>XPPFatal.log generated? >>Windows Event Logs report any problems? >>Application has same environment as client workstation where it does run? >>(i.e. drive mappings) >>Local security policy to restrictive to run the program? (Win2003 defaults >>to tighter security at console sessions than Win2000) >>Any chance hardware/software DEP is the culprit? >> >>I assume since you cannot run on the server, the performance problems are > > at > >>a network workstation. >> >>Things to check: >> >>Is it truly taking 35 seconds in the loop or is it possible that the time > > is > >>in opening the table? If it is in establishing table access, do you have >>routing or name resolution configuration errors? >>Any chance you forgot to disable oplocking when changing or upgrading to > > the > >>Win2003? >>Is the SBS server also an internet firewall/gateway using ISA 2000? If > > so, > >>have you made sure windows file services are disabled on the public nic, >>that the private nic is primary, and name resolution services (DNS/WINS) > > for > >>the windows client are not resolving to the public nic. >>No confusion regarding NetBui, TCP/IP, and NetBios encapsulated in TCP/IP? >> >>I can confirm that Xbase++ apps run fine for me on Win2K3 and have also >>worked with 2K3 SBS, but I also use ADS which eliminates any direct file >>access of tables. When properly configured, Win2K3 will perform at least > > as > >>well as Win2K. Win2K3 SBS (premium) is just a bundling of Win2K3, > > Exchange, > >>Sql Server, and ISA with some minor extra features and scripts to simplify >>the installation. Buying Win2K3, Exchange, Sql Server and ISA seperately >>and installing on single computer is esentially same as SBS except more > > work > >>and more expensive. >> >>Hopefully something above points you to a solution. >> >>Rodd >> >>"Ernesto Avedillo" <eavedillo@iacsl.e.telefonica.net> wrote in message >>news:4ace1b5d$1211a25a$9c5a1@news.alaska-software.com... >> >>>Hello to everybody >>> >>>I have developed a program thas was working very well in a windows 2000 >>>server. This last month we decided to buy a new server but this one has > > a > >>>windows small bussines server 2003 . When I try to execute this program >>>with >>>this system nothing happens , no execution, no window opened, absolutely >>>nothing. >>>I also have some problems accesing the datafiles (DBF files). When >>>accesing >>>a file, W2000 needs 1,5 seconds, WSBS2003 needs 35 seconds. >>>This is the code >>> >>> (AreaConc)->( DBGoTop() ) >>> Do While !(AreaConc)->( EOF() ) >>> AADD(aCompOld, {(AreaConc)->Num_Comp , >>>(AreaConc)->P_Peso,(AreaConc)->Lab,(AreaConc)->Fase2}) >>> (AreaConc)->( DBSkip() ) >>> EndDo >>> >>>Very simple >>> >>>Does anybody have an idea why? >>>Thanks >>> >>> >>> >>> >>> >> >> > > |