I'm getting this error when querying a MS SQL Server 2005 instance with the SQL Native client using mxODBC 3.0.4.
Error: 22008, 0, [Microsoft][SQL Native Client]Datetime field overflow, 7748
I don't always get the error, it only seems to happen for some values passed to the query. I think it is somehow related to the fact that a mx.DateTime object is being passed to the query and somehow being converted to a SQL datetime field in an improper manner.
In the query below SessionIdTime is a datetime field in SQL and I'm passing last_record[0] which is a mx.DateTime object. Not sure how to workaround this issue.
Any ideas?
sql = """
SELECT
sd.SessionIdTime, sd.SessionIdSeq
FROM SessionDetails sd
WHERE sd.SessionIdTime > ?
OR (sd.SessionIdTime = ? AND sd.SessionIdSeq > ?)
"""
db = mx.ODBC.Windows.DriverConnect('DSN=OCS')
conn = db.cursor()
conn.execute(sql, (last_record[0], last_record[0], last_record[1]))
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /mailman-archives/egenix-users/attachments/20100825/88016402/attachment.htm