CodeBase-for-DBF icon indicating copy to clipboard operation
CodeBase-for-DBF copied to clipboard

s4server or s4service code ever released?

Open gcbright opened this issue 5 years ago • 28 comments

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.

gcbright avatar Jun 14 '19 11:06 gcbright

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

fran-gb avatar Jun 18 '19 09:06 fran-gb

I thought R3 was the last release on codebase 6.5 ?

gcbright avatar Jun 18 '19 10:06 gcbright

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 avatar Jun 18 '19 10:06 fran-gb

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.

fran-gb avatar Jun 18 '19 10:06 fran-gb

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 avatar Jun 18 '19 10:06 gcbright

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 avatar Jun 18 '19 10:06 gcbright

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.

gcbright avatar Jun 18 '19 10:06 gcbright

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.

fran-gb avatar Jun 18 '19 10:06 fran-gb

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 avatar Jun 18 '19 11:06 gcbright

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

gcbright avatar Jun 18 '19 11:06 gcbright

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

fran-gb avatar Jun 18 '19 11:06 fran-gb

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?

gcbright avatar Jun 18 '19 11:06 gcbright

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 avatar Jun 18 '19 12:06 fran-gb

Few times with Windows ErrorNumber 121, but usually 0

fran-gb avatar Jun 18 '19 12:06 fran-gb

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 [email protected] To: MPSystemsServices/CodeBase-for-DBF [email protected] Cc: Subscribed [email protected] 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

addsuminc avatar Jun 18 '19 15:06 addsuminc

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

gcbright avatar Jun 18 '19 15:06 gcbright

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 [email protected] To: MPSystemsServices/CodeBase-for-DBF [email protected] Cc: addsuminc [email protected], Comment [email protected] 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

addsuminc avatar Jun 18 '19 16:06 addsuminc

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

MPSystemsServices avatar Jun 28 '19 16:06 MPSystemsServices

That would be terrific.

Thank you for your efforts,

Tony

----- Original Message ----- From: Jim Heuer [email protected] To: MPSystemsServices/CodeBase-for-DBF [email protected] Cc: addsuminc [email protected], Comment [email protected] 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

addsuminc avatar Jun 28 '19 16:06 addsuminc

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

gcbright avatar Jul 02 '19 22:07 gcbright

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.

MPSystemsServices avatar Mar 21 '20 21:03 MPSystemsServices

Great news - thanks for the update.

Tony

----- Original Message ----- From: Jim Heuer [email protected] To: MPSystemsServices/CodeBase-for-DBF [email protected] Cc: addsuminc [email protected], Comment [email protected] 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

addsuminc avatar Mar 21 '20 21:03 addsuminc

Really very good news. Thank you !

fran-gb avatar Mar 24 '20 14:03 fran-gb

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,

Shevaughn avatar Mar 27 '20 11:03 Shevaughn

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) [email protected]

MPSystemsServices avatar Mar 27 '20 15:03 MPSystemsServices

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

mschifter avatar May 17 '20 16:05 mschifter

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. [email protected]

MPSystemsServices avatar May 17 '20 19:05 MPSystemsServices

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 [email protected] Sent: Sunday, May 17, 2020 3:19 PM To: MPSystemsServices/CodeBase-for-DBF [email protected] Cc: Matt Schifter [email protected]; Comment [email protected] 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. [email protected]

— 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 .

mschifter avatar May 17 '20 19:05 mschifter