CFMX database access. Look no hands

[danp5648]

Coldfusion CFMX DSNLESS Connection how-to

I guess I called it DNSLESS because the driver embedded the information. So now the JDBC URL is a bit longer then using just the
ODBC service and there's no JNDI service helping with connection. The problem with that is its not centralized in place to edit.

This shows a good way to do it.
http://www.cfide.org/Excel_DSNLESS.html

 

[skypanther]

I realize this is an old thread. Has anyone successfully used this technique? I tried it and I get some error about mySQL_connection_test not being a valid object.

I tried about four other DSNless connection techniques and none of them worked either.

A working code example would be greatly appreciated!

Thanks,
Tim

 

[manopb]

Re: Coldfusion CFMX DSNLESS Connection how-to

The DSNs inside the Admin are just an easier way the edit an XML file and makes it fool proof.

Personally, I'm into 'easy' and 'fool proof'.:couch2:

 

[danp5648]

My god I must have been 3 years old when I posted that code.
mySQL_connection_test seems to be a java class I made ... but why?

Look at this Example:
http://www.cfide.org/Excel_DSNLESS.html

I got it down to basically two lines of code which should be kept
far away from all other code. The only Objects on your CFML page
should be Statement Objects and PreparedStatements Objects
which should open and closed.