Oh wait, it worked!
Thank you!
User Profile
Collapse
-
Thanks for the suggestion. Just tried it--still the same error.Leave a comment:
-
SQL: Exception using variables in queries
I'm getting this error when I try to insert a variable in a SQL query:
'Exception occurred.', (0, 'Microsoft JET Database Engine', 'No value given for one or more required parameters.'
...Code:def linker (Function): conn = win32com.client.Dispatch(r'ADODB.Connection') DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=db8.mdb'; conn.Open(DSN) rs = win32com.client.Dispatch(r'ADODB.Recordset')
No activity results to display
Show More
Leave a comment: