DatabaseLibrary - Not able to connect MSSQL - 2013, 'Lost connection to MySQL server during query ([Errno 10054]...

E T H I E S

unread,

Dec 15, 2015, 8:33:04 AM12/15/15

to robotframework-users

I could not figure out why RIDE is not connecting with MSSQL.

But I can successfully connect MSSQL from python directly.

The setup is as below:

*** Settings ***
Suite Setup Connect To Database pymysql ${DBName} ${DBUser} ${DBPass} ${DBHost} ${DBPort}

Error on Run as below:
"OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 10054] An existing connection was forcibly closed by the remote host)')"

Additional note:
Using RF with Python 2.7 version.
Successfully installed 'pymssql' and 'CPython'

Did I have missed any thing to update to my system?
Requesting your help on this? and please let me know if you require more information.

Hélio Guilherme

unread,

Dec 15, 2015, 8:57:28 AM12/15/15

to robotframework-users

Looks like you are mixing DB systems.

You setup to MySQL but you want to access a Microsoft SQL server.

Suite Setup Connect To Database pymysql

The driver should be pymssql.

(I don't know about CPython usage, if is totaly compatible with Robot Framework)

Please note that this is just my observation from the info you provided. I did not experiment with DB from RF.

--
You received this message because you are subscribed to the Google Groups "robotframework-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to robotframework-u...@googlegroups.com.
To post to this group, send email to robotframe...@googlegroups.com.
Visit this group at https://groups.google.com/group/robotframework-users.
For more options, visit https://groups.google.com/d/optout.

E T H I E S

unread,

Dec 16, 2015, 12:14:03 AM12/16/15

to robotframework-users

Yes, I mixed up... mysql and mssql

Now I changed the module name as 'pymssql' in RIDE settings... It is WORKING FINE.

CPython is working fine.

Thank you Helio.

On Tuesday, December 15, 2015 at 7:27:28 PM UTC+5:30, Hélio Guilherme wrote:

Looks like you are mixing DB systems.
You setup to MySQL but you want to access a Microsoft SQL server.
Suite Setup Connect To Database pymysql
The driver should be pymssql.

(I don't know about CPython usage, if is totaly compatible with Robot Framework)

Please note that this is just my observation from the info you provided. I did not experiment with DB from RF.

On Tue, Dec 15, 2015 at 1:33 PM, E T H I E S <kisna...@gmail.com> wrote:

I could not figure out why RIDE is not connecting with MSSQL.

But I can successfully connect MSSQL from python directly.

The setup is as below:

*** Settings ***
Suite Setup Connect To Database pymysql ${DBName} ${DBUser} ${DBPass} ${DBHost} ${DBPort}

Error on Run as below:
"OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 10054] An existing connection was forcibly closed by the remote host)')"

Additional note:
Using RF with Python 2.7 version.
Successfully installed 'pymssql' and 'CPython'

Did I have missed any thing to update to my system?
Requesting your help on this? and please let me know if you require more information.

--
You received this message because you are subscribed to the Google Groups "robotframework-users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to robotframework-users+unsub...@googlegroups.com.

Reply all

Reply to author

Forward