Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. izoratti

    New to MySQL - using 5.0.11 beta to learn

    ODBC is the default user for MySQL running on windows. In order to use a client program you should specify a user (and a password, if the user has one). for example: mysqlshow --user=root use mysqlshow --help for more information
  2. izoratti

    Beginner in stored procedures

    http://www.databasejournal.com/features/mysql/article.php/10897_3525581_2 you can find many others with Google. Check also the PDF doc provided - concise but helpful.
  3. izoratti

    Connect to MySQL

    BTW - performance on small intel boxes are much better than any other DB I have used - SQLSrv, SyBase, Oracle etc.
  4. izoratti

    Connect to MySQL

    I have created a MSTR project with MySQL WH (5.0.6 with MyISAM tables) with no problems at all. ODBC Driver is 3.51.06 (I used a previous version and it worked anyway) - make sure that "Don't' optimize column width" and "Return Matching Rows" options are checked
  5. izoratti

    SQL Log

    In MicroStrategy Desktop > Tools > Diagnostics TN5200-7X0-0052 in KB. Thanks a lot for the tip. iz
  6. izoratti

    SQL Log

    Hi, In the old days, DSS Agent 6.X allowed us to view all the SQL it generated (not only for reporting, for data browsing and metadata access as well) just adding the sqllog=filename parameter in the [tools] section of the DSS file. Do you know if there is something similar for MSTR Desktop...

Part and Inventory Search

Back
Top