fbpx

RC.EXE Failed and dbserver

More
1 year 9 months ago #1 by Michael Schmidt
RC.EXE Failed and dbserver was created by Michael Schmidt
My first try:

I have the latest versions of XIDE and xSharp installed (No vulcan). Created a new project "Standard VO MDI" -> I assume I need Vulcan installed? I get the following Compiler messsage:

Compiling native resources for MdiApp1...
Failed running RC.EXE

Next I started a project XSharp. Tried to get a dbserver installed with an existing db-file. Import does not work and also to rename dbserver1 is not possible. Looks like I am doing something wrong. Or do I need Vulcan installed?

Next try: Started VS Community 2015 with a new xSharp project. Compiling & running works. Where and how do I link db-files? Do i need to connect through odbc adapter?

Maybe I am still attached to the "Look & Feel" of VO and the easy use of dbserver. Is there something like a VO "South Sea" example?

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #2 by Wolfgang Riedmann
Replied by Wolfgang Riedmann on topic RC.EXE Failed and dbserver
Hi Michael,

unfortunately there are missing more pieces:

- the VO runtime including the macrocompiler and the RDDs are "in the work", actually in development
- even if they are finished, the X# group cannot give you a X# version of the VO libraries (they are copyrighted by CA), and only if you have the sources of theses class libraries you will be able to recompile them with X#

Personally, I would recommend to start freshly with X# without DBserver, maybe using SQLite or another SQL server like Firebird. Or do you have to maintain VO applications?

For new applications, consider DBF to be a dead end (this is a confession from a DBF fan like me).

Wolfgang

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #3 by Chris Pyrgas
Replied by Chris Pyrgas on topic RC.EXE Failed and dbserver
Hi Michael,

Yes, at this moment in order to use dbfs, you need the vulcan runtime dlls. No need to install vulcan, it's only the vulcan runtime dlls that are needed. This restriction will be removed later in the year, when we release the x# runtime.

Regarding the SDK libraries (which you need in order to use high-level classes like DBServer), we are writing a tool that reads the SDK code from your existing VO (any version) installation in the folder \CAVOxx\VOLIB and converts it into a x# project. This tool is 90% complete right now, we should be able to release it in the coming weeks.

Regarding the XIDE issues you found (thanks for reporting them!) :

- The error about rc.exe is a bug, fortunately very easy to fix, will do that for the next ver.
- About Import/Export in the DBServer editor, I had forgotten about them, will enable them in the next ver
- To rename the DBServer, you need to go to the Properties window and change the name of the dbserver there (in the "Name" property which appears first in the list). After saving your changes, everything should be updated with the new name

hth!

Chris

XSharp Development Team
chris(at)xsharp.eu

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #4 by Phil Hepburn
Replied by Phil Hepburn on topic RC.EXE Failed and dbserver
Frank / Michael,

If this is a home / personal project then I would recommend you use Microsoft SQL Server Express - its a FREE full version of their standard server app.

The reason for doing this is that there are many more working samples to copy and use.

This includes my own eNotes and the "ClickStart" eNotes I write.

I would reserve SQLite for small platforms - I used it for WinRT tablets and Windows phone. But with a desktop / laptop (and even powerful Surface tablets) the Express version of SQL Server is the way to go.

I believe my Cologne samples just work out of the box with the Express install. Or they di a few weeks back ;-0)

Hope this helps,
phil.
Wales, UK.

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #5 by Michael Schmidt
Replied by Michael Schmidt on topic RC.EXE Failed and dbserver
Hi Phil,

started C# with SQL lite then trying to use Access db as the Backend. I think I am doing something really wrong. I do not even get a simple Master-Detail to work (w/Delete, Append). I think I need to get first the SQL fundamentals digestet. As I have a little bit of time this might be the way to go.

Where do i find your example? Could locate it in the "Download" area.

Thanks,
Michael

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #6 by Michael Schmidt
Replied by Michael Schmidt on topic RC.EXE Failed and dbserver
Hi Chris,

thanks. As I am not in a hurry I will wait...

