Forums
This topic is locked
The diffrence
Posted 29 Jul 2003 10:06:21
1
has voted
29 Jul 2003 10:06:21 Henrik Hansen posted:
What is the the diffrence between Custom connection strings and DSN (Data Source Name)? Replies
Replied 29 Jul 2003 13:00:45
29 Jul 2003 13:00:45 Lee Diggins replied:
Hi
A DSN is a databse connection stored in your OS, you'd set this up in your ODBC connection manager.
A Custom Connection String is the same kind of thing, but the details are kept within your web site pages or an include file and sent everytime you connect to a db.
The DSN is more secure and can be used by all apps by referencing the DSN.
You would most likely use the Custom Connection String where you cannot get access to the OS and setup your own DSN, great in a hosting situation.
Hope this helps
Digga
Sharing Knowledge Saves Valuable Time!!!
A DSN is a databse connection stored in your OS, you'd set this up in your ODBC connection manager.
A Custom Connection String is the same kind of thing, but the details are kept within your web site pages or an include file and sent everytime you connect to a db.
The DSN is more secure and can be used by all apps by referencing the DSN.
You would most likely use the Custom Connection String where you cannot get access to the OS and setup your own DSN, great in a hosting situation.
Hope this helps
Digga
Sharing Knowledge Saves Valuable Time!!!