search

schanjr / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Update query does not work but insert query works onsame db with same connection string #374

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
Test Script in attachment.
Make an insert and update query on an db to witch you have a connection
Test the querys directly in DB soft like sql developer to test the querys.
Do the insert query so far so good
Do the update query -->hangs

What is the expected output? What do you see instead?
Expected: entry insert, than that entry updated by update query.

Happend: insert works
update hangs wrote the update as short or long as possible, multi line, single 
line all where valid querys and executed by db when directly executed in sql 
developer

What version of the product are you using? On what operating system?
win7 32bit
info throug platform:
AMD64
6.1.7601
Windows-7-6.1.7601-SP1
('Windows', 'WE10SBN', '7', '6.1.7601', 'AMD64', 'Intel64 Family 6 Model 23 
Stepping 10, GenuineIntel')
Windows
Intel64 Family 6 Model 23 Stepping 10, GenuineIntel
2.7.1 (r271:86832, Jun  5 2013, 15:09:57) [MSC v.1600 32 bit (Intel)]

Please provide any additional information below.
insert query works -> so connectionstring is ok
insert query works on DB -> so query is ok
update query works on DB -> so query is ok

update query does not work trough pyodbc.
Cant figure this out, test script is only +-15lines

Original issue reported on code.google.com by bart.ver...@gmail.com on 1 Jul 2014 at 10:05

Attachments: