Using CONFIGDSN - How do I find out what value pairs are not valid when I get this error message: invalid keyword-value pairs with error code -2147467259

Question

I'm trying to run this command to set up a DSN from a batch file CONFIGDSN "SQL Native Client" {"DSN=Prof;Description=proficy;SERVER=PROF;Trusted_Connection=Yes;Database=xx"} I get this error message: invalid keyword-value pairs with error code -2147467259 How do I find out which pairs are invalid?

Answer 1

Hi @Kennedy, Mike

Generally, the error is generated when you are trying to create a DSN with a parameter (keyword) that is not supported by the driver. To find out which one is not supported, start removing parameters one at a time.

Verify if the username or password are valid keywords when configuring a SQL Server DSN. For more information about the valid SQL Server-specific keyword/value pairs for data source configuration attribute strings, visit this Microsoft Web site.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.