pymssql text type

Aahz aahz at pythoncraft.com
Thu Mar 12 11:36:55 EDT 2009


[posted and e-mailed, please reply to group]

In article <851ed9db-2561-48ad-b54c-95f96a7fa42d at q9g2000yqc.googlegroups.com>,
marc wyburn  <marc.wyburn at googlemail.com> wrote:
>Hi, I'm trying to pass a text blob to MS SQL Express 2008 but get the
>follwoing error.
>
>(<class 'pymssql.OperationalError'>, OperationalError("SQL Server
>message 102, severity 15, state 1, line 1:\nIncorrect syntax near
>'assigned'.\n",), <traceback object at 0x044ABDF0>)
>
>the string it is having an issue with is
>
>(\r\n\r\n\tLogon ID:\t\t(0x0,0xE892A8)\r\n\r\n\tLogon Type:\t2\r\n\r
>\n')

What is the code you're trying to execute and what is the full traceback?
-- 
Aahz (aahz at pythoncraft.com)           <*>         http://www.pythoncraft.com/

"All problems in computer science can be solved by another level of     
indirection."  --Butler Lampson



More information about the Python-list mailing list