How do I create a DSNless connection to a database?

The following article explains how to create a DSNless connection to a database. DSNless connections are direct connections to a database that do not require a ColdFusion Administrator to make specific configurations. A DSNless connection can be used to connect to any type of database, including Microsoft SQL and Microsoft Access.

To create a DSNless connection, add the following snippet of code within your application.cfm page or to each individual page that should connect to a database:

classLoader = createObject("java", "java.lang.Class");
dm = createObject("java","java.sql.DriverManager");

con = dm.getConnection(connection string);

st = con.createStatement();
rs = st.ExecuteQuery("Select * FROM table");
q = createObject("java", "coldfusion.sql.QueryTable").init(rs);

The connectionstring will depend on the type of database. The following are two common connectionstring examples:

Microsoft SQL
"jdbc:odbc:DRIVER={SQL Server};Database="dbname";Server=db_servername.safesecureweb.com;",
"login", "password"

Microsoft Access

"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\websites\folder\mydatabase.mdb;Uid=;Pwd=;"
Note: If you use either of the above examples, you will need to change the information to refer to your database.

Comments are closed.

By using this website you consent to the use of cookies in accordance with our Privacy Notice. You may opt-out at any time in the Cookies section of the Privacy Notice page.