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 to configure a data source name (DSN) to use during a data source access, the method comprising:
selecting a driver;
providing an identifier that identifies a data source, the identifier comprising an identifier of a class of the 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 the driver executing on a computer, to access an implementation of the driver interface of the data source;
determining, by the implementation of the driver interface, connection settings for the data source and generating a connection string;
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 library or application is component object model (COM)-based.
2. The method of claim 1 , wherein the driver is used by the client to access the data source based on the DSN.
3. The method of claim 2 , further comprising:
modifying an existing DSN to use the driver so that a current client application can connect to the data source.
4. The method of claim 2 , further comprising:
creating a DSN that uses the driver for a client application that allows the data source to be configured.
5. The method of claim 1 , wherein the implementation prompts for additional information while configuring the DSN.
6. The method of claim 5 , wherein the implementation provides default values for any additional information.
7. An apparatus to configure a data source name (DSN) to use during a data source access, the 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:
select a driver;
provide an identifier that identifies a data source, the identifier comprising an identifier of a class of the 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;
determine, by the implementation of the driver interface, connection settings for the data source and generate, by the implementation of the driver interface, a connection string;
receive the connection string with the identifier from the implementation of the driver interface to the driver; and
forward the connection string from the driver to a driver manager which manages a client;
wherein the library or application is component object model (COM)-based.
8. The apparatus of claim 7 , wherein the driver is used by the client to access the data source based on the DSN.
9. The apparatus of claim 8 , 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.
10. The apparatus of claim 8 , 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.
11. The apparatus of claim 7 , wherein the implementation prompts for additional information while configuring the DSN.
12. The apparatus of claim 11 , wherein the implementation provides default values for any additional information.
13. A non-transitory computer-program product to configure a data source name (DSN) to use during a data source access, the computer-program product comprising:
a non-transitory computer-readable medium comprising code executable by at least one processor that, when executed, causes the at least one processor to:
select a driver;
provide an identifier that identifies a data source, the identifier comprising an identifier of a class of the 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;
determine, by the implementation of the driver interface, connection settings for the data source and generate, by the implementation of the driver interface, a connection string;
receive the connection string with the identifier from an implementation of the driver interface to the driver; and
forward the connection string from the driver to a driver manager managing a client;
wherein the library or application is component object model (COM)-based.
14. The non-transitory computer-program product of claim 13 , wherein the driver is used by the client to access the data source based on the DSN.
15. The non-transitory computer-program product of claim 14 , further comprising:
modifying an existing DSN to use the driver so that a current client application can connect to the data source.
16. The non-transitory computer-program product of claim 14 , further comprising:
creating a DSN that uses the driver for a client application that allows the data source to be configured.
17. The non-transitory computer-program product of claim 13 , wherein the implementation prompts for additional information while configuring the DSN.
18. The non-transitory computer-program product of claim 17 , wherein the implementation provides default values for any additional information.