Troubleshooting connection with the ODBC driver
Note
When the username and password are already specified in the DSN, there is no need to specify them again when the ODBC driver manager asks for them.
An error code of 01S02
with a message, Re-writing
occurs when a
connection string option is passed more than once in the connection string. Specifying an option
more than once raises an error. When making a connection with a DSN and a connection string, if
a connection option is already specified in the DSN, do not specify it again in the connection string.(connection
string option)
(have you specified it several times?