英文:
Console Command Utility for progress?
问题
有一个客户拥有一个Progress数据库,我需要能够使用命令行客户端连接。是否有这样的工具?我在服务器上看到可以启动proenv并运行sqlexp,我想能够从开发机器连接到远程数据库类似的操作。
英文:
A customer has a progress database and I need to be able to connect using a command line client. Does such a thing exist? Ive seen on the server you can launch proenv and run sqlexp, and I'd like to be able to do similar from a dev machine to the remote DB.
答案1
得分: 4
任何安装了Progress的开发机都会有PROENV可用。
对于SQL访问,“sqlexp”将像您已经使用过的那样工作。如果您需要4GL访问,可以使用“pro”(单用户)或“mpro”(多用户)。远程访问始终是多用户的。
您可能使用了类似于以下命令的SQLEXP:
proenv> sqlexp -db dbName -H hostName -S servicePort -user userName -password passWord -infile something.sql
MPRO的等效命令将是:
proenv> mpro -db dbName -H hostName -S servicePort -U userName -P passWord -p something.p
在这两种情况下,如果省略要运行的程序(something.*)参数,您将看到一个提示。SQLEXP更多是一个命令行,MPRO是一个带有顶部菜单系统的“编辑器”,但您也可以直接键入4GL语句并使用“GO”键(在Windows上为F2,在Unix上为F1,或者对于任何平台都可以使用^X)来执行它们。
在旧的应用程序中,允许4GL客户端使用“空白”用户名访问是常见的(尽管不是一个好主意),所以您可以尝试省略-U和-P来连接。如果出现要求输入用户名和密码的对话框,请尝试什么都不输入,或者使用F4(或^E)退出对话框。如果您没有凭据并且允许这种访问,这可能会起作用。
您连接的机器的许可证可能会影响您可以使用该连接做什么。还有一个名为“showcfg”的实用程序,它将显示您配置的许可证列表。
这只是基本的连接。一旦连接成功,如果知道您要做什么,我们可能还会有更多要说的。
英文:
Any dev machine with Progress installed will have PROENV available.
For SQL access "sqlexp" will work just as you have already used it. If you need 4GL access you can use "pro" (single user) or "mpro" (multi-user). Remote access is always going to be multi-user.
You probably used a SQLEXP command similar to this:
proenv> sqlexp -db dbName -H hostName -S servicePort -user userName -password passWord -infile something.sql
The equivalent for MPRO would be:
proenv> mpro -db dbName -H hostName -S servicePort -U userName -P passWord -p something.p
In both cases if you omit the program to run (something.*) parameter you will be greeted by a prompt. SQLEXP is more of a command line, MPRO is an "editor" with a menu system at the top but you can also just type 4GL statements and execute them directly with the "GO" key (F2 for Windows, F1 for Unix, alternatively ^X for either platform).
It is common (although a bad idea) in older applications to permit "blank" userid access for 4GL clients so you may be able to succeed in connecting by omitting the -U and -P. If you get a dialog asking for username and password try entering nothing or exiting the dialog with F4 (or ^E). That might work if you have no credentials and such access is allowed.
The licensing of the machine that you are connecting from may impact what you can do with that connection. There is also always a utility called "showcfg" which will show you a list of the configured licenses.
That's all just basic connectivity. We might have more to say if we know what it is that you want to do once you are connected.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论