Forum Discussion

mwalia's avatar
mwalia
Occasional Contributor
6 years ago

Connecting to Sql server db using pyodbc with testcomplete

Hi All, I am trying to integrate a python pyodbc extension in TestComplete 12.6 as a trial user for connecting SQL server database. I have tried the below approaches: 1. Added the ‘pyodbc’ exten...
  • AlexKaras's avatar
    AlexKaras
    6 years ago

    Hi,

     

    May I wonder if you *really* need this library? What for? Wouldn't built-in ADO object work for you (https://support.smartbear.com/viewarticle/9013/ and other articles from the SQL section) ?

     

    P.S. A side benefit of using objects and functionality provided by TestComplete itself is that the resulting code is more portable i when you need to use it for the project based on some other scripting language.

     

  • AlexKaras's avatar
    AlexKaras
    6 years ago

    Hi,

     

    > if we can use the external python library pyodbc with Test Complete.

    I would say that this should be possible. The link posted by Marsha_R and the whole https://community.smartbear.com/t5/TestComplete-Mobile-Application/How-do-i-add-Python-Libraries-and-extend-the-Pyton-support-on/td-p/118785 thread with replies from baxatob are worth reading and carefull follow-up. I am not a Python expert but it is my understanding that Python, like Java/Groovy, is pretty sensitive to correct paths and module versions but not always provides a clear and descriptive problem diagnostic. Thus, you must be careful, understand what you are doing and have an idea of what paths and default locations Python's engine may examine on your system while searching for this or that module.

     

     

     

AlexKaras's avatar
AlexKaras
Champion Level 3

Hi,

 

May I wonder if you *really* need this library? What for? Wouldn't built-in ADO object work for you (https://support.smartbear.com/viewarticle/9013/ and other articles from the SQL section) ?

 

P.S. A side benefit of using objects and functionality provided by TestComplete itself is that the resulting code is more portable i when you need to use it for the project based on some other scripting language.

 

TanyaYatskovska's avatar
TanyaYatskovska
SmartBear Alumni (Retired)
6 years ago

Thanks for sharing your ideas, Marsha, Robert!

 

mwalia, did you resolve the issue? 

  • mwalia's avatar
    mwalia
    Occasional Contributor
    6 years ago

    Hi TanyaYatskovska

     

    Yes ADO object usage can definately be a solutionfor the same.

     

    However, I was curious if we can use the external python library pyodbc with Test Complete.