ASP

1. DSN connection for MS Access?

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=prefix_domain_com”

2. DSN connection for MS SQL?

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN= prefix_domain_com;UID=dbm.domain.com;
PWD=password"

3. DSN connection for MySQL?

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN= prefix_domain_com;UID=dbm.domain.com;
PWD=password"

4. DSNless Connection for MS Access?


Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;
DATA SOURCE=" & Server.MapPath(“/databse.mdb”)
mdbfile = "/stuff/sample.mdb"
connstr = "Driver={Microsoft Access Driver (*.mdb)};
DBQ=" & Server.MapPath( mdbfile ) & ";"

5. DSNless connection for MS SQL?


DRIVER={SQL Server};SERVER=mssql.megasqlservers.com;
DATABASE= databasename _domain_com;UID=dbm_domain_com;
PWD=password;

6. DSNless connection for MySQL?


Driver={MySQL};Server=megasqlservers.com;
DATABASE=databasename_domain_com;UID=dbm.domainname.com;
PWD=password;

4. Defining Paths?


Server.MapPath("/") equates to “\domain.com\public\”
Server.MapPath(“/images”) equates to “\domain.com\public\images”

ColdFusion

1. DSN connection for MS Access


<cfquery name="schedule" datasource="db_austin_Hybeam_com">
SELECT * FROM Producers
</cfquery>

2. DSN connection for MS SQL


<cfquery name="schedule" datasource="db_austin_Hybeam_com";
server=”mssql.megasqlservers.com”;UID=”dbm.domain.com”;
PWD=”password”>
SELECT * FROM Producers
</cfquery>

3. DSN connection for MySQL


<cfquery name="schedule" datasource="db_austin_Hybeam_com">
SELECT * FROM Producers
</cfquery>

4. DSNless Connection for MS Access


<CFSET thisPath=ExpandPath("data\")>
<CFSET thisDirectory= GetDirectoryFromPath("thisPath")>

<CFQUERY NAME="test"
DBTYPE="dynamic"
CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)};
Dbq=#GetDirectoryFromPath(thisPath)#mydb.mdb;">

SELECT * FROM MyTable

</CFQUERY>

5. DSNless connection for MS SQL


<CFQUERY NAME="test"
DBTYPE="dynamic"
CONNECTSTRING=" Driver={SQL Server};Server=servername;
Database=dbname;Uid=sa;Pwd=pass;">

SELECT * FROM MyTable

</CFQUERY>

6. DSNless connection for MySQL

<CFQUERY NAME="test"
DBTYPE="dynamic"
CONNECTSTRING=" Driver={mysql};Server=servername;
Database=dbname;Uid=sa;Pwd=pass;">

SELECT * FROM MyTable

</CFQUERY>

7. Defining Paths?

<CFSET thisPath= ExpandPath("images/")>
<CFSET thisDirectory= GetDirectoryFromPath(thisPath)>

This equates to the following path:

\domain.com\public\images