Share via

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

Kennedy, Mike 0 Reputation points
2024-02-01T21:58:44.16+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
Microsoft Configuration Manager

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 25,651 Reputation points
    2024-02-02T06:29:23.65+00:00

    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.

    0 comments