Search results

  1. sdutta

    Code Beautifier for Progress 4GL

    hello. I saw that several individuals were utilizing eclipse IDE (found http://www.eclipse.org/). I was wondering if someone can please point me to coloring/highlight for 4gl/abl. I found an abl plugin but it does not seem to support openedge/progress abl/4gl. Any suggestions would be greatly...
  2. sdutta

    PRO/SQL View to ODBC

    Okay....it did copy over to the target (after i did a backup/restore and restarted replication)..although I still do not know where it is stored at. What I did see was that the replication had stopped because it corrupted the target recovery file...I need to do further research and find out if...
  3. sdutta

    PRO/SQL View to ODBC

    Thanks for the reply. unfortunately it is not in _sysviews. I did create the views in the source database...but i don't think it copied over to the target...i'm thinking its a non-system table? Strange. I'll call progress to find out.
  4. sdutta

    PRO/SQL View to ODBC

    Thank you all for your help. I tried utilizing the sqlexp tool which worked but was a real pain. I ended up utilizing winsql via an ODBC connection to the database and that worked like a charm. I have been able to create views and have our reporting tool cognos access the view. My next question...
  5. sdutta

    odbc and sql92 views

    I was having the same problem. you need to utilize sqlexplorer tool that is given by progress. go to the documents and search for sqlexp. a better option is to utilize winsql (free software to download--just google) and connect via odbc through a windows box. both of these methods require that...
  6. sdutta

    The total length of the fields in an index exceeds max key size. (129)

    I know this is an older thread but I have version 10.1c and was wondering if there is an upper limit to character field. I've heard in previous versions we had a character field length of 256 as the default. this does not seem to be the case in 10.1c. can someone please confirm? i am getting...
  7. sdutta

    PRO/SQL View to ODBC

    Good Morning, We actually already have sql brokers in place for our actual database tables. Cognos and Java is already hitting these standard database tables in progress are are able to do queries and writes. However, they could not see the views. i did grant sql access to the name of the view...
  8. sdutta

    PRO/SQL View to ODBC

    Good Afternoon, I'm trying to expose a OE created view to our reporting tool in Cognos. I would like to know if it is possible to do so. I've noticed that I can create the view through the procedure editor but I am unable to do for each queries on it. However, I can do SELECT queries on it...
  9. sdutta

    restoring a source database

    Good Afternoon, We are in the processing of creating a sandbox for our main replication so that we can test replication related procedures utilizing two of our test databases. I've been reading the OpenEdge guide for the replication. On page 82/234...
  10. sdutta

    Visual Web Developer to AppServer Web Service

    Thanks. That worked. Dumb Mistake by me. I just needed to make the call independently then assign another variable to the cout value. so now it looks like: Dim callwebservice As New webserver.webservice Dim cout As String Dim cin As String = "world"...
  11. sdutta

    Visual Web Developer to AppServer Web Service

    Good Evening everyone, I'm trying to set up a call from Visual Web Developer to a web services that I have created within the appserver. I'm able to create a 4GL Client, connect and get a response from the web service. So I know that the web service is up and running. I've utilized proxygen to...
  12. sdutta

    Connecting VB to Progress 9.1E

    thank you for the reply. i believe that solves the problem. appreciate it.
  13. sdutta

    Connecting VB to Progress 9.1E

    Hello all. I'm trying to connect VB to progress 9.1E. I've been able to establish the connection to the database however, I can't seem to access any of the tables. Can someone help me out with it? Dim cn As OdbcConnection cn = New...
Top