ODBC User data source stores information needed to connect to the data source that is targeted for connection.
DSN is needed to connect to a data source and it stands for Data Source Name.
User DSN:
Only visible to the user who created it and can only be used on the computer on which it is created.
System DSN:
It is available for all users of the computer on which it is created including NT Services.
File DSN:
It can be shared by users who have the same drivers installed on their computer.
Obviously File DSN is more portable than User DSN
How do you create a DSN?
All Windows installations have what is called a ODBC Data Source Administrator, a program to create, maintain or modify data source access that use SQL as a data source standard language.
Search ODBC Data Source on our desktop.
DSN is needed to connect to a data source and it stands for Data Source Name.
User DSN:
Only visible to the user who created it and can only be used on the computer on which it is created.
System DSN:
It is available for all users of the computer on which it is created including NT Services.
File DSN:
It can be shared by users who have the same drivers installed on their computer.
Obviously File DSN is more portable than User DSN
How do you create a DSN?
All Windows installations have what is called a ODBC Data Source Administrator, a program to create, maintain or modify data source access that use SQL as a data source standard language.
Search ODBC Data Source on our desktop.
No comments:
Post a Comment