Forum Discussion

mkirkland's avatar
mkirkland
Contributor
12 years ago

Connecting to remote MySQL database

I have yet to find a solution to get test complete 9.20.2460.7 to connect to my Ubuntu MySQL database. 



I am trying to create a new Database checkpoint with a custom query. I finally was able to get a test connection working by installing MySQL Connector/ODBC, that will work fine but the problem is with the connection from Test Complete. I was at first getting an error when trying to use the OLE DB Provider from Oracle, i installed the Oracle client/network suite and i got a bit further. I get stuck at the test connection telling me that there is no listener available. I cannot seem to get past this point.



Any help?

5 Replies

  • sastowe's avatar
    sastowe
    Super Contributor
    12 years ago
    The issue is very unlikely a Test Complete one. I used ADO all the time. This is a set of Microsoft Active X objects that you can use to connect to your MySQL database using the correct connection information. Connecting to the database is a network issue.
  • mkirkland's avatar
    mkirkland
    Contributor
    12 years ago
    I was able to resolve this issue. It was actually a bug in the 64bit ODBC connector driver. I installed the 32bit driver and it works fine
  • mkirkland's avatar
    mkirkland
    Contributor
    12 years ago
    Can i have some assistance setting up a script to connect to the MySQL Database?



    My scripts are in the jscript format, do i need to install ANYTHING 3rd party for this to connect? i.e. Oracle software



    I think im confused on the connection string information



    Here is what i am trying so far, but it fails:




    function ado(){


      var aCon;


      // Creates ADO connection


      aCon = ADO.CreateConnection();


      // Sets up the connection parameters


      aCon.ConnectionString = "Driver={MySQL ODBC 5.2 ANSI Driver};Server=192.168.0.128;"


         "Port=3306;Option=4;Database=HealthCheck;Uid=testcomplete;Pwd=test;";


      // Opens the connection


      aCon.Open();


     


      aCon.Close();


    }

  • mkirkland's avatar
    mkirkland
    Contributor
    12 years ago
    TestComplet Error:



    Microsoft OLE DB Provider for ODBC Drivers.



    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified



    Error location:~





    This happens at `aCon.Open();`