Michael

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #7 by Michael Schmidt
Replied by Michael Schmidt on topic RC.EXE Failed and dbserver
Hi Wolfgang,

I am not really suprised to hear that dbase is a dead end. I read the article "Why XSharp" but must ask the question "Why XSharp" and not for instance C# if I anyhow need to use SQL?

Thanks,
Michael

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #8 by Johan Nel
Replied by Johan Nel on topic RC.EXE Failed and dbserver
Michael,

Because you already know the VO/XBase language syntax, you can almost copy and paste 90% + of your VO business logic code and it will compile in .NET

Johan

______________________
Johan Nel
George, South Africa

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #9 by Wolfgang Riedmann
Replied by Wolfgang Riedmann on topic RC.EXE Failed and dbserver
Hi Michael,

apart from the lot of old VO applications that need to be ported to .NET with X# (and for these X# is the only choice - fortunately we have this one), I have several (personal) reasons:
  • I like the Xbase language much more than C#, personally I feel the code is better to read
  • I prefer to have the same language for my old applications and for my new ones (based on WPF/MVVM)
  • The X# language has some unique features like the preprocessor or a short property syntax. Specially the preprocessor is a killer feature
  • Don't forget the (unfortunately not ready) macrocompiler - it is another unique feature
  • as last point I would put the superior support with direct contact to the development team that adds requested features in virtually no time

These are the main reasons for me - and only for new applications. For older VO applications I have no other choice, and therefore I'm very happy that this choice exists.

Wolfgang

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #10 by Wolfgang Riedmann
Replied by Wolfgang Riedmann on topic RC.EXE Failed and dbserver
Hi Michael,

and I forgot another important thing (at least for me): even my new applications sometimes will need to access old DBF data.

Wolfgang

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #11 by Karl Faller
Replied by Karl Faller on topic RC.EXE Failed and dbserver

