On Tue, Jan 30, 2018 at 12:52 AM, sum abiut <[email protected]> wrote: > Hi, > i am trying to connect to an express server 2008 using pymssql following the > direction from > http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pymssql > > but i am getting the following error: > > sqlalchemy.exc.OperationalError: (pymssql.OperationalError) (20009, 'DB-Lib > error message 20009, severity 9:\nUnable to connect: Adaptive Server is > unavailable or does not exist (10.0.11.50 :1433)\nNet-Lib error during > Connection timed out (110)\n') > > appreciate any assistances.
get a successful connection using tsql first: http://www.freetds.org/userguide/confirminstall.htm then if you can show the exact connection parameters for tsql which are known to work we can translate them for pymssql. > > cheers, > Sum > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
