SQL Anywhere connection setup

(2 posts) (2 voices)
  1. jh_in4, Member

    The report set-up page that launches when first installing myDBR lists SQL Anywhere as one of the database vendor options.

    However I can't see, given the options of only database Host \ Port \ Name, how to connect to that kind of database.

    Unlike MySQL or MS SQL Server, SQL Anywhere doesn't store individual databases against a single server configuration - db's are connected as individual files.

    Has SQL Anywhere support since been pulled? If not, does anyone have an example config layout that works with it?

  2. myDBR Team, Key Master

    SQL Anywhere is supported.

    When using SQL Anywhere, the myDBR objects are installed into the same database where the user data resides. myDBR uses it's own naming scheme to separate the objects from your data.

    You should be able to select SQL Anywhere as your target database type.

    Sample configuration file would looks like this:

    define( "DB_VENDOR", 'sqlanywhere' );
    define( "DB_HOST", 'mysqlanywhere' );
    define( "DB_PORT", NULL );
    define( "DB_NAME", 'mydatabase' );
    define( "DB_USER", 'dba' );
    define( "DB_PASSWORD", 'pass' );
    define( "SETUP_DONE", true );

    --
    myDBR Team


Reply

You must log in to post.