Hi Manu,
Thanks for the reply and suggestion. I was reading your post, but what I see is that something similar to what we already have running. We can actually open Basic programs using an SSH folder from VS Code, and activate the MV Basic Extension. So, formatting is working, warnings, and jumps to internal basic subroutines. In the solution your are proposing, I can't see that connection to the DB could be done, also, as it would not be a local connection. Did you get that working?
What we can't get working is the following:
1. Identification (Definition) of equates. This is, that VS Code can determine that an equate is correct, the way it does in Basic Developer Kit, for example. Today, the extension is not recognizing the declared equates.
2. Function and Subroutine definitions. This is, that VS Code could show us the parameters of a subroutine or function compiled and catalogued in the same basic file (for example, BP)
3. Basic compilation and catalogue. This would be the last thing to achieve, we would be great with the two indicated above.
Regards,
Enrique
------------------------------
Enrique Murphy
Software Engineer
Aleator SRL
Buenos Aires Argentina
------------------------------
Original Message:
Sent: 08-25-2021 16:03
From: Manu Fernandes
Subject: Problem Connecting to Universe DB
Hi
We work like you win/lin as prod and dev is lin.
So I'll share my experience to sync our code locally with extension. Please take a look to these post MVVS: MV Basic for Visual StudioRocketsoftware | remove preview |
| MVVS: MV Basic for Visual Studio | I'll share our experience to edit the BASIC code locally with vscode/rocket-mvbasic.Simply, we combine the rocket-mvbasic with sftp extension sftp sync extension for VS Code - setup a ssh service on your db-server c.f. | View this on Rocketsoftware > |
|
|
Regards
------------------------------
Manu Fernandes
Original Message:
Sent: 08-25-2021 15:03
From: Enrique Murphy
Subject: Problem Connecting to Universe DB
Hi Christian!
Thanks for your reply. Oh, I see, so MVVS is actually works with local Universe copies only. The problem is that our development environments are Windows, but production are Linux, so, I think I will keep using VS Code to code through SSH against our development / production servers.
Regards!
------------------------------
Enrique Murphy
Software Engineer
Aleator SRL
Buenos Aires Argentina
Original Message:
Sent: 08-25-2021 10:36
From: Christian Bristow
Subject: Problem Connecting to Universe DB
In the first communication it looks like you are trying to connect to your remote server. You can't do that yet as it's local server code access only. You could however install a local trial version of UniVerse for Windows to play with or you could use VS Code for Linux. I am unsure if this is the only reason why you are getting the "Java 11 or Open JDK runtime environment is abnormal. ".
Currently it's not supported to use ssh but I can get ssh to work ok too. Perhaps an alternative is what Manu Fernandez is doing under the forum title of "Rocket-mvbasic and Sftp extension". The connection configuration in db.mvbasic.json is for is currently for a local connection only. You may find you can get away with just having the data source set correctly.
Developers are currently working on how to either remote connect or sync.
------------------------------
Christian Bristow
TSE
Rocket Software Inc
Original Message:
Sent: 08-24-2021 13:42
From: Enrique Murphy
Subject: Problem Connecting to Universe DB
Hi, I have installed MV Basic for Visual Studio Code. It's really cool. I could open a basic programs folder, but could not connect to the database, so I can't compile, or have the additional features I saw it provides when connected.
I have followed the documentation of this Forum, downloaded the JDK 11 from the indicated link, placed its path in the MV Basic Extension configuration, and created the following .rmv/db.mvbasic.json file:
{
"db": {
"host": "192.168.2.100",
"userName": "root",
"password": "123456",
"account": "ALEDB",
"dataSource": "UNIVERSE",
"port": 31438
},
"includes": [
{
"includeFile": "BP",
"account": "ALEDB",
"fileName": "BP"
}
]
}
First of all, whenever I open a Universe Basic, the following message appears in VS Code:
Java 11 or Open JDK runtime environment is abnormal. Please check your Java environment and settings
Second, when doing F1 -> Connect to MV Server, another messages tells me "Connect to U2 server failed"
Any ideas?
Regards,
------------------------------
Enrique Murphy
Software Engineer
Aleator SRL
Buenos Aires Argentina
------------------------------