If you need to create, remove, or look up a DSN please contact the Technical Support Team via email, chat and or telephone.
Microsoft Access, Microsoft SQL:
DSN’s (Data Source Name) and conventions:
You can integrate your databases into your websites using either of the 2 following methods:
-
DSN connection method – A DSN (Data Source Name) is the name that applications use to request a connection to a system ODBC data source. It specifies the computer name and (optionally) database that the data source name (DSN) maps to. In order for a DSN to be created for MS Access databases, the .mdb file must exist in the /databases directory of the end-users file structure.
-
DSN-less connection method – A.K.A OLE DB connection method. This method allows greater flexibility for end-users. This method does not require the database to be located in a specific directory. The database can be located in any location of the clients’ directory structure, and can be accessed in their code as long as the proper path has been specified.
To create a DSN please provide the following Information:
When creating a DSN please note that a DSN cannot exceed 32 characters in length (Sometimes caused by length of the domain name or prefix). You will need to provide the following:
Domain Name
Database Name
Database Type (i.e. MSACCESS / MYSQL)
DSN Prefix ( i.e. db_yourdomain_com)
Language (i.e. ASP/ ColdFusion)
Please ensure that Windows™ Services are enabled in the Aplus control panel for ASP, ASP.net, ColdFusion ColdFusion MX; otherwise a DSN cannot be created.
