Q: What is a DSN? DSN-less?

A: The Windows database types supported on our Hybrid platform are Access and MSSQL

Customers can integrate their databases into their websites using either of the 2 following methods:

1. 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.
2. 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.
 

Q: How do I create a DSN?

A: To Create a DSN please provide the following information:

Domain Name
Database Name
Database Type (i.e. MSACCESS / MYSQL)
DSN Prefix ( i.e. db_yourdomain_com)
Language (i.e. ASP/ ColdFusion, PHP)


Windows Services Must be Enabled

Please ensure that Windows Services is enabled (located in WebsiteOS4 > Site Builders> Windows Services) for ASP, ASP.net, ColdFusion ColdFusionMX; otherwise a DSN cannot be created.

Q: I would like more information about the Database Manager/ MySQL that is in my Website OS.

A: Click HERE to open document.