Forum Discussion

oorupabo's avatar
oorupabo
15 years ago

DB Checkpoint connection to Advantage tables

I'm new to TestComplete and would like to know whether it is possible to setup DB connection to advantage tables. The application I'm testing uses ADS to store data into ADS table and as such it is not connection to  a ADS database.



The main issue is that the ODBC drivers is not listed with the DB checkpoint and I'm unsure how to specify a connection string in DB checkpoint.



Any suggestion would be welcomed.



Thank you,



owupele


  • AlexKaras's avatar
    AlexKaras
    Champion Level 3
    15 years ago
    Hi Owupele,



    > The main issue is that the ODBC drivers is not listed with the DB checkpoint [...]

    In this case you should create a DSN using the odbcad32 utility and then use the created DSN by selecting the 'OLEDB provider for ODBC' in the providers' list when setting-up the connection for the checkpoint.
  • ujwala_bhujbal's avatar
    ujwala_bhujbal
    New Contributor
    12 years ago
    ´Hi there,



    I have a small problem regarding the DB Checkpoint connection string (TC 8).



    I want the same DB Checkpoint to work parallely for multiple DB's on multiple VMWare ?



    Below is the code sample i am trying to run for multiple DB's:

    ----------------------------------------------------------------------------------------



    sub ConStringExample(Chkpnt)

     

      ' Specifies a DB Table element

      Set DBTab = DBTables.Check_Info

    '    ' Specifies a connection string

        

      DBtab.ConnectionString = "Provider=SQLOLEDB.1;" + _

      "Data Source=23.34.234.34;" + _

      "Initial Catalog= &Chkpnt;"

     

      DBTab.Check

    End sub

     

     

    sub abc()

    call  ConStringExample(ODB_Test_2013) 

    end sub

    ------------------------------------------------------------------------------------------



    Above I am trying to paramterize the DB name by passing the parameter to the subroutine 'ConStringExample'



    'Check_Info' is my Checkpint name.

    I am not able to run this subroutine. As it fails to accept the variable in 'Initial Catalog' -field of Connectionstring.





    Can anyone guide me on this ... I have tried to parameterize the Checkpoint Value but that also doesnt work.



    The question is Can I Parameterize ConnectionString contents??





    Regards,

    Uj





    [Sorry if m posing at wrong location :( .]