The wizard provides a DSN, the connectionstring, driver, among them: the connectionstring is based on DSN, driver automatically generated, and the content of the
So you just need to fill in the DSN and driver, but prompt:
I don't think the mistakes should be DSN can save the password, so lead to did not establish a connection, if I can specify the password in programming, but in
In the import and export wizard how to specify a password
CodePudding user response:
Settled, add password=password in the connection string