Method and apparatus for configuring a data source name (DSN) for use during a data source access

• US 9,742,850 B1
• Filed: 02/20/2017
• Issued: 08/22/2017
• Est. Priority Date: 06/14/2010
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Open Invention Network LLC
• Inventors: Yaeger, Marc Todd
• Primary Examiner(s): Nguyen, Thai
• Application Number:
  US15/437,316
• Time in Patent Office: 183 Days
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 9/543 User-generated data transfer, e.g. clipboards, dynamic data exchange [DDE], object linking and embedding [OLE]
• CPC Class Codes: G06F 9/547 Remote procedure calls [RPC]; Web services
• CPC Class Codes: H04L 67/14 Session management for real-time applications in data packet communications networks H04L65/1066
• CPC Class Codes: H04L 67/141 Setup of application sessions admission control or resource allocation in data switching networks H04L47/70

Abstract

Certain aspects of the present disclosure relate to a technique to configure a data source name (DSN) for use during a data source access. A driver is selected. An identifier is provided that identifies a class, and a library or an application that implements a driver interface for accessing the data source. A connection string is forwarded with the identifier from an implementation of the driver interface to the driver. The connection string is forwarded from the driver to a driver manager managing a client.

Claims

1. A method, comprising:

providing an identifier that identifies a data source and at least one of a library or an application of the data source that implements a driver interface to access the data source;

using the identifier, by a driver executing on a computer, to access an implementation of the driver interface of the data source;

providing control to the implementation, by the driver, to access connection settings;

generating, by the implementation of the driver interface, a connection string based at least on the connection settings;

receiving, by the driver executing on the computer, the connection string with the identifier from the implementation of the driver interface to the driver; and

forwarding the connection string from the driver to a driver manager managing a client;

wherein the driver is used by the client to access the data source based on a data source name (DSN), wherein the implementation provides default values for any additional information.

2. The method of claim 1, further comprising modifying an existing DSN to use the driver so that a current client application can connect to the data source.

3. The method of claim 1, further comprising creating a DSN that uses the driver for a client application that allows the data source to be configured.

4. The method of claim 1, wherein the implementation prompts for additional information while configuring the DSN.

5. The method of claim 1, further comprising selecting the driver.

6. An apparatus, comprising:

a memory comprising instructions; and

coupled to the at least one processor

at least one processor, communicably coupled to the memory, and configured to read the instructions to;

provide an identifier that identifies a data source and at least one of a library or an application of the data source that implements a driver interface to access the data source;

use the identifier to access an implementation of the driver interface of the data source;

provide control to the implementation, by the driver, to access connection settings;

generate, by the implementation of the driver interface, a connection string based at least on the connection settings;

receive the connection string with the identifier from the implementation of the driver interface to a driver; and

forward the connection string from the driver to a driver manager which manages a client;

wherein the driver is used by the client to access the data source based on a data source name (DSN), wherein the implementation provides default values for any additional information.

7. The apparatus of claim 6, wherein the at least one processor is further configured to modify an existing DSN to use the driver so that a current client application can connect to the data source.

8. The apparatus of claim 6, wherein the at least one processor is further configured to create a DSN that uses the driver for a client application that allows the data source to be configured.

9. The apparatus of claim 6, wherein the implementation prompts for additional information while configuring the DSN.

10. The apparatus of claim 6, wherein the at least one processor is further configured to select a driver.

11. A non-transitory computer-readable medium comprising code executable by at least one processor that, when executed, causes the at least one processor to:

provide an identifier that identifies a data source and at least one of a library or an application of the data source that implements a driver interface to access the data source;

provide control to the implementation, by the driver, to access connection settings;

generate, by the implementation of the driver interface, a connection string based at least on the connection settings;

receive the connection string with the identifier from an implementation of the driver interface to a driver; and

forward the connection string from the driver to a driver manager managing a client;

wherein the driver is used by the client to access the data source based on a data source name (DSN), wherein the implementation provides default values for any additional information.

12. The non-transitory computer-program product of claim 11, further comprising modifying an existing DSN to use the driver so that a current client application can connect to the data source.

13. The non-transitory computer-program product of claim 11, further comprising creating a DSN that uses the driver for a client application that allows the data source to be configured.

14. The non-transitory computer-program product of claim 11, wherein the implementation prompts for additional information while configuring the DSN.