<div>
A search on EE comes with with no questions regarding PYODBC...
</div>


A search on EE comes with with no questions regarding PYODBC...

<div>
Also, no error messages are generated...<br />
&gt;&gt;&gt;&nbsp;<br />
&gt;&gt;&gt;&nbsp;
</div>


Also, no error messages are generated...
>>> 
>>> 

<div>
Where you have this:<br />
<br />
&nbsp; cnxn.close<br />
<br />
you need this:<br />
<br />
&nbsp; cnxn.close()<br />
<br />
Without the (), the function doesn't get called.<br />
<br />

</div>


Where you have this:

  cnxn.close

you need this:

  cnxn.close()

Without the (), the function doesn't get called.



<div>
Thanks RichieHindle, it does open &amp;&nbsp;close the database now, but still no data is getting written. Maybe it has to be opened in a specific mode?
</div>


Thanks RichieHindle, it does open & close the database now, but still no data is getting written. Maybe it has to be opened in a specific mode?

<div>
Thanks again, RichieHindle! That was it!
</div>


<div>
<div class="content wysiwyg-content">
I am using the Python code below to write to an MSAccess DB through ODBC. I don't get any errors, I know the database is being accessed because it creates a key, but the database isn't close (until I close the Python session) because the key doesn't go away. But no data is getting written to the database.<br />
<br />
Can anyone see what I am not?<br />
<br />
btw, Customer_ID is an integer.<br />
<br />
import pyodbc<br />
cnxn = pyodbc.connect(&quot;DSN=proddb<wbr />&quot;)<br />
cnxn.execute(&quot;INSERT INTO tblParts (Part_Number, Part_Description, Customer_ID, Part_Type) VALUES ('856854-001', 'BASEFRAME', 421, 'NA')&quot;)<br />
cnxn.close
</div>
</div>


I am using the Python code below to write to an MSAccess DB through ODBC. I don't get any errors, I know the database is being accessed because it creates a key, but the database isn't close (until I close the Python session) because the key doesn't go away. But no data is getting written to the database.

Can anyone see what I am not?

btw, Customer_ID is an integer.

import pyodbc
cnxn = pyodbc.connect("DSN=proddb")
cnxn.execute("INSERT INTO tblParts (Part_Number, Part_Description, Customer_ID, Part_Type) VALUES ('856854-001', 'BASEFRAME', 421, 'NA')")
cnxn.close

Can't write to MSAccess database with pyodbc

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.