Skip to Content
author's profile photo Former Member
Former Member

Connection with MySQL

Hi,

I am having an application which is having MySQL as its database back end. I am trying to connect that database with Sybase Unwired Platform(SUP2.1).

How can i do that?

Do i need to make connection/synchronization through SQL Anywhere with MySQL as it is a default available database with SUP.

Please suggest.

Regards,

Shrikant.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Apr 26, 2013 at 03:10 PM

    Hello All,

    I created a connection profile to connect MySQL server and able to connect successfully. But I'm unable to see the existing tables. Can some one help me on this issue.

    Thanks
    Pavan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Siva,

      sorry for the late response. Yes, you have to create a new JDBC template in SCC under Domains->[your domain e.g.default]-->Connections. Then select the Template tab and enter the database properties similar to the following:

      Note that you can choose DB as the database type. Then switch to the Connections tab and create a new connection by selecting the template you've just created.

      Click on the Test Connection button to verify that the connection succeeds. Hope this helps.

      Regards,

      Bishara

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2012 at 11:37 AM

    Hi,

    You can create conntection to your MySQL db under Sybase Unwired Workspace -> Enterprise Explorer -> Database Connections. I think you should check documents about SUP.

    [Removed by Moderator]

    Message was edited by: Michael Appleby

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Erhan,

      I have gone through the docs for SUP 2.1. But i didn't find any specific information regarding MySQL connection. I am assuming that i need to import some drivers for the MySQL database in the SUP installation directories. Is that all needed. Can you suggest me what else i am missing?

      If you can provide me any reference link that will be really helpful.

      Regards,

      Shrikant.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2012 at 05:06 AM

    Hi Shrikant,

    If you want to access other database you will have to create database connection using enterprise explorer.

    here i mention the way how we can create the connection. it is depends on the workspace version.

    right click on Database Connections from Enterprise Explorer->from the list of connection profile types choose which one you want ( oracle, SQL Server)->provide name for the connection->click on the icon for new deiver definition->it will open new driver definition wizard -> here you select the type of database,jar list and properties(userid,password,connection url,drivername, driver class)->click ok->you can test here whether the connection is successful or not->next->finish.

    finally you will see the database icon in the database connections.

    Thansks&Regards

    Murthy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI nishan,

      i have read this blog and understood you are able to connect to you MySql from the SUP , so the connection job is done from SUP the only thing you are unable to access the table presents in your database, that is something to do with database,

      i believe like in SAP until we will not set BAPI/RFC property as expose to the external world we will not be able to access them even though you are successfully connected the SAP.

      check is there any access table property has been set in your database.

      prem

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2013 at 08:28 PM

    hi shrikant,

    I am facing the same issue did you find any solution ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.