Click to See Complete Forum and Search --> : How to create a ColdFusion DNS to Pervasive database


pn1978
12-21-2006, 11:45 PM
I know some client side ColdFuion and I'm learning the rest on the fly. I'm trying to create a data source using a Pervasive ODBC Client Interface driver but it does not work. Any suggestion?
Can anyone tell me what I'm doing wrong
This is my settings and the error message:
JDBC URL: jdbc: pervasive://10.32.104.153:1583/TEST1
DRIVER CLASS: com.pervasive.jdbc.v2.driver
Connection verification failed for data source: TEST1
java.sql.SQLException: No suitable driver available for TEST1, please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available for TEST1, please check the driver setting in resources file, error: null

chrismartz
12-31-2006, 01:27 PM
Are you registering the database through the coldfusion admin page?

pn1978
01-05-2007, 07:25 AM
yes