Wolfgang Riedmann wrote:

  • as last point I would put the superior support with direct contact to the development team that adds requested features in virtually no time
  • [/ul]

    That certainly is #1 - apart from the eye-cancer with all those lonesome curly braces in C#...

    Re: "SQL" - up2now dev has really fulfilled any announcement with very accurate timing. So, don't give up to fast with dbf, i'd expect you might be able to use dbserver from vo in rather short time.

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #12 by Wolfgang Riedmann
    Replied by Wolfgang Riedmann on topic RC.EXE Failed and dbserver
    Hi Karl,

    personally I like DBFs very much, but unfortunately their time is over, thanks to some caching features in the Windows networking.

    ADS works very well, and if it was cheaper, I would use it everywhere.

    In my new project I use a SQLite database as local storage, and I have implemented a feature to keep the structure uptodate (if a field is missing in the table, it is added automatically at the program start).

    Wolfgang

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #13 by Phil Hepburn
    Replied by Phil Hepburn on topic RC.EXE Failed and dbserver
    Hi Michael,

    In asking why, why, why ... you are probably correct in your answer. Meaning if you are not bringing any 'history', or 'legacy' stuff with you from the past, and you are to use SQL, then C# is a perfectly good language and solution for you, I like it a lot myself.

    BUT - you will not have the support of a knowledgeable community, I know, I had a lonely 3 years or so Googling my way to the mastery of the curly braces.

    I can help you get going with SQL and X#, but you have to be committed, as I don't like wasting my time :unsure:If you are coming new to both .NET and X#, as well as new to SQL, then I will help, if you can assure me you won't change your mind after a short while. There will be a big learning curve but it is worth it - I did exactly the same years ago with Vulcan, and I am more than glad that I did.

    The BEST advice I can give is to use SQL Server Express, as it is FREE and most suitable, and will even support 2 or 3 users I seem to recall. The tools to support 'Express' are all built into Visual Studio. And I have notes and examples to support such a start and approach. You can always go to 'Lite' when you know more about lots of things. But start with Express.

    You will also need a suitable data base file, which once again I can provide - the flavour will be SQL Server, and it works with full and express versions.

    If you are interested in this way of approaching your learning, then say so, and I will tell you more about the next step and send you a suitable and compatible DB file.

    Here is the 'Stock' system open in VS 2017 :-







    Now you will see that we have a database file open and are querying it using the VS environment and tools. Yet we have done nothing as yet with an X# coded app. We need to remember at all times that SQL servers are disconnected data sources. So you can work on the data, tables and more, without a coded program / app. Just use the tools in VS.

    If you wish to go further then I will sort out a data file, and you can then try to start using 'L2S' which means "Linq to SQL". This is the easiest way into SQL use, when you have a provided data base.

    Hope this helps,
    Phil.
    Wales, UK.
    Attachments:

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #14 by Michael Schmidt
    Replied by Michael Schmidt on topic RC.EXE Failed and dbserver
    Hi Phil,

    wow, what should I say. I am more or less finished with my little VO Project (maybe another 2 weeks or so). Initially I tried to do it with C# then VB using SQL express and Access. I finally gave up.

    I think I can go back to my initial thought to use .net and use my "VO project" and write it in xSharp with SQLExpress as Backend. In other words: Yes, I am committed to learn. But you need to understand: I am not a Hardcore programmer evenso I studied Computer Science back in the 80ies. Oh boy, I am thaaat old.

    Alright, I will give you a little bit more time to reconsider your offer. If you still believe there is hope let's start in May.

    Michael

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #15 by Phil Hepburn
    Replied by Phil Hepburn on topic RC.EXE Failed and dbserver
    Hi Michael,

    I am up for it if you are :cheer:[and others can follow along as well, there are many who should try out SQL - Frank !?]

    You will do it if you keep going through each of the stages required. You don't need to be a rocket scientist to do SQL with X# - BUT - it is not a quick and trivial 'Hello world' situation. We can make things easier for both you and me by choosing the right software apps and tools. Many things have now gotten a lot easier.

    When I went through this personal 'upgrade' stage some years back, I had Geoff Schaller guide me and he was down under in Australia. Somehow I made it. From starting to try and install SQL Server, to getting some simple data output from a Vulcan program took me a solid four weeks effort :whistle:That is true!

    Now then, don't panic, we can do a lot better these days, we have better software tools, better SQL related technology, and the Microsoft downloads / installs are vastly better / improved. Oh! and I know up front just what few code lines are required in an app based on X# syntax and code. Back then I had to adapt a VB text book example (which actually contained printed errors).

    So we HAVE to do better than back then !!!

    Oh! and I forgot to mention that I also have my "ClickStartTSQL" eNotes which is an in-depth study of SQL Server in many ways, so we will not be short of help and support.

    Forget Access and any other database which was not made in MS SQL Server (MSSS). And for now, if you have some time spare, check that you have a successful download and install of the latest SQL Server 'Express' version.

    Here is the web link I found and studied for what was on offer :-

    www.microsoft.com/en-gb/sql-server/sql-server-downloads

    I have to say that I have changed my mind and think that you ought to choose the Developer version - it is also FREE, and thinking back it was how Geoff got me started. It will probably be more like 100% compatible in every way with stuff I can help you with. Please give it a go :-



    It is NOT a problem if you have already downloaded and installed 'Express' - all these versions of SQL Server happily live side-by-side. And more so now than ever. So just do it.

    Have you also downloaded and fully installed the 'Community' version of Visual Studio 2017 ? If not then that is another useful task to complete prior to my support.

    Good Luck,
    This is a journey you (and anyone following along) will enjoy - it gives great satisfaction, and I was a DBF man "as keen as the rest of them" :woohoo:

    www.visualstudio.com/
    www.visualstudio.com/downloads/



    Best regards, and power to your elbow.
    Phil.
    Wales, UK.
    Attachments:

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #16 by Michael Schmidt
    Replied by Michael Schmidt on topic RC.EXE Failed and dbserver
    Hi Phil,

    feels like going back to school. I will follow your advise and install all software components in the next couple of days. As soon as I am ready I will let you know.

    Thanks,
    Michael

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #17 by Phil Hepburn
    Replied by Phil Hepburn on topic RC.EXE Failed and dbserver
    Yes, I know, but its the only way to win when it comes to SQL.

    School is "a controlled learning environment" - oh! and I am a teacher ;)

    If I had not followed Geoff's advice for a few weeks, I would not have made it. He was/is a good teacher and delivered interesting conference sessions too.

    Once we get an installed (Community) version of VS 'seeing' the instance of the SQL Server in the relevant panes (windows), then we can move on to which database to use. It would be better to start with an already made data file, and use the existing tables within it. I will work on one to send you.

    Making a new SQL database (many tables) is just another big step up, that we don't need right at the start - but there are now tools to help us do this from .NET and our X# code, when we are ready.

    Hope this helps,
    Phil.
    Wales, UK.

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #18 by Johan Nel
    Replied by Johan Nel on topic RC.EXE Failed and dbserver
    Phil,
    Just maybe an idea. I know you a MS-SQL[Server] fan, however not everybody is (I am PostgreSQL) addicted.. :lol:

    I think maybe a good idea when you address SQL, would be to explain the similarity of the ADO.NET classes.

    They all implement DbConnection/DbCommand/DbDataAdapter and it might be good to also cover ConfigurationManager.AppSettings and how connectionstrings and DbProviderFactories work. Might be good as an advance section to also cover Application.exe.config to provide a "database" agnostic interface to your preferred RDBMS. Quite easy then to change the backend database without the need to have RDBMS specific Application versions.

    Quite easy then to have a MS-Access, SQLLite, SQLServer, Sybase, Oracle, PostgreSQL, MySQL database and with a config change let the programme connect to it.

    Johan

    ______________________
    Johan Nel
    George, South Africa

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #19 by Phil Hepburn
    Replied by Phil Hepburn on topic RC.EXE Failed and dbserver
    Hi Johan,

    Yes, when I get to adding the section on SQL to the new 'full' X# eNotes then I will certainly call on your knowledge and expertise to flesh out this section.

    For Michael starting however, MSSS seems a good place to start - if not exactly easy, it is likely to be easier than many other approaches.

    By the way I don't usually do 'fan' stuff - I like to evaluate the good and the bad (oh! and the ugly) in most things. I don't start out by hating (or loving) Microsoft, as some friends do!!

    I got into MSSS simply because I had a good paying customer who used version 2005 with SAGE. This is also how I got to using Visual Studio and Reporting Services so much as well. Paid OK ;-0)

    One thing I COULD be a fan of however, is Entity Framework 6 and beyond, as it gets the standard developer away from the necessities of ADO.NET - and that I am glad to be relieved of, ADO.NET that is. Yes, I know it is used under the cover - BUT - that is not my concern. "LINQ to SQL" and "LINQ to Entity" make life so, So, SO, much better for ordinary code designer / creators.

    How about YOU writing the SQL section for the X# notes ? You could do all the parts I don't cover when I do the Microsoft flavour, and EF6.

    Is there any other section you are keen (desperate?) to contribute ?? :whistle:

    Best Regards,
    Phil.
    Wales, UK.

    Please Log in or Create an account to join the conversation.

    More
    1 year 9 months ago #20 by Johan Nel
    Replied by Johan Nel on topic RC.EXE Failed and dbserver

    Phil Hepburn wrote: I will certainly call on your knowledge and expertise to flesh out this section.

    Cool, I will contribute where I can.

    How about YOU writing the SQL section for the X# notes ? You could do all the parts I don't cover when I do the Microsoft flavour, and EF6.

    Sure I can do something. Just keep in mind I am not a teacher. Want to get the job done in the shortest possible way.

    Is there any other section you are keen (desperate?) to contribute ?? :whistle:

    I want to continue my data-driven article series once I am past some deadlines I have at the moment.

    Maybe I will "weave" some tongue in the cheek alternative ways into the series covering what you might not address?

    Regards,

    Johan

    ______________________
    Johan Nel
    George, South Africa

    Please Log in or Create an account to join the conversation.