search

MPSystemsServices / CodeBase-for-DBF

CodeBase is a C-based library to read, write and manage DBF type tables and indexes.
GNU Lesser General Public License v3.0
53 stars 34 forks source link

s4server or s4service code ever released? #2

Open gcbright opened 5 years ago

gcbright commented 5 years ago

Has or will the source code to the server or service part ever been released (I think it was s4server.exe or s4service.exe ? By the time I got ready to buy it Sequiter was gone. Thanks for posting this, the x64 conversion was a giant help.

fran-gb commented 5 years ago

I've Code Base Client/Server 6.5 r3 2003 version. I'm looking for lasts releases/updates. Somebody can aid ?

gcbright commented 5 years ago

I thought R3 was the last release on codebase 6.5 ?

fran-gb commented 5 years ago

I dont know, for that I'm looking for. Are you using it ? Recently have often the error -935 among a client running windows 10 and a server (windows server 2012). I ask me if CB have problems with the new systems.

fran-gb commented 5 years ago

Apart from that there was not any newer version. I recall years ago that Sequiter went publishing patches. So, sure that I do not have the last reviews.

gcbright commented 5 years ago

The errors on later systems is why I am looking for the source code realease. By the time I knew I wanted to spend the money to get it sequiter was gone. Ever since I saw the release here, I have been hoping that the server version source code would be released. I suspect that if the server code is recompiled with a later version with something perhaps as simple as Unicode support will resolve the problems.

gcbright commented 5 years ago

Wanted to share this problem concerning client server. Not the error code you are getting, but why I had to fall back to my release unpatched version a while back.

From codebase technical support a long time ago.

Error -1095, Application/Library version mismatch, after rebuilding the subscription release of the client library

Article ID: C01091 Last updated: 2004/05/12 To avoid problems that could arise if a client library tries to use a server built from a different set of source code, the subscription releases of the client/server version of CodeBase use build numbers. If a client library does not have a build number or has a different build number than that of the server, then it will fail to connect and the CodeBase error -1095 will occur.

If you choose to rebuild the client library from a subscription release, it will not contain a build number. You must use the build number stamping utility from the subscription release download page to stamp the rebuilt library with the same build number as the CodeBase server's. Instructions for using the utility are included with it.

gcbright commented 5 years ago

And since 935 is close to 950. Thought you might need this. If you are getting the error, it could be as simple as how the service is configured, if running as a service on the server.

From sequiter tech support.

When starting, the CodeBase Server generates error -950 / 70168 / Unexpected Result / Failure to initialize catalog client.

This error is generated when trying to start the CodeBase Server and an instance of the CodeBase Server is already running on the same computer.

It might not be obvious that the CodeBase Server is already running if the CodeBase Server is running as a service. To check whether CodeBase Server is installed as a service and running, open Control Panel > Administrative Tools > Services and look for CodeBase Database Server.

fran-gb commented 5 years ago

I'm running s4service, yes, as a service. I catch the error in the client, randomly, we execute a certain process each day, some times twice a day and only get that error once or twice a week.

Null Input Parameter unexpected, usually in a d4seek operation, without any sense.

We are thinking to migrate to sqlserver, but .... its a huge work, with many hours to invest.

gcbright commented 5 years ago

Are you by chance compiling the client application with Visual Basic? I fixed the problem by using the following code (off hand can not rember if it was & "" or & " ". I think it was just & "" will check actual code later today.

Sinput = Sinput & ""

Before sending variable to command. Do not fully understand why but code above eliminated null problem for me from vb.

gcbright commented 5 years ago

As to the problem on the server side will post changes on server 2012 run as service that may resolve that for you.

fran-gb commented 5 years ago

Yes, its a vb6 application. I'll review all d4seek calls and change it today. Thank you very much.

gcbright commented 5 years ago

On the error on the server side, could you post an example of the last few entries from the s4server log file right before you have the problem?

fran-gb commented 5 years ago

The only error saved in the s4server.err file is this one:

2019/06/18 11:37:03 -1390 system-level communication failure 96966 connect4bufferReadRetrieve Windows ErrorNumber 0

It happens between one to five times during a day.

fran-gb commented 5 years ago

Few times with Windows ErrorNumber 121, but usually 0

addsuminc commented 5 years ago

I appreciate this discussion; we would also be interested in the client-server source.

We haven't seen any problems with Windows 10 and Server 2012 using the CodeBase DLL 6.5 1.0.0.1 (last modified 8/28/2001); while we do not have any CodeBase client-server deployments (our larger users utilize PSQL), we have used it as secondary file type along with those PSQL systems.

Occasionally we run into an odd -70 issue that seems to be related to several different things. Overall however we've found it over the years to be quite durable and plan to continue to support it.

In terms of programming languages, we use Delphi to interface to the CodeBase engine.

Regards,

Tony Frates Addsum Business Software, Inc. https://www.addsuminc.com

----- Original Message ----- From: fran_gb notifications@github.com To: MPSystemsServices/CodeBase-for-DBF CodeBase-for-DBF@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Date: Tue, 18 Jun 2019 03:20:13 -0700 Subject: Re: [MPSystemsServices/CodeBase-for-DBF] s4server or s4service code ever released? (#2)

I dont know, for that I'm looking for. Are you using it ? Recently have often the error -935 among a client running windows 10 and a server (windows server 2012). I ask me if CB have problems with the new systems.

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-503043447

This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

gcbright commented 5 years ago

Hi Tony,

Every time I think about the durability of codebase, I want to kick myself for waiting to long to purchase the source code release on server. By the time I got around to it, Sequiter was gone.

As to Delphi, do you ever get the Null problem (described above) or is that purely a Visual Basic problem?

George

addsuminc commented 5 years ago

Hello George - we haven't seen or heard of the "Null Input Parameter unexpected" issue and wish we could help to add to this conversation about that problem.

We aren't however running CB as a service. CodeBase does seem to be picky about spaces (and exact field sizes) and we do find that we have to add explict spaces to find some d4seek values, so I can see how this (in VB):

Sinput = Sinput & ""

might help, especially if Sinput was unassigned.

In Pascal this would be:

Sinput := Sinput + ' ';

(I would think that adding the explicit space would be needed, but maybe not.)

Tony

----- Original Message ----- From: gcbright notifications@github.com To: MPSystemsServices/CodeBase-for-DBF CodeBase-for-DBF@noreply.github.com Cc: addsuminc support@addsuminc.com, Comment comment@noreply.github.com Date: Tue, 18 Jun 2019 08:40:32 -0700 Subject: Re: [MPSystemsServices/CodeBase-for-DBF] s4server or s4service code ever released? (#2)

Hi Tony,

Every time I think about the durability of codebase, I want to kick myself for waiting to long to purchase the source code release on server. By the time I got around to it, Sequiter was gone.

As to Delphi, do you ever get the Null problem (described above) or is that purely a Visual Basic problem?

George

-- You are receiving this because you commented. Reply to this email directly or view it on GitHub: https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-503192689

This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

MPSystemsServices commented 5 years ago

Responding to the question relative to CB server source code, I've been intending for some time to ask the copyright owners about that but have been distracted by real life. Hope to get that done later this year and hopefully have that code posted too. I have the executable for that in its last version, but do not have permission (yet) to release it in Open Source.

Glad that there is ongoing interest in this product, as it is a reliable, robust, high performance data access solution.

Cheers, Jim

addsuminc commented 5 years ago

That would be terrific.

Thank you for your efforts,

Tony

----- Original Message ----- From: Jim Heuer notifications@github.com To: MPSystemsServices/CodeBase-for-DBF CodeBase-for-DBF@noreply.github.com Cc: addsuminc support@addsuminc.com, Comment comment@noreply.github.com Date: Fri, 28 Jun 2019 09:43:50 -0700 Subject: Re: [MPSystemsServices/CodeBase-for-DBF] s4server or s4service code ever released? (#2)

Responding to the question relative to CB server source code, I've been intending for some time to ask the copyright owners about that but have been distracted by real life. Hope to get that done later this year and hopefully have that code posted too. I have the executable for that in its last version, but do not have permission (yet) to release it in Open Source.

Glad that there is ongoing interest in this product, as it is a reliable, robust, high performance data access solution.

Cheers, Jim

--

This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

gcbright commented 5 years ago

Jim that would be beyond terrific!! Also was the source code to code reporter ever released. As to using codebase it is still my favorite C library of all time. It is highly portable, with few dependencies and just works.

Thanks George

MPSystemsServices commented 4 years ago

Just so you know, Sequiter has released the remaining source code to the Open Source Community including the server and the server administration module. Unfortunately, their SQL implementation implemented through ODBC was purchased software, so they are not able to release that. We are working on organizing this code. It turns out there are version control issues and we need to establish that the source code can actually be compiled into working versions... Stay tuned. We hope to have this published to this repository by the middle of 2020.

addsuminc commented 4 years ago

Great news - thanks for the update.

Tony

----- Original Message ----- From: Jim Heuer notifications@github.com To: MPSystemsServices/CodeBase-for-DBF CodeBase-for-DBF@noreply.github.com Cc: addsuminc support@addsuminc.com, Comment comment@noreply.github.com Date: Sat, 21 Mar 2020 14:02:55 -0700 Subject: Re: [MPSystemsServices/CodeBase-for-DBF] s4server or s4service code ever released? (#2)

Just so you know, Sequiter has released the remaining source code to the Open Source Community including the server and the server administration module. Unfortunately, their SQL implementation implemented through ODBC was purchased software, so they are not able to release that. We are working on organizing this code. It turns out there are version control issues and we need to establish that the source code can actually be compiled into working versions... Stay tuned. We hope to have this published to this repository by the middle of 2020.

-- You are receiving this because you commented. Reply to this email directly or view it on GitHub: https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-602104218

-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

fran-gb commented 4 years ago

Really very good news. Thank you !

Shevaughn commented 4 years ago

Great news! Thank you for updating this wonderful code. It seems the portability version is not included in this release. Is it planned to include it too? (Still using/updating some apps developed with Codebase running for more than 25 years without any issue). Thanks,

MPSystemsServices commented 4 years ago

Hi Shevaughn,

I'm not sure what "portability version" means.  We believe we now have all the source code except for the SQL/ODBC piece as I mentioned.  We have some modules that appear to support Linux/Unix type systems but haven't done anything with them yet.

The one thing I'm not sure we'll do is to provide versions for Clipper in compiled format, but that may come in time...

All best, Jim

On 3/27/2020 4:07 AM, Shevaughn wrote:

Great news! Thank you for updating this wonderful code. It seems the portability version is not included in this release. Is it planned to include it too? (Still using/updating some apps developed with Codebase running for more than 25 years without any issue). Thanks,

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-604941647, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKRKRPQZ77O3JTLW57U6PRDRJSCFTANCNFSM4HYG5UBA.

-- James S. Heuer M-P System Services, Inc. 1631 NE Broadway, PMB# 136 Portland, OR 97232-1425 (503) 335-8380 (503) 348-8694 (cell) jsheuer@mpss-pdx.com

mschifter commented 4 years ago

Now that codebase is open source, can somebody post the s4server source code to this project?

MPSystemsServices commented 4 years ago

All,

I apologize for the delay.  We have received what Sequiter believes is the latest server source code.  We have been distracted by other things, but hope to get it all posted to Git ASAP.

All best, Jim Heuer

On 5/17/2020 9:11 AM, Matt Schifter wrote:

Now that codebase is open source, can somebody post the s4server source code to this project?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-629821751, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKRKRPW4LVDNE4EC3XT5NF3RSAEDPANCNFSM4HYG5UBA.

-- James S. Heuer M-P System Services, Inc. jsheuer@mpss-pdx.com

mschifter commented 4 years ago

Hi Jim,

Thanks for your response. At some point during my 15 year on and off relationship with CodeBase++, I added some enhancements to the base code. I’m a C++ only programmer who started xBase coding in the 1980s (specifically DBase and FoxBase+). So I’m a big fan of the product and was sad to see it disappear when it did.

If you have plans for it, and you are looking to collaborate, please advise. I’m between jobs right now and might want to spend some time assisting.

Regards,

Matt

From: Jim Heuer notifications@github.com Sent: Sunday, May 17, 2020 3:19 PM To: MPSystemsServices/CodeBase-for-DBF CodeBase-for-DBF@noreply.github.com Cc: Matt Schifter mschifter@cfl.rr.com; Comment comment@noreply.github.com Subject: Re: [MPSystemsServices/CodeBase-for-DBF] s4server or s4service code ever released? (#2)

All,

I apologize for the delay. We have received what Sequiter believes is the latest server source code. We have been distracted by other things, but hope to get it all posted to Git ASAP.

All best, Jim Heuer

On 5/17/2020 9:11 AM, Matt Schifter wrote:

Now that codebase is open source, can somebody post the s4server source code to this project?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-629821751, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKRKRPW4LVDNE4EC3XT5NF3RSAEDPANCNFSM4HYG5UBA.

-- James S. Heuer M-P System Services, Inc. jsheuer@mpss-pdx.com

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/MPSystemsServices/CodeBase-for-DBF/issues/2#issuecomment-629846839 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AJOKIJA7BIUSRL5EV56QP7LRSA2EDANCNFSM4HYG5UBA .