Search results

  1. C

    ODBC error (codepage issue)

    @beeworks: I removed all other posts spammed in old threads. Please don't revive old threads again for asking questions. Start a new one. Furthermore posting 1 question with a good title and detailed description of your problem is enough. So don't go around posting the same question all over...
  2. C

    Secondary SQL Broker

    I assume that the with "the server shuts down", you mean the _sqlsrv2 process? What is the java version serverside? Does this always happen? Does this also happen when you access the database with SQL from another application, for instance Excel or sql explorer? What does the database log file...
  3. C

    Binary Dump Code Page

    If you are sure that both databses have the same codepage then you can enter yes. I never encountered this question during a dump/load. Are you really sure the database has not the undefined codepage? Did you perfrom the binary dump yourself? Casper.
  4. C

    Binary Dump Code Page

    You can't. Either convert the ibm-850 database first to iso8859-1 or convert the 10.1B database after load to iso8859-1. From the documentation: BTW 10.2A is the latest release,so while you are at it, use this one :-) Regards, Casper
  5. C

    Busy Agent

    Do not use webspeed to make long requests, instead batch the information to the webserver in smaller parts (say 50 products per request) and use previous next last first to let the user navigate in the results. On top of that , make sure you have enough search criteria the user can enter to let...
  6. C

    AI Best Practice

    To add to that: 4- no AIW 5 no BIW Casper.
  7. C

    Request to Webservice (longchar)

    Read up on hte sax-writer. That is the way you should make your xml. You can write directly to a longchar if you want. Casper
  8. C

    OE Arcitect

    The question is: What do you want to do with it? Like RHD said: if you are using adm/adm2 or legacy appbuilder code then it might be handy to use the appbuilder. If you have no restrictions go for eclipse. There are lots of nice things you can do with it. Casper.
  9. C

    Binary dump Load issue:

    Index rebuild during binary load I think it is already supported in 9.1X as well. You can use the "build indexes" in the proutil load command with needed parameters (-TB, -TM, -T, -B, -SS etc...). But on our databases in most cases it is quicker to do a binary load followed by an idxbuild...
  10. C

    how to hide the frame before...

    It is imposible to hide a frame when it is not yet defined. If it isn't there then you can't act on it. If the source file is xcoded and you can't modify it then it is rather difficult to change its behavior. Casper.
  11. C

    Creating temporary tables

    to add to that: Unless necessary always define your temp-table as no-undo. Casper.
  12. C

    Binary dump Load issue:

    Did you do an index rebuild during load? If not then you have to do that seperately. casper.
  13. C

    Progress for Java

    No, you should make a dedicated primary broker for 4GL connections and a dedicated secondary broker for SQL connections. BTW the server name should not be some kind of share (I see you have //mss-srv in the conection string) but a real server name defined in system32/drivers/etc/hosts or an IP...
  14. C

    Web Server and WebSpeed Topology

    The powerpoint presentation I referred to was from PDW 2004 and covered in detail how to configure webspeed within a dmz. I tried to search him just now but couldn't find it anymore on the net. If you are interested I can sent it to you offline. Just drop me a PM. Regards, Casper.
  15. C

    Problem with webspeed and external javascript functions

    I guess you have to put ajax.js in the docroot of your webserver. If it is in a directory called are then that also has to reflect in the way you declare the javascript function: e.g. are/ajax.js. If you run it as a static html page then the path of the js is relative to directory where the...
  16. C

    Progress for Java

    Try: String driver = "com.progress.sql.jdbc.JdbcProgressDriver"; String URL = "jdbc:jdbcprogress:T:<hostname>:<portnumber>:<databasename>"; String username = "<username>"; String password = "<password>"; Connection con = null; ...... Class.forName( driver ); con = DriverManager.getConnection(...
  17. C

    Progress for Java

    If you are using java then why dont you use jdbc instead of odbc? The driver version used in 9.1E is Datadirect 4.1 by the way... Casper.
  18. C

    Secondary SQL Broker

    Your parameters are not set correctly. You need to count -Mn as follows: -Mn = #4GL servers + #SQL servers + 1 for each extra broker. So in your case (with -Mn set to 5) you need to set -Mpb on the primary broker to 3 and -Mpb on the secondary broker to 1. I also wonder why you have such a...
  19. C

    Secondary SQL Broker

    Well like the message you have more then 70 simultanous database connections. Fun part (well, not really) is that even in the latest release of OpenEdge this results in the _slqsrv2 proces not accepting any connections anymore, even if the number of connections have dropped. So the "Retry the...
  20. C

    Rebuild of db

    Well it probably isn't the best. But I tend to split up data in small and large clusters with the criteria I already mentioned. So i think in terms of 512 and 8 :-) I never use clustersize 64. You must realize that just by using typeII storage area's you already gain a perfromance boost and I...
Back
Top