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.
12,268 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CosmogHong-MSFT 19,986 Reputation points Microsoft Vendor
    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 No comments