|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: file DSN, system DSN |
|
From: |
elewis |
|
Date: |
5/30/2000 1:47:49 PM |
|
IP: |
204.106.63.5 |
System DSNs and file DSNs differ in one fundamental way. A file DSN is just that, DSN information that is stored in a file. These can be read (and edited) with any text editor.
System DSNs are stored in the registry (ergo the system in system dsn). If you have any system DSNs setup on your machine and your familiar with regedit you can see them at the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini
File DSNs offer the distinct advantage of being portable to some extent. In other words you can create one on your PC and copy it to another machine (usually a web server) as long as absolute path information stays the same, or you can edit it to point to the location where your database will reside on the server.
File DSNs also solve the problem of having to get your ISP to create DSNs for you.
Im not sure what you are working on but you can forego all this DSN stuff by using ADO in your ASP projects and create DSN-less connections right in your ASP pages.
Hope this helps. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
