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.

 

mwalia's avatar
mwalia
Occasional Contributor
6 years ago

Thanks AlexKaras

 

 

 

Thanks for sharing the solution. ADO object works.

 

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

  • AlexKaras's avatar
    AlexKaras
    Champion Level 3
    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.

     

     

     

  • CraigB's avatar
    CraigB
    Contributor
    6 years ago
    Hi I'm late to this thread, but I've also been trying to use pyodbc because ADO only works if I'm using a trusted connection - if I try using anything else I get a COM exception (who doesn't love COM?) stating that some unspecified provider wasn't found. I've tried the steps in the links about getting Python modules to work, but had no luck. Unfortunately, as is so often the case, there's no actual documentation that I can find either for using Python modules (the linked instructions actually state that the instructions TestComplete documentation gives is not correct) or for using TestCompletes ADO COM component. I'd prefer to use pyodbc, if for no other reason than it's not COM which I thought had died over 10 years ago. But also because there's available documentation for it and, well, I'm supposed to be writing Python code. It's difficult enough writing code for TestComplete because any reference to TestComplete shows up as an error in the code.