Lotus Notes Query with ColdFusion - Access

[ocarmona]

Is it possible to access/query Lotus Notes with Coldfusion? How can I create
the DSN in Coldfusion Administrator Successfully?

I have searched the web and not found a successfull article. I already have
the DSN successfully created in the ODBC Manager, but how o I do it in CF
MX7.01 ??

It keeps giving me an error:

Connection verification failed for data source: SeguimientoERJ
java.sql.SQLException: No suitable driver available for SeguimientoERJ, please
check the driver setting in resources file, error:
The root cause was that: java.sql.SQLException: No suitable driver available
for SeguimientoERJ, please check the driver setting in resources file, error:

Text

I have used the ODBC Socket type and the Other... no luck.. PLEASE HELP - Many
say is possible but no example or have not met any succesfull people on this.

[A3gis]

You need to get your hands on the <a target=_blank
class=ftalternatingbarlinklarge
href="http://www-142.ibm.com/software/sw-lotus/products/product4.nsf/wdocs/notes
sqlhome">NotesSQL</a> driver.

Setup a SYSTEM DSN, then tell coldfusion to access that.

[ksmith]

You already have the ODBC datasource according to your post. Confirm it is a
system datasource and not a user datasource in the ODBC manager. You only have
2 choices from CFMX to connect to an ODBC datasource. You can use the ODBC
socket or use the jadazoom JDBC/OLE bridge which CF uses as the msaccess
unicode driver.

Recreate the odbc socket. Make sure you have the user and password setup in
the advanced properties of the DSN. If it fails, run a test query like "select
* from foo" against it. Let us know the error.

You can review the technote on the jadozoom driver at: <a target=_blank
class=ftalternatingbarlinklarge
href="http://www.adobe.com/go/2d2a7a19.">http://www.adobe.com/go/2d2a7a19.</a>
Although this driver is usually used for access it should connect to any odbc
dsn. Just follow the instructions and give it a try. Again if the dsn fails,
run a test query anyway and post the error.