Manualshelf

Installation guide

ManualsBrandsSAP ManualsComputer equipmentDB:ODBC
41424344454647484950
mxODBC - Python ODBC Database Interface
3.2.5 Available Data Source Types (DSNs)
There are three kinds of data sources that you can install on Windows machines:
1. User Data Sources (User-DSN)
2. System Data Sources (System-DSN)
3. File Data Sources (File-DSN)
User Data Sources (User-DSN)
User data sources are only visible to the user creating them. Other users normally
do not have access to these data source definitions.
When running an application that is meant to run as service, you have to make
sure that you create the user data source under the user name of the service.
If you intend a data source to be available for all users, or to avoid permissions
problems, creating a system data source is a better option.
When connecting to a user DSN, you have to specify the DSN name as part of the
connection string of
mx.ODBC.Windows.DriverConnect() using the form
"DSN=mydsn". If you use the mx.ODBC.Windows.Connect() API to connect, pass
the DSN name as first parameter.
System Data Sources (System-DSN)
System data sources are available to all users of the system. This is the
recommended setup, if you run services that need to access the data sources from
more than just one account.
When connecting to a system DSN, you have to specify the DSN name as part of
the connection string of
mx.ODBC.Windows.DriverConnect() using the form
"DSN=mydsn". If you use the mx.ODBC.Windows.Connect() API to connect, pass
the DSN name as first parameter.
File Data Sources (File-DSN)
File data sources are special in the sense that they store the data source
connection information and options in a dedicated file rather than in the registry.
This can be useful if you want to manage data sources across many servers and
keep the data source files on a central file server.
You create such DSN files using the ODBC manager.
In order to connect to such a data source, you have to use the
mx.ODBC.Windows.DriverConnect() API and provide a
"FILEDSN=c:\myfile.dsn" entry instead of the usual "DSN=mydsn" as part for
the connection string.
22