Method and apparatus for configuring a data source name (DSN) for use during a data source access
View Patent ↗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.
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.