I'm making a little progress, I think. the link is similar to the one I used last night. now, I'm getting the following error:
Connection verification failed for data source: dev []java.lang.NoClassDefFoundError: java/sql/Savepoint The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint I've tried adding the .jar class to the Java and JVM page in CF Admin, but still get the error. I use w2k and am able to run MySQL 4.1.7 and the MySQL Administrator and Query Builder without any problems. When I try to add the DSN, CF Admin automatically populates the id/pw fields. I guess it's getting the info from the mysql server. What I'm trying to do is create a DSN so I can extract data from a Access 2000 db and place it in a MySQL db using cfquery and cfinsert. Chris On Sun, 30 Jan 2005 07:58:37 -0600, Adrian J. Moreno <[EMAIL PROTECTED]> wrote: > Chris, > > is this the article you followed from Macromedia? > > How to use MySQL 4.1 with ColdFusion MX > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 > > I followed these steps on my Win2k machine without any problem. What OS > are you running? > > Try entering 127.0.0.1 instead of "localhost". > > How are the ID and PWD "automatically populated"? Do you plan to pass > them in via <cfquery>? If you didn't enter them in the Datasource form > fields, then CF Admin can't verify the connection. > > You can verify user access privileges by downloading MySQL > Administrator: http://www.mysql.com/products/administrator/ > > See if you can connect to your database using that ID/PWD with MySQL > Query Browser: http://www.mysql.com/products/query-browser/ > > HTH, > > Adrian > > Chris Gomez wrote: > > I am trying to set up a MySQL 4.1.7 DSN connection, but i keep getting > > the following error: > > > > Connection verification failed for data source: dev > > []java.sql.SQLException: SQLException occurred in JDBCPool while > > attempting to connect, please check your username, password, URL, and > > other connectivity info. > > The root cause was that: java.sql.SQLException: SQLException occurred > > in JDBCPool while attempting to connect, please check your username, > > password, URL, and other connectivity info. > > > > I have loaded the latest ODBC and JDBC drivers from the MySQL site. I > > selected MySQL as the driver, then entered the DSN name, schema name > > and server (localhost, in this case). The user id/pw are > > automatically populated. > > > > I checked Macromedia's site and tried using the Other ODBC driver and > > configured it with the JDBC URL and Class data. However, I get the > > same authentication error. > > > > I've also tried to create a DSN for the mysqltest schema and created a > > connection for it, either. > > > > any help appreciated. > > > > Thanks, > > > > Chris > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
